We currently use dynamics ax 2009. We have created O.E.Ms as Foreign vendors in dynamics. We have created Foreign warehouses (Where foreign vendors supply goods) also in dynamics. Anytime there is a supply from the O.E.Ms, A Purchase order is created in dynamics with the OEM account and the foreign ware house where the Goods are delivered. Hence the O.E.M. is paid based on Goods delivered to the foreign warehouse.
Delivered Goods in foreign warehouses are shipped down to Nigeria; while this is done other costs are incurred. In dynamics, a transfer journal is used to move the items from the overseas warehouse to the local warehouse.
Calculation of accurate inventory valuation by including additional charges beyond purchase cost
How do we recognize other costs incurred in the course of shipping the items so that we have the actual value of items in our warehouses bearing in mind the following:
· The Goods are delivered at purchase cost to the overseas warehouse
· The Goods are shipped to local warehouses irrespective of Created purchase orders. The goods may be from several purchase orders which may be from several O.E.Ms. (Consolidated invoice). How do we then apportion cost to these several items in different purchase orders.
· Using the miscellaneous charges function means we will have to start tracing all the purchase orders used in creating the consolidated items and start apportioning costs on them one after the other after the invoice on these transactions have been posted (after delivery by O.E.M. who would have sent in his invoice after delivery). The second question then arises- How do we apportion miscellaneous charges on a single item transaction with many other item lines in the same order.
Is there any other solution you can think of