Re: GTIN - Global Trade Item Numbers
Kevin Fox <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
Exactly Kevin D Fox Sent from my iPhone On Feb 5, 2013, at 12:13 PM, "Shurge, Stephen (MTL)" <sshurge-0QhDaq10B7lWk0Htik3J/[email protected]> wrote: > 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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of [email protected] > 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 > [email protected] > -----mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] napsal(a): ----- > Komu: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> > Od: Richard Stover <[email protected]> > Odes*latel: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > 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: [email protected] > > |Putting the ROI in ERP | > | April 21 - 24, 2013 | Orlando, Florida | www.inforum2013.com > > > > -----Original Message----- > From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [[1]mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] 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-Zwy7GipZuJhWk0Htik3J/[email protected] > [[2]mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] 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: > [email protected]<[3]mailto:[email protected]> > [[4]cid:[email protected]] > [[5]cid:[email protected]] |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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change > list options, > visit: [8]http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > 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-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: [10]http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at [11]http://archive.midrange.com/mapics-l. > > </[email protected]> > > References > > Visible links > 1. mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > 2. mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > 3. mailto:[email protected] > 4. file:///tmp/cid:[email protected] > 5. file:///tmp/cid:[email protected] > 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > 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-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.