Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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 .
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 .
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 .
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 .
Use record ID from table (ledgerJournalTrans) to get the correct amount per line.
Alternative methods for reconciling inventory with General Ledger
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.
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.
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 .
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.
Okay, thanks .
I will check blog site.
Business Applications communities