jeanie's avatar
jeanie
Experienced Partner
12 years ago
Status:
Open

Statements: Don't produce statements with $0 owing

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 "Include customers with zero balance" tickbox in concert with the previous option. i.e. you still list all these zero balance statements on the basis of the fact that the actual balance of the account is not zero (because of invoice(s) AFTER the specified date).

 

"Suppress the printing of statements with $0 owing"

Sales
statements
  • Matthew_W's avatar
    Matthew_W
    MYOB Staff
    11 years ago
    Status changed:
    New
    to
    Open
    Hi jeanie, thank you for your suggestion. It would be great to see some feedback from the community about this change to see how they would like to see it work as an alternative.
  • TonyLane's avatar
    TonyLane
    Ultimate Cover User
    12 years ago

    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