Invoicing & Accounting

FX-Calulator

The FX calculator and how currency conversion is applied.

Modules

Order/ORDER_MARGIN_ALL_SERVICES: Activates the field Mark-up in Service Details as well as the Mark-up area in the new Price Calculation Dialog

Order/OrderSD_settlement_type: Shows the tab Settlement Types in Master Data, the functionality is described here.

Order/Item_Details_Prices: Provides the Price Details tab for all Travel Types. This is a straightforward calculation module you can use to enter details of a service. The total sum of these details is transferred to the price field that is active depending on mode (Agent / Principle Sales) and purchasing currency.

Rights

Edit mark-up settings for Supplier: If the module Order/ORDER_MARGIN_ALL_SERVICES is assigned, the selection Allow Markup is available in Supplier Master Data. If a role has the right, the user can prevent the entry of mark-ups for certain suppliers by removing the check mark. The Price Calculation is then provided for this supplier as described under Mode Agent Sales.

Mode Agent Sales

You provide travel services in the name of and for the account of various suppliers.

You receive commission or incoming invoices showing commission.

Mode Principle Sales

You Purchase services and receive net Purchase invoices.

The revenue is mainly generated by a mark-up, nevertheless, the entry of commission is possible.

MIX Agent Sales / Principle Sales

A setting in Supplier Master Data allows certain suppliers to be activated for net Purchases, but prevents to enter a mark-up for others.

Master Data

In order to detect Purchase and Sales Currency, the correct setup of Master Data is absolutely necessary.

Detailed information can be found here:

Supplier Master Data

Customer, Foreign Currency settings

Order creation, Foreign Currency Sales

Service Details (new adjustments Release 14.7.1)

The view of the Service Details mask will change:

Settlement Type

The field Settlement Type is moved to the left side, to the area which carries mainly payment values.

Settlement Type will only be available if your organizational unit works with settlement types and the corresponding module Order/OrderSD_settlement_type is assigned.

Button Price Calculation

The field Total Price is now provided with the Price Calculation button . This button takes you to the new Price Calculation dialogue. You will find a detailed description in the following course of this description.

Area Purchase Price, Purchase Price (FCY)

The Purchase Price in Base Currency, the Purchase Price in Foreign Currency if applicable, and the exchange rate used are displayed but cannot be edited at this point.

Changes shall be done in the Price Calculation dialogue.

View Service Details (Agent Sales)

^{Service Details Agent Sales}

View Service Details (Principle Sales)

A newly created module Order/ORDER_MARGIN_ALL_SERVICES allows the entry of an individual Mark-up per service. If this module is assigned to the organizational unit, an additional field Mark-up can be found below Total Price. In addition, the service price is then generally entered in the Price Calculation dialog, so the fields Total Price and Mark-up cannot be entered in the Service Details mask.

^{Service Details Principle Sales}

Price Calculation - new dialog

The appearance of the new Price Calculation detail mask depends on the settings of the organizational unit (with / without Order/ORDER_MARGIN_ALL_SERVICES module) and on the Purchasing or Sales Currency used.

Areas which are not relevant for the specific service item are always hidden.

This screen shows the maximum possible level of detail, a description of the individual areas and various use cases can be found below.

^{Price Calculation max. level of detail}

Description of Areas

1 Base / Purchase Currency

Sales Price (Base Currency)

The Sales Price in Base Currency. The currency indicator is preset according to the Base Currency of the organizational unit and cannot be changed.

Agent Sales: Active, the field is editable. Exemption: Purchases are made in Foreign Currency.

Principle Sales: Inactive, the field is not editable. In this mode, the Purchase Price (Base Currency) is the calculation basis; the Sales Price (Base Currency) is the result of this plus the mark-up entered. If no mark-up is entered, the value from Purchase Price is transferred to the Sales Price field. Once the calculation is completed, the field Sales Price (Base Currency) can be activated and the Sales Price can be adjusted to a round total, for example.

Purchase Price (Base Currency)

The Purchase Price in Base Currency. The currency indicator is preset according to the Base Currency of the organizational unit and cannot be changed.

Agent Sales: Inactive, the value from the Sales Price (Base Currency) field is taken over.

