How to get Purchase Order Transactions to Show Remaining Items To Be Recieved

This is my first post on the website so go easy on me.

I’m having an issue in the custom purchase order for where I have quantity and received but To Be Received only shows Yes or No. How can I create a Sub-List Field that would display Quantity – Received? Any help is appreciated greatly.

Rookie Asked on May 25, 2021 in Purchasing.

Formula (Numeric) | {quantity}-{quantityshiprecv}

Kind of like this on a search but per line Item on the transaction form


on May 25, 2021.
Add Comment
1 Answer(s)
Best answer

You can create a new Transaction Line Field.

Customization -> List, Record, Field, Transaction Line Field

Create a field called Decimal Number field called Remaining. Apply to Purchase Item. Uncheck Store Value, and under Validation & Defaulting add this formula to the Default Value {quantity}-{quantityreceived}

Please let me know if that does not make sense. This method will make remaining available on the PO form. You may need a slightly different method if you want to review remaining on a saved search for export.

Beginner Answered on May 25, 2021.

Oh man I could upvote your reply a hundred times THANKS!

on May 25, 2021.

🙂 I’m glad that was helpful.

on May 25, 2021.

You drink coffee? Beer?  How can I buy you one?

on May 25, 2021.

This is great! when you mention a slightly different method for saved search – would you have any idea’s on how to leverage this in a saved search / report?

on July 22, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor