Skip to main content
Solved

PO order report not able to sort

  • 15 July 2024
  • 7 replies
  • 54 views

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. 

7 replies

nhatnghetinh
Rank
Userlevel 7
Badge +5

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

Hi Everyone. 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*
H
Rank
Userlevel 6
Badge +3

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
Rank
Userlevel 7
Badge +5

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT

Hi Everyone. 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*
H
Rank
Userlevel 6
Badge +3

Hi @Harshita 

Please send the Report Designer .rpx file.

 

Best Regards,

NNT

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

1 Attachment
nhatnghetinh
Rank
Userlevel 7
Badge +5

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

Hi Everyone. 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*
H
Rank
Userlevel 6
Badge +3

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
Rank
Userlevel 7
Badge +5

Hi @Harshita 

I have tested your report and it works fine.

 

 

 

 

Best Regards,

NNT

1 Attachment
Hi Everyone. 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*

Reply


Terms & ConditionsCookie settings