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 No | Payment Date | Customer | Payment method | Deposit To Account Name | Invoice No | Journal No | Amount | Reference No | Memo | Currency Code | Exchange Rate |
| 1001 | 10-9-2024 | Partnership Healthplan of CA:Aya Angeles | Check | Payments to deposit | 1001 | | 12 | TY37465 | | | |
| 1001 | 10-9-2024 | Partnership Healthplan of CA:Cristy James | Check | Payments to deposit | 1003 | | 35 | TY37465 | | | |
| 1003 | 10-9-2024 | UBH Claims Dept:Gabriel Navarro | Check | Payments to deposit | 1002 | | 25 | AR25441 | | | |
