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

    • BMITMVRS Bill of Material Production Cost Variance Report

      Production Cost Variance Report Application Overview The Production Cost Variance Report prints the cost variance between planned cost and actual production cost for selected items. Planned production cost is calculated based on the routing for each ...

    • BM1501 Bill of Material Feature/Option Configuration Maintenance

      BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...

    • Feature - Newly Received Item Inquiry with Date & Category Range Plus Show Total

      Released Date: 03/08/2025 Version: 8.5 & Higher In COP -> Inquiry -> Newly Received Item Inquiry, it prompts for three parameters: Rec Date: You can either enter a single date or press Enter for ALL Category: You can either enter a single category or ...

    • ARAGEMNU Accounts Receivable Aging Reports

      Reports Aging Reports Application Overview The Aging Reports are reports that can tell you a great deal about the state of a customer's account. It will tell you how much the customer owes you, and how old these owed amounts are. In A/R Setup, you ...

    • Canceled PO Line Items Still Exporting on EDI

      Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...