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

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 following CSV columns are supported:

ItemNo - Item number
Desc - Item description
TagNo - Physical count tag number
Loc - Physical count tag location
BinNo - Multi-Bin only - Physical count tag bin number
UM - Item unit of measure
ProdCat - Item product category
MatType - Item material cost type
FrozenOH - Frozen quantity on hand (only applicable if post date is on or before the last freeze date)
CurrentOH - Item quantity on hand at tag location
OldQtyOH - If running multi-bin this is the bin quantity on hand. Otherwise it is the item quantity on hand at the tag location
CountedQty - Counted quantity
NewQtyOH - New quantity on hand for the item
VarQty - Variance quantity
VarCost - Variance cost
PostingComments - Comment about the posting status of the tag

Variance Report By Item/Warehouse  


Enter "Y" in Export to CSV File?, enter CSV File Name & Path.



The following CSV columns are supported:  

TagNo - Physical count tag number 
ProdCat - Item Product Category
Loc - Physical count tag location
BinNo -  Physical count tag bin number
ItemNo -  Physical count tag item number
Desc - Item description
UnitCost - Item unit cost
UM - Item unit of measure
TagQty -  Physical count tag quantity counted
AccumQty - An accumulated count quantity provided if there is more than one tag for an item. If there is only one tag for an item, the accumulated quantity will equal the counted quantity.
TagCost -Item total cost based on the physical count tag quantity
InvBal -  Item quantity on hand at the tag location
InvCost - Item total cost based on the item's quantity on hand at the physical count tag location
VarQty - Quantity variance
VarCost - Cost variance
PostingComment - Comment about the posting status of the physical count tag


Modified programs: IM10S2, IM10P2, IM10P2B, IMTIWVS1, IMTIWVP1, IMTIWVPB

DLM





    • Related Articles

    • 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 ...

    • 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 ...

    • Feature - Multi-Bin Physical Count Enhancement

      Release Date: 10/31/2022 Version: 8.5 & Up This project enhances the physical count processing for multi-bin users. It is not applicable to non-multi-bin users. Multi-bin users can now perform the following two new functions: Cycle Count by Bin ...

    • IM1000 Inventory Management Physical Count Processing

      Physical Count Processing Application Overview In just about any Inventory Management package, it is necessary to physically count inventory items periodically to ensure that the theoretical quantity on‑hand figures being used in the package are ...

    • Feature - Allow Physical Count Tag Import Without Serial Number

      Released Date: 10/25/2010 In I/M -> Processing -> Physical Count Processing -> Utility -> Import Physical Count Tag, we will require the user to provide a CSV file with the following columns: (A) Location (Can Be Blank) (B) Bin Number (Required If ...