Skip to Content
0
Former Member
Oct 21, 2011 at 03:48 PM

Customs Duty

106 Views

Hello,

In my case, every material has an NGP code (mentioned in the field: Commodity Code/Import code number for foreign trade)

So, when I create a purchase order , I want that the customs duty is calculated in proportion to value taking in consideration the NGP code.And the amount is displayed for each item and also in the header.

this is an example of what I mean.

Material.....................NGP Code..............Quantity (ST)................Unit price...........Total price

X............................... NGP1...............................100................................10.........................1000

Y................................NGP1...............................40.................................20..........................800

Z................................NGP1...............................10..................................5............................50

A.................................NGP2..............................100................................10.........................1000

*For NGP1 a fixed amount 3.000 TND is distributed like this :

X : (1000/1850) * 3000 = 1621 TND

Y : (800/1850) * 3000 = 1297 TND

Z : (50/1850) * 3000 = 81 TND

*For NGP2 a fixed amount 2.000 TND :

A : 2000 TND

What can you advise me to do?

thanks in advance