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

Notifications

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans