Dynamics Community Forum Thread Details

Vendor&Customer/Ledger reconciliation

Best practice tips to avoid problems with Vendor & Customer reconciliation

Within this blog post I will summarize some of the most important tips and tricks that you should take into consideration when setting up Dynamics AX to avoid reconciliation problems between the Ledger and Vendor& Customer data.

Tip 1: Group posting profiles

Don't change vendor group , in case of this vendor had already posted transactions on it.Because Vendor and customer balance list reports depends on group posting profile .

Example:

Vendor #1 had transactions on ledger account related to group X by 100 $ , after that you changed the group to be Y.

In ledger account X balance will be 100$ but in vendor balance list report balance will be Zero on group X and 100$ on group Y .

Also it will affect in reconciliation report in AX .

48185.1.png

6082.2.png

solution :

Reallocate the amounts from old group to the new one .

Tip 2: Main account setup

Lock all ledger accounts that have been setup in the Vendor and Customer posting form for manual entries as shown in the next screenshot .

Users mustn't use these accounts for manual entries .

1234.3.png

Tip 3: Don't duplicate the voucher transaction

Don't duplicate the voucher transaction on different lines with different vendors or customers , it will affect in reconciliation report in AX, the report depends on the voucher to generate the amount so in this case it will duplicate the amounts .

0638.4.png

87771.5.png

solution :

Use record ID from table (ledgerJournalTrans) to get the correct amount per line.

Alternative methods for reconciling inventory with General Ledger

Approach 1

Use Vendor&Customer/Ledger reconciliation report Vs summary trial balance Vs Vendor&customer balance list report .

General ledger > Reports > Reconciliation > Vendor &Customer.

General ledger > Reports > Transactions > summary trial balance.

Accounts payable & receivable > Reports > Status > Vendor & Customer balance list.

Approach 2

To compare posted amounts on specific ledger account Vs Vendor transactions.

View posted journal entries for the main account Vs History by transaction report.

Accounts payable & receivable > Reports > Transactions > Vendor & Customer> History by transaction.

8637.6.png

implementing these practices will safeguard against problematic transactions that can occur in the future,and will make you able to use other reports like Vendor and customer aging confidently .

Thanks.

Quick Links

Leaderboard