When a customer has made a pre-payment on a Sales Order but no invoice exists in NetSuite to match to.
Step-by-step guide
- In the bank account configuration, make sure the following option is ticked: Setup > Bank Reconciliation setup > Bank Account Configuration > (select the account you want to be able to match the prepayment to the Sales Order) > Matching Preferences
- If the bank transaction description contains the sales order information, this will be matched during the processing of the matching rules. If not the transaction will need to be manually matched.
- Select the customer name under the "NAME" column
- This will open up the "POPUP" screen which will display all open transactions for the selected customer, including any open sales orders.
- Apply the amount of the transaction to the required sales order and click on "Submit".
- The amount has now be applied to the open sales order. Once the user has completed the other transactions on the bank statement, click on "Save" in order to submit the transaction(s) on the bank statement. Once processed the Fast Four Bank Reconciliation tool will create a customer deposit against the selected Sales Order.
- When in the sales order you can see the deposit under "Related Records" tab.
- At the time the Sales order is made into the invoice, the payment is automatically applied to the invoice and the amount owing is reduced by the deposit(ed) amount(s).
Once the payment has been generated from the bank statement, no further user action is required. Any future payment made on the invoice will apply to the open amount.
Related articles