Payment Duplicate Issue on Bank Transaction

dev13

Hi All,

 

Can you help me with this? I am having a problem on payment duplicating. 

 

So the flow is like this:

via API

> Invoice created via API (Invoice 14222)

> Payment made in our dashboard, which is the $5,000 created via API automatically allocated in the invoice. (CR000389)

 

via MYOB site (manual)

> User go to Banking tab "Banking Transactions" then look for the invoice (14222) then Match amount and save. 

 

> After that, successfully matched & allocate it to Invoice 14222 (But where does CR000390 come from?)

 

> Then once done, checked the Invoice again, then the Invoice is now Fully Paid (Closed). And see, there are 2 payments now, which is wrong, it should only have 1 payment. 

 

Can you help me what to do? They do this for bank reconciliation.

 

Is there a function via API that says CR000389 should be matched to invoice 14222, so the user won't need to manually match it from their banking transaction for reconciliation? 

 

I am using /Sale/CustomerPayment for the API. Is there other API endpoint that I should use aside from this?

 

Thank you so much!

CloverQ

Hi @dev13 

 

Thank you for the detailed screenshot.

 

Bank transactions can be matched to open invoices, which would create the payment transaction automatically to close off the invoice. In your case, the bank transaction was matched to the remaining balance of invoice 14222, which creates the payment activity of CR000390 thus closed the invoice. 

 

Since the payment was already recorded via API (CR000389), the bank transaction should be matched to this payment instead of the invoice. Please undo the matching then match the bank transaction to CR000389 so there's no double up.