Re: BPCS 405CD - IIM List Price Update for all records

Actually, any of those choices would work (well, except query!).  Do you
have a programmer available?  Any programmer with SQL experience could do
it in about 30 seconds, if it's that easy of a change, or an RPG program
would be very easy as well, especially if you want an audit log showing the
before and after price, or anything like that.  We normally do ours using
the download-to-a-spreadsheet method, but we do lots of analysis and
negotiating with sales folks ... if they would say 5% across the board, I'd
be delighted!  I can't think of any downsides to just changing the IIM
price field.  (Keep in mind that the new price will only affect new orders
... orders already in house will keep their original price.)



                                                                                
            
                    lorrel@gencor.com                                           
            
                    Sent by:                 To:     <bpcs-l@midrange.com>      
            
                    bpcs-l-bounces@mi        cc:                                
            
                    drange.com               Subject:     BPCS 405CD - IIM List 
Price       
                                             Update for all records             
            
                                                                                
            
                    01/24/2003 12:15                                            
            
                    PM                                                          
            
                    Please respond to                                           
            
                    "SSA's BPCS ERP                                             
            
                    System"                                                     
            
                                                                                
            
                                                                                
            




Can anyone please tell me how I can update the List Price field in the IIM
for all records. I would like to do an increase of 5% across the board. Is
there a way to take the ILIST field value, multiply it by 1.05, then put it
back into the table? I am not sure whether this can be done through an RPG
or CL program, query, SQL statement, or if the data needs to be downloaded
off the AS400, modified, and then uploaded again.  I am not a programmer,
so
the simplest method would be the best. Any feedback would be greatly
appreciated.

Thanks,

Larry Orrel
Gencor Industries


Larry Orrel
Director of Information Systems
Gencor Industries
Phone: (407)290-6000
Fax: (407)298-1806
mailto:lorrel@gencor.com



_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.