|
Good day Roger B. Have you considered loading data into the Vendor/Item contract master? As for inventory evaluation - depending on how you track variances, there may be no need to update your standard cost. If data comes from vendor in a text or excel data file, I can surely help you out in creating an import to your system i. Let me know -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of mapics-l-request@xxxxxxxxxxxx Sent: Thursday, March 01, 2007 1:00 PM To: mapics-l@xxxxxxxxxxxx Subject: MAPICS-L Digest, Vol 5, Issue 34 Send MAPICS-L mailing list submissions to mapics-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request@xxxxxxxxxxxx You can reach the person managing the list at mapics-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Updating PO Item and Release files (David Williams) 2. Time phased inventory cost changes (Roger.Blocher@xxxxxxxxxxxxxxxxxxx) 3. Re: Time phased inventory cost changes (RArnold@xxxxxxxxxxxxxx) 4. Guidelines for MAPICS-L mailing list (mailman@xxxxxxxxxxxx) 5. Re: Updating PO Item and Release files (sjones@xxxxxxxxxxxxxx) 6. Re: Updating PO Item and Release files (David Williams) 7. Re: Updating PO Item and Release files (Eric Wolf) 8. Re: Updating PO Item and Release files (DaleGindlesperger@xxxxxxxxxxx) ---------------------------------------------------------------------- message: 1 date: Wed, 28 Feb 2007 13:05:56 -0800 (PST) from: David Williams <jdwill5@xxxxxxxxx> subject: [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated. ____________________________________________________________________________ ________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 ------------------------------ message: 2 date: Wed, 28 Feb 2007 17:23:26 -0500 from: Roger.Blocher@xxxxxxxxxxxxxxxxxxx subject: [MAPICS-L] Time phased inventory cost changes How are other MAPICS users addressing the need for keeping up with vendor cost changes in a proactive manner? Can you point me to a package/solution that will provide us an option to pre-load future cost changes with an effective date? (We have both one-at-a-time changes as well as mass loads for 2000 item cost changes from a single vendor.) Also, we need to take into account the impact on inventory and new purchase orders. Ideally we would start buying under a new price in advance of updating the inventory cost. (This may be asking too much!) The possiblity of loading the purchase price field in advance of loading the unit cost default and the current cost fields. Thoughts? Suggestions? THANKS Roger Blocher TECH International I.S. Manager 740.966.8009 740.966.8090 (fax) ------------------------------ message: 3 date: Wed, 28 Feb 2007 22:17:02 -0500 from: RArnold@xxxxxxxxxxxxxx subject: Re: [MAPICS-L] Time phased inventory cost changes We may have something that may do what you need. We created a screen that allows our purchasing group to enter an item, price and effective date. We then take the current effective price to the item master for repricing. We do this in a scheduled job after midnight. This gives us the ability to track pricing changes by user as well as set price changes in the future. It would be easy to mass load the file from a data transfer. If you're updating the costs, then it should be an fairly easy change... If you think this may help, let me know, we'll shoot you the source. Thanks, Bob Arnold MIS Manager H-P Products, Inc. 330-875-5556 ------------------------------ message: 4 date: Thu, 1 Mar 2007 06:30:25 -0600 from: mailman@xxxxxxxxxxxx subject: [MAPICS-L] Guidelines for MAPICS-L mailing list Monthly posting of the guidelines for participation in the MAPICS Mailing List. Keep to the subject. The topic of the list is MAPICS (Manufacturing, Accounting and Production Inventory Control System), the ERP software package originally developed by IBM and now sold by Infor Global Solutions. Any discussion related to MAPICS in particular or ERP systems in general is acceptable. Discussion of unrelated topics will be actively discouraged. When quoting messages, do not quote the entire message. Just quote the parts that are needed to make the appropriate references. Flames are absolutely prohibited. If you disagree with someone, feel free to argue the facts, but no personal attacks will be tolerated. The official language of the MAPICS Mailing List is English. Do not post personal messages. Please use direct E-Mail. This list is international in scope and personal messages just end up costing money. Job and/or employment messages are forbidden. Please use the various jobs oriented conferences, such as midrange-jobs@xxxxxxxxxxxxx Advertising products, repeated postings, etc, are strictly prohibited. Also, if you have a solution that will specifically help another participant, feel free to tell that person. And finally, if you are a vendor, please identify yourself as such... do not try to pass yourself off as a user of your own products (even if you are). By posting to this mailing list, you are granting MIDRANGE dot COM and David Gibbs (david@xxxxxxxxxxxx) non-exclusive, unlimited, rights to republish its contents. This list IS copyrighted as a compilation. Republication of this mailing list, for anything other than personal use, without the explicit permission of the list owner is a violation of U.S. Copyright Law and will be dealt with as such. Collecting or "Mining" of email address from this forum, or any related web archive, is strictly and explicitly prohibited (not to mention that it is extraordinarily unprofessional). Violation of the above guidelines will be determined by the moderator and will result in the offending party either a) being forced to run Application Recovery Procedures for MAPICS I on a System/34 with worn out diskettes and impatient, cranky users, or b) permanent disconnection from the conference (you decide which is worse). To subscribe, unsubscribe, or change mailing list options, please vist http://lists.midrange.com/mailman/listinfo/MAPICS-L If you have questions or comments about these guidelines, please feel free to contact the moderator, Dave Shaw, via internet e-mail at mapics-l-owner@xxxxxxxxxxxxx MIDRANGE dot COM is a non-commercial organization and is not connected with any corporation, periodical, or commercial enterprise. For more information, send Internet E-Mail to INFO@xxxxxxxxxxxxx MIDRANGE dot COM and midrange.com, the owners and operators of this list are in no way associated with Infor Global Solutions, International Business Machines (IBM), "Midrange Computing" magazine, or "Midrange Systems" magazine. The opinions expressed here are strictly those of their authors, and in no way reflect the opinions or statements of direction of the aforementioned companies. ------------------------------ message: 5 date: Thu, 1 Mar 2007 07:47:06 -0500 from: sjones@xxxxxxxxxxxxxx subject: Re: [MAPICS-L] Updating PO Item and Release files We have a trigger on the itembl file. I used this template to setup our trigger, http://www.pbhall.us/trigger.html The hardest part of the trigger program is you must gain exclusive access to the file in order to add the trigger. David Williams <jdwill5@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 02/28/2007 04:13 PM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated. ____________________________________________________________________________ ________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 _______________________________________________ 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. ------------------------------ message: 6 date: Thu, 1 Mar 2007 05:15:29 -0800 (PST) from: David Williams <jdwill5@xxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files Thanks for the information. --- sjones@xxxxxxxxxxxxxx wrote:
We have a trigger on the itembl file. I used this template to setup our trigger, http://www.pbhall.us/trigger.html The hardest part of the trigger program is you must gain exclusive access to the file in order to add the trigger. David Williams <jdwill5@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 02/28/2007 04:13 PM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated.
____________________________________________________________________________ ________
Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 _______________________________________________ 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.
____________________________________________________________________________ ________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ ------------------------------ message: 7 date: Thu, 01 Mar 2007 08:52:35 -0800 from: "Eric Wolf" <eric_a_wolf@xxxxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms ------------------------------ message: 8 date: Thu, 1 Mar 2007 12:09:54 -0500 from: DaleGindlesperger@xxxxxxxxxxx subject: Re: [MAPICS-L] Updating PO Item and Release files Group.... I know all the advantages of triggers - they have been explained to me over and over. But I keep being burned on them with things like Eric mentioned, and others (difficulty in adding or maintaining them in a 24/7 environment). Am I being too conservative in my outlook in that I make every effort to avoid using them, and instead run periodic jobs (nightly seems to be adequate usually) to examine all the files and take any necessary actions? I'd appreciate a brief set of responses as to how many of us are using triggers, just a personal survey, if I may. 1) Can't live without triggers - they put sliced bread with butter to shame! 2) Use them, they are OK, the pain is pretty well worth it 3) Triggers? What are they? So I don't bury the thread on this, please reply to my direct address. This is totally unofficial, I'm just scratching a curiosity bone.... Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 dgindles@xxxxxxxxxxx "Eric Wolf" <eric_a_wolf@hotm ail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject Re: [MAPICS-L] Updating PO Item and 03/01/2007 11:52 Release files AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms _______________________________________________ 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) digest 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. End of MAPICS-L Digest, Vol 5, Issue 34 ***************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.
midrange.com
