Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steven Kfare]

Hello,

We are running AX 2012 R3. We are noticing that our A/R sub-ledger does not agree with the A/R account in the General Ledger. The General Ledger account is to not allow manual entry. So we are not sure how the the two ledgers are not in sync. #FinancialAccounting?

——————————
Steven Kfare
Senior Business Analyst
The New York Times
New York NY
——————————

[Ryan Sorenson]

Have you done the year end close process for 2017?  I’m wondering if you’re finding that AR reconciles through 12/31/17 but they don’t reconcile in January 2018.  If the balances haven’t been carried forward to 2018, or are needing the process run again due to transactions being posted in 2017 after the most recent YE close, then this would throw off your GL balance.

If that’s not it, the report Shirley mentions is good to start with.  If that doesn’t identify the issue, the other thing you can do is go to the AR account’s transactions, and filter to exclude any transactions with a ‘Posting type’ of ‘Customer balance’.  This is because transactions that are typical AR transactions such as invoices, payments, etc have a posting type of customer balance.  So by excluding those you’ll be able to see unexpected transactions.

——————————
Ryan Sorenson
Sunrise Technologies, Inc.
Riverton UT
——————————
——————————————-

[Shirley Adams]

In D365 there is a report called “Customer to Ledger reconciliation report you can run in the AR module Inquiries and Reports – it doesn’t always catch things, but is a good first step.  As a best practice, it’s good to do this reconciliation between AR and the GL accounts monthly to avoid having to dig through too many entries that are hitting one account (along with AP, Inventory, etc.). 

It could be a lot of things:  other modules posting to the same accounts  (project accounting, AP, etc), things posting from AR that shouldn’t be – cash discounts or some other auto posting.  The best way to find it is to start with the reconciliation report and then dig into each transaction – I usually export to Excel and then work from there.

——————————
Shirley Adams
AKA Enterprise Solutions
New York NY
——————————
——————————————-

[Steven Kfare]

We are on AX2012 R3. I don’t believe such a report exist in that version. If it does it is not under inquire. I will need to check with the users to see if this was an issue in the prior year when we went live or if just started in 2018.

——————————
Steven Kfare
Senior Business Analyst
The New York Times
New York NY
——————————
——————————————-

[Ryan Sorenson]

In 2012 that report is in a different location – GLReportsReconciliationCustomerCustomer.

——————————
Ryan Sorenson
Sunrise Technologies, Inc.
Riverton UT
——————————
——————————————-

[Christi Weber]

?We are also in AX 2012, but R2 instead of R3.  It takes a little bit of time, and is somewhat of a manual process, but what I would do is run the AR Aging Report without details by month and compare your totals to your General Ledger totals until you find the month that you are off.  Once you find the month you are off, you can export your General Ledger entries to Excel and pivot by the financial dimensions to get your totals by customer.  You can compare the totals by customer to your AR Aging report to see which customer balance does not match.  Then you can look at the customer transactions to see which one is causing your problem.

Early on in using AX, we had this problem due to interest invoices, but were able to correct through a simple general ledger entry.

I hope this helps!

——————————
Christi Weber
Accountant II
ICM Inc
——————————
——————————————-

[Suzanne White]

?Good Morning,
I guess my post yesterday did not send.   Do you use the Prepayment function?  If you do, then the balance of the GL for AR less the balance in the Prepayment account will reconcile to the Total balance of the aging report. If you already know that, then try the reconciliation function.  I have never had to use that. We are also in AX2012R3.   I

——————————
Suzanne White
Accounting Manager
Kai USA Ltd
Tualatin OR
——————————
——————————————-