Line level Tax of Invoice/Sale Order

arindam

Hi All,

I have a query -

For Sales Order and Invoice window, I have calculated Line level tax. Now in which feild of which table I'll update that value.

I am not finding any Tax feild in Sales Line table. I can see feilds like 'Amount without Tax' and 'Amount with Tax' (something like) but there are no such specific feild where i can store line level tax.

Please advice.
Thanks.
Arindam

NR

There are fields like Tax% and Tax amount in the sales line.

If you dont find these fields, then perhaps you are working on a global db.

arindam

I am not having Tax% and Tax amount in the sales line.

Please suggest. I am using 'CRONUS, USA and CANADA.

diptish.naskar

I am not having Tax% and Tax amount in the sales line.

Please suggest. I am using 'CRONUS, USA and CANADA.

Hi,

In the base database, you will not find these fileds in the line level, you can open the sales line subform and then drag and drop the field on the form.

If you don't want the values to be displayed on the form, you can zoom in the sales line subform by pressing Ctrl+F8 to see the values present in the fields.

arindam

"In the base database, you will not find these fileds in the line level, you can open the sales line subform and then drag and drop the field on the form."

If I dont find the feilds in the database table, then how i can drag n drop the feilds on the form.

NR

Perhaps, you are working on the global database. Check out these fields in the localized version.

arindam

That means I am working on wrong database ?
If i develop my application then will it not run on Global Database ?
If I want to run my application with Global Database then what will be the options ?

NR

1. That means I am working on wrong database ?
The fields you are looking for (Tax Amount etc) are part of the localized version. The database is localized to address the statutory requirements which is country specific.

2. If i develop my application then will it not run on Global Database ?
You can run the application developed on the global database. But, what you seem to be asking is available in the localized db.


3. If I want to run my application with Global Database then what will be the options ?
You will have to design your application in the global database. Now the Tax part which might be available as a standard in the localized db.

darshanm

hye man.. you have zoom the sales line n see.

go to designer mode and bring the fields on sales line subform.

arindam

I did that. But I am not getting these 2 feilds there (Tax% and Tax Amount) at Sales Line table.

I am using US and Canada database. May be this is localization issue.

Savatage

out of curiosity.

Go to Object Designer -> Sales Line Table
Hit Design & What do you have for field #25?

It should be Tax%. If you have it then you can add it to the form.

darshanm

u should use Indian database

arindam

I am using US and Canada database. I need to work on US database not India database.



Savatage, as far ur advice I explored Sales Line table and #25 feild of the table is 'VAT%' not 'Tax%'. I am pasting the feild details.


Sales Line Table (#37)
Enabled Field No. Field Name Data Type Length Description
Yes 1 Document Type Option
Yes 2 Sell-to Customer No. Code 20
Yes 3 Document No. Code 20
Yes 4 Line No. Integer
Yes 5 Type Option
Yes 6 No. Code 20
Yes 7 Location Code Code 10
Yes 8 Posting Group Code 10
Yes 10 Shipment Date Date
Yes 11 Description Text 50
Yes 12 Description 2 Text 50
Yes 13 Unit of Measure Text 10
Yes 15 Quantity Decimal
Yes 16 Outstanding Quantity Decimal
Yes 17 Qty. to Invoice Decimal
Yes 18 Qty. to Ship Decimal
Yes 22 Unit Price Decimal
Yes 23 Unit Cost (LCY) Decimal
Yes 25 VAT % Decimal
Yes 27 Line Discount % Decimal
Yes 28 Line Discount Amount Decimal
Yes 29 Amount Decimal
Yes 30 Amount Including VAT Decimal
Yes 32 Allow Invoice Disc. Boolean
Yes 34 Gross Weight Decimal
Yes 35 Net Weight Decimal
Yes 36 Units per Parcel Decimal
Yes 37 Unit Volume Decimal
Yes 38 Appl.-to Item Entry Integer
Yes 40 Shortcut Dimension 1 Code Code 20
Yes 41 Shortcut Dimension 2 Code Code 20
Yes 42 Customer Price Group Code 10
Yes 45 Job No. Code 20
Yes 46 Appl.-to Job Entry Integer
Yes 47 Phase Code Code 10
Yes 48 Task Code Code 10
Yes 49 Step Code Code 10
Yes 50 Job Applies-to ID Code 20
Yes 51 Apply and Close (Job) Boolean
Yes 52 Work Type Code Code 10
Yes 57 Outstanding Amount Decimal
Yes 58 Qty. Shipped Not Invoiced Decimal
Yes 59 Shipped Not Invoiced Decimal
Yes 60 Quantity Shipped Decimal
Yes 61 Quantity Invoiced Decimal
Yes 63 Shipment No. Code 20
Yes 64 Shipment Line No. Integer
Yes 67 Profit % Decimal
Yes 68 Bill-to Customer No. Code 20
Yes 69 Inv. Discount Amount Decimal
Yes 71 Purchase Order No. Code 20
Yes 72 Purch. Order Line No. Integer
Yes 73 Drop Shipment Boolean
Yes 74 Gen. Bus. Posting Group Code 10
Yes 75 Gen. Prod. Posting Group Code 10
Yes 77 VAT Calculation Type Option
Yes 78 Transaction Type Code 10
Yes 79 Transport Method Code 10
Yes 80 Attached to Line No. Integer
Yes 81 Exit Point Code 10
Yes 82 Area Code 10
Yes 83 Transaction Specification Code 10
Yes 85 Tax Area Code Code 20
Yes 86 Tax Liable Boolean
Yes 87 Tax Group Code Code 10
Yes 89 VAT Bus. Posting Group Code 10
Yes 90 VAT Prod. Posting Group Code 10
Yes 91 Currency Code Code 10
Yes 92 Outstanding Amount (LCY) Decimal
Yes 93 Shipped Not Invoiced (LCY) Decimal
Yes 95 Reserved Quantity Decimal
Yes 96 Reserve Option
Yes 97 Blanket Order No. Code 20
Yes 98 Blanket Order Line No. Integer
Yes 99 VAT Base Amount Decimal
Yes 100 Unit Cost Decimal
Yes 101 System-Created Entry Boolean
Yes 103 Line Amount Decimal
Yes 104 VAT Difference Decimal
Yes 105 Inv. Disc. Amount to Invoice Decimal
Yes 106 VAT Identifier Code 10
Yes 107 IC Partner Ref. Type Option
Yes 108 IC Partner Reference Code 20
Yes 5402 Variant Code Code 10
Yes 5403 Bin Code Code 20
Yes 5404 Qty. per Unit of Measure Decimal
Yes 5405 Planned Boolean
Yes 5407 Unit of Measure Code Code 10
Yes 5415 Quantity (Base) Decimal
Yes 5416 Outstanding Qty. (Base) Decimal
Yes 5417 Qty. to Invoice (Base) Decimal
Yes 5418 Qty. to Ship (Base) Decimal
Yes 5458 Qty. Shipped Not Invd. (Base) Decimal
Yes 5460 Qty. Shipped (Base) Decimal
Yes 5461 Qty. Invoiced (Base) Decimal
Yes 5495 Reserved Qty. (Base) Decimal
Yes 5600 FA Posting Date Date
Yes 5602 Depreciation Book Code Code 10
Yes 5605 Depr. until FA Posting Date Boolean
Yes 5612 Duplicate in Depreciation Book Code 10
Yes 5613 Use Duplication List Boolean
Yes 5700 Responsibility Center Code 10
Yes 5701 Out-of-Stock Substitution Boolean
Yes 5702 Substitution Available Boolean
Yes 5703 Originally Ordered No. Code 20
Yes 5704 Originally Ordered Var. Code Code 10
Yes 5705 Cross-Reference No. Code 20
Yes 5706 Unit of Measure (Cross Ref.) Code 10
Yes 5707 Cross-Reference Type Option
Yes 5708 Cross-Reference Type No. Code 30
Yes 5709 Item Category Code Code 10
Yes 5710 Nonstock Boolean
Yes 5711 Purchasing Code Code 10
Yes 5712 Product Group Code Code 10
Yes 5713 Special Order Boolean
Yes 5714 Special Order Purchase No. Code 20
Yes 5715 Special Order Purch. Line No. Integer
Yes 5750 Whse. Outstanding Qty. (Base) Decimal
Yes 5752 Completely Shipped Boolean
Yes 5790 Requested Delivery Date Date
Yes 5791 Promised Delivery Date Date
Yes 5792 Shipping Time DateFormula
Yes 5793 Outbound Whse. Handling Time DateFormula
Yes 5794 Planned Delivery Date Date
Yes 5795 Planned Shipment Date Date
Yes 5796 Shipping Agent Code Code 10
Yes 5797 Shipping Agent Service Code Code 10
Yes 5800 Allow Item Charge Assignment Boolean
Yes 5801 Qty. to Assign Decimal
Yes 5802 Qty. Assigned Decimal
Yes 5803 Return Qty. to Receive Decimal
Yes 5804 Return Qty. to Receive (Base) Decimal
Yes 5805 Return Qty. Rcd. Not Invd. Decimal
Yes 5806 Ret. Qty. Rcd. Not Invd.(Base) Decimal
Yes 5807 Return Rcd. Not Invd. Decimal
Yes 5808 Return Rcd. Not Invd. (LCY) Decimal
Yes 5809 Return Qty. Received Decimal
Yes 5810 Return Qty. Received (Base) Decimal
Yes 5811 Appl.-from Item Entry Integer
Yes 5900 Service Contract No. Code 20
Yes 5901 Service Order No. Code 20
Yes 5902 Service Item No. Code 20
Yes 5903 Appl.-to Service Entry Integer
Yes 5904 Service Item Line No. Integer
Yes 5907 Serv. Price Adjmt. Gr. Code Code 10
Yes 5909 BOM Item No. Code 20
Yes 6600 Return Receipt No. Code 20
Yes 6601 Return Receipt Line No. Integer
Yes 6608 Return Reason Code Code 10
Yes 7001 Allow Line Disc. Boolean
Yes 7002 Customer Disc. Group Code 10
Yes 10000 Package Tracking No. Text 30

Savatage

VAT = Value Added Tax

arindam

That I know, but the question is for US -
Tax% = VAT%. This is very confusing to me.

As far as I know VAT is applicable in Europe and Tax is in US.

Savatage

I think VAT might be used in Canada too?

arindam

Hi all,

I think that I got the solution for the problem.

I checked with localized and global database. The observations are hereunder :

I developed my code unit with VAT% in navision US database and then I exported the same codeunit to Global database. It ran perfectly. Internally Navision converted the VAT% to Tax% for the global database. However, the code is still showing VAT% at global database.

So I think Navision takes care this issue internally. We only need to know which feild we need to use.

Hope this will help.

Arindam