Bank Accounts

This code identifies a bank account. You can enter the code directly or select from the bank account table.

This field is used to link a description to its record. This description can be printed on the records, displayed when the record code is entered in a screen, or used on selection.
The title, used by default in the reports and entry masks is replaced by the short title when it is required by display and print constraints.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

• Click Translation from the Actions icon in the corresponding field.
• In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

The connection language must be defined as a default language for thefolder.

Bank address.

This code is used to identify amongst other things, the Country of a BP.
This is important information, associated with a number of characteristics useful for performing controls on other linked information, in particular:

• the telephone number format,
• the format of the number that identifies a company or an activity (site tax ID number, NAF in France), and whether its entry is mandatory or not,
• the postal code format of the town and also the code of the geographic subdivision, and whether their entry is mandatory,
• whether the VAT number of this community is mandatory,
• the Bank ID code format.

The postal code, which entry format is defined in the Country table, is used to define the town/city, state/region and the geographical subdivision, if defined for the country.
If you modify the postal code, the city/town and state/region corresponding to this new code are automatically displayed. The principle is the same for the geographical subdivision if it is present for the country.
You can also directly enter a town/city name or state/province. If the city/town, state/region are defined, the associated postal codes are displayed automatically.
The control of this information and its mandatory nature depend on the setup carried out in the country management. For the control to be applied, the POSCOD - Warning nonexistent postal code parameter (SUP chapter, INT group) must also be set to 'Yes'.

Particular cases:

- for ANDORRA, indicate 99130,
- for MONACO, indicate 99138,
- for the other foreign countries, indicate the national identifier of the country or 99999 if not known.

When the postal code is defined as mandatory for the country, it must be entered if the Postal Code or City/town fields are entered, or if information is modified in the BP address window. However, this control is not applied in document creation.

The city automatically suggested is the one associated with the postal code previously indicated. It is also possible to manually enter the name of a town/city:
- If the town/city is already defined, the associated postal code is automatically displayed,
- If it does not exist and the postal code control has been set up in the Country record, a warning message is displayed but the continuation of the entry is authorized (in order for this control to be applied, the CTY - Nonexistent city alert parameter - SUP chapter, INT group - must also be set 'Yes'),
- If it does not exist and the postal code is set up as mandatory for the country, a blocking message is displayed in case the fields Postal code or City/Town are entered or in case of modification of information in the address window of the BP. However, this control is not carried out in document creation.

Notes.

• Its format is defined in the Country record setup.
• Depending on this setup, the entered town/city can automatically be converted into uppercase after it has been entered.
• In order to make selections easier without taking into account the format (accented characters/uppercase letters/lowercase letters), the selection window available on this field proposes a column dedicated to the search, where the names of the towns/cities are displayed in uppercase.

Click this icon to open a mapping site and locate the entered address.

Code making it possible to specify the county where the bank is located.

Telephone number.

The format depends on the country.

Fax number

The format depends on the country.

Full email address.

Title used in some screens or reports when there is not enough space to view the long title.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

• Click Translation from the Actions icon in the corresponding field.
• In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

The connection language must be defined as a default language for thefolder.

Default bank account number.

International identification code for banking institutions defined by the ISO standard.

For countries for which the IBAN management box is checked, the IBAN is automatically calculated after the user has entered the Bank ID field.
The country code and the bank ID must have been previously entered for the bank account currently under setup.

Enter the QR-IBAN number for the sender. This is used when generating sales invoices as QR-bills and this number is used as the sender's account number in the QR payment slip.

See the Swiss localization guide for detailed information on QR-bills.

Enter the 9-digit routing or transit number for the bank.

This field is required when generating bank files with an ACH format, whether fixed or XML file.

Note: The KUS activity code must be active to use ACH payments.

Enter the unique 15-character code assigned to you by the bank.

This field is required when generating bank files with an ACH format as an XML file.

Note: The KUS activity code must be active to use ACH payments.

Enter the unique 15-character code assigned to you by the bank.

This field is required when generating bank files with an ACH format as an XML MTS file.

Note: The KUS activity code must be active to use ACH payments.

Paying bank linked to the Bank ID number.

Additional paying bank linked to Bank ID number.

Specify here the issuer number to be provided during a magnetic transfer.

Bank code for the interfaces to the cash management software

Access code used to limit the access to the bank for certain users.
If this field is assigned, only users with this access code in their profile can use this bank.

Site that possesses this bank account. Entering this information automatically updates the company code.

Enter a unique code or string appearing in the bank statement file to identify this bank account.

This field is optionally used in the context of the advanced bank statement import process. Depending on the setup, the bank statement import uses this information to automatically find the Sage X3 bank account belonging to the bank statement file. Typically, this is needed when importing statement files containing multiple statements from different bank accounts for the same bank in one file.

Refer to the Advanced Bank Statement how to guide for more details.

This field requires the KSW – Swiss localization activity code to be active. You use it to enter the ISR customer number for the given bank account. This number is used for payments with ISR number (inpayment slip with reference numbers).

For suppliers, the ISR customer no. is also used to search for a matching BP account if support for ISR code line entry on purchase invoices is active in the SWIPURBVR - Swiss ISR usage purchasing parameter (LOC chapter, SWI group).

Refer to the Swiss legislation guide on the How to tab for more details regarding payment and ISR setup.

Enter the ISR customer ID if you use ISR customer invoices with a standard bank account and not a Postfinance account. The ISR customer ID is issued by your bank.

This field is only available if the KSW – Swiss localization activity code is active.

Enter or select the Revenue Payment entry type (GESTPY) code for this bank account. This code is used in the related Bank register.

