2.08.2011

Receive Payments Does Not Display Invoice Number

Receive Payments Window
A payment from a customer may be partial or in full. It may apply to:
  • A single invoice, or
  • Multiple invoices.
In MYOB, it is easy to apply a customer payment because all outstanding (unpaid) invoices are displayed in the Receive Payments window. If you have a good accounting control procedure that strictly requires a purchase order from a customer and that you loyally enter the purchase order number in the Customer PO# field in the Sales Invoice window of MYOB, then you will have no problem entering a customer payment.

What if your office doesn't have that kind of strict control? This means that it's possible that you don't have a customer's PO. How would you know if a particular payment applies to the correct invoice?

MYOB does not display your invoice number, only your customer's PO number.


One solution is to use the Find Transactions of MYOB. But that's time consuming because you have to go back and forth from one window to another. Take a look at the image above. If you didn't enter a PO# in your invoice window, your only lead to the correct invoice is the date and the amount.

Invoice form window
Better Solution

Enter both your invoice number and your customer's PO number in the Customer PO# field.  For example, if your invoice number is 799499 and your customer' PO number is 123456, in the Customer PO# field of your invoice form, enter 799499--123456. See the example on the right image.

When you open your Receive Payments window, it will display your invoice number. That way, it will be easier for you to locate the invoice that your customer is paying. See the image on top for the example. Both the invoice and PO numbers are reflected.

4 comments:

  1. How about generating an Invoice with partial payment? For example, total amount in invoice is SGD 35,000.00. But there's a need for 30% downpayment, follows by another 30% and upon completion of project, balance of 40%. If the quantity for each items is 1, I will key in 0.3 in the qty column. But what if the qty is 15? This is a real headache for me as I've been searching the website for an answer but to no avail. Thank you. From Amy-Singapore.

    ReplyDelete
  2. Your invoice should indicate the full amount in order to recognize the receivable (so that you would know you still have something to collect). Include a note in the invoice about the terms, in your case 30-30-40. You can insert a line after the last invoice item. That way, your terms are more visible. If there was a down payment, you can enter that immediately at the bottom of the invoice. To remind your customer of the second collection, print out a statement of account instead of an invoice. That way, your customer sees the history of your transactions.

    ReplyDelete
  3. What to do if the invoice already collected, still reflects on the Ageing of Receivables report.

    ReplyDelete
    Replies
    1. Fully settled invoices should not reflect on the ageing report. The Ageing report captures only uncollected items. I suggest that you check the invoice in question. To do that, view the ageing report and drill down the item (a magnifying glass appears when you point your cursor on an amount). Keep on drilling down until you see the invoice in question. Check the items in the invoice that cause your invoice to remain outstanding. Hope this helps.

      Delete

Thank you! I'll attend to your message shortly.