|
Paul, File MBAWRES6 contains the unique comment header number that you are looking for. If you do a *HIVAL SETLL to this file you will get the last comment header number. Increment that number by 1 and that will be the next available comment header number. To secure the comment header number, I recommend you write your record to this file first, then subsequent files. There is another important file, MBEECPP which contains a cross reference from the COM line item to the comment header number. This is what is used to link the comment to the comment header (MBAWREP) and comment line file (MBAXREP). Hope this helps. Nathan Quinones Custom Systems Corp 973-726-0202 x213 http://www.cussys.com |---------+--------------------------------------------------------> | | Paul Lanier <planier@xxxxxxxxxxxxxxxx> | | | Sent by: | | | mapics-l-bounces+nathan.quinones=cussys.com@x| | | idrange.com | | | | | | | | | 03/20/2003 09:17 AM | | | Please respond to MAPICS ERP System | | | Discussion | | | | |---------+--------------------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx> | | cc: | | Subject: Adding Comments to COM line items | >------------------------------------------------------------------------------------------------------------------------------| Our company has a need to add comments to the line items of COM orders to provide customer specific information pertaining to the items ordered. Most of the time this is handled via maintaining orders. I have been asked if we can do this from an off-line procedure. I have determined that the comments are recorded in the file MBAXREP - Comment Line Physical File. In this file there is a Comment Header Number (AXKANB). Can someone tell me what system file the COM order enter/order amend programs use to determine the next Comment Header Number to assign? If I try to add these comments from outside of MAPICS, I would like to increment this number so that the number won't be re-assigned by MAPICS. We are still using ver3 of XA. Any help would be appreciated. Paul Lanier MIS Manager William Powell Company planier@xxxxxxxxxxxxxxxx (513) 852-2086 "This e-mail and any attachment may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer." _______________________________________________ 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, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx 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 mailing list archive is Copyright 1997-2024 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.
midrange.com
