Solved

Add Non-Stock Item Details to Customized Sales Order Report

  • 11 November 2021
  • 6 replies
  • 149 views

Userlevel 3
Badge +1

Is it possible to get non stock item details to be shown on the sales order report in Acumatica, for now they only contribute to showing the order total in the report but is it possible to show this information as well?

lines 2 and 3 are required to be shown in report

 

icon

Best answer by Naveen Boga 10 December 2021, 07:53

View original

6 replies

Userlevel 7
Badge +17

Hi @TharidhiP  It seems you have used the custom tables in this report hence unable to work with the above provided report.

 

 

Userlevel 3
Badge +1

@Vinay K ,sorry for the late reply. I have attached the report for clarity.

Userlevel 5
Badge +1

@TharidhiP Share the additional joins here that you have added to that report. 

Userlevel 5
Badge +1

@TharidhiP Its a out of box feature to display in the Sales Order report. 

 

If you are talking about shipment screen then you need to select “Require shipment” for the item in the Non-stockitem screen. Which will show both in the screen and report as well. 

 

Happy coding!

Userlevel 3
Badge +1

Hi @Naveen B I have customized the report with additional joins, could that be the reason why non-stock items are not seen?

Userlevel 7
Badge +17

Hi @TharidhiP  Yes, it is possible to show the Non Stock details in report.

For your reference, default Acumatica Sales Order report is already showing the Non-Stock item details on the report.

Here is the screenshot for your reference.

 

 

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