Thursday, February 11, 2010

JD Edwards Mass Cost update for Items With Onhand Qty in inventory

Mass Cost update for Items With Onhand Qty in inventory
 

Today I did mass cost update by using Z-file Method
I order to do cost existing cost method cost update like 02 cost , you have to do following steps:
1. Populate F4105Z1 file using P4105Z1 Program these fields liitm,imlitm,limcu,'JDEIC' TranType,'A' "Transaction Action" ,'IC' CostMethod,'1' DirInd, UNCS Cost/Price.
2. Run R4105Z1I.
3. Check F4105 File if this created IC entries for the items you wanted to update cost(UNCS).Also check F4111 if this program created records in this file means you are doing something wrong. Check costing selc purchasaing , this field must keep Blank.Also see F0911 for no record created.
4. After that run R41052 in processing option put cost Method 02 (Depends on you which cost type you want to update)
and Doc type - IB in purge record put 1.
after this run you will see IB batch will create. so inventory cost is correct and GL is correct also.

 

No comments: