IQ Jnl. Import Setup
Object Definition
| Object Type | Page |
| Object ID | 70314195 |
| Object Name | QWESR IQ Jnl. Import Setup |
| Source Table | QWESR IQ Jnl. Import Setup |
Controls
| Type |
Caption |
ToolTip |
| Field |
Integration Setup Code |
Specifies the unique identifier for this integration. |
| Field |
File Settings Code |
Specifies the unique identifier for the file settings. |
| Field |
Posting Nos. |
Specifies the code for the number series that will be used to assign document numbers to ledger entries that are posted in this integration. This is only used if Document No. is not assigned on the lines. |
| Field |
Source Code |
Specifies the source code that will be assigned to the ledger entries posted in this integration. This is only used if Source Code is not assigned on the lines. |
| Field |
Default Posting Date |
Specifies the date that will be assigned to the entries handled in this integration. Useful if the date is missing from the file. Cannot be combined with specifying the Posting Date field on the Columns FastTab. |
| Field |
Copy VAT Setup to Jnl. Lines |
Specifies whether VAT should be calculated and added to the ledger entries posted in this integration. The posting groups on the chart of accounts will be used for the calculation. |
| Field |
Check Column Headers |
Specifies whether the file's column headers should be checked against what has been set for this integration. This setting is only active if the file setting has Column Headers enabled. |
| Field |
Language Code |
Specifies the language that is used in the file for fields of the Option type. This setting will also affect the language used in any error messages displayed when processing a file. |
| Field |
General Journal Template Name |
Specifies the name of the general journal template that the journal lines will be imported to. |
| Field |
General Journal Batch Name |
Specifies the name of the journal batch that the journal lines will be imported to. |
| Field |
Require Empty Journal |
Specifies whether the journal batch must be empty before the journal lines can be imported. |
| Action |
Import Template |
Import the file that you want to manage in this integration to facilitate the settings on the Columns FastTab. The file needs to contain column headers so that it is possible to link to the correct field. Open the File Settings page to set up the type of file to import. |
| Action |
Export Template |
Create a sample file based on current settings. |
| Action |
File Settings |
Open and edit the settings for the type of file to be handled. |
| Action |
Validation Order |
Specify the order in which the data should be applied. If the business logic requires that a certain field be populated before another field can contain data, you can use the Validation Order field to specify the appropriate processing order. To specify the order, use the Up and Down actions on the Validation Order page. |
| Sub page |
Columns |
Integration Queue Journal Import Columns |
This documentation is generated from Spider v27.0