When generating statements up to a particular date (e.g end of last month) MYOB provides a useful tickbox option - "Only included statements up to invoice date". However, you don't honour the "Includ...
Hi Jeanie,
I do understand your dilemma and it is one that has confronted other users in the past and will continue to do so and perhaps made difficult to efficiently resolve with the advent of AccountRight Live.
I believe the problem stems from what is set as Trading Terms for your customers within your company file. Please see the following link where it has been discussed:-
Printing/Emailing Statements to only include previous month invoicing
User GazzaA responded privately to me saying:-
Thanks for your response. Yes, I understand your explanation, however I have a situation were I was sending Statements as at Dec 31, and have only one Invoice dated Jan 1 for a customer who I know has no other invoices outstanding.
This customer still appears in the list of Statements to be printed/emailed. My query is - why does this customer appear in the list when the filter is set to show only outstanding invoices dated prior to Dec 31?
Hope this makes sense
I responded privately saying:-
The only way I know is to avert that situation is to restore the backup of the company file (and giving it an appropriate name) done after close of business each month (on the last day of the month) and then run print/email statements from that restored company file when statements are required based on the end of that previous month. Once they have been run I then close and remove it.
The Trading Terms are again encumbering your specific instance as AccountRight identifies that although there is no outstanding invoices as at 31/12/2012 but there is one dated 1/1/2013 so it thinks "I need to print a zero balance statement to let the customer know that as at 31/12/2012 they are starting from a zero balance". It does seem a bit silly but in accounting terms it is a reasonable concept.
--------------------------------------------------------------------------------------------------------------------------------
My suggested workaround to avert that situation may be difficult or unmanageable to do in AccountRight Live so I believe this issue now needs thorough analysis and resolution from MYOB; therefore I have voted for it