LTPUR not recalculated after changing ITEMBL with SQL
Bryan Burns <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <CADGXpD=s2aGD=nW+g5seVvdE7PjPf-dnC-07Md6NK502+TBV-g@mail.gmail.com> |
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. Two questions: 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 records? _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.