Is there a way to CSV customer payments that has both Invoice and Credits to apply with? I don't see a way to map the Credits in the CSV mappong page. Use case is to clear bunch of invoices that were reversed with JEs in the past from the AR aging. Appreciate your help. Thanks
a
AK47
08/08/2024, 9:57 PM
yes, but it's a bit complicated. First you have to create the payment manually and select some invoices manually so that the total amount of invoices is > than the total amount of credits. Then once the payment is saved, you can csv import to update that payment and apply more invoices.
AK47
08/08/2024, 9:57 PM
I have my clients do this when there hundreds or thousands of invoices. Create the payment manually. Select the credits manually. Select some invoices manually so the total of the invoices is more than credits...save...then CSV import the remaining invoices
AK47
08/08/2024, 9:58 PM
its silly, but it allows for csv importing of payments without any dev, so 🤷♂️
p
Pat
08/08/2024, 10:06 PM
How are the journalw applied there then, how did you map Credit (jounals) to Customer Payments?
Pat
08/08/2024, 10:14 PM
I think Im disconnected there. If i create the payment with only those invoices, i will have a payment posting to Dr. Undeposited funds and a Cr to AR. Our intention is not post anythong or at least net the GL impact to zero hence we apply to invoice and Credit(JE) for exact same amount.
a
AK47
08/08/2024, 10:24 PM
I don't see how the GL impact will be 0 unless there is a JE afterwards to reverse the payment. You need to create the payment and apply it to those invoices to clear them. Alternatively, you can add a discount line to each invoice to make the balance $0, but again, this would have a GL impact.
p
Pat
08/08/2024, 10:37 PM
Transactions applied from Credit tab, has an opposite impact it creditss the undeposited fund acct and debits the AR, while those applied under invoice tab debits the undep fund and credits the AR. So the net GL impact for thay would be zero. Notice also the total payment amount if you do thay is 0
c
Chris Corcoran
08/09/2024, 8:51 PM
@Pat reach out to Kevin Ha at CloudExtend (dm'ing you his info). He's tested building a template in Excel that would enable you to upload credits and payments against invoices at the same time use CloudExtend's Excel for NetSuite App.