General description #

The currency contract report provides statistical information related to currency hedging of all the contracts(purchase and sales) created by a company. This report includes all the contracts of a company in which currency hedging has been entered to eliminate currency risk regarding business and accounting. This report allows you to check the status and values(contract and hedged) of its hedged contracts. The report also gives you the figures for the non-hedged amount in these contracts.

All the currency and hedging-related data of a contract like FX rate, hedging value, etc are furnished in the report. In this report, information is given on the multiple currencies used in the contracts. Using filters on the report you can arrange and get data for each currency separately. With this, you can calculate the total contract value, hedged value, and balance of all the contracts of the respected currency.

The report is available only for customers with configuration valuta.contracten enabled.

Columns #

• Subsidiary: The column displays the subsidiary for which the contract has been made. This subsidiary name is fetched from the related contract field “Subsidiary”. On hover, displays the info text “Subsidiary that owns the contract/lot”.
• Currency: This column displays the currency used in the contract. On hover, displays the info text “Currency”.
• Base currency: The base currency of the operating subsidiary is displayed in this column. On hover, the column displays the short info text “Base currency.”
• Contract Number: The purchase or sales contract number of the contract is given in this column. On hover, displays the info text “Contract number”.
• Relation: The relation for which the contract is made is displayed in this column. This column value is fetched from the related contract. On hover, displays the info text “Relation”.
• Product Code: The name(code) of the product used in the related contract is displayed in this column. On hover, displays the info text “Short code of the product”.
• Quantity: This column shows the quantity of the product as per the contract. On hover, displays the info text “Quantity per contract line”.
• Quantity Unit: The quantity unit used in the contract is displayed in this column. On hover, the column displays the short info text “Quantity unit.”
• Pricing Unit: This column specifies the unit of measurement used for the pricing of products in the contract. On hover, the column displays the short info text “Unit the contract is priced in.”
• Exchange Rate: The exchange rate of the base currency of the subsidiary with the foreign currency, at the time of contract creation is given in this column. This value is fetched from the field “Exchange rate” of the related contract. On hover, displays the info text “Currency exchange rate”.
• Expiration date: The expiration date of the currency hedge contract is given in this column. The value is fetched from the field “Expiration date” of the hedging contract. On hover, it displays the short info text “Expiration date.”
• Remarks: Any remarks added to the hedging contract are displayed in this column. On hover, the column displays the short info text “Remarks chosen in contract or placed at stock lot.”
• Closing date: The closing date of the hedging contract is displayed in this contract. The value is fetched from the “closing date” field. On hover, the column displays the short info text “Closing date.”
• Contract Value in F.C: The total amount of contract for a product in foreign currency is given in this column. This value is retrieved from the related contract field “Contract Value”. On hover, displays the info text “Total contract value in foreign currency”.
• Contract Value in Base currency: The total amount of contract for a product in base currency is given in this column. On hover, displays the info text “Total contract value in base currency”.
• Amortized contract value: The column displays the value of the amortized quantity (if any) for the contract. On hover, the column displays the short info text “Amortized contract value.”
• Currency Hedging Contract no: The contract number of the hedging contract agreed with the bank (to avoid the currency risks in the trade) is displayed in this column. This hedging contract number is fetched from the related contract’s currency hedge section. On hover, displays the info text “Currency hedging contract no.”.
• Hedging line exchange rate: The exchange rate agreed in the hedging contract with the bank is given in this column. This value is fetched from the “Currency Hedge Section” of the related contract. On hover, displays the info text “Hedging line exchange rate”.
• Amount hedging line: This column gives the amount from the contract value on which the currency hedging has been specified. This value is fetched from the field “amount” in the currency hedge section of the related contract. On hover, displays the info text “Amount hedging line”.
• Balance: This column displays the amount from the contract value on which currency hedging has not been done. On hover, displays the info text “Balance”.
  • Calculations: Contract value – Amortized contract value – Amount hedging line = Balance
• Status: This column gives the status of the currency contract whether open, closed, or confirmed. On hover, displays the info text “Status”.
  • Open: This means nothing has been done with this hedging line yet.
  • Closed: This means that the hedging line has been closed and nothing further needs to do with this line.
  • Confirmed: It means the line has been hedged and confirmed as well by the buyer/seller.