PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Collapse]Goods
    [Expand]Mass Printing
     Integration PANTHEON with WebShops
    [Expand]Issue
    [Expand]Receiving
    [Expand]Single Administrative Document (SAD)
    [Expand]Transfer
    [Expand]Price change
    [Expand]Inventory count
     Create Consignment Report
    [Expand]Recurrent Invoicing
    [Expand]Prepare cash discount
    [Expand]Custom warehouses
    [Expand]Stock
    [Expand]Trošarinska skladišča
    [Expand]Material Movements
    [Expand]Income/Expense Comparison
    [Collapse]Invoices Issued Report
     [Collapse]Invoices Issued/Profit Margin Report
       Izpis TXT datotek za potrebe ZDavP
      [Collapse]Invoices Issued Report
        Invoices Issued Report - Summary by Customs Tariff
        Invoices Issued Report - Detailed by Customs Tarif
        Invoices Issued Report - By Documentation
        Invoices Issued Report - By Archive
        Rekapitulacija prodaje
        Invoices Issued Report - Detailed
        Invoices Issued Report - Detailed - Retail Price
        Invoices Issued Report - Summary by Items
        Invoices Issued Report - by Customers and Items
        Invoices Issued Report - by Customers
        Invoices Issued Report - Chronologically
        Invoices Issued Report - Journal
        Invoices Issued Report - by Items and Columns
        Invoices Issued Report - by Suppliers and Items
        Invoices Issued Report - By transporter
        Sumarno po identu in stolpcih
        Creating Invoices Issued Reports in a Foreign Currency
        Invoices Issued Report - by Departments
        Invoices Issued Report - by Cost Centers
        Invoices Issued Report - by Payment Methods
        Kronološko detajlno
        Trošarine
        Avansi
        2CC - Invoices Issued Report - By Countries of Cus
      [Expand]Profit Margin Reports
      Special Payment Orders
     [Expand]Browse DDV-VP Forms
     [Expand]Commercial Records
     [Expand]Reports on Packaging and Packaging Waste
     [Expand]ZEUS Sales
      Kako uporabimo predlogo
     [Expand]Processing Center
    [Expand]Invoices Received Report
    [Expand]Value-Added Tax
    [Expand]Overview of Material Movement
    [Expand]Summary Reports
    [Expand]Refresh Stock
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 687.5089 ms
"
  4520 | 5229 | 338373 | Updated
Label

Creating Invoices Issued Reports in a Foreign Currency

Creating Invoices Issued Reports in a Foreign Currency

Creating Invoices Issued Reports in a Foreign Currency

010379.gif010380.gif010381.gif010411.gif010382.gif010383.gif

000001.gif If the invoices in different currencies are included in the report and you do not select a currency in the Convert to Currency field, the value total in the report will be meaningless, as it will be the sum of amounts in different currencies. In such cases, it is recommended that you enter a currency in the Convert to Currency field.

If you select a currency in the Convert to Currency field, the prices and values in the report will be converted to the selected currency using the exchange rate specified in the Bank for FCY Docs. field. One of the following exchange rates will be used:

 

  • Exchange Rate for Price List (see Program Parameters | Company | General)
  • Bank of Slovenia (see Program Parameters | Company | General)

The date that will be used for the conversion will be determined the same way it is when entering issue invoices: the date for the exchange rates is usually the date of the invoice. You can specify a different date at Program Parameters | Goods | General.  For an example see Invoices Issued Report in a Foreign Currency.

If you create a report in a foreign currency, the currency used in the report will be shown among the report criteria in the report header.

 

 

Example:

  • Invoice 09302000001 was created in USD. The amount of the invoice was 100 USD, and the Bank of Slovenia's middle exchange rate the day the invoice was created was 1 EUR = 1.32 USD. VAT was not calculated for the invoice.
  • The amount in the invoice was 100 GBP, and the Bank of Slovenia's middle exchange rate the day the invoice was created was 1 EUR = 0.67 GBP. VAT was not calculated for the invoice.

1. Invoices Issued Report without Currency Criteria

If you do not enter currency criteria, the total of these two invoices will be the sum of two amounts in different currencies, and will therefore be meaningless.

62499.gif

2. Convert to Currency (USD)

Let's suppose you would like to show both invoices in the same currency in order to compare information. You would like the report to be in U.S Dollars, so in the panel for entering criteria for the invoices issued report, select the code for the Dollar, USD, in the Convert to Currency field.

You would like to use the Bank of Slovenia's exchange rates. These are also the exchange rates that you use when entering documents.

 

Note that the currency that you selected appears in the report header among the report criteria (Currency - USD).

The program will produce a report with the following information.

  • Issue invoice 09302000001 does not require conversion, as it was created in the selected currency (USD). The value of the invoice is 100 USD.
  • Invoice 09302000002 was created in GBP. The value of the invoice is 100 GBP. In the report, this amount will be converted to USD: 197.02 USD.

 62500.gif

 62501.gif

3. Convert to Currency (EUR)

If you select the currency code for the Euro in the convert to Currency field, all invoices will be converted to Euros using the exchange rates that you selected in the Bank for FCY Docs. field. In line with the settings that you have entered, the exchange rate on the day that each invoice was issued will be used.

  • Invoice xxx was created in USD. The value of the invoice was 100 USD, and the middle exchange rate of the Bank of Slovenia on the day the invoice was issued was 1 EUR = 1.32 USD. The value of this invoice in the report will therefore be 75.76 EUR.
  • Invoice xxx was created in GBP. The value of the invoice was 100 GBP, and the middle exchange rate of the Bank of Slovenia on the day the invoice was issued was 1 EUR = 0.67 GBP. The value of this invoice in the report will therefore be 149.25 EUR.

62502.gif

62503.gif

 

000001.gif The values in invoices issued reports are therefore NOT generated simply by copying the values in the in EUR field in the invoices (see Value Bar), but are recalculated using the same parameters that were used when the invoices was created.

 

If the value in the invoice does not match the value in the invoices issued report, it means that either the document or the exchange rates have been changed. In this case, we recommend that you check the exchange rate in the document against the exchange rate used for posting (see Financials | Reports | Summary Reports | Automatic Posting).

 



 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!