Principle Sales: Active, the Purchase Price (Base Currency) forms the base of calculation, this plus mark-up results in the Sales Price (Base Currency). If no mark-up is entered, the value from Purchase Price is transferred to the Sales Price.

Sales Price (Purchase Currency)

The Sales Price in Purchase currency. This field is only displayed if the supplier or its settlement type is used to identify a Purchase in a currency other than the Base Currency. The currency indicator is preset and cannot be changed. It is based on the currency of the Supplier Account payable assigned to the respective supplier or Account ID (CR), assigned to the settlement type.

Agent Sales: Active, the field is editable.

Principle Sales: Inactive, the field is not editable. In this mode, the Purchase Price (Purchase Currency) is the calculation basis; the Sales Price is the result of this plus the mark-up entered. If no mark-up is entered, the value from Purchase Price is transferred to the Sales Price.

Purchase Price (Purchase Currency)

The Purchase Price in Purchase currency. This field is only displayed if the supplier or its settlement type is used to identify a Purchase in a currency other than the Base Currency. The currency indicator is preset and cannot be changed. It is based on the currency of the Supplier Account payable assigned to the respective supplier or Account ID (CR), assigned to the settlement type.

Agent Sales: Inactive, the value from the Sales Price (Base Currency) field is taken over.

Principle Sales: Active, the Purchase Price forms the base of calculation, this plus mark-up results in the Sales Price. If no mark-up is entered, the value from Purchase Price is transferred to the Sales Price.

Exchange rates

FX Rate (System): The Buy rate defined in Order Master Data/FX Rates is set as the default value for the Purchase currency.

FX Rate (Deviant): Activate this field by using the radio button if you want to use an individual exchange rate for the service (e.g. due to currency hedging).

Calculator

In addition, you will find a calculator in all price fields. With the help of this calculator you can, for example, calculate the total price for an accommodation by entering price/night together with the number of persons and nights. The result is transferred to the respective field.

^Calculator

2 Commission

This area is collapsed the first time the Price Calculation is opened. Only after the entire order has been saved commission values are calculated based on the settings of Supplier / Commission Conditions. If there are values in this area later, the area is displayed in open state. Via the + / - icon you can open or close it as required.

Mode Revenue Calculation

Here you determine which value should form the basis for your commission calculation. Activate the selection by ticking the checkbox. The corresponding fields for entering your individual values are activated according to your selection for input:

Purchase Price (Base Currency)

This option is only available in Agent Sales. This enables you to activate the Purchase Price (Base Currency) field, which is otherwise inactive in Agent Sales, since the value is usually identical to the Sales Price. Now enter a different Purchase Price, the difference is determined (Sales Price ./. Purchase Price) and transferred to the Calculated Commission field. The value Commission % is calculated automatically.

^{Mode Revenue Calculation - Purchase Price (Base Currency)}

Calculated Commission

This option opens the Calculated Comm. field and allows you to enter an expected revenue as an absolute value. The Purchase and Sales price are not affected. The percentage value is also calculated at this point.

^{Mode Revenue Calculation - Calculated Commission}

Commission %

Activates the field Commission %, existing values can be changed or a new value can be entered. This entry is used to calculate the value in the Calculated Comm. field. Purchase and Sales values remain unaffected. Entered values overrule settings from Supplier / Commission Conditions.

^{Mode Revenue Calculation - Commission %}

Purchase Price (Purchase CY)

This option is only available in Agent Sales and if the service is Purchased in Foreign Currency. It activates the Purchase Price (Purchase Currency) field for input. If you now enter a different Purchase Price, the difference is determined (Sales Price ./. Purchase Price) and transferred to the Calculated Comm.(Base CY) field. The value Commission % is calculated as well as the Calculated Comm. value in Base Currency based on the exchange rate used.

^{Mode revenue calculatation - Purchase Price (Purchase CY)}

Commission %

The commission rate defined in the supplier settings is transferred to this field and the calculated revenue is determined based on it. You can overwrite this value using the selection under Mode Revenue Calculation.

Calculated/Received Comm. (Base CY)

Here you find the value of the expected commission and, after processing the incoming invoice, the revenue actually posted.

Calculated/Received Comm. (Purchase CY)

This field is only available when Purchase is made in Foreign Currency. It shows the value of the expected commission and, after processing the incoming invoice, the revenue actually posted. The Calculated Comm. (Purchase CY) is used to determine the Calculated Comm. (Base CY) value based on the exchange rate used. The value of the Received Comm. (Base CY) is in turn derived from the processed incoming invoice.

Commissionable Amount (Base CY)

If the entire Purchase Price is not subject to commission, the value which actually is can be entered here. The calculated values are now transferred to Calculated Commission and Commission %.

Commissionable Amount (Purchase CY)

This field is only available when Purchase is made in Foreign Currency. If commission is not paid on the entire Purchase Price, the value that is actually subject to commission can be entered here. The calculated values are now transferred to Calculated Comm. (Purchase CY) and Commission % and the values in Base Currency are calculated based on this.

3 Mark-up

This area is only shown if the module Order/ORDER_MARGIN_ALL_SERVICES is assigned. However, you can still prevent the entry of mark-ups for individual suppliers by settings in Supplier Master Data and hide the area. The area is expanded when the Price Calculation is opened, but can be closed by clicking on the - /+ icon.

The currency indicators are preset and depend on the currency of the organizational unit, the purchasing currency and the customer currency. We recognize the latter by the customer assigned to the order or the currency indicator set in order details. You can use the radio buttons to open fields for input and decide on which basis the mark-up should be calculated. The corresponding values are calculated either using the exchange rate used ( Purchase currency / Base Currency) or the exchange rate defined in master data (customer currency).

Mark-up Base Currency

TThis field is always available if the module is assigned.

Mark-up Purchase Currency

Only available for Purchase in Foreign Currency and otherwise hidden.

Mark-up Customer Currency

Only available for Sales in Foreign Currency and otherwise hidden.

4 Sales Currency

The currency indicator is preset and cannot be overwritten. If no Sales Currency other than the Base Currency is detected, this area remains hidden.

Sales Price (Customer CY)

The base for calculating this value is the Sales Price (Base Currency) and the exchange rate, from Base Currency to customer currency, defined in Order Master Data/FX Rates.

FX Rate

Sell rate, from Base Currency to customer currency, defined in Order Master Data/FX Rates.

Adopt Purchase Value

This indicator is set under the following conditions and cannot be removed:

Agent Sales AND Purchase Currency = Sales Currency, but different from Base Currency.

Example: A travel agency based in Switzerland (CHF) sells a TUI package that is offered in EUR. The travel agencies' customer will also pay in EUR. The travel agency will pass on the catalog price 1:1 to the customer, i.e. there must be no conversion at a possibly different exchange rate.

Principle Sales:

The individual setting of the supplier in order master data does not allow margin calculation (Allow markup NOT selected)

AND the supplier is not set to "Purchase net" (Commission mode).

AND Purchase currency = Sales Currency, but different from Base Currency.

5 Broker / Agency Commission

This area is only displayed if a broker and/or agency is assigned to the order. At the beginning the area is closed, but can be opened by clicking on the - /+ icon. The values for the broker or agency commission to be settled are only calculated when the entire order is saved.

Calculated Commission

The currently calculated commission to be paid.

Paid Commission

The commission already settled. If this differs from the calculated commission, a corrected settlement is automatically created in the following settlement cycle.

Use cases

The use cases listed below describe the manual creation of a service.

When importing from external systems, the corresponding fields are filled and any necessary conversion to local or customer currency takes place in the background. Manual adjustments in the Price Calculation Dialog can be made at any time, but please note that manual adjustments will be overwritten by subsequent imports. If you want to prevent this, you can assign the Order/PREVENT_CRS_REIMPORT module to add the Prevent repeated CRS import field in Service Details.

^{Prevent repeated CRS import}

Mode Agent Sales

Purchase and Sales in Base Currency

In this case, you can enter the Sales Price as usual in the Total Price field in the service details mask; the corresponding fields are transferred to the Price Calculation in the background. Only when you want to make changes, such as adjusting the expected commission, is it necessary to open the Price Calculation.

^{Agent Sales, Service Details}

