×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
David,
Other replies correctly referenced the ITH file as a source for this data. And I also would have the same question posed by one of the other replies about your wording - 'For a certain file . . . ' - which is a little confusing. That said, the IIM file has a field called ILDTE - date of last transaction. This MAY be what you are looking for - but realize that this would be for ANY transaction executed. If you are looking for the last date of a certain transaction type such as a PO receipt (U) or a cusotmer order shipment (B) - which may be what you mean when you say 'For a certain file . . . ', then the ITH would probably be the best choice.
Hope this helps.
Bud
Bud North, CPIM
Phoenix Business Consulting
Cell: 508-572-9701
Email: bnorth@xxxxxxxxxxxxxxxx
________________________________________
date: Wed, 20 Oct 2010 14:36:18 +0200
from: David.ANTONISSE@xxxxxxxxxxxxxxxx
subject: [BPCS-L] Last transaction date per item info - which file and
field?
For a certain file I have to find the last transaction date for a list of
items.
Which field in which file should I use in a query to find this information?
Thank you very much!
Rgds,
David Antonisse
The NetherlandsPlease consider the environment before printing this e-mail.
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
