Re: IM Inq - Open Orders - By Item/Warehouse
Peter_Vidal-/[email protected]
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <OF91D88F6A.CDE5AC90-ON8525775F.00576934-8525775F.0057B7A0@pall.com> |
Can someone tell me where the item description for Open Orders - By Item/Warehouse on screen AMI1D2 comes from? ITD20 - Truncated item description. The field is found in ITMRVA and in ITEMASA. If you have EPDM, The Truncated Item Description - 20 characters (ITD20) and the Truncated Item Description - 10 characters (ITD10) fields are automatically updated with truncated versions of the item description during ITMRVA file maintenance. If items are added or changed outside of MAPICS, these fields may not have been populated or updated correctly. To identify items with blank or incorrect abbreviated description fields, write a query over ITMRVA to find all items where ITD20 not equal to first 20 characters of ITDSC, or ITD10 not equal to first 10 characters of ITDSC. To update the abbreviated description fields: Maintain the description via Item Revision File Maintenance (MAPICS Browser) by changing the item description and then change it back. This will correct the ITD10 and ITD20 fields. Obviously, you can always do a program to fix this... My $0.02 cents... Good luck! PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 727-815-3104 | Fax: 727-815-3120 | www.pall.com "Imagination is more important than knowledge" Albert Einstein (1879 - 1955) -------------------------------------------------------------------------------- Attention: This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication. -------------------------------------------------------------------------------- _______________________________________________ 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.