Possible to update 02 cost with a batch job?

[ChrisSugano]

I need to update the 02 cost of 7500 item branch records. Anyone know of a batch job that would update the cost and create the IB cost adjustment transaction in cardex?

I don't want to do it through SQL since that would throw the cardex way off.

I looked at the speed cost application, but that way is Item by item and would take forever.

 

[Guy Robert]

Use table F4105Z1 with your changes and process using R4105Z1I.


Guy Robert
Syntax.Net

 

[ChrisSugano]

Thank you, this is what I needed.

One more question. Any idea why it would tell me "Update not Allowed"? I added 1 item to the table F4105Z1 but batch job did not update the 4105.

OK, I figured that out, but it does not create an IB transaction in Cardex. Any thoughts?

 

[Guy Robert]

To make a change to an already existing record, SZTNAC must be equal to C
or 04


Guy Robert
Syntax.Net

 

[ChrisSugano]

I set SZTNAC to C during my testing, and the 02 cost did change, but an IB transaction was not created. So When I look at Cardex, the sum of PAID is wrong.

Maybe this is not a problem, but I would have expected to see the IB transaction when changing the value of inventory.

 

[Jde_Bala]

Are you looking for something like R41052.

You can load an 'IC' cost and update your 02 cost.

Bala

 

[ChrisSugano]

R41052 and Cost type IC was the solution I was looking for.

Thank you.