How to handle Product and Landed cost data accuracy during dispatch in Compiere ERP?

For any imported product, additional cost involved like freight, insurance, trucking charges etc., and it should include along with product cost during sales

for one of our customer, we have maintained stock GL at each product category level

In Compiere ERP system, landed cost GL maintained in separate GL. So it’s not considered the additional cost during sales.

So we have modified and mapped to Stock GL for Landed cost at product category level

Problem :

Some of the product category not mapped to stock GL and leads to mismatch value between Trial balance vs Stock summary report for the past 3 months history data

Solution :

We have identified the list of landed cost document no list by running the report “Accounting entries by Date”. From that, we have prepared the sql by deleted the fact details for the list of docs and changed the posted value to “N”.

Then the scheduler posted the value with the correct GL mapped against product category

Next step, we have identified the sales happened for the products/lot by preparing the sql.

After that, deleted the fact details and re-posted the value which included LC cost along with Product cost