Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Vendor&Customer/Ledger reconciliation

(0) ShareShare
ReportReport
Posted on by 206

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.

*This post is locked for comments

  • mseddek Profile Picture
    mseddek 206 on at
    RE: Vendor&Customer/Ledger reconciliation

    Hi

    Okay, thanks .

    I will check blog site.

    Regards

    Mohamed

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Vendor&Customer/Ledger reconciliation

    Hi,

    This is the dynamics community forum; not a blog site.

    Please do not use this forum in the future for sharing such kind of information but rather specific blog sites that you can synchronize with the dynamics community.

    Thanks,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans