Financial accounting sub tab in Accounting tab in ADDRESSES

image-20240418-164954.png

Contents

Topic in the order

Basic data


Field description of the sub tab Financial accounting

Field

Description

Field

Description

Payment term

For the preallocation in the outgoing invoicing. Entry in the basic data ACCOUNTING → PAYMENT TERMS.

In COMPANY → INVOICING → Preallocations tab you can record preallocations for payment terms of customers for the address entry.

Payment term - Creditor

For information only – no further function.

Payment term - Duty/Tax

Here you can enter an alternative payment term if the system automatically creates invoices for duty and tax.

Payment term - Seafreight Export/Import

Here you can enter an alternative payment term for Seafreight per sector Export and Import respectively.

Payment term - Airfreight Export/Import

Here you can enter an alternative payment term for Airfreight per sector Export and Import respectively.

Payment term - Transport/Warehouse

Here you can enter an alternative payment term for modes Transport or Warehouse respectively.

Payment term - Road

Here you can enter an alternative payment term for mode Road per sector Export, Import, National and Dispo.

Payment term - Rail

Here you can enter an alternative payment term for mode Rail National or International.

Automatic invoicing duty/tax

CargoSoft can create automatic invoices in the file. This requires the CargoSoft module CargoCom.

Country– VAT-ID

The 2-digit country code.

This is used to determine the correct tax key.
A search mask is available.

→ For more information, see Tax key preallocation in receivables and payables. 

VAT-ID no.

The VAT-ID no. including the country code for the print on receivables.

It is furthermore possible to check the VAT-ID no. for correct formatting.

→ Activate this function in basic data COMPANY → GENERAL COMPANY PARAMETER → Specials tab: checkbox Check VAT-ID no.

If this checkbox is activated, the system will check the entry in the field VAT-ID no.

→ This requires that the Country field has been filled before the VAT-ID no.

If you have entered a country code of one of the EU member states in the Country field, the program will run the check after you have entered the VAT-ID no. 

The Country field does not replace the country prefix of the actual VAT-ID no. The country code is thus added to the actual VAT-ID no. All VAT-ID numbers are entered without blank spaces.

COUNTRY EXAMPLES:

  • Country DE: VAT-ID no.: DE123456789

  • Country GR: VAT-ID no.: EL123456789

  • Country CY: VAT-ID no.: CY12345678X

  • Country GB: VAT-ID no.: GB123456789 or GB123456789012 or GBGD123 or GBHA123

  • Country ES: VAT-ID no.: ESX2345678X or ESX23456789 or ES12345678X

  • Country NL: 
    The format of the VAT ID number in the Netherlands (BTW ID) has changed for certain companies.
    The new format is recognized as valid in addition to the old format in the system.
    Structure of the new NETHERLANDS BTW identification number: OB number NL twelve, 1.-10.th digit can be numbers, letters and the characters '+' and '*' in random order; 11th - 12th digit must always be a number.

The VAT ID no. of European addresses is the identification number required for the data transmission to Chinese customs.  

Formatting check of enterprise addresses

If you enter a VAT-ID number in the tabs address, accounting, clients and customs in an address, the check will be made to save whether the correct format has been entered. In addition, a mandatory field check for the VAT-ID no. field is activated when the country code is entered.

Only the country code can be entered and the field for the number can remain empty.
If a VAT-ID no. is recorded, the format check is carried out.   

If the address is not a company (ADDRESSES → General tab → Sales sub tab → Checkbox contractor (=enterprise) deactivated), the mandatory field check for the VAT ID no. is now deactivated in the above-mentioned tabs.

Financial account

This checkmark allows the invoicing on this address.

mc.

For information only – no further function.

Altern. acct. no. (see below)

Here you can enter an alternative account for financial accounting.
If this entry is valid for debtor and creditor bookings, it suffices to fill this field with address type and account (account type and address number).

Alternative account (creditor)

Here you can enter an alternative account for financial accounting.
This entry is transmitted to financial accounting in case of creditor bookings (payables).

Alternative bill-to-party

If the receivables are always to be issued to an alternative address, e.g. the address of central accounting, enter the corresponding address here.

The alternative address must be recorded in CargoSoft.

Date of last invoice

The date of the last invoice in CargoSoft.

Date of last shipment

The date of the last shipment in CargoSoft.

Credit Reform

For information only – no further function.

Accept difference in accruals (payables)

Only valid for the CASS address to edit and transfer the invoice as CArgoSoft payable.

If the difference between the CASS invoice and the accrual exceeds the tolerance entered in the basic data, the system automatically inserts A (accept) into the payable.

Accumulate posting lines (CargoCom payables)

Here you can set whether posting lines with the same file number, activity type, currency code and tax key are combined in one line and the amount is added up.

The checkbox concerns the topic Master data for importing incoming vouchers and Automatic incoming voucher processing (...).

Internal house

For internal invoicing, e.g. from one branch to another.

If this checkbox is activated, two new voucher types become available in the outgoing invoicing: Internal Invoice (I1) und Internal Credit Note (I2)

A new window opens after you have selected of one of these voucher types in the invoice header.
Please enter the opposite file number.

The account sheet is posted for both files.
One file has a negative amount, the other a positive amount.

(The dataset is saved in eafako_t, the counter file with eafako_t.original_pos='N' so that it will not appear in the invoicing overview.)

Collective account

For information only – possibly for interface transmissions.

Customer no.

Here you can enter the own customer number into the supplier address.

This field is for information only.

Supplier no.

Here you can enter the own customer number into the supplier address.

This field is for information only.

Payment method

Freely editable 1-digit field.

For information only!

Account type

Synchronized with the corresponding field in the header data.

Selection via search mask – entry in ADDRESSES → ACCOUNT TYPES.

Tax number

For information purposes.

Can also be used for reports (receivables).

Tax office

For information purposes.

Can also be used for reports (receivables).

Commercial register

For information purposes.

Can also be used for reports (receivables).

Enforce sales tax

If this checkbox is activated, the entries in the fields Sales and Input tax key cannot be edited in the voucher entry.

Sales tax key

Used for the preallocation in the outgoing invoicing.

Input tax key

Used for the preallocation in the incoming invoicing.

Cost center

For financial accounting transfer – Entry in basic data ACCOUNTING → COST CENTERS. 

Block order entry

If this flag is set, this address can no longer be used in the order entry.

If you block an address subsequently and open a file with this address, the file is also blocked for further editing.
The system issues a corresponding message and makes an entry into the syslog.
Repeat print and emailing from such a file are still possible.

This flag is usually set by accounting interfaces.

Fields: Alternative financial accounts

These fields for alternative financial accounts in the addresses are used for the invoicing.

image-20240418-165210.png

The check of alternative financial accounts is performed on the Administration tab in INVOICING in COMPANY.

For every address you can enter an alternative financial account in the basic data to post the voucher to a different account number in the financial interface.

The system checks the following upon invoicing

1. Invoicing on A-addresses

You can only invoice on an A-address if a valid alternative financial account has been entered. Valid means ...

  • that the entered address exists in the CargoSoft addresses.

  • that the account type is allowed for the selected invoicing voucherr type.
    (In this case A-addresses are not allowed as alternative financial accounts!)

  • that the account is not blocked.

  • that the open items do not exceed the credit limit (if this is checked).

  • that the entered account is a financial account.

In this case, the voucher is saved and posted in the A-address in CargoSoft.
The financial interface uses the alternative financial account (e.g. Accounting journal in Environment → Invoicing)

2. Invoicing on other addresses

For all other address types D(ebtor), K(reditor), G (mixed account current), the system does not check the alternative account types upon the entry in CargoSoft. 

The voucher is saved and posted in the selected address in CargoSoft.

The financial interface uses the alternative financial account.

In this case the alternative financial account does not need to exist in CargoSoft.

An incorrect account number is only detected by financial accounting upon financial accounting transmission!

Alternative Account fields in client separated addresses

This is controlled via the Order data 2 tab in GEN COMPANY PARAMETER in COMPANY via the checkbox Addresses per client: image-20240418-165231.png

By activating the checkbox, an additional Clients tab is added to the tab bar of the master data ADDRESSES.

ADDRESSES → Client tab → Financial accounting sub tab

  • The view on the Financial acounting sub tab may differ, if the partial client separation is activated.  

  • When working with addresses per client, the financial account data are entered on the Financial accounting sub tab in the Clients tab in ADDRESSES!!

  • The sub tabs on the Clients tab are identical to those on the Accounting tab in ADDRESSES.

  • If the Clients tab is activated, these data have priority over the Accounting tab → In this case you can disregard the Accounting tab.

  • For more information, see Clients tab in ADDRESSES

Â