Hi everyone. I would like to know how to hide the canceled PO lines on the printed report form. Thank you.
Solved
How to Hide Canceled Purchase Order Lines on the Printed Report Form?
Best answer by Robert Sternberg
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.
+7Hello!
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.
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
Kindly see the attached RPX file. Btw, where can I set the condition that you have said?
Thank you.
+19Hello
Please try adding a Visible Expression to show the PO Line only when Canceled not equal to True. (Or cancelled = False)
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Hi
Thanks for the reply. But it doesn’t seem to work. I tried both true and false. Am I missing something?
+19Hello,
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
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
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.
+7Hello
https://www.augforums.com/acumatica-rps-versus-rpx-file-types/
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
+7Please 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.
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
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.
If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
1 person likes this
+7Try this version. Let me know if it works out better for you.
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.