Question

Unshipped Amount Calculation

  • 10 November 2023
  • 2 replies
  • 41 views

Userlevel 4
Badge +1
  • Jr Varsity III
  • 92 replies

Hey Folks, wondering if anyone has had any challenges with some of the “TOTALS” metrics on the SO. 

We are looking to understand how the Unshipped Amount is calculated on a SO because it does not match the formula presented:

The formula per the HELP icon is:

The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items. The unshipped amount for each line is calculated as the amount in the Ext. Price column (after Line-level discounts were applied) divided by the line quantity (the Qty. column) and multiplied by the unshipped quantity (the Open Qty. column). At the moment of order creation when no item quantities are shipped, the amount is equal to the Line Total; this total does not include any freight amount. This box appears only if the Inventory feature is enabled on the Enable/Disable Features form.

Metrics:

As you can see the Unshipped Amount = 7,336.54 

If you review the lines for the particular SO in question we see:

It seems like the Unshipped Amount should equal: 9,660.48?

Are we missing something here?


2 replies

Badge +1

Hello @K2a , what is in Amount , Unbilled Amount, Unshipped Qty columns? What do you have on Discounts tab?  What build version do you have? Was this order created manually on SO301000 screen or was it created from Quote or Opportunity? Do you have customizations? Do you have only one order with unexpected totals or more than one? You can also create a case and we’ll help you.

Userlevel 4
Badge +1

Hello @K2a , what is in Amount , Unbilled Amount, Unshipped Qty columns? What do you have on Discounts tab?  What build version do you have? Was this order created manually on SO301000 screen or was it created from Quote or Opportunity? Do you have customizations? Do you have only one order with unexpected totals or more than one? You can also create a case and we’ll help you.

I opened a ticket.   

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