Product Cost Issue - Average PO & Batch/Lot

[Muhammad Rizwan Anwar]

Dear All,

We have the following configuration for Product Costing in an iDempiere Installation:

1. Costing Method: Average PO
2. Costing Level: Batch/Lot

3. Attribute Set is attached with "IsAutoGenerateLot" functionality to produce Lot Numbers automatically

The system generates Costs accurately at the time of Material Receipts and Production Order (Single Production). This is very stable and there is no issue.

But sometimes the system increases the Cost of Some Product Lots (In the M_Cost table) very high at the time of consumption entries like Customer Shipments/Internal User Inventory/Production Lines etc.

We are not able to figure out the exact reason for this abnormal behavior. Please guide us on how we can find out the reason.

Thank you

Rizwan Anwar

[Heng Sin Low]

Usually consumption shouldn't be an issue it should not change your average cost at all. One exception here is when your on hand (in your case, the on hand for your lot) goes to -ve and perhaps that's one area you should check it. The other things that could goes wrong are the flow that's outside of the normal trx flow, for e.g reversal of transaction and RMA return.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/7f5e3f11-f837-468f-b610-0b747eb97431n%40googlegroups.com.

[Muhammad Rizwan Anwar]

Thank you very much for the quick response.

We have disabled Negative Inventory so the system doesn't allow -ve quantities.

Reversals are frequently made in the system. What can be the workaround if Reversals/RMAs are the reason for the change of Average Cost?

Currently, to correct the accounting, we manually change the Average Cost of the Product Lot and repost all the relevant transactions.

[Heng Sin Low]

Well, first, you have to test and confirm that indeed is the issue here. 

Then we can talk about whether there's a workaround or it is a blocking issue that needs to be resolved.

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/d60b9f98-0d8e-4b6e-ba26-e224301296can%40googlegroups.com.

[Muhammad Rizwan Anwar]

Okay. I Will test comprehensively and share the results here soon. Thanks

[KiênDX - Việt Nam]

This problem I have encountered. I have to edit the code in MCost.java and MCostDetail.java.

In file MCost.java: 

method setWeightedAverage (BigDecimal amt, BigDecimal qty) , you add param MovementType.

I not calculate cost when MovementType in ('V-','C+')

if (Util.isEmpty(MovementType) 

|| (!Util.isEmpty(MovementType) 

&& (!MovementType.equals("V-") && !MovementType.equals("C+")))) {

BigDecimal oldSum = getCurrentCostPrice().multiply(getCurrentQty());

BigDecimal newSum = amt;

BigDecimal sumAmt = oldSum.add(newSum);

BigDecimal sumQty = getCurrentQty().add(qty);

if (sumQty.signum() != 0)

{

BigDecimal cost = sumAmt.divide(sumQty, 12, RoundingMode.HALF_UP);

setCurrentCostPrice(cost);

}

}

you can refer to this solution

Vào lúc 10:39:36 UTC+7 ngày Thứ Hai, 6 tháng 9, 2021, see2r...@gmail.com đã viết:

[Heng Sin Low]

Hi,

It will be greatly appreciated if you can post the issue and solutions to a Jira ticket.

Thanks & Regards,

Low

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/07de83d4-64a2-47cd-bb93-5c7303085795n%40googlegroups.com.

[Muhammad Rizwan Anwar]

Here is the Jira Ticket

https://idempiere.atlassian.net/browse/IDEMPIERE-4950

I will share my testing there