Solved

Purchase Order Lines


Userlevel 2
Badge

Hi all,

So I noticed that when creating a PO with multiple line items with the same inventory ID, when the PO is printed the system sums all of the lines together and only prints out one line item with the aggregated total qty. Our hope was to create a PO with multiple lines that correspond to requested on dates which you can change on the line level. We are trying to avoid having to cut a PO for each day and just have one PO with the different requested on dates at the line level. 

Wanted your thoughts on if this is possible.

 

Thanks,

icon

Best answer by Raj Gopinathan 13 May 2022, 22:48

View original

5 replies

Userlevel 2
Badge

Hi @byates,

The  out of the box version of the PO report sums the PO line quantities to create one line per inventory item. You can change that by removing the “Sum” in the Value field:

 

It should then print each line individually. 

Userlevel 2
Badge

So, would you want the report to print all the lines separately but on the same printed form? That would requiring modifying the Purchase Order report PO641000 (the printed form) and obviously would require adding a column for the Requested On date as well which does not exist in the default printed version.

Userlevel 2
Badge

Thanks to you both. I have removed the Sum and added the Promise Date but for whatever reason it is only listing the first line item, but it does show the line comments for all 3 lines. The qty on the one line item is now correct though and shows only the first line qty and not the sum of all lines. So making progress.

 

 

Userlevel 2
Badge

Good progress. You might also want to check in the Schema Builder - Sorting and Grouping tab for the Grouping. You might have removed the sum of the price but still the lines might be grouped by Inventory Item.

Userlevel 2
Badge

Good progress. You might also want to check in the Schema Builder - Sorting and Grouping tab for the Grouping. You might have removed the sum of the price but still the lines might be grouped by Inventory Item.

…. I should have thought about that. That was it!  Thanks Raj. (and Donna)

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 — 2020  Acumatica, Inc. All rights reserved