NetSuite does NOT display the Amount Due on vendor bills We must drill into the records to see the amount due or literally hit the “Pay” button on the bill to see how much is outstanding. There’s a quick and easy way around this – by creating a custom field that sources its value from… Continue reading Displaying Amount Due on Vendor Bills
Tag: amount remaining
Print Amount Remaining Instead of Total for Invoices Using Advanced PDF/HTML Templates
There are instances wherein the Total on Invoice printouts using Advanced PDF/HTML Templates should be replaced with the Amount Remaining. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Invoice PDF/HTML Template: Click Customize/Edit Top Right Corner: Toggle Source Code Insert the following codes accordingly: <td align=”right”><b>Amount Remaining</b></td> <td align=”right”>${record.amountremaining}</td> Click Save
Formula to generate the remaining amount without tax for Partially paid transaction types in proportion of amount paid to total amount
For open invoices partially paid, consider the following example… Subtotal /{ amt (net of tax) } =370.00 –> This amt is without tax Discount Item= 0 Tax Total =55.50 Total /{ total gross amount } = 425.50 Amount Due / { amt remaining }= 287.50 Amount paid= 138.00 Since we need to get the amount remaining… Continue reading Formula to generate the remaining amount without tax for Partially paid transaction types in proportion of amount paid to total amount