SOP Blank Invoice - Creating a calculated field for Balance Due

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: SOP Blank Invoice - Creating a calculated field for Balance Due

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

Victoria Yudin 22,766 on at

Like (0)

Report

RE: SOP Blank Invoice - Creating a calculated field for Balance Due

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?
Suggested answer

sandipdjadhav 18,267 on at

Like (0)

Report

RE: SOP Blank Invoice - Creating a calculated field for Balance Due

Hello,

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

Thanks
Sandip