Item Last Received Date Not Updated When Received from I/M Transaction Processing
Release Date: 09/28/2017
Q - Based on my observation, if we receive item from Inventory Transaction Processing as an "R" (Receiving) type, then the item last received date will not be updated. See sample screen below for the field. Why is that?
Q - Based on my observation, if we receive item from Inventory Transaction Processing as an "R" (Receiving) type, then the item last received date will not be updated. See sample screen below for the field. Why is that?
A - The main reason why I/M receiving does not update the Item Last Received Date is because the I/M Receiving Transaction is mostly used for “Inventory Adjustment” purposes. Therefore, receiving from I/M should not update the Item Last Received Date. Generally speaking, the item last received date is updated through the Purchase Order module when the receiving transaction is posted.
Also, as of 3/11/2016, Elliott will also update the item date last received when produced from a BOMP production work order. See the following article for more details:
You may also use this utility at Global Setup -> Utilities -> I/M Utilities -> Utilities -> Generate Statistic Info -> Generate -> Recalc Item Date 1st and Last Recv. This utility resets the item Date First Received and Last Received based on the Inventory Transaction Audit Trail file. Inventory Transaction Audit Trail file is used for a lot of statistical information calculations, therefore, we suggest keeping a reasonable amount of history in the Inventory Transaction Audit Trail file (e.g., 3 years).
EMK
Related Articles
AP0202 Accounts Payable Transaction Processing
Processing A/P Transaction Processing Advanced Features The A/P Modules includes many features and functions, not applicable to all business, which we let you Pick & Choose to enhance your functionality and processing needs. These are detailed in the ...Feature - Add Age Days and Last Calculated Date to Stock Status Inquiry
Release date 1/9/2021 Version 8.5 & Up This feature adds "age days" and "last calculated date" to the Stock Status inquiry screen. These fields come from Item File Maintenance field 27: Age days is a good way to indicate what your inventory turnover ...BM1800 Bill of Material Production Transaction Processing
BM1800 Bill of Material Production Transaction Processing ← Bill of Material / Work Order Plus Production Transaction Processing Application Overview The Production Transaction Processing application allows for reporting progress made toward ...CP01012 Customer Order Processing Newly Received Item Inquiry
Newly Received Item Inquiry Application Overview This application is a useful sales tool to see which “Key Items” have been received. A key item can be a hot or fast moving item preferred by customers and usually tracked by salesmen. As soon as these ...Feature - Option to Control if Item Last Received Date Is Updated from BOMP
Release Date - 4/12/16 The Item Date Last Received is updated when posting BOMP Production Transactions or when posting PO Receivings. With this feature, the user now has the option to choose if the field is updated only when posting PO Receivings or ...