gbelcher
Member
Has anyone solved this problem? If so can you give me some insight?
I have a client that has asked if I can correct the weight average cost (the dollar cost per unit used to calculate cost of sales). Having JDE calculate the weighted average cost correctly would give my client the correct cost of sales needed for accounting/reporting and flexibility in the order of processing purchases/sales. My Client’s business model requires that inventory on hand in JDE will be less than zero at times, and this fact is one source of the incorrect calculation of weighted average cost.
Overview: Weighted average cost for an item at a branch plant should match the detailed entries in the F4111 file. They want the following formula to hold in JDE even when the QuantityOnHand < 0.
WeightedAverageCost = (QuantityOnHand * CurrentWeightedAverageCost + TransactionQuantity * TransactionUnitCost) /
(QuantityOnHand + TransactionQuantity),
i.e.,
F4105.COUNCS = (F41021.LIPQOH * F4105.COUNCS
+ F4111.ILTRQT * F4111.ILUNCS) /
(F41021.LIPQOH + F4111.ILTRQT)
If F41021.LIPQOH + F4111.ILTRQT = 0 then set F4105.COUNCS = 0.
It will be necessary for you to determine the relationship between the F4111, F43121, F4105, and the P4312. Right now:
A. They know that when the inventory on hand goes below zero for any purchasing transaction, the formula above does not hold true.
B. They think the COUNCS value is calculated from the entries in the F43121 not the entries in the F4111, but these two tables should be consistent. (F43121.PRAREC should equal F4111.ILPAID for PRDOC = ILDOC, PRDCT = ILDCT)
Mark Belcher
Mark Wizz, Inc.
mobile 713.725.83.95
I have a client that has asked if I can correct the weight average cost (the dollar cost per unit used to calculate cost of sales). Having JDE calculate the weighted average cost correctly would give my client the correct cost of sales needed for accounting/reporting and flexibility in the order of processing purchases/sales. My Client’s business model requires that inventory on hand in JDE will be less than zero at times, and this fact is one source of the incorrect calculation of weighted average cost.
Overview: Weighted average cost for an item at a branch plant should match the detailed entries in the F4111 file. They want the following formula to hold in JDE even when the QuantityOnHand < 0.
WeightedAverageCost = (QuantityOnHand * CurrentWeightedAverageCost + TransactionQuantity * TransactionUnitCost) /
(QuantityOnHand + TransactionQuantity),
i.e.,
F4105.COUNCS = (F41021.LIPQOH * F4105.COUNCS
+ F4111.ILTRQT * F4111.ILUNCS) /
(F41021.LIPQOH + F4111.ILTRQT)
If F41021.LIPQOH + F4111.ILTRQT = 0 then set F4105.COUNCS = 0.
It will be necessary for you to determine the relationship between the F4111, F43121, F4105, and the P4312. Right now:
A. They know that when the inventory on hand goes below zero for any purchasing transaction, the formula above does not hold true.
B. They think the COUNCS value is calculated from the entries in the F43121 not the entries in the F4111, but these two tables should be consistent. (F43121.PRAREC should equal F4111.ILPAID for PRDOC = ILDOC, PRDCT = ILDCT)
Mark Belcher
Mark Wizz, Inc.
mobile 713.725.83.95
