It's the nature of the relationship that is important in determining what you can display. You can display attributes from "parent" objects that have a 1 to many relationship to the current object. In this case the customer information you want to display is not related directly to shipped items. Instead you would have to traverse order, or order history to get to the customer information.
In order to work around this, we've done things like using sql to create logical files that can then be joined as secondaries to the current object or its parent in order to provide visibility of the data where needed. In this case, you might create a logical by joining historical order with customer in sql, and then creating a secondary from that logical joined to historical order. Finally, you would be able to pull in information from historical order and its secondaries in shipped items. You could also cut out the middle-man in sql and make the logical with the key fields from shipped item.
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Charley Simpson
Sent: Wednesday, September 10, 2008 3:10 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Integrator question...
I am trying to create a view in Shipped Item where I can use a Relationship to piggy-back into the Customer file to pick up the Territory related to the sold-to customer (we are concerned with the sold-to territory, not the ship-to).
I have customer number (sold-to) available to me and it says it is field dhcanb (Order Shipment). In the relationships for Shipped Item "Order Shipment" has "shipmentHeader" as its ID.
I have seen other relationships, Customer Invoice in Shipped Item as an example, where the joins appear to me to be passed through by piggy-backing on an existing relationship to connect to another table. ( shipmentHeader.dhggnb=feggnb ). I thought I could create a relationship using this customer number relationship to "Piggy-back" into the customer file but I can't seem to find the right structure.
I am obviously grasping here as I am not trained in Integrator.
Any help or insight is appreciated.
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
As an Amazon Associate we earn from qualifying purchases.