Notifications
Announcements
No record found.
I began working for a company which is still using the long out of support version 9.0. I do not know if the previous controller ever used the system generated aging he stopped at least 10 years ago. It therefore has many problems, including but not limited to ancient invoices still on the aging with un-applied payments, credit memos, anything that could be done wrong has been done wrong. This person was let go 1-2 years ago. His replacement attempted to get this mess cleaned up but ultimately she got out of Dodge. I need to wipe out everything prior to 2019 repopulated the aging with legitimate receivables. There is no budget for upgrading to the current version of DynamicsGP which would be my first choice. In some instances I can create a credit memo and apply it against the invoice in other instances, in spite of being a listed invoice, I can't apply a payment. There are also 100 or more payments & credit memos that were applied but not posted. The G/L is millions of dollars off from the aging. I would welcome any insight into a way to eliminate this problem. I've thought about creating a new A/R account but I'm confident the aging would stay with the old A/R account. I suspect the the A/P aging is in even worse shape but that is some other poor sucker's problem at this point in time. The only thing that occurs to me is creating a new company file but there is a huge amount of A/R invoices and payments that would have to be reentered or imported. Does anyone have any ideas beyond find another job?
Hi,
Are you using the Bank Reconciliation of your GP as that will need to be taken a look at too. :(
1. Is the amount in your GL, the correct AR Amount?
2. What would be the basis to get the real AR Amount?
Is the bottom line aging total completely out of whack with your GL AR balance? Can you at least get to GP 10? If so, the GL Reconcile routine will help.
support.microsoft.com/.../information-about-differences-when-you-reconcile-general-ledger-to-pay
Yes, the bank reconciliation is being used. The bank rec is in better condition than the A/R & A/P agings but the bank reconciliations are done by other people. I can look at them but they have some problems as well.
I've been an accountant for 38 years, I've seen good sets of books and I've less good sets of books. I have never seen a worse set of books than these. I trust nothing.
#1. No, the G/L balance for A/R is even worse than the aging. The previous controller used a spreadsheet as the aging. Our best bet is to come up with a reasonably accurate aging and plug the G/L to get in balance and then keep it in balance.
2. A magic wand would be nice... I literally had open invoices from 2014 through 2018 and credit memos, debit memos, payments. My theory is to post all un-posted items that are not recent to get rid of them. We have chosen 1/1/2019 as the date from which we would reconcile the invoices and payments. If I could erase everything prior to 1/1/2019, I would. Then look at the invoices and payments to verify a reasonably accurate receivables balance. For the staff we have the invoicing is very high volume at modest margins.
We do not have access to GP 10, if we upgraded we might as well go current. The owner waffles but the fact is there is no money for an upgrade with this Covid pandemic. Some of our biggest customers are airlines which aren't exactly buying right now... I have no choice but to use what we have.
If you have unposted cash receipts and credit memos you can pull them up and apply them to invoices. Somewhere along the way you will need to get to a point(date) as your cutoff. You can turn off posting to the GL and enter transactions that will allow you to move everything to history. Most likely in the end you will need to enter a ledger entry to get the GL AR balance in agreement with the AR AR balance. The same thing will need to happen on the AP side. Do I dare ask when was the last year GP was closed?
The last year that GP was closed was 2018. The A/P & A/R modules have never been closed individually. How do you turn off posting to the G/L? Strangely enough, the last time I ran GP was in 2007 when this same version was installed new at another company. It didn't need cleaning.
I was hoping you had registration keys for GP 10. They would be free. Can you log into CustomerSource or have you been cutoff? If you are still in contact with your reseller they may be able to help.
Tools->Setup->Posting->Posting you select the module and unclick the box to post to the GL. It sounds like you a really deep hole here. If you want to send me your phone number via a private message I will call and get you started.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
