General description #

The sales elimination report gives you an overview of all sales orders (paid and open), as well as finalised and non-finalised orders. The orders displayed in the report are associated with the sales contracts for which currency (hedging) contracts are associated, allowing you to keep track of and eliminate differences between the contract exchange rates and the current exchange rate of the orders. The report allows you to calculate the difference between the contracted exchange rates and the current exchange rates so that you can book the same and eliminate the differences.

Columns #

• Currency: The currency selected for the contract is displayed in this column. The value is fetched from the field currency of the related contract. On hover, the column displays the info text “Currency”.
• Base Currency: The currency of the operating subsidiary for the contract is displayed in this column. On hover, it displays the info text “Base currency.”
• Invoiced: The column represents whether the order is invoiced or not. On hover, the column displays the info text “Amount of the borderline whose sales invoices are exported and have a paid date”.
• Display no.: The contract number of the related sales contract of the invoice is displayed in this column. On hover, the column displays the info text “Display number”.
• Contract Date: The contract creation date of the related sales contract is displayed in this column. On hover, the column displays the info text “Date contract was closed”.
• Relation name: The name of the relation/supplier of the sales contract is displayed in this column. On hover, the column displays the info text “Buyer/seller of the product”.
• Exchange rate: The exchange rate of the sales contract is displayed in this column. On hover, the column displays the info text “Currency exchange rate”.
• Total contract value in F.C: The column displays the value of the total contract quantity in currency used for the contract. On hover, the column displays the info text “Total contract value in foreign currency”.
  • Calculation: Total contract value in F.C = Total contract quantity / Exchange rate.
• Total contract value in Base currency: The column displays the value of the total contract quantity in base currency. On hover, the column displays the info text “Total contract value in base currency”.
• Remaining value in kg: This column gives the value(amount) of the remaining quantity from the contract. On hover, the column displays the info text “Remaining value in kg”.
  • Calculation: Remaining value in kg = Remaining quantity from contract * (price per ton/1000).
• Quantity Unit: The quantity unit used in the contract is displayed in this column. On hover, the column displays the info text “Unit used in quantity”.
• Pricing Unit: The pricing unit from the contract is given in this column. The pricing unit is used for the invoicing. On hover, the column displays the short info text “Unit the contract is priced in.”
• Remaining value in F.C: This column displays the value(amount) of the remaining quantity from the contract in the currency used in the contract. On hover, the column displays the info text “Remaining value in FC”.
  • Calculation: Remaining quantity in F.C. = Remaining quantity from contract * (price per ton/1000) / exchange rate.
• Remaining value in Base Currency: This column displays the value(amount) of the remaining quantity from the contract in base currency. On hover, the column displays the info text “Remaining value in Base currency”.
• Contracts currency reference: The bank contract number of the currency contract related to the sales contract is displayed in this column. On hover, the column displays the info text “Contracts currency reference”.
• Contract currency date: The expiration date of the currency contract is given in this column. On hover, the column displays the info text “Contract currency date”.
• Contract currency total amount: The sum of all the contract lines of currency contracts is given in this column. On hover, the column displays the info text “Contract currency total amount”.
• Contract currency remaining amount: The remaining amount from the total currency contract value is given in this column. On hover, the column displays the info text “Contract currency remaining amount”.
  • Calculation: Contract currency Remaining amount = Contract currency total Amount/Total contract Value in F.C * Remaining value in F.C.
• Total contract exchange ratevalue: Displays the value of the Contract as per the exchange rate. On hover, the column displays the info text “Total contract exchange rate value”.
  • Calculation: Total Contract exchange rate value = Purch. Inv. Amount in F.C * Exchange rate.
• Total default exchange rate value: Displays the value of the contract as per the default exchange rate. The default exchange rate is a custom field in the contract screen. If there is no value entered for the default exchange field in the contract, the value 1 is taken by default in place of the default exchange rate. On hover, the column displays the info text “Total default exchange rate value”.
  • Calculation: Total Default Contract exchange rate value = Purch. Inv. Amount in F.C * Default Exchange rate.
• Difference: The difference between the contract exchange rate value and default exchange rate value is calculated in this column. On hover, the column displays the info text “Difference”.
  • Calculation: Difference = Total contract exchange rate value – Total default exchange rate value.
• Total contract exchange rate value ccy: The value of the remaining amount in foreign currency as per the contract exchange rate is given in this column. On hover, the column displays the info text “Total contract exchange rate value ccy”.
  • Calculation: Total contract exch rate value ccy = Contract currency remaining Amount * Exchange rate.
• Total default exchange rate value contract currency: The value of contract currency remaining amount as per default exchange rate is displayed in this column. On hover, the column displays the info text “Total contract exchange rate value ccy”.
  • Calculation: Total default exch rate value contract currency = Contract currency Remaining Amount * Default Exchange rate.
• Contract currency difference: The difference between the contract exchange rate value and default exchange rate value is calculated in this column.
  • Calculation: Contract currency difference = Total Contract exchange rate value CCY – Total Default exchange Rate Value contract currency.
• Invoice number: The invoice number of the booked (goods) invoice is displayed in this column. On hover, the column displays the info text “Invoice number”.