Failed to apply receipt through Autolockbox

 Hi,

I am trying to simulate the Autolockbox form submission with CONCSUB program.

1) Upload the data to ar_payments_interface table

2) execute process lockboxes, to create the new transmission information

3) update the ar_payments_interface with relevant information for new transmission ID.

4) execute process lockboxes, to submit validation for the new transmission information

 After upload, it seems the receipt header can uploaded successful, but it can’t link with the invoice for “applied”

 

Case 1 – receipt amount = 0, can’t applied to any transactions

1)       invoice A, amount = 288

2)       Debit note B,  amount = -288

 

Case 2 – receipt amount = 704, applied to another transaction (e.g invoice C with full amount).