Skip to main content
Solved

PO order report not able to sort


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

View original
Did this topic help you find an answer to your question?

7 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 362 replies
  • 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


Forum|alt.badge.img+3
  • Author
  • Captain II
  • 317 replies
  • July 15, 2024
nhatnghetinh wrote:

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+9
  • Captain II
  • 362 replies
  • July 15, 2024

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT


Forum|alt.badge.img+3
  • Author
  • Captain II
  • 317 replies
  • July 15, 2024
nhatnghetinh wrote:

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT

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


nhatnghetinh
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 362 replies
  • 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


Forum|alt.badge.img+3
  • Author
  • Captain II
  • 317 replies
  • July 15, 2024
nhatnghetinh wrote:

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+9
  • Captain II
  • 362 replies
  • Answer
  • July 15, 2024

Hi @Harshita 

I have tested your report and it works fine.

 

 

 

 

Best Regards,

NNT


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings