Feature - Add Item Age, Cost, and Extended Cost to Cycle Count Worksheet CSV Export

Feature - Add Item Age, Cost, and Extended Cost to Cycle Count Worksheet CSV Export

Release Date: 4/15/19

Version: 8.2 and up

This feature adds three new columns to the CSV file exported from the Cycle Count Worksheet. The item age will be provided if option 6. Show Computed Qty On-Hand is set to Y. 



The item cost and extended cost will also be exported if option 6. Show Computed Qty On-Hand is set to Y, but the user must have rights to see this information. This is determined by options 13 and 14 on screen 2 of User Global Security Setup. Both options must be set to Y or the cost fields will not be exported.


If the user has the rights to see the item's cost and and option 6. Show Computed Qty On-Hand is set to Y,  three new columns will be exported. The item age column heading will indicate the last time the Recalculate Item Inventory Age Days was run from Global Setup-> Utilities-> I/M Utilities-> Generate Statistical Info. If the user is a warehouse user and the item export has a GTIN unit of measure, the cost exported will be the GTIN cost (cost by the case, carton, etc.).


Programs Modified: IM08S1, IM08P1, IM08P1B
CLS


    • Related Articles

    • WMS Physical Cycle Count Processing

      Two Approaches Supported for Physical/Cycle Count The goal of this application is to make the physical/cycle count process paperless. To do this the application needs to be able to generate the count records for a physical or cycle count so that they ...

    • IM08S1 Inventory Management Print Cycle Count Worksheet

      Print Cycle Count Worksheet Application Overview To obtain an accurate picture of the actual inventory in a warehouse or manufacturing facility, it is often necessary to close the entire plant down for a period of time to take physical inventory. ...

    • Feature - User Defined CSV Export Item Batch Support

      Release Date - 2/5/18 This feature gives the user the ability to define a batch that can be used when running the User Defined CSV Export. The batch can be defined from I/M-> Reports-> User Defined CSV Report-> Maintenance-> User Defined CSV Batch. ...

    • Feature - Added CSV Support to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse

      Release date: 6/26/2018 CSV support has been added to the Physical Count Posting Update Edit List and the Variance Report By Item/Warehouse. Physical Count Posting Update Edit List Enter "Y" in Export to CSV File?, enter CSV File Name & Path. The ...

    • Elliott Physical Count Processing

      Q. How can we process physical count with Elliott using a spreadsheet export and import method? We are prefer to have a variance report before posting to inventory. A. Elliott provides a verify efficient tool to create a worksheet with a spreadsheet ...