Of course, the Total Price can also be entered in the Price Calculation Dialog in the Sales Price (Base Currency) field. The value entered there is transferred to the Purchase Price (Base Currency) field. Should the Purchase Price differ, this will be modified by using Mode Reveue Calculation.

^{Agent Sales - Purchase and Sales in Base Currency}

Purchase in Foreign Currency, Sales in Base Currency

If you sell a trip (as agent) which is advertised in a Foreign Currency, the basic precondition is the correct creation of the supplier in the master data. On the basis of the Supplier Account payable assigned to the respective supplier or Account ID (CR), assigned to the settlement type, we identify the currency in question and provide you with additional fields in the Price Calculation Dialog for Sales and Purchasing in the corresponding purchasing currency.

The Sales Price (Purchase currency) is transferred into the field Purchase Price (Purchase currency) here. If the Purchase Price (Purchase currency) differs, this will be adjusted via Mode Revenue Calculation.

The corresponding values in Base Currency are calculated automatically using the exchange rate.

^{Agent Sales - Purchase in Foreign Currency, Sales in Base Currency}

Purchase in Base Currency, Sales in Foreign Currency

Another area is added if we identify from the assigned customer that the order creation ( Sales ) should be in a currency different from your Base Currency. The Sales Price (Customer Currency) is calculated using the exchange rate defined in the master data (Base Currency → Sales Currency), which is also displayed in this area.

The Sales Price (Customer Currency) and the FX Rate cannot be changed in the dialog.

^{Agent Sales - Purchase in Base Currency, Sales in Foreign Currency}

Purchase in Foreign Currency, Sales in Foreign Currency

In addition to the Sales Currency, the fields for entering the Purchase Currency are now available in the Base / Purchase Currency area. If you enter the Sales Price (Purchase Currency), this value is transferred to the Purchase Price (Purchase Currency) field. If the Purchase Price (Purchase Currency) differs, this will be adjusted via Mode Revenue Calculation.

The values in Base Currency are calculated using the exchange rate and the fields are filled automatically.

The Sales Price (Customer Currency) is calculated using the exchange rate defined in master data (Base Currency → Sales Currency), which is also displayed in this area.

^{Agent Sales - Purchase in Foreign Currency, Sales in Foreign Currency}

Purchase and Sales in identical Foreign Currency

If both Purchase and Sales take place in identical Foreign Currency, the Purchase Price (Purchase Currency) is transferred 1:1 to the Sales Price (Customer Currency) as a default. The checkbox Adopt Purchase Value is now displayed and checked, a change of the setting is not possible. The definition takes place within the master data of the supplier only.

^{Agent Sales - Purchase and Sales in identical Foreign Currency}

^{Agent Sales - Adopt Purchase Value}

Mode Principle Sales

If the Order/ORDER_MARGIN_ALL_SERVICES module is assigned to your organizational unit, an additional Mark-up field is found in the Service Details mask. The entry of price values now takes place entirely in the Price Calculation Dialog, to be opened via the button .

The fields Total Price and Mark-up in the service details are therefore not editable.

Purchase and Sales in Base Currency

The initial value here is the Purchase Price (Base Currency), the mark-up entered (or the value calculated using the percentage specified) is added to this and transferred to Sales Price (Base Currency).

If you would like to adjust the Sales Price (Base Currency) after the calculation is complete, a radio button is now available to activate the field. Changing the Sales Price increases or decreases the value of the mark-up, the Purchase Price (Base Currency) will not be affected.

^{Principle Sales - Purchase and Sales in Base Currency}

Purchase in Foreign Currency, Sales in Base Currency

The basic precondition is the correct creation of the supplier in the master data. On the basis of the Supplier Account payable assigned to the respective supplier or Account ID (CR), assigned to the settlement type, we identify the currency in question and provide you with additional fields in the Price Calculation Dialog for Sales and Purchasing in the corresponding Purchasing Currency.

The exchange rate is taken from master data (purchasing currency → Base Currency). You also have the option to apply an individual exchange rate for this service, activate the entry by selecting the radio button FX Rate (Deviant). The selected exchange rate will also be suggested later when entering the incoming invoice.

You can now decide whether you want to enter the amount of the mark-up in purchasing or Base Currency or a percentage value. The Mark-up Base Currency field is activated at the beginning, you can activate the Mark-up Purchase Currency field by selecting the corresponding radio button.

