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

(0) Share

Report

Posted on by Community Member 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

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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

Hello,

Thank you for your reply.

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

Are there any rounding rules or patterns under this setting?
TheNeos 1,335 on at

Like (0)

Report

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.