Home Forums Advanced Inventory Count Advanced Inventory Count Bin Filter Ranges

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • Shane SimmonsShane Simmons
      Post count: 2

      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,

      Nathan SilvermanNathan Silverman
        Post count: 26

        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

        Shane SimmonsShane Simmons
          Post count: 2

          Excellent, thank you for your help!

        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.