Solved

Purchase Order Lines


Userlevel 4
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

8 replies

Userlevel 5
Badge +1

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 3
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 4
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 3
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 4
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)

Userlevel 4
Badge +1

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)

I am running into an Issue that is similar. 
But the Grouping Edits do not help. 
Would you mind sharing the Grouping Tab in the Schema Builder?

Userlevel 5
Badge +1

@krausef77 

You will need to remove groupPOLine from the Groups Collection.

Next, move the fields from “groupHeaderSection2 (Header of groupPOLine)” to “detailSection1”

Remove the sum function from QTY and Extended Price.

After you’ve made those changes, it will not group POLine by inventory ID.

If you still need some help, I can share some screenshots.

I have done this in two ways, first the method where I remove the grouping and move fields to the detail line changing the sum functions.   I have also done this by adding the POLine.LineNbr to the groupPOLine.  I do not change anything the report sections. The second option is the quickest to deploy. 

 

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