web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Difference Between Tri...
Microsoft Dynamics AX (Archived)

Difference Between Trial Balance and Retail Sales Transaction

(0) ShareShare
ReportReport
Posted on by Baski2210 66

Hi,

One of my customer cross verifying their retail sales report(without tax value) and trail balance value for sales by every month. But they facing the difference between the retail sales and Trial balance value. I'm not good at finance.  I have verified all the retail transactions value in both ax and sql are same. But Still, I don't know why the difference showing in the trial balance.

Please anyone can give an idea.

*This post is locked for comments

I have the same question (0)
  • Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at

    Could you share a screenshot with an example, where you have a difference?

  • Baski2210 Profile Picture
    Baski2210 66 on at

    Dear Crispin,

    I mentioned the  example scenario in below,

    Store Id Account name              debit     credit         Sales      

    XXXX Sales Merchendise     47000     7319000 7272000

    Retail Sales by range report - without tax 7285000

    727200-7285000= -13000

    * its for per month.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The difference seems to be a 'flat' amount. Can this be related to some extra fees or charges related to your retail sales?

    Can you identify the voucher of this sales transaction and share it so that we can see all of the accounts used?

    Many thanks,

    Ludwig

  • Baski2210 Profile Picture
    Baski2210 66 on at

    Thanks for the suggestions.

    How to compare before posting statement sales transaction lines value and after posted statement sales transaction lines values?

    Any suggestion please?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans