× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


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

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.