Miscellaneous Charge

All,

A customer said it needs to allocation the value of the Miscellaneous Charge (Siscomex) by CIF value of the products in the purchase order. example:

Net value = $ 12,426.14

Freigth = $ 320.81

Insurance = $ 36.83

CIF = $ 12,783.78

Allocation Siscomex:

Siscomex = $ 214.50

$ 12,783.78 / $ 29,898.51 x $ 214.50 = US $ 91.71

Siscomex amount allocated for the item: US $ 91.71

Does anyone know how I do it in AX?

What is the component with amount $ 29,898.51 here? I believe it is not the order value.

By any chance can you get the % calculation formula for Siscomex. If you do, you can create a master out of it and apply the autocharges based on item/vendor.