The initial value here is the Purchase Price (Purchase Currency), the mark-up entered (or the value calculated using the percentage specified) is added to this and transferred to the Sales Price (Purchase Currency).

If you want to adjust the Sales Price (Base Currency) after the calculation is complete, a radio button is now available to activate the field. Changing the Sales Price increases or decreases the value of the mark-up, the Purchase Price (Purchase- as well as Base Currency) is not affected.

^{Principle Sales - Purchase in Foreign Currency, Sales in Base Currency}

^{Principle Sales - Purchase in Foreign Currency, modify mark-up}

^{Principle Sales - Purchase in Foreign Currency, modify Sales Price}

Purchase in Base Currency, Sales in Foreign Currency

Another area is added if we identify from the assigned customer that the order creation ( Sales ) should be in a currency different from Base Currency.

The Sales Price (Customer Currency) is calculated from the Sales Price (Base Currency) using the exchange rate defined in master data (Base Currency → Sales Currency), which is also displayed in this section. Sales Price (Customer Currency) and FX Rate cannot be changed.

In addition, you now have the option to specify the desired mark-up in customer or Base Currency. At the beginning the field Mark-up Base Currency is activated.

^{Principle Sales - Purchase in Base Currency, Sales in Foreign Currency}

^{Principle Sales - Purchase in Base Currency, Sales in Foreign Currency, modify mark-up}

^{Principle Sales - Purchase in Base Currency, Sales in Foreign Currency, modify Sales Price}

Purchase in Foreign Currency, Sales in Foreign Currency

The exchange rate is taken from master data (purchasing currency → Base Currency). You also have the option to apply an individual exchange rate for this service, activate the entry by selection the radio button FX Rate (Deviant). The selected exchange rate will also be suggested later when entering the incoming invoice.

Another area is added if we identify from the assigned customer that the order creation ( Sales ) should be in a currency different from your Base Currency. The Sales Price (Customer Currency) is calculated using the exchange rate defined in master data (Base Currency → Sales Currency), which is also displayed in this area.

The Sales Price (Customer Currency) and the FX Rate cannot be changed in the dialog.

You can now decide whether you want to enter the amount of the mark-up in customer, Purchase or Base Currency, or a percentage value. The field Mark-up Base Currency is activated at the beginning; you can activate the other fields by setting the corresponding radio button.

^{Principle Sales - Purchase in Foreign Currency, Sales in Foreign Currency}

Purchase and Sales in identical Foreign Currency

If both, the Purchase and the Sales, take place in identical foreign currencies, you may decide depending on the supplier:

The Sales Price in Foreign Currency (e.g. a catalogue price) should be taken over 1:1 as the Sales price in the customer currency.

This basic setting is defined in the supplier's master data only, to do this, remove the Allow Mark-up indicator, Commission mode must NOT be net Purchase:

^{Master Data settings - Adopt Purchase Value}

The checkbox Apply Purchase Value is now displayed and activated, it is not possible to change the setting in the dialogue:

^{Purchase and Sales in identical Foreign Currency, Adopt Purchase Value}

Despite identical Purchase and Sales Currencies, the calculation of the Sales Price shall take place on the basis of the current daily exchange rate:

^{Master Data settings - Allow Mark-up}

^{Purchase and Sales in identical Foreign Currency, Calculate Sales Price}

Traveltype Flight

For a flight service with ticket documents, the Price Calculation button is only active in the ticket item. Ticket values are still modified in the ticket mask, if necessary, and cannot be edited in the Price Calculation dialog. Only the Mark-up field can be edited in the ticket mask as well as in the price calculation.

^{Price Calculation on Ticket Level}

Price Details

The module Order/Item_Details_Prices activates the tab Price Details which can be edited directly in the service as well as from the order screen by selecting the service. Add here a description of the partial service, the unit price and the quantity. The respective total prices of the partial services are determined and a total sum is calculated. In addition, the current value of the service and the new total price determined on the basis of the partial services are displayed in the lower area. This price is transferred to the price field that is active depending on the mode and purchasing currency when you save the order.

The partial services as well as the person allocation are for information only, these details will not be printed.

