Hi, we need to create an automatic round up for cu...
# accounting
n
Hi, we need to create an automatic round up for customer who underpay their invoice up to $1 - the discount taken at payment should be set to Misc. Expense GL account that does not have a dept or other expenses. The max threshold is $1. Please share any thoughts about how this can be done. Can we set up something like a write off process if any payment is underpay up to $1? Thank you in advance.
Can someone please suggest on this? Thank you.
s
NetSuite has a bundle small balance write off, have you looked at that?
n
@Suitestallion can you please share the details of the bundle? Also, please let me know how does it work?
s
To write off small balances in NetSuite, configure the Deduction and Chargeback Management SuiteApp by setting write-off limits, defining a small balance write-off type, and using the scheduled script (DC Small Balances Write Off MR) to create credit memos and automatically apply them to close out small underpayments on invoices. The process allows for automated identification of invoices meeting specific criteria (amount/currency) and generates corresponding transactions to maintain cleaner Accounts Receivable aging reports.
n
@Suitestallion Is it free? Or Does this license costs money? It looks like it needs to be provisioned to our account. I tried it and that is what it says.
@Suitestallion I found it on SuiteApp Marketplace. Thank you.
s
Glad you figured out, I am at Suiteworld and network sucks , it’s a little process to set up but SA should walk you through
👍 1
n
@Suitestallion I have configured the deduction charge type, setup, and write off limits. Then enabled the MR script to run on one particular invoice that is open and remaining amount is $1. But. for some reason, the script didn't create a credit memo. The accounting period is open. Not sure, what else is missing. Can you please help me with it?
s
Did you create a saved search? There is a field to select the saved search
n
Yes, i have modified the default saved search that is provided by the suiteapp and put a criteria to limit to show the invoice that has remaining amount =<$1
image.png
image.png,image.png