The current Generate Inventory Worksheet screen has 2 limitations:
- you can only select a range of items, categories etc.
- generating different selections for the same location prompts with the option to replace the existing worksheet or do nothing.
Ideally, you should be given the same choice that exists when exporting data to an existing file. i.e. Append or Overwrite.
This would allow you to "build" an inventory worksheet selectively in multiple steps. For example, there is no way currently to generate for both category A and C without also including B. With this option, you could generate a worksheet for category A, then generate for category C and be asked if you want to add to the existing worksheet rather than replace it.
by: Dean M. | over a year ago | Operations Management
Comments
Or break the worksheets down into the "Sort by" level so you could have a worksheet for Category A and another for Category C at the same location.