Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am having an issue reconciling the values in my customer sales report and Acc. Schedule overview. When I run a "Customer Sales List" report using a dimension 'region', I get a different value than when I look at the same dimension for the same period in the Acc. Schedule Overview.
A couple things to note
1. Each time I run the report and look at the Acc. Schedule I ensure that they are ran at the same time - it is not a timing issue as to when I update the analysis
2. Related to the first point - all other dimesions are are giving the correct values. I am using the dimesions to separate different regions, and it is always one particular region where there is an issue so there is something going on with that particular one.
Does anyone have an idea of how to trouble shoot this - I am at my wits end trying to figure this out.
Are you reconciling to the accounts receivables g/l account or the revenue g/l accounts? Worth considering the receivables account is gross whereas the revenue is net. The report itself only looks at customer ledger entries which are invoice or credit memo and calculates the “Sales (LCY)” field per entry it finds. Are you using an analysis view for the account schedule? Only important if region is not a global dimension.
Adding onto what Josh wrote... When I am looking (using) an Account Schedule report I am reading the General Ledger Entries. When I am running a NAV Report like Customer Sales List or Customer Item Statistics, I normally have to ask my developer what are the key values and where are they coming from. In most cases they could be extracted from different sources, that might not match the actual Debit and Credit to the GL Accounts.
Just something I learned over the years to first understand how the amounts are calculated before comparing. This helps.
After a day of digging, i found the difference was created by a data entry error. Thakn you for your response though
Business Applications communities