Hello,
We are calculating commissions based on profits of each AR document.
For example, if the total prices of 1 invoice is 1000, and the total cost of all the items on invoice is 800, then the commission would be calculated based on 200.
However, we encountered a case:
We did oversell for 1 item, such as item A. and Item A has 0 qty and 0 average cost in system. Supposing, we sold 10 cases item A at price $100, since item A has 0 average cost and 0 ARtran cost, the profit for Item A is calculated to $1000. which is not right in the real world.
The next day, we did receipt on item A with unit cost $80.
So the total profit of item A on that invoice should be only $200.
Is there a way for us to adjust that profit? If we can not do it on that single invoice, can we do a combination of several docs to adjust?
