Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Different numbers - Ac...
Small and medium business | Business Central, N...
Answered

Different numbers - Account Schedule vs. Customer sales list

(0) ShareShare
ReportReport
Posted on by themanjosh 85

Hello,

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.


Thank you!

  • themanjosh Profile Picture
    themanjosh 85 on at
    RE: Different numbers - Account Schedule vs. Customer sales list

    After a day of digging, i found the difference was created by a data entry error. Thakn you for your response though

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Different numbers - Account Schedule vs. Customer sales list

    Hello,

    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.

    Thanks

    Steve

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Different numbers - Account Schedule vs. Customer sales list

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans