Posted for Alokofkhai I work in Rep.of Benin. Here they charge different type of taxes. 1. Normal vat - 18% 2. Sales tax - 1% 3. Special Tax on Sales - 3% Total vat on sales is 22% How do I do this
Hi, Are the percentages fixed? Do they apply to all sales and purchase? Does VAT work according to the EU model? Does VAT work like the US / CAN sales tax model? More information would be interesting.
and also: do you have to post 3 separate amount on different accounts? or it is ok to post the total amount in one account? do you have to report (for fiscal reason) those 3 taxes separately? or it is enough to report the total? how they are paid to the authority?
quote:
and also: do you have to post 3 separate amount on different accounts? or it is ok to post the total amount in one account? do you have to report (for fiscal reason) those 3 taxes separately? or it is enough to report the total? how they are paid to the authority?
Originally posted by navisi0ne - 2006 Feb 09 : 11:31:43
HI, yes, I have to post the 3 separate amount on different accounts and I have to report 3 taxees separately. Thanks
Alofokhai, you’ll have to use the Sales Tax functionality, the standard Navision VAT handling will only allow for a single tax for each line, using the VAT Bus. Posting Group and VAT Prod. Posting Group. Therefore you should have a look at the Sales Tax Funcionality (Tax Area, Tax Jurisdiction, Tax Groups and Tax Detail), the access to these forms/tables are not visible in the standard W1 Navision version. You’ll have to setup a tax area e.g. SALES, for this tax area you assign 3 tax jurisdicctions, “VAT”, “STAX” and “SPECIAL”, again a single code in the “Tax Group” table, and the combination of Tax Jurisdiction and Tax Groups in the “Tax Details” table, which gives you 3 lines, one for each tax you mention. Hope this gives you some idea on how to achieve this. Saludos Nils
quote:
Alofokhai, you’ll have to use the Sales Tax functionality, the standard Navision VAT handling will only allow for a single tax for each line, using the VAT Bus. Posting Group and VAT Prod. Posting Group. Therefore you should have a look at the Sales Tax Funcionality (Tax Area, Tax Jurisdiction, Tax Groups and Tax Detail), the access to these forms/tables are not visible in the standard W1 Navision version. You’ll have to setup a tax area e.g. SALES, for this tax area you assign 3 tax jurisdicctions, “VAT”, “STAX” and “SPECIAL”, again a single code in the “Tax Group” table, and the combination of Tax Jurisdiction and Tax Groups in the “Tax Details” table, which gives you 3 lines, one for each tax you mention. Hope this gives you some idea on how to achieve this. Saludos Nils
Originally posted by nilsm - 2006 Feb 10 : 08:10:24
Thanks Saludos Pls, where will I enter there 3 separate taxes percentage and how will the system do the computation. Thanks once again waiting for your response
Alokofkhai, you’ll have to enter the 3 detailed tax lines in the “Tax Detail” table (T322), which you can access with Form 468, as mentioned before, you have to include the access to these tables if you are working with a W1 version. In that table you include a line for each of the Jurisdictions you created and always use the same Tax Group. When calculating tax, Navision takes all the jurisdictions within the specified tax area and finds all tax details that have matching tax group codes. With out using the option “Calculate tax on tax” in the tax detail, Navision will add the tax for each tax line, based on the amount of your calculation. I am aware that this is not the proper “US Sales Tax” usage, but we have been using this same approach (several different taxes on sales/purchase transactions) in several customer projects. Please let me know if you need some additional indications. Saludos Nils
quote:
Alokofkhai, you’ll have to enter the 3 detailed tax lines in the “Tax Detail” table (T322), which you can access with Form 468, as mentioned before, you have to include the access to these tables if you are working with a W1 version. In that table you include a line for each of the Jurisdictions you created and always use the same Tax Group. When calculating tax, Navision takes all the jurisdictions within the specified tax area and finds all tax details that have matching tax group codes. With out using the option “Calculate tax on tax” in the tax detail, Navision will add the tax for each tax line, based on the amount of your calculation. I am aware that this is not the proper “US Sales Tax” usage, but we have been using this same approach (several different taxes on sales/purchase transactions) in several customer projects. Please let me know if you need some additional indications. Saludos Nils
Originally posted by nilsm - 2006 Feb 10 : 14:19:32
Pls. Saludos I do not understand, do I have to create a field say percentage to hold the percentage for each tax in T322. Pls. be more specific. Thanks Alofokhai
quote:
do I have to create a field say percentage to hold the percentage for each tax in T322
No, this won’t be necessary. The fields for the percentages are called “Tax Below Maximum” and “Tax Above Maximum”, which related to the field “Maximum Amount/Qty.”. As per your description, I assume that you don’t have limit/maximum amounts, therefore simply use “Tax Below Maximum” and leave the “Maximum Amount/Qty.” Field blank. In the field “Tax Below Minimum” you put the tax percentage for each tax you mention. Saludos Nils
quote:
quote:
Alofokhai, you’ll have to use the Sales Tax functionality, the standard Navision VAT handling will only allow for a single tax for each line, using the VAT Bus. Posting Group and VAT Prod. Posting Group. Therefore you should have a look at the Sales Tax Funcionality (Tax Area, Tax Jurisdiction, Tax Groups and Tax Detail), the access to these forms/tables are not visible in the standard W1 Navision version. You’ll have to setup a tax area e.g. SALES, for this tax area you assign 3 tax jurisdicctions, “VAT”, “STAX” and “SPECIAL”, again a single code in the “Tax Group” table, and the combination of Tax Jurisdiction and Tax Groups in the “Tax Details” table, which gives you 3 lines, one for each tax you mention. Hope this gives you some idea on how to achieve this. Saludos Nils
Originally posted by nilsm - 2006 Feb 10 : 08:10:24
Thanks Saludos Pls, where will I enter there 3 separate taxes percentage and how will the system do the computation. Thanks once again waiting for your response
Originally posted by Alofokhai - 2006 Feb 10 : 11:53:45
Pls. Saludos, How do I include access to these Tables (T322,T318,T319,T320 & T321) as you mentioned. Also, do I have to disable the normal (VAT) calculation in order to use the Sales Tax Functionality in Navision. Thanks for your constantly responses. Alofokhai
quote:
quote:
Alofokhai, you’ll have to use the Sales Tax functionality, the standard Navision VAT handling will only allow for a single tax for each line, using the VAT Bus. Posting Group and VAT Prod. Posting Group. Therefore you should have a look at the Sales Tax Funcionality (Tax Area, Tax Jurisdiction, Tax Groups and Tax Detail), the access to these forms/tables are not visible in the standard W1 Navision version. You’ll have to setup a tax area e.g. SALES, for this tax area you assign 3 tax jurisdicctions, “VAT”, “STAX” and “SPECIAL”, again a single code in the “Tax Group” table, and the combination of Tax Jurisdiction and Tax Groups in the “Tax Details” table, which gives you 3 lines, one for each tax you mention. Hope this gives you some idea on how to achieve this. Saludos Nils
Originally posted by nilsm - 2006 Feb 10 : 08:10:24
Thanks Saludos Pls, where will I enter there 3 separate taxes percentage and how will the system do the computation. Thanks once again waiting for your response
Originally posted by Alofokhai - 2006 Feb 10 : 11:53:45
Pls. Saludos, How do I include access to these Tables (T322,T318,T319,T320 & T321) as you mentioned. Also, do I have to disable the normal (VAT) calculation in order to use the Sales Tax Functionality in Navision. Thanks for your constantly responses. Alofokhai
His name is Nils, not Saludos. Saludos is just something like “Greetings” or “kind Regards” [;)]. Saludos
Thanks for your aclaration, Thomas [;)] Now to the question itself… 1) Open the Form 332, General Ledger Menu, Select the configuration drop down menu, right mouse click, and open the menu items. Add a line for each new form access you need, enter the caption in the Caption field, select RunObject in the Action Field and select the following forms(!) in the RunObject field - 464, 466, 467, 468. In Navision, you never “open” tables, you always must use forms to show data to the user. 2) You’ll have to setup a default VAT Setup to activate Sales Tax, e.g. blank VAT Business Posting Group, blank VAT Product Posting Group, and select Sales Tax in field VAT Calculation Type. Saludos Nils