Table of Contents

Field Mappings

Field mappings is a way to collect custom data to consignment or a consignment address. Field mappings will be processed after the default logic in Logtrade Connect to get data from a source or a source document has been executed.

You can setup field mappings to read a value from another table or set fixed values. Field mappings are rule based, so you can set them up for a specific customer, vendor, shipping agent etc. Field mappings are often used to read data from custom fields on e.g. sales order.

Click here to learn more about how to setup field mappings.

The examples below shows three different scenarios:

  1. Set sales person code on sales order as the Consolidation ID on the consignment.
  2. Set GLN on customer as Custom Data 1 on the consignment.
  3. Set a fixed value as gate code on the delivery address for a specific customer.

Settings

  1. Open the list of field mappings.
  2. Scenario #1 - Create a new row with:
    • Source Document Type = Sales Order.
    • From Source Field No. = 43 (lookup the field list and select Salesperson Code).
    • To Table = Consignment Header.
    • To Field No = 9.
  3. Scenario #2 - Create a second row with:
    • Source Type = Customer.
    • From Source Field No. = 90.
    • To Table = Consignment Header.
    • To Field No = 36.
  4. Scenario #3 - Create a third row with:
    • Source Type = Customer.
    • Source No. = A customer number of your choice.
    • From Source Field No. = 90.
    • Mapping Type = Fixed Value.
    • To Table = Consignment Address.
    • To Address Type = Delivery.
    • To Field No = 26.
    • Fixed Value = 1234.

Workflow

Scenario 1 - Salesperson as Consolidation ID

  1. Create a sales order.
  2. Set a sales person code on the sales order.
  3. Create a consignment for the sales order.
  4. Verify that the Consolidation ID on the consignment has the value of the sales person code on the sales order.

Scenario 2 - Customer GLN as Custom Data 1

  1. Set GLN on a customer
  2. Create a sales order for the customer.
  3. Create a consignment for the sales order.
  4. Verify that the Custom Data 1 on the consignment has the customs GLN number.

Scenario 3 - Gate code

  1. Create a consignment for the customer in your field mapping for this scenario.
  2. Open the list of consignment addresses (Related->Addresses).
  3. Select the row with address type Delivery.
  4. Click on View.
  5. Verify that Gate Code has the value you have setup in the field mapping.

Video

Consignment