Export (0) Print
Expand All

Currency Exchange Rates

Microsoft Dynamics NAV 2013

At the end of the fiscal year, you must adjust currency exchange rates for payables and receivables so that they are valued correctly in the annual balance. The Adjust Exchange Rates batch job supports different valuation methods in order to meet legal requirements in Germany.

Valuation Methods

According to the Bilanz Modernisierungs Gesetz (BilMoG), payables and receivables are valued differently depending on the difference between the reference date and the due date. This is managed by the Adjust Exchange Rates batch job where you can specify which valuation method to use. If the due date is less than one year after the reference date, the Adjust Exchange Rates batch job must be run using the lowest value valuation method.

The following table describes the valuation methods.

Valuation method Description

BilMoG (Germany)

Each ledger entry is adjusted based on the due date. If the due date is more than one year after the reference date, exchange rates are adjusted by using the standard valuation method. Full unrealized gains and losses are calculated and posted. If the transaction is partially applied, only the remaining amount is included in the adjustment.

If the due date is more than one year after the reference date, exchange rates are adjusted by using the lowest value valuation method. This ensures that receivables are not valued above their original posting amounts, and that payables are not valued below their original posting amounts.

Lowest value

Exchange rates are adjusted by using the lowest value of the two exchange rates. Currency losses are always calculated and posted. Currency gains are only calculated and posted up to the original local currency value of the transaction.

This ensures that receivables are not valued above their original posting amounts, and that payables are not valued below their original posting amounts.

Standard

Exchange rates are adjusted according to standard valuation principles. Full unrealized gains and losses are calculated and posted. If the transaction is partially applied, only the remaining amount is included in the adjustment. For more information, see Adjust Exchange Rates.

German companies must use the BilMoG (Germany) option when they run the Adjust Exchange Rates batch job. This ensures that each transaction is adjusted using the appropriate valuation method as required in Germany. This also enables two fields in the request window, where you can specify the two dates that must be used to calculate the adjustment. The following table describes the fields.

Field Description

Valuation Reference Date

Specifies the base date that is used to calculate which entries are short-term entries.

Short term liabilities until

Specifies the date that separates short-term entries from long-term entries. Short-term entries have a due date that is before or on this date. The default value is the value of the Valuation Reference Date field plus one year.

See Also

Show:
© 2014 Microsoft