Could use SQL:
SELECT ITNBR,STDUC, CURUC FROM amflibn.itemasb WHERE STDUC <> CURUC
to check data first

update STDUC = CURUC from amflibn.itemasb
 WHERE STDUC <> CURUC

update STDUC = CURUC from amflibn.itmrvb
 WHERE STDUC <> CURUC

I'd try it in test first!


-----Original Message-----
From: August, Michael [mailto:maugust@dialight.com]
Sent: Thursday, February 28, 2002 3:46 PM
To: 'mapics-l@midrange.com'
Subject: RE: copy standard costs to current


Dave,

I don't believe there is any other way then to do this using a program.
Which in that case you will need to write one to do the ITEMASB and another
to do the ITMRVB if you are using EPDM.

Regards,
Michael August
Programmer / Analyst
Dialight Corporation



-----Original Message-----
From: Shaw, Dave [mailto:dshaw@syratech.com]
Sent: Thursday, February 28, 2002 3:26 PM
To: Mapics-L (E-mail)
Subject: copy standard costs to current


Hi, folks!

My cost accountants want to copy costs from standard to current.  I know we
can copy current to standard from a menu option now, but there (still!)
doesn't seem to be a way to do what my guys want.  Am I missing anything
here?  Can Browser (which we have) do it?  I can't check on Browser easily
right now, it locks up my PC. (OY!)

I used to know how to do this programmatically, so I don't anticipate any
problems doing that if need be, but I'd hate to write something if I don't
need to.  We're on XA release 6.

Thanks in advance!

Dave Shaw
MAPICS-L Moderator
Rauch Industries, Inc.
Gastonia, NC
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@midrange.com To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


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