Harish0412
Level 1

Payments

I'm trying to import customer payment through excel import, We have received a check from parent customer for two different sub customer. If I import this, I'm getting an error that customer's invoice can't be found. But on changing the Ref No in the first column I'm able to import. But each row is considered as different payments. Please provide the right format of excel file to import payments received from single parent customer to different sub customer invoices.

Ref NoPayment DateCustomer Payment methodDeposit To Account NameInvoice NoJournal NoAmountReference NoMemoCurrency CodeExchange Rate
100110-9-2024Partnership Healthplan of CA:Aya AngelesCheckPayments to deposit1001 12TY37465   
100110-9-2024Partnership Healthplan of CA:Cristy JamesCheckPayments to deposit1003 35TY37465   
100310-9-2024UBH Claims Dept:Gabriel NavarroCheckPayments to deposit1002 25AR25441