Skip to content

Advanced Inventory Count

Generate Count Sheets not working correctly

Viewing 3 posts – 1 through 3 (of 3 total)
  • Author
    Posts
  • #8949
    Andrew D.

    Hi,

    I have an item with a quantity of 74 in a bin. The item is tracked by serial number, lot number, and expiration date. When I create the count and sheet I correctly specified a location code filter, item filter, and bin code filter.

    When I use the Generate Count Sheet action, I only select the Include Inventory boolean and leave every other boolean or filter off, then click OK. Since the item has a quantity of 74, I would expect 74 count sheet lines to be created.

    Instead, 638 lines are created.

    When I open the count sheet lines, the Bin Quantity field shows the correct value of 74. If I filter the lines where Expected Quantity is 1, I get 74 lines, which is correct. The remaining lines all have an Expected Quantity of 0.

    This is why I am getting 638 lines instead of 74. The extra lines are all zero expected quantity lines. These lines have the correct item no. and bin, but it’s adding serial numbers that are no longer available in the system.

    Why is the Generate Count Sheets function creating count sheet lines with an Expected Quantity of 0?

    #10824
    Geoff M.
    Insight Works

    Hey Andrew,

    There are a couple more fields that you can set to resolve this issue. First, ensure that the “Inventory As of Date” on the inventory count card is set to the current day. Next, when you are generating the count sheet and under the Inventory Options fast tab, set “Empty Bins Activity Period” to “0D”. When you generate the count sheets, this should keep the system from including lines with an expected quantity of 0.

    Cheers,

    -Geoff

    #10830
    Andrew D.

    Thanks Geoff. Setting “Empty Bins Activity Period” to “0D” resolved the issue.

Viewing 3 posts – 1 through 3 (of 3 total)
  • Sign in below to reply.