Richard and Vojtech:
Instead of using a user field in one of the Mapics files there is a way to accomplish this thru Mapics options and here is a suggestion.
1. From the COM Main Menu select option 6 (File Maintenance)
2. From the File Maintenance Menu select option 7 (Code Files)
3. From the Code File Maintenance Menu select option 14 (Item Industry Class) and create yourself an item industry class of GTIN via the F6 key twice (first time to edit second time to add entry)
4. Go back to the COM Main Menu and select option 6 (File Maintenance)
5. From the Item Maintenance Menu select option 3 (Related Item Information)
6. From the Maintenance Item sub file screen put a 15 next to the item would want a GTIN associated to
7. On the next screen press F6 and add the GTIN by putting an item industry class of GTIN (previously created) and then GTIN number under Industry item number and a description if you want.
8. After adding these records you will have a record added to Mapics file MBB6CPP which you can now chain to by item number and item industry class code (GTIN) and retrieve your GTIN number and there are also some user fields you can use for you own purposes if you need.
I not sure if this is an avenue you would like to use.
Steve
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Vojtech.Mrazek@xxxxxxx
Sent: Tuesday, February 05, 2013 3:39 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] GTIN - Global Trade Item Numbers
Hello,
we use the GTIN code for our manufactured items. We put GTIN code to the
table MBB2CPP in the field B2OEMN (Char 22). You could use any user field
in the ITEMASA/ITMRVA instead.
I created an trigger program (*INSERT *BEFORE) to calculate GTIN code for
our new products.
I think you should not use Customer Item Cross Reference file (MBBIREP),
because the GTIN code is not specific for each customer, it is specific
for each item.
Do not hesite to contact me.
Best Regards
Vojtech Mrazek
KAREL BOCH
vojtech.mrazek@xxxxxxx
-----mapics-l-bounces@xxxxxxxxxxxx napsal(a): -----
Komu: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Od: Richard Stover <rstover@xxxxxxxxxxxxxxxxxxxxx>
Odes*latel: mapics-l-bounces@xxxxxxxxxxxx
Datum: 3.2.2013 02:19
P*edm*t: Re: [MAPICS-L] GTIN - Global Trade Item Numbers
Just so I am clear, you are setting up the COM Item Cross Reference so
that whether a customer uses the GTIN no. or the regular product number
the regular product no. gets used internally?
Did you consider using a user defined field in Item Revision so that you
can use either one or both, say for labeling?
Best Regards
Richard (Dick) Stover | Consulting Manager
C: 215-499-8530 | E: rstover@xxxxxxxxxxxxxxxxxxxxx
|Putting the ROI in ERP |
| April 21 - 24, 2013 | Orlando, Florida | www.inforum2013.com
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[[1]mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Shurge, Stephen
(MTL)
Sent: Wednesday, January 30, 2013 1:56 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] GTIN - Global Trade Item Numbers
Hi Richard:
I am not sure what you mean by "Anyone dealing with this?".
We have several customers who are using GTIN numbers. Most are using these
codes as their item #'s.
So we are setting up item cross reference tables in COM to handle this.
If you have any specific question or concerns please elaborate in an
email.
Steve Shurge
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[[2]mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Stover
Sent: Wednesday, January 30, 2013 12:51 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] GTIN - Global Trade Item Numbers
Anyone dealing with this? This is similar to a global UPC product
identifier and starting to gain some traction among companies that have to
ship outside the US, especially with consumer products. INFOR support
says it is part of future plans, but no commitment date
Best Regards
Richard (Dick) Stover | Consulting Manager
C: 215-499-8530 | E:
rstover@xxxxxxxxxxxxxxxxxxxxx<[3]mailto:erodriguez@xxxxxxxxxxxxxxxxxxxxx>
[[4]cid:image007.png@01CDBB75.D4F69530]
[[5]cid:image008.jpg@01CDBB75.D4F69530] |Putting the ROI in ERP |
[Infor_GoldPartner_Logo_RGB_1500px_72dpi_101712]
[Description: Description: Description:
Infor]<[6]
http://www.inforum2013.com/agenda-events/>| April 21 - 24, 2013
| Orlando, Florida | www.inforum2013.com<[7]
http://www.inforum2013.com/>
--
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: [8]
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
[9]
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: [10]
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 [11]
http://archive.midrange.com/mapics-l.
</rstover@xxxxxxxxxxxxxxxxxxxxx>
References
Visible links
1. mailto:mapics-l-bounces@xxxxxxxxxxxx
2. mailto:mapics-l-bounces@xxxxxxxxxxxx
3. mailto:erodriguez@xxxxxxxxxxxxxxxxxxxxx
4. file:///tmp/cid:image007.png@01CDBB75.D4F69530
5. file:///tmp/cid:image008.jpg@01CDBB75.D4F69530
6.
http://www.inforum2013.com/agenda-events/
7.
http://www.inforum2013.com/
8.
http://lists.midrange.com/mailman/listinfo/mapics-l
9.
http://archive.midrange.com/mapics-l
10.
http://lists.midrange.com/mailman/listinfo/mapics-l
11.
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
