Feature - Show Items with Qty Variance on Tag Variance Reports

Feature - Show Items with Qty Variance on Tag Variance Reports

Release Date - 5/19/16

When printing the tag tag variance reports from I/M-> Processing-> Physical Count Processing-> Reports-> By Warehouse/Variance Amt and I/M-> Processing-> Physical Count Processing-> Reports-> By Item/Warehouse, the user has the option to show Variance Items Only. This parameter was based on a cost variance. If the item has a quantity variance but it is a zero cost item, the variance will not print on the report. A new option has been added to allow the user to choose to only show items with a quantity variance.



Variance Items Only? - This field defaults to N. Choosing Y will only print items with a cost variance. Choosing Q will print items with a quantity variance even if there is no cost variance. Choosing N will show all items even if they do not have a quantity or cost variance.

When running I/M-> Processing-> Physical Count Processing-> Reports-> By Warehouse/Variance Amt and choosing Y or N, this report will print in descending order by the cost variance. If Q is chosen for the Variance Items Only prompt, the report will print in descending order by the quantity variance.


The I/M-> Processing-> Physical Count Processing-> Reports-> By Item/Warehouse Report also supports this new option.



Variance Items Only? - This field defaults to N. Choosing Y will only print items with a cost variance. Choosing Q will print items with a quantity variance even if there is no cost variance. Choosing N will show all items even if they do not have a quantity or cost variance.  The sorting order for this report has not changed.

NOTE: If, after installing this update, you receive a Btrieve 139 error on the Variance Work File or the Tag Work File, you will need to regenerate the tag work files. This can be done by running  The I/M-> Processing-> Physical Count Processing-> Reports-> Generate Tag Work File.



Programs Modified: IMTAGWRK.FD, IMTAGWRK,SL, IMVARWRK.FD, IMVARWRK.SL, IMVARWRK.IO, IMTIWVP1, IMTIWVPB, IMTIWVS1, IMTWVS1, IMTWVP1, IMTWVP1B, IMGTGWRK, IMGTGWRB.
CLS



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