Dear Sir… My consultant found error while running adjust cost FIFO method by So… before running adjust cost I know it issue by average eventhough I set method by item is FIFO thus for correct costing I must be calculate by runing adjust cost but result is wrong by Item is calculate Item Dear Sir… My consultant found error while running adjust cost FIFO method by So… before running adjust cost I know it issue by average eventhough I set method by item is FIFO thus for correct costing I must be calculate by runing adjust cost but result is wrong by Item is calculate Item by lot tracking Ohh god… Why 's costing using lot for calculate too in example : Item A have lot Before calculate PO(GRV lot 01) 01/01/05 Item A 10 @10 PO(GRV lot 02) 02/01/05 Item A 10 @20 PO(GRV lot 03) 03/01/05 Item A 10 @30 SO(lot 01) 04/01/05 Item A -10 @10 SO(lot 03) 05/01/04 Item A -10 @10 After calculate PO(GRV lot 01) 01/01/05 Item A 10 @10 PO(GRV lot 02) 02/01/05 Item A 10 @20 PO(GRV lot 03) 03/01/05 Item A 10 @30 SO(lot 01) 04/01/05 Item A -10 @10 SO(lot 03) 05/01/04 Item A -10 @10 ??? 05/01/04 Item A 0 @20 ??? Can you explain me Why lot tracking is involved in method of adjust cost ?
Hi If I load up a lotted item in 3.70 Cronus and receive 10 in on one date at 0.50 and 10 in at a later date at 1.00 with different lot numbers, if I then sell 20 on different later dates and run the adjust cost item entries I will get a 5.00 cost for the first sale and 10.00 for the second. Have you processed any purchase invoices for the lot yet? Where are you looking for these costing figures?
I see value of costing in Item Ledger Entry. and if you test in situation like me ,you can see error in last transaction : SO(lot 03) 05/01/04 Item A -10 @10 ??? SO(lot 03) 05/01/04 Item A 0 @20 ??? In last transaction when calculate adjust cost finish Program 'll create new record when it found record must be adjust cost but I don’t know why program adjust cost by lot… Thank you
Hi Your zero is the Invoiced Quantity I presume? I also presume this is at the Value Entry level as the ledger entry would show you one line? Ultimately at the item ledger entry the level is correct in my version - exactly as you have done it in 3.70 I get the following: 05/01/05 Invoiced Qty -10 Cost per unit 0.00. 25/01/05 (when I posted the adjust cost batch) Invoiced Qty 0 Cost per unit 30.00. This adjsutment aligns the cost with the batch. I have invoiced no purchase lines, and just runt eh adjust cost routine after all transactions. You might want to check your hotfix.