JDEdwardsE1 Connector - Item Update
This document describes the process of updating items from a JDEdwardsE1 ERP system to the App4Sales platform.
Data Source Configuration
The connector retrieves item data from the JDEdwardsE1 ERP system by making a POST request to the DataService endpoint (route: /jderest/dataservice). The data is retrieved from a view named V4102XPI2.
The items are fetched in batches of 2500. The request is filtered by the BusinessUnit which is configured in the connector settings.
Data Mapping
App4Sales Field | Source Field (API/Excel/DB) | Logic/Notes |
ItemCode | F4102_LITM | Direct mapping. |
InternalItemCode | F4101_ITM | Direct mapping. |
EanCode | F4102_AITM | Direct mapping. |
Unit | F4101_UOM1 | Direct mapping. |
Description | F4101_DSC1, F4101_DSC2 | The description is a concatenation of the source fields. |
SalesPrice | - | The sales price is not retrieved in the main item update process. It is retrieved on demand per customer. See the "Price Logic" section for more details. |
VatPercentage | - | Hardcoded to 0. |
VatIncluded | - | Hardcoded to 'E' (Excluded). |
Item Classes and Free Fields
The connector maps sales categories from JDEdwardsE1 to Item Classes and Free Fields in App4Sales. The following sales categories are mapped:
App4Sales Field | Source Field (API/Excel/DB) | Logic/Notes |
ItemClass / Free Field | F4102_SRP0 | Mapped to an Item Class and a Free Field with the name "Category code 10". |
ItemClass / Free Field | F4102_SRP1 | Mapped to an Item Class and a Free Field with the name "Sales catalog section". |
ItemClass / Free Field | F4102_SRP2 | Mapped to an Item Class and a Free Field with the name "Sub section". |
ItemClass / Free Field | F4102_SRP3 | Mapped to an Item Class and a Free Field with the name "Sales category code 3". |
ItemClass / Free Field | F4102_SRP4 | Mapped to an Item Class and a Free Field with the name "Sales category code 4". |
ItemClass / Free Field | F4102_SRP5 | Mapped to an Item Class and a Free Field with the name "Sales category code 5". |
ItemClass / Free Field | F4102_SRP6 | Mapped to an Item Class and a Free Field with the name "Category code 6". |
ItemClass / Free Field | F4102_SRP7 | Mapped to an Item Class and a Free Field with the name "Category code 7". |
ItemClass / Free Field | F4102_SRP8 | Mapped to an Item Class and a Free Field with the name "Category code 8". |
ItemClass / Free Field | F4102_SRP9 | Mapped to an Item Class and a Free Field with the name "Category code 9". |
Domain Specifics
Price Logic
The sales price is not retrieved during the main item update process. Instead, it is fetched on-demand when a user views an item for a specific customer. This is done by calling the OptA4SGetItemPriceForCustomer method.
This method sends a POST request to the FormService endpoint (route: /jderest/formservice) with the item code, customer code, quantity, and business unit to retrieve the customer-specific price.
Stock & Availability
The stock is not retrieved during the main item update process. It is fetched on-demand when a user views an item. This is done by calling the OptA4SGetStockForItem method.
This method sends a POST request to the FormService endpoint (route: /jderest/formservice) with the item code and business unit to retrieve the stock information.
The connector setting StockCode can be used to specify which stock value to use. If not specified, it defaults to "GRAND TOTAL".
Related Settings & Prerequisites
The following connector settings are used by the item update process:
BusinessUnit: The business unit to filter the items on.
Token: The authentication token for the JDEdwardsE1 API.
StockCode: The code to identify the stock value to be used.