Solved

PO lines are consolidating

  • 7 September 2022
  • 5 replies
  • 149 views
L
Rank
Userlevel 6
Badge +5

Hello,

We have a PO with 4 lines for the same stock item.

Each line has a different Requested date.

When I print the PO, it consolidates this to 1 line on the printed PO.

We do not want this, we want to print the 4 lines to show each requested date.

 

 

icon

Best answer by Kandy Beatty 7 September 2022, 20:18

View original
If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

KBEATTY,

 

You rock once again!!!

It didn’t work using the line QTY as they were all the same.  But I used your example exactly except I used the requested date instead of the qty and *poof*, perfection!

THANK YOU!!!!

Glad to have helped. :) 

It’s interesting for sure that the system does that out of the box. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
L
Rank
Userlevel 6
Badge +5

KBEATTY,

 

You rock once again!!!

It didn’t work using the line QTY as they were all the same.  But I used your example exactly except I used the requested date instead of the qty and *poof*, perfection!

THANK YOU!!!!

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

HI @ltussing03 

My local Acumatica was like yours, it was combining all the lines:

 

I went into the Report Designer and changed under the Build Schema > Sorting and Grouping

I changed these conditions on the report and saved a new version:

Then when I ran that new PO report, it separated the lines:

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
manikantad18
Rank
Userlevel 7
Badge +12

Hi @laura01 In My standard Acumatica I am able to see the same behavior as @ltussing03  reported.

 

@ltussing03 My suggestion to show the Item and Description in different columns will resolve the reported issue I believe

Thanks

Acumatica Functional Consultant
Laura02
Rank
Badge +18

Hi, is your PO report customized?  I did a quick test in my demo using the standard po report, ordering the same item on two lines with different requested dates, and my lines are not consolidated to 1 line. (The standard report doesn’t show expected dates but I can add expected date and still have 2 lines.)

Are you creating a Blanket PO?  I tested with a Normal PO.

 

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


Terms & ConditionsCookie settings
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