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

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

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