Dynamics Community Forum Thread Details

Old AP transactions on Aged Trail Balance can't be cleared off

September is our FYE and I've been trying to clear up everything that has been cluttering up because it wasn't handled correctly on the front end. I have a few transactions in AP that need to be removed but because they are from the previous year they won't They have a net zero balance, the Aged Trail indicates an unposted credit document that has been applied, yet there is nothing to post. I have showing an invoice and payment but it isn't cleared from the AP trial. Any suggestions on how to remove before I close the year. Thanks,

I have a few suggestions:

First, go to TRANSACTIONS >> PURCHASING >> APPLY PAYABLES DOCUMENTS, and try to apply your transactions there. If that solves your issue, great! If not, keep going with these suggestions.

Next, try running the unmodified version of your Aged Trial Balance. Go to MICROSOFT DYNAMICS GP >> TOOLS >> SETUP >> SYSTEM >> ALTERNATE/MODIFIED FORMS & REPORTS. Select an ID (many times there is only one), change the TYPE to "reports" and then expand the PURCHASING node so that you can find your Trial Balance Report. Please note, there may be more than one listed, because there are different TB reports that you may be using. Expand the node for the report you are using, and change it the unmodified report. (It will say simply "Microsoft Dynamics GP.") Save your change and then re-run your aging. If the report now shows correct data, then the problem is with your modified report.

If you still have an issue, you can try running both the Check Links and Reconcile utilities. Check Links can be run by going to MICROSOFT DYNAMICS GP >> MAINTENANCE >> CHECK LINKS. From there, change the "series" dropdown to PURCHASING, and then click the ALL button in the middle of the screen. Click OK and send the report to the screen.

Reconcile can be run by going to MICROSOFT DYNAMICS GP >> TOOLS >> UTILITIES >> PURCHASING >> RECONCILE. In this window, there are five different reconcile options. You may have to run the reconcile utility up to five times, once for each of these options, in order for the utility to correct the problem.

Once you run both the Check Links & Reconcile utilities (possibly up to 5 times), try your aging report again.

Hopefully, these suggestions will solve your problem for you. If they do not, post back here for more assistance, or contact your GP consultant for more detailed troubleshooting.

Quick Links