Intercompany order revenue and COGs discrepancy

(0) Share

Report

Posted on by gtipler

Hello all,

coming across a peculiar problem with inter-company sales order postings that I hope this group can help with. When creating an inter-company order with the "unit price equal to cost price" parameter set to TRUE, the revenue and COGS postings to do not align. It looks like the revenue is being calculated by rounding the cost price for the item to 2 d.p, assigning to the unit price and then multiplying by the quantity on the line receive the total amount. However, the COGS is multiplying the raw cost value by the quantity and then rounding the total. This is causing penny differences between them per item (as shown below), which with large line quantities results in significant recognition of intercompany profits.