-
Inventory Count - Tracking Metrics
Hello there, My team has a process for inventory cycle counts primarily in Google Sheets. The final step is to upload a item adjustment for the variance. I'm calculating IRA (formula below) in Google Sheets. IRA = [ 1-the sum of the absolute variance / # the sum of the total inventory ] x 100 Source:…
-
Saved Search with Item Next Count Date and Count Interval
We do not use SmartCount, however, we still use inventory counts by filling in the Next Count Date and Count Interval on the item or assembly record. I want a saved search to show the Next Count Date and Count Interval but it keeps showing up as blank. Does anyone know how to do this?
-
Inventory Adjustment Date
Hello, for example, we created an inventory count las June 21 but it was only approved today June 24. There is a discrepancy in the quantity so an Inventory adjustment was automatically created by the system. The date in the Inventory Adjustment is the date when the Inventory Count was approved. My question, is there a way…
-
Error trying to approve Inventory Count
When we try to approve an inventory count we are getting a vague error message that the bin numbers are not available. I spent several hours breaking the count into chunks so I could find the item causing the problem. All we're trying to do is zero out the inventory. TIA Mike
-
How to customize Inventory Count Sheets?
Is it possible to include additional native fields from the Inventory Count on the PDF that is created via Transactions --> Inventory --> Print Inventory Count Sheet ? We're hoping to include Department and Memo fields in the header of the Inventory Count Sheet PDF. Upon reviewing the Supply Chain Preferences page, I see…
-
Generate Cycle Count - Includes items already in a prior IC with started status
Hello, We conduct our cycle counts utilizing last date, next date and count frequency. When I generate a cycle count from a plan, I would like to assign a list of items to multiple operators to count on the same day. After creating the first plan (see below) I then go to generate the second plan for another operator and…
-
Inventory item last count date by location
Hello I'm trying to build a report by location to show the number of items not counted within the last 3 months and then be able to drill down and see these items. I have been able to create a report using an item saved search and using the location last count date. However, I'd only like to include the counts that have…
-
I can not see the items in Create Inventory Count
Hello I chose the subsidiary,location, start and end date but can not see any items. I also activated the feature for inventory counting So what I should do?
-
How do I create a report that shows inventory quantity by item, location and lot code?
I'm trying to create a report that shows inventory counts by item, location and lot code as of a specific date, but can't get it to work. What do I need to do to create this report? It's ok if it's just a long list of data, because I can export and clean it up in Excel, but so far, I haven't been able to create a report I…
-
Cycle Count By Bin
Is it possible to create cycle counts by Bin instead of item? We are having issues trying to perform counts in a timely manner when we have certain skus in many bins.