Getting rid of a paid sales invoice

Hi PFCCOG 

To help you with the query please refer to this Help Article: Deleting a transaction. Just note that there are a number of restrictions when deleting transactions. Your security preferences and user role must allow deleting, the transaction can't be in a locked period and the transaction must be in your current financial year, which the Help Article I have provided also explains and gives instructions to.

Please let me know how you get on, and if you require further assistance. 

Thank you for responding Jesh_D.

I don't want to delete the sale. I need to show it as paid and don't know how to do that.

Sorry, I didn't make myself clear in original post.

Hi PFCCOG 

Thank you for your response and clarification. You can follow the steps on how to record payments against invoice to show them as paid by following the instructions in this handy Help Article: Receiving Payments.

Once you have followed the steps, the invoice/s in question will be paid and therefore can be closed. Please let me know if you have any further questions I can assist with.

Thank you again for your quick response but my question has not been answered yet. I know how to receive payments.

Let me try and break it down again...

This customer is the head office for a group of individual companies that buy from us. Head Office paid a lump sum of $20,000. I entered the payment through Banking/Receive Money into our bank account. I then went into Sales/Receive Payments and deposited each individual store into the Debtors Clearing Account. I then went into Banking/Reconcile Accounts and reconciled the Debtors Clearing Account making sure that the deposits column amount matched the withdrawals column amount (which it did). 

Every month since February I have been chasing this one customer for payment of the overdue $110. They sent me the remittance from Head Office which showed that $110 was paid as part of the $20,000 lump sum.  Somehow I didn't allocate the $110 into MYOB so it's still showing as outstanding. They have definitely paid this $110 but I don't know how to show it as paid in MYOB since it was allocated in February and I've already reconciled and done the BAS for February (Q3).

Do I need to unreconcile the bank account and start over with the payment allocation?

Hi PFCCOG , if I may suggest - if you have balanced the $20,000 without paying off the $110, then one of the other store's accounts must have had $110 applied to it incorrectly. Perhaps if you run the Sales - Customer Payments (closed invoices) report for the date you recorded the store accounts as paid, then compare it with the remittance from head office, you may find where the problem lies. 

(You may need to run this report to Excel and add a column totalling the net sale and the GST amount). 

Thank you so much Mike! I didn't know that report existed!

Now I'm even more confused because there are no other invoices I have allocated the $110 to yet the debtors clearing account is balanced :(

Is there another way I can mark it as paid?

Thank you Mike. I'll try work it out. :)