Base Configuration
Field reference for the DATANORM Setup page – all sections, their fields and the shipped defaults.
DATANORM Setup is the central configuration of the app. You reach it from the application search or from the role centre under Setup.
General
Default Vendor No.
–
Vendor proposed when importing.
Default DATANORM Version
Version 5
Version used for export. Import detects the version itself.
Ask for Vendor on Manual Import
on
Prompts for the vendor on every manual import instead of always using the default vendor. Recommended if you read in files from several suppliers.
Import Settings
Duplicate Handling
Mark for Manual Review
What happens when an article is already known: skip, update, create new, or mark for review.
Duplicate Match Field
DATANORM Article No.
Field used for matching: article number, EAN/GTIN or vendor item number.
Match Duplicates per Vendor
on
Takes the vendor into account when matching, so different suppliers may reuse the same article number or EAN without overwriting each other.
Check Pending Staging for Duplicates
off
Also checks not yet synchronised data from other sessions. Deliberately off, because re-reading the same file would otherwise flag every article as a duplicate.
Auto-Sync to Items
off
Transfers approved staging data to the item master without a further click.
Archive Imported Files
on
Keeps the original file content on the import session – valuable for troubleshooting.
Record Filters
This is where you switch individual record types on and off. All toggles are on by default.
Process Articles
A and B record
Process Texts
T record
Process Prices
P record
Process Product Groups
S record
Process Discount Groups
R record
Process Dimensions
D record
Process Graphics
G record
Process Surcharges
Z record
Process Services
C record
Process Part Lists
J record
See also Record Type Reference.
Automation
Batch Size
10,000
Number of lines processed per block.
Use Background Processing
on
Processes large files in a background session so the client is not blocked.
Background Threshold
1,000
Line count above which the import runs in the background.
Auto Approve Staging
off
Marks imported records as approved immediately, skipping manual review.
Skip Duplicate Check
off
Speeds up very large imports at the cost of duplicate detection.
Turning on Auto Approve Staging and Skip Duplicate Check together means a file goes into your item master unchecked. Only do that for files whose quality you know.
Price Lists
Write Purchase Price Lists
on
Writes imported prices as purchase price lines into a DATANORM price list per vendor.
Purchase Price Source
Net Price then List Price
Which DATANORM price becomes the purchase price: net price (indicator 2), list price (1), or preferably the net price with the list price as fallback.
Apply Discount Groups to Purchase Price
off
Applies the discounts of the DATANORM discount group to the list price. Discounts are chained multiplicatively, as DATANORM specifies.
Write Scale Prices (Z Records)
on
Transfers scale prices as additional price lines with a minimum quantity.
Write Sales Price Lists
off
Also writes the list price into a sales price list for all customers.
Price List Status
Active
Whether new price lists are active immediately or created as drafts.
Price List Code Prefix
DN
Prefix of the generated price list codes, for example DN-PUR-10000.
Covered in full under Purchase Price Lists.
Part Lists (Sets)
Create Assembly BOM from Part Lists
on
Builds assembly BOMs on the set item from J records.
Include Optional Set Lines
off
Also picks up lines with calling flag 2 and 4. By default only automatically inserted lines are used.
Set Item Replenishment System
Assembly
Whether the set item is switched to Assembly automatically or left untouched.
In full under Building Assembly BOMs.
Item Defaults
These values apply to every item synchronisation creates.
Default Item Category Code
Item category for new items.
Default Gen. Prod. Posting Group
General product posting group.
Default VAT Prod. Posting Group
VAT product posting group.
Default Inventory Posting Group
Inventory posting group.
If one of these posting groups is missing, synchronisation fails for the affected item with an error message in staging. See Common Problems.
Numbering
Item No. Series
Number series for newly created items. If left empty, the DATANORM article number is used as the item number.
Import Session No. Series
Number series for import sessions.
Actions
Initialize Units
Creates the default mappings for DATANORM units. Run once after installation.
Run Feature Tests
Runs the smoke tests for licence, setup, SFTP, import, sync and export.
Run Record Type Test Cases
Verifies the DATANORM 4 and 5 record types against the specification.
Show Test Results
Results of the last run, including detail messages.
See Built-in Tests.
Last updated