How to Import AR Payments against an Invoice using the SO number

Hi, @wfilipiak67 

Through import scenario, you want to apply the Invoices to Payment to close the Payment and Invoices for the completed Sales Order? Please confirm.

Yes. 
The sales order has been shipped, Invoice created & released. 
Then the client then gets a file with the payment amount for the Sales Order. 
So all we have is the Sales Order number. 
We are setting the Customer Order Nbr. field to the sales order, with the hope that that can be used to select the correct Document in the Grid.

If the sales order is open, the payment can be applied against it via the Orders to apply tab. (thanks for that assistance) 

Here is the Import Scenario that accomplished the task. The Highlighted section is the Trick. 
Thanks to Rodgrio for the Assistance.
 

I’ve never seen that format for the highlighted section.  Did you manually type that in with the arrow?  Is this trick in the documentation at all?  Thanks, looks like it will be useful in the future!  Glad you got it working as well.

Edit: Any chance you can post the XML export of the scenario? Thanks either way.  

Noah,

The arrow section is available in base imports. Since I was in a grid, I thought I needed to use a custom key.  The Arrow acts like a search by. It is available for lots of fields in the Import Scenarios. 
 

Here is the import