• From: NC, USA
  • Registered: 09/22/2007
  • Posts: 15

Topic: Item Valuation Currencies

I'm in the evaluation process of using FA for a small company in the US. Most of the inventory parts are purchased parts from other countries (Euro/Pound/CHF).

If parts are purchased the inventory is calculated at the exchange rate of the receipt of the goods. Now the payments are sometimes delayed and will have depreciation over time.

The valuation of the inventory is still based on the invoiced price and I would like to understand if there is a "easy" way to re-value the inventory based on exchange rate fluctuations.

Example:
1. Buy equipment from Europe at Euro 100 @ 1.35 = $ 135
2. Re-Value Inventory at Month End @ 1.25
3. Sell equipment to US customer for $200
4. Define Gross Margin / Define Exchange Rate gain/loss

Greatly appreciated if someone can point me to the right directions how to accomplish this task with FA.

Thanks

  • Registered: 12/25/2007
  • Posts: 2,448

Re: Item Valuation Currencies

Internal bookkeeping, and also inventory valuation is processed in home currency, so there is no easy way to accomplish your goal. I guess you will need some additional routine to revaluate inventory on demand.

Janusz