Price Details

Settlement Details

The Settlement Details at service level reflect the Price Calculation. You may check all the values here, but no changes are allowed. These must be made directly within the Price Calculation dialog.

Exception:

The payment type (agency/client settled) can also be adjusted at this point, if permitted by the master data settings of the supplier.
The value of the submitted commission at service level can be edited at this point.

^{Settlement Details}

Supplier Master Data

If the module Order/ORDER_MARGIN_ALL_SERVICES is assigned to your Organizational unit, an additional checkbox Allow Mark-up is available in Order Master Data / Supplier.

This is selected by default when a new supplier is created, as soon as the module is assigned.

To prevent the entry of mark-ups for a supplier, deselect this indicator. This is only allowed for roles to which the right Edit mark-up settings for Supplier is assigned.

For this supplier, the Price Calculation Dialog will then be available as described under Mode Agent Sales, and in case of Purchase and Sales in identical Foreign Currency, the Sales Price (Purchase Currency) will be taken over 1:1 in Sales Price (Customer Currency).

^{Supplier Master Data}

A detailed description of all fields of the supplier master data can be found here.

Account Payable, set Foreign Currency (Supplier Invoice Payable)

When creating the account, select the currency in which you expect the incoming invoices from the supplier. This account payable is now used for the specified currency only.

It is only necessary to select the currency if it differs from your Base Currency.

The subsequent change of the currency of an account payable is not possible.

^{COA - Account Payable, set Foreign Currency}

Settlement Type

If you want to assign different vendor accounts with different purchasing currencies to one supplier, this can be defined via Settlement Types, to which you assign corresponding Settlement Accounts.

Definition of Settlement Types

The Order/OrderSD_settlement_type module activates the Settlement Type tab in your Order Master Data. Here you first define your settlement type(s):

Settlement Type: Assign a short "ID" here.

Description: This is the description that will later be available in the service details.

Valuta immediately: If this indicator is set, the turnover recognition point is not the departure date but the creation date of the service.

Hidden: This settlement type cannot be selected when the service is created manually; it is addressed and assigned to the service using rulesets or import files.

^{Settlement Types, Definition}

Definition of Settlement Accounts

After creating the Settlement Type, you can select it in the Settlement Accounts tab of the supplier, which you define as follows:

Supplier ID: The selected supplier is preset.

Valid From: Select the date from which the setting should apply.

for CNX: Triggers a different posting if the service is flagged as canceled (status XX).

Destination: The setting only applies to the destination defined here; if you do not want any restrictions, enter a "*" here.

Travel Type: The setting only applies to the Travel Type defined here; if you do not want any restrictions, enter a "*" here.

Settlement Type: The setting only applies to the settlement type selected here, to be set in the service.

Account ID (CR): Enter the account payable to which the expense is to be posted.

Account Commission VAT: Revenues can be posted to a different revenue account depending on the criteria defined here.

Account Commission Non VAT: Revenues can be posted to a different revenue account depending on the criteria defined here.

Account Commission Insurance: Revenues can be posted to a different revenue account depending on the criteria defined here.

Package Account, Margin Account, Margin Account Negative: These fields refer exclusively to a single margin booking logic acc. to § 25a UStG (German tax law), the definition of accounts at this point has no effect on the posting of the mark-up´s in connection with module Order/ORDER_MARGIN_ALL_SERVICES

^{Settlement Accounts, Definition}

By assigning the settlement type to the service, its Purchase currency is determined and the corresponding input fields are displayed in the Price Calculation:

^{Service Details, Settlement Type}

^{Customer, Foreign Currency settings}

^{Account Receivable, set Foreign Currency}

Define an account group for one-time-customers (Divers Debtors)

This account enables you to process orders for customers you deal with only once or very rarely, as well as for "trial" customers.

Create the account receivable / debtor account within your CRM Master Data together with the currency indicator. Of course, the sub-division by initial letter can also be made for divers debtors in Foreign Currency or the distinction by company / private customer can be defined.

Please do NOT make a currency setting if the account receivable is to be managed in your Base Currency.

^{Account Receivable - CRM Master Data, set Foreign Currency}

Divers Debtors, Chart of Accounts

