Create calculation and Field description


Contents


Fields on the Calculation tab

Field

Function

Field

Function

Reference number

Reference number of the service order

Service type

Service type of the service order

Container

Container number from the service order (FCL only)

Container number from the service order:
If a container number was sent with the provider response, the container number in the goods description is automatically replaced, provided that this was configured in the interface.

Bill. code

Billing code

(In case of expense accruals (voucher type R1), the service type deposited in the billing code is taken as a basis upon transfer into the account sheet.)

Click on the arrow next to the column to open a popup window and enter up to 5 lines of additional text - analogous to the voucher entry.

Arrow (per line)

Click on the arrow (available in every line next to the column Billing code) to open a popup and enter up to 5 lines of additonal text - analogous to the voucher entry. This text is translated upon voucher entry (provided that a corresponding translation is available in the basic data).

Description

Description of the billing code

Code

Here you can select the calculation code F = Fixed price or M = Multiplication from the dropdown menu.

F is pre-assigned by default for rate transfer from ECM since the calculation is made in ECM.

Quantity

Quantity of the amount that is to be calculated

Unit/Qty.

Unit of quantity
This is either suggested based on the billing code or can be selected/changed manually via the dropdown menu.

Single amount

Single amount to be calculated

Total amount

Total amount for this billing line (calculated by the system based on code and amount).

CUR

Currency

Upon entry or transfer of rate lines in foreign currency from ECM, the application follows the following priority:

  1. Rate quota

  2. Vessel R.O.E. (from the Statistic tab in the file)

  3. R.O.E. from basic data CURRENCIES

R.O.E.

Exchange rate
If entered in the basic data, the R.O.E. is pre-assigned.
Manual entries are also possible.

Revenues

Revenues

Expenses

Expenses

Balance

Balance

Voucher type

The voucher type can be selected from the dropdown menu.

Available voucher types:
G = Credit note
R = Invoice
R1 = Accrual expenses
R5 = Accrual revenues

Account types

The account type can be selected from the dropdown menu.

Available account types:
K = Creditor
G = Mixed acount
D = Debtor

Account

Account number of the address

Name

Name of the address

Sorting

Pre-assigned automatically; but can be changed manually in order to determine a sorting of the billing codes. This will be the order in which the lines are transferred into the outgoing invoicing.

Booked

This checkbox is activated upon transfer of a line into the account sheet.

Voucher no.

Display of the voucher number after successful transfer into the account sheet

ECM Service contract (Purch.)

Display of the ECM service contract number upon transfer of a purchase rate (EK) from ECM

ECM Service contract (Sell.)

Display of the ECM service contract number upon transfer of a sales rate (VK) from ECM

ID

System identification number (assigned per line by the system)

Manual Booking

Indication of whether the billing line has been added or changed manually.
These lines are not deleted in case of a recalculation via ECM.

Origin

Origin of the rate

Destination

Destination of the rate

Filling rule: Calculate order

Provided that Filling rule 31 Calculate order is entered in basic data ADMIN → STATUS TYPES, this status is automatically inserted in the status system (Infotab → Status system or on the Status main tab) if:

  • you click context menu→ Calculate order and Calculate buying/selling.

  • you manually enter a selling line (invoice) on the Calculation tab.

The status is inserted when you select Voucher type R or R5, not after saving.
When calculating repeatedly, the status is also inserted multiple times, provided that this has been configured in the status types.

As soon as the status is has been entered, function Automatically start function Calculate order no longer takes effect.

Filter

On the Calculation tab you can apply a filter to each column to filter the result accordingly (similar to Excel).

Display rows grouped and folded

On the Calculation tab you can group the individual lines according to each account.

This group can be folded or unfolded using the arrow key in the upper area (next to the field reference number) and the setting can be saved viaSave layout.

 

 

Â