Skip to content
+1-888-319-3663

COMMUNITY FORUM

add fields to taPoLine

JGrebe asked 7 years ago
We have added the following fields to the taPOLine node: QTYCMTBASE, QTYUNCMTBASE, LINEORIGIN, ADDRSOURCE. They are showing under the Node Maintenance for taPOLine. These fields are all available in the PO10110 table. We can add these to our purchase order map and assign values. When the map runs the values are not being populated.
Answers
Lorren answered 7 years ago
J,

The problem is that the underlying Microsoft eConnect stored procedure, taPoLine, does not have those fields as parameters so there is no logic that will actually update them.

The method you would need to use, would be to create a SQL Script Task that runs on Document Success that updates the table directly.

Lorren

If you would like to submit an answer or comment, please sign in to the eOne portal.