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.
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.
Oh man I could upvote your reply a hundred times THANKS!
🙂 I’m glad that was helpful.
You drink coffee? Beer? How can I buy you one?
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?
ChasePounders
Formula (Numeric) | {quantity}-{quantityshiprecv}
Kind of like this on a search but per line Item on the transaction form