Invoices with foreign currency - requirements analysis
This page describes requirements related to foreign currencies in orders and invoices app.
Inhalt
- 1 Requirements Analysis
- 1.1 Description
- 1.1.1 General Problem
- 1.2 Required Fields and Functions
- 1.2.1 Scenario 1:
- 1.2.2 Scenario 2:
- 1.2.3 General:
- 1.3 Tasks
- 1.4 Additional Information
- 1.1 Description
Übersicht und Status
Requirements Analysis
Description
A user creates a PO and POL, the price is recorded in a foreign crrency. The following errors occur when the user processes the invoice for this PO/POL:
Scenario 1: Invoice will be processed in primary currency (= system currency = e.g. EUR)
User creates POL and enters the amount/price in a foreign currency
The system calculates the encumbered amount in the primary (=system) currency - this will be displayed as encumbrance in the finance app as transaction
The user creates an invioce and invoice line for the POL - when linking the POL, the system displays the original amount in foreign currency but displays it as amount in primary currency - only a EUR sign is attached to the original price in foreign currency and thus further calculated
The correct amount from encumbrances (finance app) is not used
The further calculation is therefore based on the original price - just with primary currency → The correct amount from the encumbrance is not used
The payment is therefore incorrect
Scenario 2: Invoice Processed in Foreign Currency (e.g. GBP)
After creating the invoice line, the amounts from the purchase order line are correctly adopted, meaning the correct encumbered amount from the finance app is used.
However, additional costs cannot be processed in the primary currency (EUR).
This includes VAT, shipping costs, etc.
Currency differences cannot be compensated in the primary currency (as additional costs or similar).
Although it is possible to update the invoice amount by adjusting the exchange rate, which typically must be calculated first, this is very cumbersome in practice.
General Problem
The invoice shows either the primary or the foreign currency price.
It is essential to see both prices, especially for statistical surveys regarding price development and trends.
Required Fields and Functions
Scenario 1:
During invoice processing, the encumbered amount from the purchase order should be used for further calculations.
Scenario 2:
When adding additional costs, it should be possible to select a currency or at least use the set primary currency.
General:
More transparent display of the original price (foreign currency) and the actual invoice price – possibly an additional field for the original price.
When selecting the status "Checked" in invoice app:
Output of actual amounts (additionally in the primary system currency).
The invoice amount then has the status "intended for payment" in the budget overview of the finance app.
Advantage: all data of the invoice can still be changed.
Alternatively: new additional action: Review - as a function before approving and paying.
Output of actual amounts (total price and additional costs) on the invoice, invoice lines, on the purchase order for linked invoices.
Option to specify amounts in both foreign and primary currency – the system should then calculate the exchange rate.
List price (in the original currency) as a separate field on invoice lines – added value for reports, especially for Scenario 1.
Tasks
...
Additional Information
...
Relevant Functional Analyses
Discussion in a D-SIG
Relevant existing Jira Tickets
...