Hi All, I need ‘creative’ help when it comes to invoicing and displaying balance ‘due’. We have like 50 different term rates for customers. How would I show the balance due based on term rate, correctly on the invoice? Would we need a new custom field to be built/displayed and manually inputted? There are some customer’s we have that are ‘livid’ because their invoices don’t display the ‘true’ balance due based on term rates that are negotiated. Example INV00123 Total $14.962.03 Terms 20% Deposit, Net 60 Term Balance Due: $2992.40 (20%) **NOTE: i just want to make sure I’m not crazy when I tell someone that NS isn’t going to dynamically calculate the terms of any term you make through the Accounting Lists {Set Up > Accounting > Accounting List > Type = Terms}

From my experience I have not seen NetSuite natively calculate or do this so I would presume your approach of going with a custom field and having it calculated and then displayed on the invoice to be correct.

@Ahad Arain Thanks for that. Sometimes just someone reconfirming what is possible is a great doublecheck

of course

Yeah, correct labels should be PaidValue and Unpaid Value... AFAIK NetSuite uses DUE DATE for • on the VendorBill for payment processing • Aging calculation for Customer Inovice when processing Dunning and Open Invoices report Terms are used for calculating DEFAULT value of DUEDATE (you can change that) and providing PRINTED instruction to Customer how. to pay...