Skip to main content
Answer

PO order report not able to sort

  • July 15, 2024
  • 7 replies
  • 105 views
H
Captain II
Forum|alt.badge.img+3

Hello all,

I have the below Po order details & the result in PO Order report:
The Inventory IDs are same for all, but have modifications made in the Line description column


 

PO Order report PO641000


When we compare the above screenshots we see that the Line description are not on the same line number as in the PO screen (PO301000). So I am looking to print the descriptions & details in the same way as they are entered in Line level in PO Order.
How can I achieve this?

I tried the below in report designer, but still no changes,
 


Thanks. 

Best answer by nhatnghetinh

Hi @Harshita 

I have tested your report and it works fine.

 

 

 

 

Best Regards,

NNT

7 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi @Harshita 

Because the report is sorting according to the current group.

Take the example of PO641000 report.
You Add [POLine.LineNbr] to the first line of groupPOLine as below to sort it as you require.

 

 

 

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Chris Hackett
H
H
Captain II
Forum|alt.badge.img+3
  • Harshita
  • Author
  • Captain II
  • July 15, 2024

Hi @Harshita 

Because the report is sorting according to the current group.

Take the example of PO641000 report.
You Add [POLine.LineNbr] to the first line of groupPOLine as below to sort it as you require.

 

 

 

 

Best Regards,

NNT

Hey @nhatnghetinh , tried it. Didnt work out

nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
H
H
Captain II
Forum|alt.badge.img+3
  • Harshita
  • Author
  • Captain II
  • July 15, 2024

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT

Attaching here.
Kindly extract the RPX file from the ZIP.

1 Attachments
nhatnghetinh
Captain II
Forum|alt.badge.img+11

Hi @Harshita 

I see that your report has not added "[POLine.LineNbr] to the first line of groupPOLine" like my screenshot above.

 

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Chris Hackett
H
H
Captain II
Forum|alt.badge.img+3
  • Harshita
  • Author
  • Captain II
  • July 15, 2024

Hi @Harshita 

I see that your report has not added "[POLine.LineNbr] to the first line of groupPOLine" like my screenshot above.

 

 

Best Regards,

NNT

Hey @nhatnghetinh , I had added then checked out since it didnt work so i removed it.

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • Answer
  • July 15, 2024

Hi @Harshita 

I have tested your report and it works fine.

 

 

 

 

Best Regards,

NNT

1 Attachments
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
Chris Hackett
H
Terms & ConditionsCookie settingsAccessibility statement
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