Skip to content

Advanced Inventory Count

Advanced Inventory Count Bin Filter Ranges

Viewing 3 posts – 1 through 3 (of 3 total)
  • Author
    Posts
  • #8362
    Shane S.

    Hello,

    I am looking to generate a count sheet that is filtered by Bin. This needs to filter bins from 2 separate ranges into 1 count sheet.

    eg. The Bin Code filter would contain ranges for   01-01-A1..01-06-D1 and 01-18-A1..01-22-A2

    Is this possible and if so, What would be the correct syntax to enter into the Bin Code Filter Box?

     

    Thank you,

    #9699
    Nathan S.
    Insight Works

    Hi Shane,

    Most of the Count Sheet field filtering uses standard Business Central filtering syntax. This documentation from Microsoft should be useful: Sorting, Searching, and Filtering Lists – Business Central | Microsoft Learn

    With that being said, I think you would use “01-01-A1..01-06-D1&01-18-A1..01-22-A2” without the quotes. The “&” character should be a concatenation of both bin ranges.

    Cheers,

    Nathan

    #9700
    Shane S.

    Excellent, thank you for your help!

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