Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 40

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 21st February 2007, 23:26
Mick Andrus Mick Andrus is offline
Join Date: Apr 2002
Location: South Carolina
Posts: 53
Mick Andrus is on a distinguished road
Baan: Baan Vc0 - DB: Oracle - OS: AIX
Seeking explanation of tax calculations Net, Gross, etc.
Baan: Other/Unknown

I would appreciate if someone can describe for me how the tax calculations are supposed to work in Baan 5.0c. I'm the IT Director of our company and I'm currently in a disagreement with a consultant on the nature of tax processing. I have gone to Baan Support but I can't get an explanation I can understand.

We are implementing a VAT tax system for one of our companies. There are three tax settings that can be entered in tcmcs0136s000: Net, Gross, and Gross over Hundred.

I'll use a manually entered purchase invoice as an example. My understanding is that when I use tfacp1110s000 to enter an invoice for processing I should get results like these based on the tax type in use on the tax code I'm using for the invoice.

Invoice amount = 100, tax rate = 17.5, tax calculated = 17.50

Invoice amount = 100, tax rate = 17.5, tax calculated = 14.89

Gross over Hundred
Invoice amount = 100, tax rate = 17.5, tax calculated = 17.50

Further, if after entering the invoice amounts I then go to enter detail lines using session tfacp1112s000, using the Gross over Hundred method the system reduces the invoice amount to 82.50 and leaves the tax calculated amount at 17.50.

In our system, using the Net method the system I enter an amount of 100 and the system treats it like a Gross calculation, calculates a tax of 14.90 and reduces the invoice amount to 85.10.

This Net calculation doesn't seem right but Baan Support says that this is the way it is designed to work.

This seems like a simple topic but I'm having trouble getting a simple answer. Can anyone help explain it to me?
Reply With Quote
Old 22nd February 2007, 12:37
Andreas's Avatar
Andreas Andreas is offline
Senior Member
Join Date: Nov 2001
Location: Hannover
Posts: 263
Andreas is on a distinguished road
Baan: ERP LN FP5 - DB: Oracle 10g - OS: AIX, SLES
It's correct

Hi Mick,
although this seems a little confusing the calculation is correct.
Depending on the Tax Setting you have to enter the net or the gross amount.
Let's take your example.

Tax Setting:
Enter in tfacp1120s000 the Gross-Invoice-Amount (The Label says Grossamount)
Tax Value = 100 *17.5/117.5 = 14.89

Enter in tfacp1120s000 the Net-Invoice-Amount (The Label says Netamount)
Tax Value = 100 *17.5/100 = 17.5
Nevertheless you have to insert The Gross-Amount in tfacp1110s000, in this case 117.5. On the third Form of the session you can see the Netamount.

Gross over Hundred:
Tax Value = 100 *17.5/100 = 17.5
In this Case you have to enter the Gross-Amount in tfacp1120s000 if you define the Tax-setting at detail level.
If you define it on Invoice level then indeed the Amount is reduced to 82,50 , but also Label changes to Netamount.

The same with Net-Method defined on Invoice-Level. If you go to tfacp1120s000 and save the data the label changes to Netamount.

You can always confirm on the third form of tfacp1110s000.

Hope this helps,
Jazz is not dead, it just smells funny!
Reply With Quote
Old 2nd March 2007, 22:03
Mick Andrus Mick Andrus is offline
Join Date: Apr 2002
Location: South Carolina
Posts: 53
Mick Andrus is on a distinguished road
Baan: Baan Vc0 - DB: Oracle - OS: AIX

Thanks Andreas. This is a good explanation.
Reply With Quote
Old 7th March 2007, 10:51
Leerkes Leerkes is offline
Join Date: Mar 2007
Posts: 61
Leerkes is on a distinguished road
Baan: BaanV, LN - DB: Oracle - OS: Unix
Exclamation Tax calculation

If in Baan a tax calculation should take place, then the system needs to know whether the base amount on which the tax calculation should take place, should be interpreted as gross, nett or gross over hunderd.
This information is stored on the tax code, which you already discovered.

Your example however with tfacp1110s000 is not a very good one, because there this is not applicable. I will explain why:
The total invoice amount which is at the bottom of each paper invoice consists of net amount, tax amount and late payment surcharge. This amount is the amount which should (per definition) be filled in on the first form of tfacp1110s000. This means that the invoice amount in tfacp1110s000 is per definition a GROSS amount. If you choose tax on header, then no matter what tax code you will be chosing, the tax calculation will always be done by interpreting the invoice amount as Gross. You might say that then also only tax codes of type GROSS should be allowed with tax on header in tfacp1110s000, but apparently the designers did not want to force users to create for each tax code a net and a gross variant.

The other reply about tfacp1120s000 is correct, because if you have tax on line with a cost invoice then the amount in that session is interpreted depending on the tax country/code.

Reply With Quote
Old 23rd September 2014, 03:08
Perfectshark Perfectshark is offline
Junior Member
Join Date: Aug 2004
Posts: 6
Perfectshark is on a distinguished road
Baan: 5 - DB: SQL Server - OS: XP
This should go on the help file!

This thread is so old and so true. We were struggling understanding the tax codes until I saw your explanations. Now it all makes sense!

This is still valid for LN 6.1 10.2.1
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
sales order line tax vs sales order header tax blanchap Distribution, Transportation & Warehousing 1 20th July 2005 02:21
Deduction Tax Mohamed_alsadr Finance, Invoicing and Integration 4 9th June 2005 20:04
Finalization Error when Posting a Sales tax avpatil Finance, Invoicing and Integration 2 31st October 2003 20:03
About tax type Ucanyu Finance, Invoicing and Integration 3 8th January 2003 12:05
tax problem parames Distribution, Transportation & Warehousing 0 18th July 2002 06:57

All times are GMT +2. The time now is 12:50.

©2001-2018 - -