Line-item data from xSuite Helix
The line-item data extracted by xSuite Helix is not always complete.
In the case of incomplete line-item data, an attempt is now made to automatically suggest the missing data. This applies in particular to PO line item numbers and material numbers.
New fields
The xSuite Helix item data recognition can read item texts, such as article texts, international article numbers (EAN), or manufacturer part numbers.
In order to make these fields usable in the xSuite Invoice Monitor, the /WMD/FP_IFOCI item table has been extended with the following fields:
MFRPN (Manufacturer Part Number)
EAN11 (International Article Number (EAN/UPC))
Determination of missing line-item data
For each order-related item of an xSuite Interface document, the field Order item must be filled with the item number. If the item number has not been imported, the system attempts to find the correct item.
The implementation is called in the TRANSFER_RECORD method of the /WMD/IF_FP_OC_TR_IF_DOC interface during the transfer from the intermediate table /WMD/FP_IFOCI. The algorithm is implemented in the /WMD/CL_FP_OC_ENRICH class. This class can be redefined using a user exit class (Exit ID FPOC000022).
The process of automatic position data assignment
The system checks the item numbers of all the line items. For each line item without an item number, the system attempts to determine the correct number. Several approaches are used to determine the item number:
If the purchase order has only one line item, that PO line item is used.
If the purchase order has multiple line items, the system performs a valuation. A PO line item receives a high score if the total amount, the unit price, or the quantity of the PO line item match the data of the line item.
To find a match based on material, the system compares the new fields (see New fields) as well as the Material Number Used by Vendor (IDNLF), Short Text (MATN_TXT), Material Number (MATNR), and Material Number Corresponding to Manufacturer Part Number (EMATN) fields of the /WMD/FP_IFOCI table with the PO line item data from the EKPO table.
The system selects the PO line item with the highest score. If multiple line items have the same rating, the first hit is used.
If the system was unable to determine a rating, the first (non-deleted) line item in the EKPO table is suggested. For technical reasons, a PO line item is always required in the xSuite Invoice Monitor.
If the material number is empty, the material number from the PO line item will be used instead.