Solved

Is it possible to do Document like SO/Invoice profit adjustment?

  • 22 August 2020
  • 1 reply
  • 172 views

Userlevel 6
Badge +5

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?

icon

Best answer by ray20 28 August 2020, 06:50

View original

1 reply

Userlevel 6
Badge +5

To those who are also interested in this topic.
Thanks to Acumatica, as I checked, The business oversell case as I mentioned above is already solved by them.
After the receipt is done, the previous ARTran.Cost would be updated automatically. So it is OK for the profit calculation based on Invoice.

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved