SOP Blank Invoice - Creating a calculated field for Balance Due

(0) Share

Report

Posted on by Community Member

I have been reading the other discussions on this and it appears it may not be possible but I would like confirmation.

Client wants Payment Received (amount entered in the Amount Received field in Sales Transaction Entry) to replace Trade Discount on the printed copy of the SOP Blank Invoice. Done and was pretty simple but now the Total data field needs to reflect the amount received. Can it be down as a different calculated field and if so can anyone tell me what that would be?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hello,

Create Calculated field and add/minus your sub totals including Payment Received to get grand total.

Thanks
Sandip

Was this reply helpful? Yes No
Verified answer

Victoria Yudin 22,769 on at

Like (0)

Report

Nasha,

If I understood correctly and you're only pulling in the payment received from the SOP transaction itself then another option might be to use the On Account Amount - that should be what's left due on the invoice after the payment, which I think is the number you're after?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This did the trick. Thank you Victoria......

Was this reply helpful? Yes No