Thanks to all who responded.

I tried Tom Stieger's suggestion (it was the easiest for me with my lame programming skills) and it seems to work well.

I have always appreciated this list and the willingness of folks to share their insight.

Thanks and Cheers!!


Charley Simpson

Turbonetics Inc.
Phone:805-581-0333
Direct:805-426-3410
Fax: 805-581-2640
www.TurboneticsInc.com
www.eTurbochargers.com

________________________________

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail.




-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Otto Meyn
Sent: Thursday, September 11, 2008 5:59 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Integrator question...

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.

_______________________________________________
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.