Hi everyone. I would like to know how to hide the canceled PO lines on the printed report form. Thank you.
Best answer by Robert Sternberg
View originalHi everyone. I would like to know how to hide the canceled PO lines on the printed report form. Thank you.
Best answer by Robert Sternberg
View originalHello!
You can set a condition in the report design to filter to Canceled = False.
This will exclude rows that have been canceled.
If you need more help you can upload your RPX file here and we can take a look.
Hi
Kindly see the attached RPX file. Btw, where can I set the condition that you have said?
Thank you.
Hello
Please try adding a Visible Expression to show the PO Line only when Canceled not equal to True. (Or cancelled = False)
Laura
Hi
Thanks for the reply. But it doesn’t seem to work. I tried both true and false. Am I missing something?
Hello,
When I downloaded the file, it was .RPS instead of .RPX and I couldn’t open it. I tried to answer without trying your report file. If you can post the file,
Best,
Laura
Hi
I tried to download again the report from Acumatica but it is .RPS I don’t know why either. Could you please attach your sample report so I can check it? Thank you.
Hello
https://www.augforums.com/acumatica-rps-versus-rpx-file-types/
Hi
Thanks for the info. Kindly see the attached .RPX file, thank you.
Please see the two versions.
Only hiding the line will still include the cancelled line’s quantity and cost in the total fields.
Removing the line will remove the line’s quantity and cost from the totals as well, this is probably what you want.
Hope this helps. This is untested so let us know if you have any issues getting it to work and remember now you have the original .rpx to roll back to if something does not function as expected.
hope this helps.
Hi
Wow, it works. One more thing, the Purchase total doesn’t deduct the cancelled line’s amount. Hoping for your additional assistance on this. Thank you so much.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.