RE: 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.

ChasePounders 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 Answers
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.