Good afternoon,
I have had a request from our payables team to need show the remaining amount to be invoiced on our Purchase Order list, and I can’t see that this is available so looking to create a calculated field that subtracts the Amount Received Not Invoiced (301, Decimal) by the Amount (60, Decimal) if possible.
This field will be placed on to the Purchase Order List page that comes from the Purchase Header Table (38), and when looking through the support and trialing a few options in Sandbox I can only see options to Sum, Average, Min, Max etc. Is there a way that you know of that I can create a field to minus two decimal values?
Thanks,
Richard.
Those options are from FlowFields, to create a calculated field, use the “Calculated field” option in the Simple Object Designer main menu. (Calculated fields are not really fields, so you design them for use on pages, not on tables).