Finance | Project Operations, Human Resources, ...

How the D365 FinOps calculates the sales tax before and after invoicing?

(0) Share

Report

Posted on by JAYAKRISHNAN M S

145

Hello Experts,

I am noticed that a difference between individual tax amount before (Temporary sales tax transaction from action pane Sell tab -> Tax group -> Sales tax) and after (Posted sales tax from invoice journal screen). Attached the screen shot as bellow,

Temporary sales tax transaction screen.

Actual tax for highlighted row = 3511 * (15 / 100) = 526.65

Debugged the Temporary sales tax transaction calculation and figure out the following steps,

1. Base tax - Sales subtotal / (tax code), Here we are using 15%.

2. Calculated tax at run time - Calculate the individual item sales tax and fill the temporary table and takes sum of the calculation.

3. Calculated difference - Calculated tax at run time - Base tax

4. Find the biggest calculated tax amount and subtract the Calculated difference (from Step 3).

Posted sales tax screen for above same row.

How the calculation are made in FinOps and excited to looking forward to the tax calculation methodology using in FinOps. Any help would be appreciated.

Thank you.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report
Hi sir,

Please refer the logic in the class of TaxTrans>>displaySourceRegulateAmountCur():

display TaxRegulationAmountCur displaySourceRegulateAmountCur(TaxTrans _taxTrans) { // changeDisplaySign = this.doChangeDisplaySign(_taxTrans); // return _taxTrans.SourceRegulateAmountCur * this.taxChangeDisplaySign(_taxTrans.TaxDirection, _taxTrans.ReverseCharge_W); }

regards

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi JAYAKRISHNAN M S,

Is it possible that your users overwrite the calculated sales tax by making use of the adjustment button/functionality in the temporary sales tax group form?

Best regards,

Ludwig

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report

Hi Ludwig Reinhard,

Thank you for the quick response.

In this case, users did not change anything. I had double check as well.

Thank you.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report

Hi Judy Jee,

Thanks for the quick response.

Sorry for made a confusion here. Actually I am aiming the Methodology / Formula like that instead of method and edit the post as well.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

If users did not change anything can this issue be the result of a foreign currency / rounding issue?

Is this a foreign currency order?

Best regards,

Ludwig

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report

Hi Ludwig Reinhard,

We are using the SAR (Saudi Riyal) as Accounting currency and below are the details,

1. Currency in Ledger setup.

2. Currency setup.

3. VAT code setup.

The Customer account in sales order having the same currency (SAR) as well.

ie, Its not a foreign currency order and no rounding rule specified / changed in setup as well.

Also checked in the USMF legal entity with same item price and tax resulting the same, 526.63 (15% Sales) as calculated sales tax amount for 3511.

Thank you.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

This looks to be issue with Tax calculation method

Can you check if your calculation is at Line level or Total (GL > Parameters > Tax)

which gets trigger based on sales tax code on calculation method.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report

Hi Saurabh Bharati,

Thanks for the response.

Calculation is based on Total and here is the shot,

1. GL - General tab

2. GL - Tax options tab

Thank you.

Was this reply helpful? Yes No