Question

Historical Sales Order 'Backlog'

  • 22 September 2022
  • 9 replies
  • 96 views

Userlevel 5
Badge +1

If you run the Sales Order Summary Report (SO610500) with no beginning date, the current date as ending and and additional filter of status not equal to complete, you would get a list if all Sales Orders that still need to be filled the their Open Qty and Open Amount.  I would call this the ‘Sales Order Backlog’ or Open Balance

I would like to see this same “Backlog” as of a historical date , say a year ago.  How could this be done? not quite sure where to begin…  thoughts?

 

 


9 replies

Userlevel 5
Badge

@dsimmerly - You can select the end-date back in the history. 

 

 

Userlevel 5
Badge

@dsimmerly - You can also create Additional Sort and Filters for the date on that report.

 

Userlevel 5
Badge

@dsimmerly - Sorry. I actually meant START DATE back in the history.

 

Also, you try those Additional Sorts and Filters. Moreover, you can create a GI with Data Parameters. It would be much more flexible.

Userlevel 5
Badge +1

@dsimmerly

Hi, 

I have exacty the same need as you. 

I need to see the historical sales order backlog. 

Did you find a solution for this?

Best regards

Lars

 

 

 

I did not

Userlevel 5
Badge

@dsimmerly - I just did a slight modification on the standard Sales Order GI to add Open Quantity and Unpaid Balance. You can do that as well. You can use the data filters to retrieve the required data. Let me know if you need this xml.

 

Userlevel 5
Badge +1

@RohitBhandurge The resulting report with a end date in the past would not give a list of open order on that date it would provide the current status which would be complete

 

 

@dsimmerly 

Hi, 

I have exacty the same need as you. 

I need to see the historical sales order backlog. 

Did you find a solution for this?

Best regards

Lars

 

 

 

Userlevel 5
Badge +1

@RohitBhandurge I am sorry this does not provide my need.  

Let me ask in a very specific way - I need a list if all orders that on this date a year ago were in the open status

That‘s not good. 
Seems that Acumatica is nor able providing such data. 

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