Hello, I need to clear old invoices however I need it to not impact the GL balance as the accountant said most of those payables are not in the GL anymore.
Thanks
Hello, I need to clear old invoices however I need it to not impact the GL balance as the accountant said most of those payables are not in the GL anymore.
Thanks
Maintenance, Clear Data, Clear Paid Transactions or Clear Lookup Data depending on what you are trying to remove. Lookup data may also affect inventory reporting, so you should be clear on what you want to get rid of and why.
I should also mention that you should backup your file before you delete anything so you can go back and see it later if you need to.
Hi Richard
There are old purchase invoices from previous years that need cleared from the vendors. There is one issue in which – the ledger doesn’t agree to the GL. So, if I posted a negative invoice to “clear the AP” that may impact the GL balance, but most of those payables are not in the GL anymore. So, the AP listing somehow got unlinked to the GL at some point.
So I am looking a solution to clear the old payables without impacting the GL figures
Thanks
the ledger doesn’t agree to the GL
Are you trying to say you have a Data Integrity problem that you are trying to solve?
if I posted a negative invoice to “clear the AP” that may impact the GL balance
No if about it. It's guaranteed.
I am confused by what you are now trying to accomplish. Fix a data integrity problem or remove some unneeded old vendor invoices?
The second option will not fix the first. But you already have the menu structure to allow you to do the second one. I would work on a copy of your file first to make sure you know how to do it and review the results. Did you try it yet? Because of the modular aspect of Sage 50, when you clear Paid Vendor transactions or Lookup invoices, it does not affect the G/L.
*Community Hub is the new name for Sage City