Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS forum

How exactly RMS calculates "SalesTax" amount in [Transaction] (SQL)Table

Posted on by Microsoft Employee

Hi,

Does anybody know how exactly RMS calculates "SalesTax" amount in [Transaction] Table?

Some transactions only have one line (only one record in [TransactionEntry]) but sometimes those tax amount doesn't match up.

One example:

[Transaction] Table (Header):

TransactionNumber SalesTax
001 0.14

[TransactionEntry] Table (Detail):

TransactionNumber Item# SalesTax
001 AA 0.1331

Even rounding into 2 decimal, 0.13 < 0.14... 

Also, we looked at [TaxEntry] table 's tax amount.

We rounded the Tax amount into 2 decimal and sum up by each transaction#, but there are still some transactions have discrepancies between this totaled value and [Transaction] table's SalesTax...

Now we'd like to know how exactly [transaction].salestax value is coming from.

Thank you.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How exactly RMS calculates "SalesTax" amount in [Transaction] (SQL)Table

    Hello,

    Thank you for your reply.

    Our setting is following.  (not "tax-inclusive"...)

    SalesTaxSetting.JPG

    Are there any rounding rules or patterns under this setting?

  • TheNeos Profile Picture
    TheNeos 1,335 on at
    RE: How exactly RMS calculates "SalesTax" amount in [Transaction] (SQL)Table

    Hello,

    Provided that in Store Operations Administrator > File > Configuration > Sales Tax Sales Tax Inclusive is ticked and prices are entered as such,

    Price / (Price/Tax) = tax.

    There may be more than one tax involved.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,888 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,247 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans