Item Last Received Date Not Updated When Received from I/M Transaction Processing

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?


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 ...
    • 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 ...
    • 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 ...
    • Feature - Utility to Re-Calculate Item First Received and Last Received Date

      Release Date - 5/5/16 The purpose of this utility is to recalculate an item's first and last received date. The application will prompt for an item first received cut-off date. For any item with a first received date on or after this date, the ...
    • CP0000 Customer Order Processing Overview

      Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a reference guide ...