The newly created account is automatically transferred to your Chart Of Accounts. To avoid any possible incorrect entries, it is not permitted to change the currency indicator here.

^{Account Receivable - Chart of Accounts}

^{Customer account (Direct Debtors)}

Link your customer to a debtor account/account receivable

When you create a customer, you might want to link them to their own debtor/ account receivable, rather than using the Divers Debtor account.

The account receivable can be created by entering the required account code as part of the new customer details under the tab Billing/Payment Setting.

Enter the account code into the field Assigned Debtor and assign a currency code as well, if needed.

Do NOT enter a currency indicator if the customer currency is the same as your Base Currency.

^{Account Receivable - CRM, link customer to an account receivable}

Account Receivable, Chart Of Accounts

The account assigned in the CRM is automatically transferred to your Chart Of Accounts. There the field Currency is no longer editable to avoid errors due to different entries.

^{Account Receivable - Chart of Accounts}

Account Receivable / Direct Debtors, CRM Master Data

The required assignment of debtors to the organizational unit in the CRM Master Data is also carried out automatically; here too, the currency indicator of the account receivable cannot be changed.

^{Account Receivable - CRM Master Data, Direct Debtor}

Order creation, Foreign Currency Sales

If no customer is assigned to the order, or if no Sales Currency other than Base Currency is specified, the corresponding areas/fields are not available in the Price Calculation Dialog:

Mark-up Customer Currency
Sales Currency

When the order is saved, if a Foreign Currency is later recognized as the Sales Currency, the recalculation is carried out completely automatically in the background. The hidden fields are then of course also available in the Price Calculation Dialog.

A new calculation is also triggered in the background if the order customer, and therefore possibly the Sales Currency, changes afterwards. You can check this in the Price Calculation Dialog at any time.

Account Receivable, Foreign Currency

If an Account Receivable (Foreign Currency) is assigned to the order customer, this is taken over when a service is created.

^{Order creation, Account Receivable / Direct Debtor - Foreign Currency}

Account Group / Divers Debtor, Foreign Currency

If the order customer is not linked to it´s own account receivable, but the order is to be settled in a currency other than the Base Currency, enter the desired currency code directly in the order AFTER initial saving of the order. The pre-condition for this, is the existence of an account reveivable / divers debtor in the respective Foreign Currency, which is now assigned to the order. To do this, enter the currency indicator in the detail area (at shopping basket level).

In the Price Calculation and in the order, the values are now determined and displayed in the desired currency.

This indicator can of course also be transferred from booking systems.

^{Order creation, Account Receivable / Divers Debtor - Foreign Currency}

FX Rates

Midoco receives daily updated exchange rates from the European Central Bank ECB from EUR into any major currency and provides you with the exchange rate in the opposite direction based on this.

You can, of course, enter deviating exchange rates and set them for an entire month, for example. The "Global" indicator inherits this exchange rate in each of your subunits.

^{FX Rates}

Entry of a Supplier Invoice (FCY), manually

In the dialog for entering the incoming invoice, the FX Rate from the service is preset. This might be the exchange rate from the master data at the time of the creation of the service or the deviating exchange rate entered there. The current exchange rate from your master data is also displayed. Activate the use of the daily exchange rate by setting the radio button if you want to post the incoming invoice at this rate.

Entry of Supplier Invoice, Foreign Currency

Chart of Accounts

In the Chart of Accounts you will find new indicator Foreign Currency Bank Account, which can be activated when selecting a sub-ledger account.

Please set this indicator in the sub-ledger account you have created for your bank account in foreign currency.

^{COA - Foreign Currency Bank Account}

Error handling

The wrong currency code was transmitted by an external system.

If the Purchase currency does not match the currency of the supplier's account payable, you will be notified of this by an error in the order:

^{Error message, Currencies do not match}

Now open the Price Calculation Dialog , here the Purchase Price in the currency of the supplier is suggested to you. If the values are correct, confirm this by pressing the save button.

Otherwise, change the supplier assigned to the service and save the new values in the Price Calculation Dialog.

The Purchase value as well as the correct currency indicator are now also transferred to the Service Details, the error in the order has been fixed.

^{Error message, Currencies do not match, troubleshooting}