RE: copy standard costs to current

[lisa.thomas@xxxxxxxxxxx]

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.