Authorization object: STATRUECK

CargoSoft enables to create files. CargoSoft also transfers open accruals into the report depending on the search criterion.
These can afterwards be loaded into the payable.

To create such a file, select Environment menu → Controlling → Open accruals Excel-import format.

The open accruals program is one of the list programs: These programs start with a search mask and output a report as the search result.


Column split(if cost splitting = J)
Split

SPLIT is set, if cost splitting takes place upon entering the accruals.
→ It is splitted to the positions when importing the file.

Example

List of all open accruals for a service provider– in this case a carrier, transport company – for a specific month in order to book a monthly invoice/collective invoice.

Press F3 → The search result will be displayed as a report (8 columns).

You can now export this result to Excel (xls, not xlsx) or as a csv-file in order to load it or possibly edit it in advance.

Side note: Loading the Excel file into a collective incoming invoice

In order to follow the path of these work steps, the previously created Excel file is now used in CargoSoft to create a collective incoming invoice of an invoicing party.

For this, please open the accruals from the list and compare them to the individual files of the payable.

  • The individual amounts are distributed to the sub-files/consol files.
  • Accruals are booked against them.
  • The conformity indicator is automatically set to U in each line.

→ The invoice can now be saved and booked.