Documentation
Back to website >

Fibunorm interface

The Fibu interface is located on the left side of the quick start bar under "Accessories" - "Fibunorm Interface".

Fibunorm interface

 

With the help of this interface, the invoice data is output as a customer target position; incoming payments are not transferred accordingly.

 

Outlay

The booking period can be set via the selection box after complete months. If you want an individual output period, you can select the date fields "from"- "to" and set a free period for output.

For compatibility reasons, the file name should always be"fibunorm.fbu".

Select period

 

Structure of the Fibunorm format 2.0


File name: *.FBU

Record length: 128 bytes + CR LF

At the beginning of a file there is always a preamble (V-phrase). This contains the version number of the Fibunorm format, creation date, and so on.

Each invoice is introduced by a header record (H record) and can be extended by name (N record), address fields (A record) and extension fields (X record). At least one split record (S record) with the net amounts must be at the end of an invoice. If different revenue accounts are used, a split record is transferred for each revenue account. Unknown record types must be ignored during import.

Numeric fields (###) are displayed right-aligned with leading blanks. However, it should also be possible to process left-justified fields during import. In fields with a decimal point, this is always transferred as a point (.). Each file is preceded by a preprocessing record with version number and creation date.

At the end of the successful conversion to the FIBU format, the FBU file should be deleted.

 

V-phrase (preamble)

The V-phrase is a prephrase that is output once at the beginning of the file.

The Fibunorm format is designed so that various applications can extend the file. The"Created text" from the"V" preprocessing block contains only the application name that created the file. The record by record identifier is in the header record (header ) in record type"H". The second field can be used to name the application that created the record or to determine the application for which a return is intended.

 

H phrase (headers)

The H-rate is placed in front of each invoice.

The field "Application" in combination with the field "Direction" indicates from which application the FIBU data set was created (Direction E for export), or for which application a data set is intended (I for import).

The field GR is used specifically by the program EURO and specifies whether the FIBU data record is an invoice or a credit memo. By default, the EURO uses positive amounts as the sales or amount field and uses this field to indicate the"negative" amount. To obtain the true +/- sign of a sales amount, the amount for a"G" in the RG field must simply be multiplied by -1. This is always correct.

The complete document amount including any tax is transferred in the"Gross" field. Splitting to different revenue accounts is carried out using record type"S" (split records).

The "Target" field contains the net payment target in days.

The"Bank statement" field contains the number of the bank statement when incoming payments are posted.

The"Date created" field contains the date on which the posting record was created. Not to be confused with the document date. EULANDA® uses a customer debit position as standard for the FIBU output. All documents are created here at the end of the month and the creation date is this export date. However, it is also possible to generate actual taxation; this is supported by the EURO program. The EURO then exports the complete FIBU data record to the Fibunorm file on receipt of payment. In this case, the creation date is the entry date of the incoming payment.

The "Reference" (in preparation) is used to uniquely identify an invoice by Invoicing and FIBU. If an incoming payment is posted in the FIBU, the amount can be transferred back to invoicing via this reference.

 

N phrase (name phrase)

The N-phrase contains the name fields of the address data set.

 

A phrase (address phrase)

The A-phrase serves as an extension of the name set.

 

X-set (Xtended extended set)

The extended X set is mainly used to transfer cash discounts to the FIBU. The "Deadline" field is used as the target. If the cash discount is valid for the entire invoice amount, the"Cash discount percentage" field is used and"Cash discount amount" contains blanks. If only certain items are subject to cash discounts, the absolute cash discount amount is specified in the"Cash discount amount" field and the"Cash discount percentage" field contains blanks.

 

S-record (split record)

For each VAT rate or revenue account used for an invoice, a split rate (S rate) is added. If actual accounting (EAR) is used, the incoming payment fields and the financial account can be transferred in the S record.

If you are working with Actual Accounting, the date of the incoming payment (PA DATE), the financial account and the incoming payment amount (PA Amount split) are transferred in the split record. The transfer of the gross price is necessary due to rounding differences.

In the TARGET accounting (debtor debit position only, i.e. FIBUs), the incoming payment is only entered in the FIBU.