Frequently Asked Questions / Anveo EDI Connect / Initializing fields with data

Initializing fields with data

When you use NAV type mappings to create records in NAV tables (Anveo EDI Connect buffer tables or regular tables) you can initialize fields with data. Let’s say that you want to export sales invoices: the document type of the EDI Document should be “Sales Invoice” and all lines will be filled with items. The initializing is done by the filter property you can set on a table loop. For the EDI Document type, the filter is “Document Type=CONST(Invoice)” and for the item lines, it’s “Type=CONST(Item)”.

If you need to import an order you could initialize the sales or purchase header with “Document Type=CONST(Order)”, perhaps with “Direction=CONST(Incoming)” aditionally.

Of course you can assign these values in data mapping lines, but as they are constant values they don’t change for every record and you can save some mapping lines by assigning the values by a filter.

The result of this is that every record created will have these values in the fields. If you have a lot of mappings in your system, for different partners or customers, you can use the field “Project Code” on the one hand to group your EDI Documents and on the other hand quickly see which document belongs to which partner / customer.