Hi, I am writing a script for a customer to generate bulk CSVs for their Cash Receipts Journal import. They are using Peachtree 2017 (Quantum Accounting). 

These are sales receipts to be applied to their customer invoices (seen in Receive Money section under Customers & Sales). 

We have got the import working now, to apply the payments to invoices. However, thus far we have had to manually specify every invoice number to apply for each payment. 

My question is: is it possible to import receipts via CSV, have them applied to invoice, without specifying the invoice numbers? We want SAGE to automatically select the invoice(s) to apply based on the amount, like what happens when you create a new Receive Money transaction in the GUI. 

I tried removing the "Invoice Paid" field, but I get errors that the "G/L Account" field is required (which is not used for Apply to Invoice transactions). If I leave it blank or put an invalid invoice number, it errors on import. 

Am I missing something here? Is there another field that I need to include that SAGE is not telling me? Or is automatic apply to invoice not possible from CSV import? 

Here is the field list help documentation I've been following for reference:
http://help.sage50.na.sage.com/en-us/2017/sage50us/Content/IEFIELDS/IEFIELDS_Cash_Receipts_Journal.htm

These are the fields we are currently using in the import:

Here is an example of a CSV file used for import testing:

TEST1234,TEST1002P,04/27/2018,Cash,1020,-10.00,,1,TEST0001,0,,-10.00