Changing the way Actual Customs allocates from Quantity to Value in landed cost

[VassilisM]

Hi all,

We are trying to find a way to allocate actual cost in landed costs by item value and not by quantity.

Is it possible to do so?

For example, we have the following landed cost

Here we have 100 pcs in total and 100 EUR. The system automatically allocates the value of 100 EUR per quantity by dividing the quantity of items with the actual customs amount, and therefore we get the values in customs value column. (100psc/100EUR = 1EUR per quantity)*line quantity

What we want, is to make it calculate the allocated values by dividing the base doc value of the items with the actual customs. (100EUR/780EUR = 0,1282EUR per EUR) and afterward multiply with the line's total value to populate the column customs value.

Is there any configuration for that?

Thank you,

Best regards,

Vassilis Mamakos

[SonTran]

For the customs calculation, you need to define customs group in Item Master Data > Purchasing Tab

[SonTran]

Hi,

You can change the allocation method in Administration > Setup > Purchasing > Landed Cost.

In your case, change from Quantity to Cash Value before customs.

Hope this helps,

Son Tran

[VassilisM]

Hi,

Unfortunately, when you use the fields, from "costs" tad in landed cost, the amount is being allocated is going to the field "Alloc. Costs Val" and not in the field "Customs Value".

The point here is to get the value in the field "Customs Value".

In any case, thank you for your answer.