1
RefNumber on Customer Payment Imports
Question asked by Sean Pearson - 6/27/2024 at 5:30 PM
Unanswered
Hello, we're trying to import customer payments from a spreadsheet, and there will often be multiple lines with the same refnumber. Is there a simple way to do that without producing an error? Thanks in advance.

2 Replies

Reply to Thread
0
Steve Replied
Employee Post
Hi Sean, if there are multiple lines with the same Ref Number then Axis uses that number to group the rows on the same Customer Payment transactions.  Is that what you wanted to do?
Steve Batten
0
Sean Pearson Replied
So here's my problem.  My client receives ACH payments along with Excel based payment vouchers for their larger customers. Many of these customers are setup in QuickBooks as customers by location (there is no customer/subcustomer relationship due to how their integrated CRM works).  When they receive a payment, the amount is spread out over many customers.

For Example, I receive errors when I try to import the following:
 
CustomerRefFullNameTxnDateRefNumberApplyToInvoiceRefTotalAmountPaymentAmount
Acme-Los Angeles7/9/202412345645985851.01504.46
Acme-Whittier7/12/202412345644995851.01346.55

When I check the log file, I see the following error:

ReceivePaymentStorage::VerifyInvoiceTxnID    The TxnID doesn't match an invoice to pay for the specified customer:job and AR account or the invoice is already paid.

What am I doing wrong here? Does the TotalAmount have to equal the total amount paid by a particular customer or can it be the total amount of the entire import? If they receive a large payment, it could be tied to 50 customers - but I'm using the same reference number. It would not be feasible if we had to do 50 separate imports of 1 line each when we receive payment vouchers.

Please help ASAP.

Thanks, Sean

Reply to Thread