I would find a USER field, unused, in the item shipment record. Then
have a program on the job scheduler to run at night and populate the
field of there might be an exit program to populate the field
immediately.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Wednesday, September 10, 2008 6:38 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Integrator question...
Charley-
If I am reading your question correctly you have multiple levels of many
to 1 relationships and you want to get to attributes that are beyond the
first level. Example: Shipped Items -> Order Shipment -> Sold-to
Customer.
At least with R7 you cannot do this through the edit view or edit
attribute card dialogs. You may be able to
create a logical attribute with the same characteristics as your target.
(i.e. Numeric, 2, 0)
The logical expression will look like this:
&relatedShipmentHeader.relatedCustomer.territory&
This is now at the shipped items level and can be pulled in as an
attribute for views, subsets, cards, etc...
If this doesn't work in R6, then you'll have to use Josh's idea to
create logical files.
-Tom Stieger
Engineer
California Fine Wire
805-489-5144 x235
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[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...
Hi, Listers!
R6 w/Integrator
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.
Charley Simpson
_______________________________________________
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,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
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,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
midrange.com
