Incomplete link expressions
Less than to read
In most cases, links and references between nodes can be determined based on the Sage X3 Table definition (GESATB) by using the Linked table and Link expression fields.
On some tables, these links can’t be determined or are not defined explicitly in the Sage X3 Table definition.
For example, in the PINVOICED table, the SIDLIN field is expected to be a reference to the SalesInvoiceLine node. However, the PINVOICED table definition does not have all the information to build this reference. This is because the sales invoice number, SIHNUM, is defined in another table: PINVOICEV.
You can use the Data models function to define new references on nodes. You can do this when a part of a key is missing or is not defined for a linked table in the Sage 3 Table definition.
- As an example, to add a reference to the SalesInvoiceLine node in the PurchaseInvoiceLine node, you can add first a standalone property to be referenced to the SalesInvoice node. You can see this in line two in the image below:
- Then, create the expected reference to the SalesInvoiceLine node on line 3. You can do this by defining a link expression to the reference that had been added to line 2:
- You can also fill the Overwrite property field to define the new reference as replacing the SIDLIN property on the PINVOICED node.
Another example
- The STOFCY property is missing in the SCHGD table definition to build a valid reference to the STOLOC table as defined in the link expression below:
- The STOFCY property is stored in another table: SCHGD.
- To add this reference to STOLOC on the SCHGD node, you can define a link in the Data models function (GESAWM) to the SCHGH table. You can see this in line 1. Then, add the expected reference to the STOLOC table using the STOFCY field of the SCHGH table:
- Optionally, you can fill the Overwrite property field to define the new reference as replacing the LOC property on the SCHGH node.