ale_baan
8th May 2006, 09:39
Hello all,
In order to calculate margin, we take the costs from each sales order line. The point is that on that on the sales order line table "tdsls401" are present 3 costs:
- vcop: variable standard cost amount
- fcop: full standard cost amount
- copr: cost amount of goods sold
We think it'd be reasonable to take "copr" so as to calculate margin on cogs, however we found that in some cases "copr" (which should include all item surcharges) is lower than "fcop" (!).
The question is: how are those 3 fields *exactly* calculated? which information do they take and from which source?
Thank you,
In order to calculate margin, we take the costs from each sales order line. The point is that on that on the sales order line table "tdsls401" are present 3 costs:
- vcop: variable standard cost amount
- fcop: full standard cost amount
- copr: cost amount of goods sold
We think it'd be reasonable to take "copr" so as to calculate margin on cogs, however we found that in some cases "copr" (which should include all item surcharges) is lower than "fcop" (!).
The question is: how are those 3 fields *exactly* calculated? which information do they take and from which source?
Thank you,