Clearing Client Paid Transactions with Sage 50 Cloud, how?

SUGGESTED

HI all,

Our business has some long term clients, with a huge list of invoices and payments.  To prevent the client statement from getting too long, every year we clear the old data, to reduce the length of our receivables->client aged report.  We need to mail these statements to our clients periodically.  

We have been using Sage 50 Premium for many years.  The process always worked flawlessly before.  This year we switch over to Sage 50 Cloud.  The program itself is still being run on our PCs, but the data file is now online with Sage.

Just like before, we first linked & applied all old transactions, invoices and payments.  These transaction zero each other out.  Next as before we do maintenance->clear data->clear paid transactions->clear paid client transactions

Then we select one client as an example, and attempt to clear.  We did click "clear lookup data from all paid transactions".

To our dismay, the client statement stayed just as long with all the old data!  The data in them is cleared (when we double click them, the old data said "There is no data to Report".  But the client statement didn't reduce in size and still  include all the old invoices and payments listed.  As I mentioned we must be able to get rid of these old invoices and payments once a year, else the statement is too long.  I don't see any reason why this didn't work, except that we switched to Sag 50 Cloud this year.  Everything we did was the same as before, and it used to work.

We don't want to attempt to clear any other client's data, until we get this client's statement working.

Thanks for your help!

Parents
  • 0

    I have no experience with using Remote Data Access but I understand some things cannot be done if you are still sharing the file.  It is possible you need to unshare before you can do some things like removing data.

    However, can you have a look at the Statement options in the image below.  You can find this under Setup, Settings, Receivables, Options.

    If you are using the second one, you should consider the first one marked by the red arrow.  I always use Zero in the box so fully paid transactions are not shown on the statements.  Will this help you keep your historical data and still get a statement that shows pertinent information?

Reply
  • 0

    I have no experience with using Remote Data Access but I understand some things cannot be done if you are still sharing the file.  It is possible you need to unshare before you can do some things like removing data.

    However, can you have a look at the Statement options in the image below.  You can find this under Setup, Settings, Receivables, Options.

    If you are using the second one, you should consider the first one marked by the red arrow.  I always use Zero in the box so fully paid transactions are not shown on the statements.  Will this help you keep your historical data and still get a statement that shows pertinent information?

Children
  • 0 in reply to Richard S. Ridings

    Hi Richard.  Thanks for your reply.  Unfortunately that (changing the days to 0) didn't help.  The client aged report still shows the old transactions, some as old as 2018.  These transactions are indeed cleared, because we don't see them anymore when we use "Receipts" for this client.  

  • 0 in reply to CCHIPSS

    I am confused.  Your first post indicates

    To prevent the client statement from getting too long

    Did my suggestion to remove the fully paid transactions from the Customer Statement?  Are you actually running the statement from Reports, Receivables, Customer Statements (option at the bottom - see first image below).

    A different problem is how to remove paid transactions from the customer aged report.  You need to use a different reporting option on the report (See the second image below).

    Customer Aged Reports and Customer Statements are different things according to the program.

    The Receipts module has an option to Include Fully Paid Transactions on the Receipt menu.