When importing collective invoice files from Excel (cost splitting), a billing text can be entered for each billing code.

Environment menu → Invoicing → Cost splitting.

Here you can do a cost splitting and either buffer the data in the table "schnifakt_t" or directly enter a collective invoice number and create collective voucher items (SP/GP) from it.

If you select the item "from Excel table" under "Split by...", you can read in the data via an Excel file.
This file was extended by own billing texts.

At the end, collective outgoing vouchers are also generated or these schnifakt_t records.
The data records from the schnifakt_t table can be selected in an outgoing voucher in the Voucher items tab via the right mouse menu "Billing records".

Contents

Related topics


Note the structure of the Excel file

When creating the Excel file, it is important to ensure that the order of the first 4 columns remain the same as before.

Columns remain the same as before:

  1. File number (The heading must begin with the text "Position" or "File").
  2. Activity type
  3. Amount
  4. Invoice number

Invoice texts 1-5 can be placed further to the right and do not have to directly follow the first 4 columns.

The headings would have to end with the words "Text1, Text2, ..." or "Text 1, Text 2, ..." and are only available when transferring from an Excel file if the columns are created with the heading, otherwise the new text fields are hidden.


Cost splitting in Invoicing in Envorinment

Context menu entry Read Excel file

Split option ...   Load from file


The following rules apply when copying the text:

  • If the column for text 1 is filled, all texts from the Excel file are taken, also empty texts from the other columns 2 to 5.
  • If the column for Text1 is empty and at least one of the columns Text2 to Text5 is filled with a text, the 1st text is read from the accounting type, all other texts from the Excel file (also empty texts).
  • If none of the text columns is filled with a value, all data will come from the accounting type as before.


With the arrows in front of the fields and in the heading, the texts can be displayed per position or for all rows and columns.

Read-in texts can be changed manually and transferred to all rows of a column.

In order to use this function, a direct right-click must be made in another text field above or below (same column) after the manual change in a text field and Copy text to all rows must be selected in the context menu, whereupon a warning message appears.


ATTENTION: When transferring texts, a direct right-click must be made in the other field for the function to take effect.

  • No labels