| Aura panel |
|---|
| summary | Einleitung |
|---|
| params | JTdCJTIyYm9keSUyMiUzQSU3QiUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyMzQ2NTY3MSUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybm9ybWFsJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExNiU3RCU3RCUyQyUyMmhlYWRlciUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMDE0OWIwJTIyJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnNpemUlMjIlM0ExOCUyQyUyMm5hbWUlMjIlM0ElMjJib29rLW9wZW4lMjIlMkMlMjJjb2xvciUyMiUzQSUyMiUyM2ZmZiUyMiU3RCU3RCUyQyUyMmhlYWRsaW5lJTIyJTNBJTdCJTIydGV4dCUyMiUzQSU3QiUyMnRleHQlMjIlM0ElMjJFaW5sZWl0dW5nJTIyJTJDJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMm5vcm1hbCUyMiUyQyUyMmZvbnRTaXplJTIyJTNBMTglN0QlMkMlMjJhbGlnbm1lbnQlMjIlM0ElN0IlMjJob3Jpem9udGFsJTIyJTNBJTIyc3RhcnQlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyMzAwNDliMCUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyd2lkdGglMjIlM0ExJTdEJTdEJTJDJTIyYmFzZSUyMiUzQSU3QiUyMmJveFNoYWRvdyUyMiUzQSU3QiUyMnNoYWRvd3MlMjIlM0ElNUIlN0IlMjJjb2xvciUyMiUzQSUyMnJnYmEoMCUyQyUyMDAlMkMlMjAwJTJDJTIwMC4wOCklMjIlMkMlMjJ4JTIyJTNBMCUyQyUyMnklMjIlM0ExJTJDJTIyYmx1ciUyMiUzQTElMkMlMjJzcHJlYWQlMjIlM0EwJTdEJTJDJTdCJTIyY29sb3IlMjIlM0ElMjJyZ2JhKDAlMkMlMjAwJTJDJTIwMCUyQyUyMDAuMTYpJTIyJTJDJTIyeCUyMiUzQTAlMkMlMjJ5JTIyJTNBMSUyQyUyMmJsdXIlMjIlM0EzJTJDJTIyc3ByZWFkJTIyJTNBMSU3RCU1RCU3RCUyQyUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyYm9yZGVyJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjMwMDQ5YjAlMjIlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIyYm90dG9tJTIyJTNBdHJ1ZSUyQyUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSU3RCUyQyUyMnNpemUlMjIlM0ElN0IlN0QlMkMlMjJib3JkZXJSYWRpdXMlMjIlM0ElN0IlMjJyYWRpdXMlMjIlM0E4JTdEJTdEJTdE |
|---|
|
The voucher items in the billing lines of the incoming invoicing can be loaded and pre-assigned either from an Excel file or a .csv-file.
Loading a .csv-file is always suggested if Excel is not available, e.g. because it is not installed on the terminal server. |
| Panel |
|---|
| panelIconId | atlassian-info |
|---|
| panelIcon | :info: |
|---|
| bgColor | #FFFAE6 |
|---|
|
This function is located in the context menu |
...
Contents
| Child pages (Children Display) |
|---|
|
Links to further informationRelated pages
...
The file must be structured as follows to be loaded.
...
| Panel |
|---|
| panelIconId | atlassian-info |
|---|
| panelIcon | :info: |
|---|
| bgColor | #FFFAE6 |
|---|
|
If you would like to create an Excel file yourself, please keep the exact wording of the headline in mind! |
...
Overview of Excel file requirements
The data must be entered on the first sheet. |
|
|---|
The file numbers must be entered one below another without blank lines. | The transfer will cancel if the Filenumber column is not filled. |
|---|
The columns must be entered in the following order:
→ Pls see alteration above!
| Filenumber (as an alternative: HAWB) → Activity type → Amount → tax key → Accrual No. → Acc. No. |
|---|
Check for double HAWB numbers | When using HAWB in column 1, the system checks whether the HAWB number exists twice in the import file.
If the HAWB number is found multiple times in the file, this file CANNOT be loaded.
The system will make an entry in the protocol. |
|---|
The amount is loaded without currency indicators. | The currency in the billing lines is pre-assigned from the voucher header data. |
|---|
The columns Accrual No. and Acc. No. are optional. | If filled, they are also loaded.
Filling the accrual date in the report is – in most cases – executed through the generation of the CargoSoft Excel list. Side Note: create excel file with open accruals from CargoSoft.
The entry of this accrual list in CargoSoft is explained in detail in Open accruals Excel-import format in Controlling. |
|---|
If accruals for the files are recorded in CargoSoft, these are automatically suggested (under consideration of the address, file number, and service type). | The accrual is converted to the currency of the voucher header as far as possible.
If this is not possible due to missing R.O.E.s, an information message will appear.
Please check the currency and the amount in the billing line. |
|---|
The currency was probably changed to the currency of the accrual, but not the amount. |
|
|---|
Basic data cannot be found → | If no file, service type, or tax key from the Excel file can be found in CargoSoft, an error message will appear and the transfer will cancel. |
|---|