AP Sensitive/AP Aging Report

• 09-15-2008 8:55 AM

  S. Brown Joined on 09-15-2008 Posts 1

  AP Sensitive/AP Aging Report Reply Contact I'm having problems with having my AP aging report tie back to the AP GL account. Why would it be off? Will this have something to do with the date settings? Running the AP Aging report during the month will only show me what is aging at that time, but running the AP Sensitive report, I can set a time frame, but I don't understand why it isn't tieing back to the GL Account for AP. Does Solomon have a certain time frame things have to be posted? PLEASE HELP!!!!

  Tags: solomon, Microsoft Dynamics SL

• 09-15-2008 12:46 PM

  In reply to

  Gail J-N Joined on 03-13-2008 Posts 39

  Re: AP Sensitive/AP Aging Report Reply Contact This can be caused by a number of problems, including future & prior period postings, data conversion issues, data fixed "under the hood", batches incompletely released, and other data issues.   The most common cause, though, is that a journal has been posted to the AP Account directly from GL.   We have a business rule in our accounting department that says the AP AR Accounts can ONLY be posted to from their respective modules - never from GL.   You can check in GL transaction detail for GLTran.Account equal [your AP account] and GLTran.Module Not Equal 'AP'. Another thing I check after that is whether the AP Aged Balance = Vendor Trial Balance (Prior Period Format) = AP Period Sensitive Trial Balance (Historical Format) when all are run currently (with nothing transacting in between).   In theory, all of these reports should agree, and if they don't, you have a data integrity problem.   Check out the AP Integrity Check for some potential solutions. Hopefuly this will get you started. Gail J-N

• 09-15-2008 12:48 PM

  In reply to

  Gail J-N Joined on 03-13-2008 Posts 39

  Re: AP Sensitive/AP Aging Report Reply Contact PS You might also find Knowledgebase article 888149 helpful.   This is available on Customer Source & Partner Source How to reconcile the balances in the Accounts Payable module with the appropriate account in the General Ledger module in Microsoft Dynamics SL (888149 - modified: 2007-11-21) This article describes how to reconcile the balances in the Accounts Payable module with the appropriate account in the General Ledger module on a monthly basis. This article also describes the reports that you can use during the process. Gail J-N