Hello,
I am trying to import payments for a large customer and I continue to run into the same problem...
About 1,000 - 2,000 invoices are created for this customer every day and right now I am manually applying a lump sum payment across each invoice - It takes about 8 hours each day to apply payments in NetSuite for this ONE customer. Is there a way to import customer payments as a lump sum payment amount AND have the lump sum payment applied to specific open invoices (we receive a file from the customer each day)? The auto-apply option will not work for us since there are so many invoices and the payment does not always cover the invoice most aged. I understand how to import customer payments via the import assistant, but when I do the import it applies the payment to the invoices correctly; however, each individual amount then shows up as a payment on the bank reconciliation. This means about 2,000 lines need to be checked on the bank reconciliation page when in reality only the lump sum amount hit the bank account.
It seems a majority of the NetSuite modules fail to pass the QuickBooks test. All other GL software I've used has this type of feature so I am hoping NetSuite offers this and I am simply doing something wrong. Any help would be greatly appreciated!
Thank you!