Færdiggjort

fix MS SQL script error

Hi,

We have a script to calculate Item price and VAT.

We get a wrong result in terms of precision.

IMPORTANT: variable must be the type of decimal(9, 4) and using of TRUNCATE is not allowed

Let's say the unit price Includes tax = 2.1, and Exclude tax = 1.8261,

we need 1000 items so the total cost Includes VAT should be 2100 (Unit price Inc. VAT * Quantity).

Now, let us calculate it by the unit price excluding the VAT.

First, we find the taxable amount which is (Unit price * quantity) is 1826.1

The tax is 15%, so we compute the VAT, which is (taxable amount * tax rate) is 273.9150

Finally, we need to find the total include tax which is (Taxable amount + VAT) the result is 2100.02

That's unexpected! We expect 2100.

How to solve this issue

Evner: Microsoft SQL Server, SQL, Database Administration

Se mere: fix script error cost, script error fix, fix cgi script error 500 oscommerce, internet browser script error fix, fix script error joomla virtuemart, fix script error warning, fix youtube script error, fix stop script error firefox, fix youtube script error message, fix sql script freelance, fix oscommerce sql error, script error fix free, install shield sql script create user error 27502, execute ms sql stored procedure perl script, execute perl script ms sql server, fix script error tube, ms sql script bak file, http error 404 problem accessing reason not found powered by jetty 9.4 z snapshot, http error 404 problem accessing reason not found powered by jetty:// 9.4 z snapshot

Om arbejdsgiveren:
( 27 bedømmelser ) Riyadh, Saudi Arabia

Projekt ID: #32229441

Tildelt til:

Ghazik

Hello I am ready to work on your fix MS SQL script error task. please send me message for further discussion. Thanks

$10 USD in 7 dage
(0 bedømmelser)
0.0

8 freelancere byder i gennemsnit $21 timen for dette job

rsinfotechindia

Hi There, I'm interested to work on your project regarding fix MS SQL script error I am an expert PHP/WordPress designer and developer who has 7+ years of experience in designing and developing an awesome website bas Flere

$30 USD på 1 dag
(1 bedømmelse)
3.8
aap31374

I have more than 15 years of experience in SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very g Flere

$25 USD in 7 dage
(5 bedømmelser)
3.3
skyappweb

Mobile Apps Development expert with several apps listed in own Google Play Store Account Start-to-end Web & Mobile apps development We’re empowering teams to achieve greatness together. We are a passionate team of s Flere

$25 USD in 3 dage
(0 bedømmelser)
0.0
akiramayya05

I have strong knowledge on SQL tables. I have created 50+ tables and Stored Procedures I have written lot of complex queries also. Please contact through chat, i will start your work if you ok .

$20 USD in 7 dage
(0 bedømmelser)
0.0
rsinghrahul

I am a certified MySQL developer. Working as a professional software Engineer in TCS. I have good and long term experience in writing sql queries.

$20 USD in 5 dage
(0 bedømmelser)
0.0
abmojahed

dear, im expert at mssql server i can help you to rezovled you problem a full stack developer with more than 20+ years of experience. Regards

$30 USD in 2 dage
(0 bedømmelser)
0.0
m7almasoud

Hello I am a database developer and I have done something like that before. For more details contact me.

$10 USD på 1 dag
(1 bedømmelse)
0.0