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

[Andre Juneau]

??Our Customer Aging Report does not reconcile with the GL Trial Balance. The difference changes almost daily, but not always. We have been monitoring the reconciliation on a daily basis for a couple of weeks and we cannot identify any reasons that would cause this. We make sure to request an aging report with the right date and the appropriate Customer Group filter, and, we also make sure that all the transaction vouchers that are posted to the GL AR Main Account have a “Customer Balance” Posting type.
Would anyone know of anything that could be causing these somewhat daily changes in the un-reconciled difference?

——————————
Andre Juneau
Bush Brothers & Company
Knoxville TN
——————————

[Ryan Sorenson]

Hi Andre,
There are four different GL accounts in posting setup.  I assume when you reconcile, you’re reconciling the aging to the total of those four accounts?  You said that all the transactions are ‘customer balance’ and the one account is locked from manual entry.  Is this the same with the other three accounts?

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

[Andre Juneau]

?I’m reconciling the Customer aging (filtered on TRADE Customer group) to the AR Main Account 110110. There are currently no customers assigned to the RET Customer group.
Thanks for bringing this up, because there was indeed some confusion, on our part, with the proper filtering of the Aging Report, prior to my initial post to AXUG.

——————————
Andre Juneau
Bush Brothers & Company
Knoxville TN
——————————
——————————————-

[Trevor Mullen]

Have you run the reconciliation report to see if anything got posted to the ledger but not to a customer? 

General Ledger > Reports > Reconciliation > Customer > Customer

——————————
Trevor Mullen
Staff Accountant
Acuative Corp
Strongsville OH
——————————
——————————————-

[Andre Juneau]

?I never did run the reconciliation report until now. It is very helpful. It did reveal the sources of some of the difference, but not most of it. We’re not looking at very much of a total difference, it’s just that it should tie. Thanks for the tip on the use of that report. We just had our Go Live in November … still learning.
Any other thoughts?

——————————
Andre Juneau
Bush Brothers & Company
Knoxville TN
——————————
——————————————-

[Stacy Black]

Andre,

Can you provide a snapshot of your Aging report criteria?  Also have you confirmed that the AR account is locked for manual entry and that your posting profiles are setup correctly?

——————————
Stacy Black
Senior Application Consultant
MCA Connect
Denver CO
——————————
——————————————-

[Andre Juneau]

?Here’s a snapshot of our aging criteria …

Here’s a snapshot of our Posting profiles … (note … there are currently no customers assigned to the RET Customer group).

And finally, here’s a snapshot of the AR MA 110110 Setup.

——————————
Andre Juneau
Bush Brothers & Company
Knoxville TN
——————————
——————————————-

[Stacy Black]

Hi Andre,

A couple other items that I notices were:

Your Criteria was set for Due date, this could bring an imbalance since some customers may not have the same due dates.  A better method would be to use Transaction date.  This is the date the invoice was posted to the GL as well.

Payment positioning – if you have anyone who makes overpayments or payments on account you will want to include that amount in your balance as well.

Another item recommend as part of your month end is to run the “reconciliation” reports in the General ledger (General ledger>  Reports> Reconciliation).  These reports will show you any transaction that has not properly passed from the sub ledger to the GL and vice versa. 

In each of the areas (Customer, Bank, Vendor, etc)  you set your monthly date parameters and choose your posting profile.  Make sure you select for differences only so you only see those that are issues.  Your goal would be to have a report that comes back blank.

——————————
Stacy Black
Senior Application Consultant
MCA Connect
Denver CO
——————————
——————————————-