Technical Mapping
Technical mapping
Products
Products are mapped dynamically inside BC from either items or item variants.
Transactions
Transactions are based on item transactions. Item transactions can have different document types as sources.
Sales Orders
Sales Shipments
Sales Invoices
Sales Cr. Memos
Item Transactions without document type.
The document headers and lines are transformed into “Order Head” and “Order Lines” that will be sent to Madden in the API.
Source Entity (Sales Header) | Target Entity (NPX MA Order Head) | Description |
"No." | "Document No." | Copies the sales document number. |
"Document Type" | - | Checks if the document type is an order. |
"Ledger Type" | "Ledger Type" | Sets to "Sales Invoice" for new entries. |
"Order Date" | "Created Date" | Sets the created date based on the order date. |
"Posting Date" | "Created Date" | Optionally sets the created date based on the posting date if the document number is empty. |
"Sell-to Customer No." | "Customer Code" | Copies the sell-to customer number. |
"Sell-to Customer Name" | "Customer Name" | Copies the sell-to customer name. |
"Currency Code" | "Currency Code" | Copies the currency code. |
"Location Code" | "Location Code" | Copies the location code. |
"External Document No." | ExternalTransactionID | Maps the external document number. |
"Ship-to Country/Region Code" | Market | Maps the ship-to country/region code. |
"Shortcut Dimension 1 Code" | "Shortcut Dimension 1" | Maps the first shortcut dimension code. |
"Shortcut Dimension 2 Code" | "Shortcut Dimension 2" | Maps the second shortcut dimension code. |
"Dimension Set ID" | "Dimension Set Id" | Maps the dimension set ID. |
"Requested Delivery Date" | DeliveredDate | Maps the requested delivery date, if not 0D. |
Module Value (OrderTypeCode) | OrderType | Sets the order type based on module value lookup. |
Source Entity (Sales Line) | Target Entity (NPX MA Order Line) | Description |
"Document No." | "Document No." | Maps the document number from the sales header. |
"Line No." | "Line No." | Maps the line number directly. |
Type ("Sales Line Type"::Item or Statement) | "Line Type" | Maps the sales line type to the MA order line type. |
"Description" | Description | Copies the line description, trimmed to the target's max length. |
"No." (Item No.) | "Item No." | Maps the item number. |
"Variant Code" | "Variant Code" | Maps the item variant code. |
Quantity | Quantity | Maps the sales line quantity. |
"Location Code" | "Location Code" | Maps the location code. |
"Amount Including VAT" | MoneyItemTotalVAT | Maps the total amount including VAT. |
"VAT Base Amount" | MoneyItemTotalNet | Maps the net amount (base amount for VAT calculation). |
VATValue | "Amount Including VAT" - "VAT Base Amount" | Calculates and maps the VAT amount. |
MoneyDiscount | Calculated from "Line Discount Amount" and "VAT %" | Maps the discount amount after excluding VAT. |
"Unit Cost (LCY)" | "Unit Cost (LCY)" | Maps the unit cost in local currency. |
"Posting Date" | "Posting Date" | Maps the posting date. |
"Shortcut Dimension 1 Code" | "Shortcut Dimension 1" | Maps the first shortcut dimension code. |
Source Entity (Sales Shipment Header) | Target Entity (NPX MA Order Head) | Description |
"No." (Document No.) | "Document No." | Maps the shipment document number to the order document number. |
"Ledger Type"::"Sales Invoice" | "Ledger Type" | Sets the ledger type to "Sales Invoice" for new entries. |
"Order No." | "Document No." | Maps the order number from the shipment to the document number. |
"Order Date" | "Created Date" | Sets the created date based on the order date. |
"Posting Date" | "Created Date" | Optionally sets the created date based on the posting date if the document number is empty. |
"Sell-to Customer No." | "Customer Code" | Maps the sell-to customer number. |
"Sell-to Customer Name" | "Customer Name" | Maps the sell-to customer name. |
"Currency Code" | "Currency Code" | Maps the currency code. |
"Location Code" | "Location Code" | Maps the location code. |
"External Document No." | ExternalTransactionID | Maps the external document number. |
"Ship-to Country/Region Code" | Market | Maps the ship-to country/region code. |
"Shortcut Dimension 1 Code" | "Shortcut Dimension 1" | Maps the first shortcut dimension code. |
"Shortcut Dimension 2 Code" | "Shortcut Dimension 2" | Maps the second shortcut dimension code. |
"Dimension Set ID" | "Dimension Set Id" | Maps the dimension set ID. |
Module Value (OrderTypeCode) | OrderType | Sets the order type based on module value lookup. |
Source Entity | Source Field | Target Entity | Target Field | Description |
Sales Shipment Line | "Document No." | MA Order Line | "Document No." | Maps the shipment document number to the order line document number. |
Sales Shipment Line | "Order Line No." | MA Order Line | "Line No." | Maps the order line number directly. |
Sales Shipment Line | Type | MA Order Line | "Line Type" | Maps the shipment line type to the MA order line type. |
Sales Shipment Line | Description | MA Order Line | Description | Copies the line description, trimmed to the target's max length. |
Sales Shipment Line | "No." | MA Order Line | "Item No." | Maps the item number. |
Sales Shipment Line | "Variant Code" | MA Order Line | "Variant Code" | Maps the item variant code. |
Sales Shipment Line | Quantity | MA Order Line | Quantity | Maps the shipment line quantity. |
Sales Shipment Line | "Location Code" | MA Order Line | "Location Code" | Maps the location code. |
Sales Invoice Line / Sales Line | Financial Fields | MA Order Line | Financial Fields | Validates and maps financial details (VAT, discount, unit cost, etc.). |
Sales Shipment Line | "Requested Delivery Date" | NPX MA Order Head | DeliveredDate, CompletedDate | Sets the delivered and completed dates based on the first shipment line processed. |
Sales Shipment Line | "Posting Date" | MA Order Line | "Posting Date" | Maps the posting date. |
Sales Shipment Line | "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code" | MA Order Line | "Shortcut Dimension 1", "Shortcut Dimension 2" | Maps the dimension codes. |
Source Entity (Sales Invoice Header) | Source Field | Target Entity (NPX MA Order Head) | Target Field | Description |
Sales Invoice Line | "Document No.", "Order No." | NPX MA Order Head | "Document No." | Prefers "Order No." from the first invoice line; falls back to "Document No." if "Order No." is empty. |
Sales Invoice Header | "Posting Date" | NPX MA Order Head | CompletedDate | Sets the completed date based on the posting date if the invoice is not linked to an order. |
Sales Invoice Header | "Order Date" | NPX MA Order Head | "Created Date" | Sets the created date based on the order date. |
Sales Invoice Header | "Sell-to Customer No." | NPX MA Order Head | "Customer Code" | Maps the sell-to customer number. |
Sales Invoice Header | "Sell-to Customer Name" | NPX MA Order Head | "Customer Name" | Maps the sell-to customer name. |
Sales Invoice Header | "Currency Code" | NPX MA Order Head | "Currency Code" | Maps the currency code. |
Sales Invoice Header | "Location Code" | NPX MA Order Head | "Location Code" | Maps the location code. |
Sales Invoice Header | "External Document No." | NPX MA Order Head | ExternalTransactionID | Maps the external document number. |
Sales Invoice Header | "Ship-to Country/Region Code" | NPX MA Order Head | Market | Maps the ship-to country/region code. |
Sales Invoice Header | "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code" | NPX MA Order Head | "Shortcut Dimension 1", "Shortcut Dimension 2" | Maps the dimension codes. |
Sales Invoice Header | "Dimension Set ID" | NPX MA Order Head | "Dimension Set Id" | Maps the dimension set ID. |
- | - | NPX MA Order Head | "Invoice Only" | Sets based on the presence of an "Order No." in the invoice lines: true if absent, otherwise false. |
Module Value (OrderTypeCode) | - | NPX MA Order Head | OrderType | Sets the order type based on module value lookup. |
Source Entity (Sales Invoice Line) | Source Field | Target Entity (NPX MA Order Line) | Target Field | Description |
Sales Invoice Line | "Document No." | NPX MA Order Line | "Document No." | Maps the invoice document number to the order line document number. |
Sales Invoice Line | "Line No." | NPX MA Order Line | "Line No." | Maps the invoice line number directly. |
Sales Invoice Line | Type | NPX MA Order Line | "Line Type" | Maps the invoice line type to the MA order line type. |
Sales Invoice Line | Description | NPX MA Order Line | Description | Copies the line description, trimming to fit the target's max length. |
Sales Invoice Line | "No." (Item No.) | NPX MA Order Line | "Item No." | Maps the item number. |
Sales Invoice Line | "Variant Code" | NPX MA Order Line | "Variant Code" | Maps the item variant code. |
Sales Invoice Line | Quantity | NPX MA Order Line | Quantity | Maps the invoice line quantity. |
Sales Invoice Line | "Location Code" | NPX MA Order Line | "Location Code" | Maps the location code. |
Sales Invoice Line | "Amount Including VAT" | NPX MA Order Line | MoneyItemTotalVAT | Maps the total amount including VAT. |
Sales Invoice Line | "VAT Base Amount" | NPX MA Order Line | MoneyItemTotalNet | Maps the net amount (base amount for VAT calculation). |
Sales Invoice Line | VAT Calculations | NPX MA Order Line | VATValue | Calculates and maps the VAT amount. |
Sales Invoice Line | "Line Discount Amount", "VAT %" | NPX MA Order Line | MoneyDiscount | Calculates and maps the discount amount after excluding VAT. |
Sales Invoice Line | "Unit Cost (LCY)" | NPX MA Order Line | "Unit Cost (LCY)" | Maps the unit cost in local currency. |
Sales Invoice Line | "Posting Date" | NPX MA Order Line | "Posting Date" | Maps the posting date. |
Sales Invoice Line | "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code" | NPX MA Order Line | "Shortcut Dimension 1", "Shortcut Dimension 2" | Maps the dimension codes. |
Source Entity (Item Ledger Entry) | Source Field | Target Entity (NPX MA Order Head) | Target Field | Description |
Item Ledger Entry | "Document No.", "Document Type" | NPX MA Order Head | "Document No.", "Ledger Type" | Maps document number and type from the item ledger to the order head. |
Item Ledger Entry | "Posting Date" | NPX MA Order Head | "Created Date" | Sets the order creation date based on the item ledger's posting date. |
Item Ledger Entry | "Location Code" | NPX MA Order Head | "Customer Code", "Customer Name", "Location Code" | Uses the location code to populate customer and location fields. |
Item Ledger Entry | "External Document No." | NPX MA Order Head | ExternalTransactionID | Maps the external document number. |
Item Ledger Entry | "Country/Region Code" | NPX MA Order Head | Market | Maps or retrieves the market/country code from the location record if the item ledger's country/region code is absent. |
Item Ledger Entry | Quantity | NPX MA Order Head | "Transaction Type" | Sets the transaction type to 'Return' if the quantity is positive. |
Item Ledger Entry | "Global Dimension 1 Code", "Global Dimension 2 Code" | NPX MA Order Head | "Shortcut Dimension 1", "Shortcut Dimension 2" | Maps the dimension codes directly. |
Item Ledger Entry | "Dimension Set ID" | NPX MA Order Head | "Dimension Set Id" | Maps the dimension set ID. |
- | - | NPX MA Order Head | "Currency Code" | Fetched from LCY Code in General ledger setup. |
Source Entity (Item Ledger Entry) | Source Field | Target Entity (NPX MA Order Line) | Target Field | Description |
Item Ledger Entry Lines | "Document No.", "Entry No." | NPX MA Order Line | "Document No.", "Line No." | Maps the document and entry number directly to order line document and line number. |
Item Ledger Entry Lines | Description | NPX MA Order Line | Description | Copies the line description, fitting it to the target's max length. |
Item Ledger Entry Lines | "Item No." | NPX MA Order Line | "Item No." | Maps the item number. |
Item Ledger Entry Lines | "Variant Code" | NPX MA Order Line | "Variant Code" | Maps the item variant code. |
Item Ledger Entry Lines | Quantity | NPX MA Order Line | Quantity | Maps the quantity, adjusted for sign (negative if needed). |
Item Ledger Entry Lines | "Location Code" | NPX MA Order Line | "Location Code" | Maps the location code. |
Item Ledger Entry Lines | "Sales Amount (Actual)" | NPX MA Order Line | MoneyItemTotalNet, MoneyItemTotalVAT | Maps the sales amount as both net and VAT. |
Item Ledger Entry Lines | "Cost Amount (Actual)" | NPX MA Order Line | "Unit Cost (LCY)" | Maps the cost amount per unit, adjusted for sign (negative if needed). |
Item Ledger Entry Lines | "Global Dimension 1 Code", "Global Dimension 2 Code" | NPX MA Order Line | "Shortcut Dimension 1", "Shortcut Dimension 2" | Maps the dimension codes. |
Item Ledger Entry Lines | "Posting Date" | NPX MA Order Line | "Posting Date" | Maps the posting date. |
Value Entry | "Discount Amount" | NPX MA Order Line | MoneyDiscount | Maps the discount amount, calculated from Value Entries |
VAT Entry (implied but not detailed) | VAT calculations | NPX MA Order Line | VATValue |
|
Updated: 2024-06-18 17:38 by Johan Carlstedt
