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.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.