This field only displays for a Polish or South African legislation for a Bank register.

Enter or select the Expense Payment entry type (GESTPY) code for this bank account. This code is used in the related Bank register.

This field only displays for a Polish or South African legislation for a Bank register.

This option makes it possible to create a document for each due date or a document by note during the validation of a paying bank notice on the bank.

If 'yes', there will be an item by due date with as posting date the due date. If not the posting date will be the note date.

Current line of the grid.

• Bank journal: the journal where the entries are posted for this bank.
• Journal of checks to be collected: journal where the entries of check remittances are posted.
• Payment receipt journal: journal where notes payable/receivable are posted on collection.
• Discount journal: journal where notes payable/receivable deposits are posted on discount. This journal can be identical or different from the payment receipt journal.

Two journals can used whether the payments relate to fixed asset suppliers or not:

• Purchase notes payable journal: journal where notes payable on purchases are posted.
• Fixed assets notes payable journal: journal where notes payable on fixed assets are posted.

Each journal can be set to Cash management or Miscellaneous operations.

The entry of the bank journal is mandatory.
The entry of the other journals is optional. They will replace those entered in the general parameterization.
In any case, these must be the cash management or MO journals.
The choice of a journal type is made in a local menu.

Used to associate a document type to a journal type, in other words a posting phase.

Used to associate a cash account to a journal type, in other words, a posting phase.

This field displays the BP Code, which is mandatory when one of the journals is associated with a collective account. The BP code must be a miscellaneous BP and is considered as a subdivision of the bank account.

For example, this setup makes it possible to follow the entries and avoid duplicating bank accounts in Financials.

Use this field to specify the accounting code of the site.
The accounting code is a default value used in the setting up of accounting entries.
It refers to a table that lists a certain amount of elements (collective accounts, accounts or parts of accounts) that can be used for the determination of the documents that will be posted.

Specifies the operation-keeping currency.

The entries posted on a bank account held in a different currency to that of the company will be valued in company currency.

Mention here the exchange rate type to be used to perform the conversion.

The type is used in the bank allocation function to value the virtual balance of the bank in company currency.

This field is only available if the account currency is different from the related ledger or journal currency and if the FIFRC- activity code is active and the FIFRC – FIFO rate calculation parameter (CPT chapter, CLO group) is set to Yes.

Use this field to enter the bank account number from which the bank charges wlll be debited.
This code is only used when generating bank files. The setup of a specific charge account does not generate any particular accounting entry. The validity of the entered number is submittted to the control of the bank account number key.
 

This field is used to enter the currency of the account on which the bank charges will be debited.
The defa ult currency will be the same as the main account's.
 This field is entered if the bank ID of the specific charge account has been entered.

This field displays the IBAN prefix (International Bank Account Number) of the account from which the bank charges will be debited.
This code is only used when generating bank files.
 This field is entered if the Bank ID of the charges specific account has been filled.

Field not used by the software.

Field not used by the software.

If this field is set to ‘Yes’, the balance control for this bank is activated in function Payment/receipt entry. The balance control will be run in the currency of the bank.
If parameter PROBALCTL - Progressive balance control (chapter TRS - group PAY) is set to ‘Yes’, the balance control field is displayed and enabled.

Enter the extension for file names that are generated for electronic transfers. The extension is required when the bank account contains more than three characters.

When checked, this box is used to generate bank files with format AFB160 and line '07' ('Additional records').

When this box is checked, the bank carries out a global posting (one debit line taken into account by deposit slip).
When this box is not checked, the bank carries out a unitary posting (one debit line taken into account by payment).
This information is used in the context of the bank file generation with the SEPA format. It corresponds to the field 'BatchBooking' in the .xml file.

This field displays the analytical dimension type associated with the bank. The displayed dimension types default from the Company/site associated with the bank/cash.

Select the check format based on the type of check you are printing to:

• Check-stub-stub
• Stub-check-stub
• Check-stub

If the parameter USACHK - US/Can Check Printing (chapter LOC, group USA) is set to Yes, the field is active. If this parameter is set to No, the field is in active and set to Not Used.

This field displays the next check number or you can enter a check number.

Check numbers must first be entered in the Checks (GESCHB) function. You can access this from the Checkbook icon.

This field is only active when the CHQCT - Check controls  parameter (TRS chapter, BNK group is set to Yes.

Click the Checkbook icon to open the Checks (GESCHB) function to assign check numbers for a unique bank account. Enter the beginning and ending numbers from the check stock.

Click the Lookup icon to view the check status and the corresponding Positive Pay date and Positive Pay sequence number if relevant.

Statuses include:

Unissued – initial status when checks are generated through check book

Issued – status once check has been printed for auto checks or assigned for manual checks

Voided – manually void or automatically voided through payment deletion or cancellation

Posted –payment and check are posted

Cleared –check has cleared bank

You cannot manually adjust a check with a status of issued, posted, or cleared. Those statuses are set systematically when activities are performed on the linked payment. Only unposted checks can be reprinted.

This field is only active when the CHQCT - Check controls (TRS chapter, BNK group) parameter is set to Yes.

Select Yes for MICR printing. This enables the Bank transit and Checking account fields. The check number and the MICR line are printed on the checks.  

Enter the bank transit numbers to be printed on the MICR line for checks.

Enter the bank's checking account number to be printed on the MICR line on checks.

Enter the Positive Pay bank file name created in the Bank files function (GESTFB).

This field is available only if the CHQCT - Check controls (TRS chapter, BNK group) parameter of the bank is set to Yes and if the Bank file check box is selected in the Bank files function (GESTFB).