Booking module
- Hauke Gulich
- Sabrina Stelter
Contents
Basic data
Batch invoicing
The batch invoicing processes every recorded voucher.
This includes all incoming and outgoing vouchers that were completely recorded in CargoSoft TMS or automatically arrived via interfaces.
→ In this context, the verb to process means that the voucher is booked onto the respective account sheet.
The following tables are filled for this purpose:
spktopo_t | Every voucher results in an entry. |
|---|---|
spktoleist_t | All voucher lines are saved (cumulated per service type with revenue or expense values and house and foreign currency). |
spktoaart_t | All voucher lines of a voucher are saved (cumulated per billing types or, if the recording has taken place without billing type, cumulated per service types with various voucher information). |
spktocont_t | If a billing line addresses a container, thus includes an entry of one or more container numbers, the respective amounts are determined per container and saved in this table. |
Account sheet and environment menu Controlling
In some instances, these tables save the data in a redundant manner on purpose. This enables the customers to make their own evaluations.
These table entries are required for the appearance of the voucher in the different displays (tabs) of the account sheet.
They are also necessary for the correct start of the reports for the billing type statistics (environment, controlling) and for the service type statistics.
Accounting interface
The second crucial function of the batch invoicing is to correctly fill the tables for the financial accounting interfaces.
The data are grouped depending on the accumulation recorded in the basic data. The data are then assigned to the general ledger accounts and cost centres also deposited in the basic data.
They are finally saved in the tables fibuko and fibupo. These tables are evaluated by all interface programs according to the different financial accounting systems.
One statistikins_t table entry is made per file number that the batch invoicing processes into a voucher.
CargoService or TMS programs also add various entries to this table.
If the batch invoicing does currently not process, i.e. if no vouchers with billing indicator abrech_kennz = [E] can be found in table eafako_t, the statistics program will start. It processes a certain amount of entries in the table statistikins_t before the batch invoicing is restarted to examine if new vouchers are available for the processing.
Statistics program
The statistics program processes the table statistikins_t, which includes information of place and type of process per file number.
It loads all important data of a file from the order tables (the most important being eakopf_t, eaairkopf_t, eaware_t, eawarecont_t). It then resorts and regroups the data and saves them in the statistics tables per file.
The most important statistics tables are:
Statistik_t
Statistikcont_t
These tables are the basis for
all standard evaluations in TMS (menus Controlling and Statistic),
and are used for
the creation of customized reports,
the dynamic search for files, and
the dashboard.
Another important function of the statistics program is to recalculate the data in the table sblt_v.
→ This table is the basis for the totals sheets and G-V-Reports in the Controlling menu.
The statistics program also initiates follow-up processes, e.g. data transmission to external partners.
The statistics program processes a defined number of files before it pauses to enable the performance of the batch invoicing.
Error management
Both booking module programs enter messages into a file named faktura.log or statistik.log.
→ These files are located on the communication server in the home directory in the subfolder log.
If actual error messages appear while the batch invoicing executes the voucher processing, the users who have recorded the voucher will receive an email including the reasons for the program abortion. This email is also available in the sidebar of the order.
Users entered in all three fields Send error to email address 1 (or 2 or 3) in basic data COMPANY → INVOICING → Extras tab are also informed of batch invoicing abortions via email.