Skip to main content
Question

Historical Sales Order 'Backlog'

  • 22 September 2022
  • 9 replies
  • 150 views

dsimmerly
Pro I
Forum|alt.badge.img+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

RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

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

 


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Author
  • Pro I
  • 114 replies
  • September 22, 2022

@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

 

 


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@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.


RohitBhandurge
Jr Varsity III
Forum|alt.badge.img

@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.

 


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Author
  • Pro I
  • 114 replies
  • September 22, 2022

@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


Forum|alt.badge.img
  • Freshman I
  • 13 replies
  • February 27, 2024

@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

 

 

 


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Author
  • Pro I
  • 114 replies
  • February 27, 2024
LarsD wrote:

@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


Forum|alt.badge.img
  • Freshman I
  • 13 replies
  • February 27, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings