I've run into a similar problem with updating files via SQL. The Online
Knowledge base suggested running a XA reorg which would recalculate the
field in question (NOOPS in the FACMST file). For our specific case it
didn't work because it was not updated to recalculate that field in an
EPDM environment. I ended up just calculating the field myself and
updating it through SQL as well.
All the warnings and caveats per Kevin Fox's reply pertain as well.
California Fine Wire
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryan Burns
Sent: Monday, February 06, 2012 6:02 AM
Subject: [MAPICS-L] LTPUR not recalculated after changing ITEMBL with
In an XA5.5 test environment, I updated LTVEN and LTSAF using SQL; but
LTPUR has not been re-calculated for those items I updated.
I went into ITEMBL file maintenace on a record and I was able to get it
re-calculated that way.
1. This was my first accomplishment using SQL to do an update and I'd
like to know if I did any damage, and what other file/fields can be
damaged with even the most careful use of SQL?
2. How can I automagically get the LTPUR recalculated for about 130
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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
As an Amazon Associate we earn from qualifying purchases.