Is there a way to CSV customer payments that has b...
# ask-stanley-ai
a
Is there a way to CSV customer payments that has both the invoice and the credit or journal you are applying on the customer payment all in one
c
AI generated answer (using internal Slack threads):
Yes, it is possible to CSV customer payments that have both the invoice and the credit or journal you are applying on the customer payment all in one. However, the process is a bit complex and requires a few manual steps before you can import the CSV. Here are the steps: 1. First, you need to create the payment manually and select some invoices manually so that the total amount of invoices is greater than the total amount of credits. 2. Once the payment is saved, you can then use a CSV import to update that payment and apply more invoices. This method is particularly useful when dealing with hundreds or thousands of invoices. It allows for CSV importing of payments without any development work. As for applying journals, the GL impact will not be zero unless there is a journal entry 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. Transactions applied from the Credit tab have an opposite impact, it credits the undeposited fund account and debits the AR, while those applied under the invoice tab debit the undeposited fund and credit the AR. So the net GL impact for that would be zero. Notice also the total payment amount if you do that is 0. Please note that this method does not allow you to apply multiple unapplied payments to existing JEs for customers via CSV. Only customer payments can be applied to invoices via CSV. If you need to apply multiple unapplied payments to existing JEs, you would need to use a script. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.882263243
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.875854552
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.865173399
Please provide your feedback on this answer.
b
Not really, at least not through the native Customer Payment CSV import. NetSuite only supports the Invoices sublist there, so you can apply the payment to one or more invoices, but you can’t include the Credits sublist or an A/R journal application in the same CSV.