Howdy ya'll - does anybody know the best report to...
# general
s
Howdy ya'll - does anybody know the best report to look at quantity on hand as of a particular date with Bin information?
m
Hmm, I know you can check inventory as of a date using the inventory valuation report, but I don't use Bin Numbers so hard to say if this is a solution for you.
s
Yeah, inventory valuation half works... The bin numbers are formatted in a very strange way (i.e. BinNameA(Count),BinNameB(Count)) so for example it'll be like Staging(3),Production(0),Floor(3) all in a single column
Appreciate the response though!
m
I recall this issue in relation to reports, it worked better through saved searches but you couldn't date the inventory. Apologies I could not help further!
s
It's all good! Very much appreciate your response.
s
Yeah inventory valuation report can have bins, I just hate the format of that report.
s
Seriously! I just hate reports in general in NS to be honest... I mean, even on the inventory valuation. I'm even having trouble filtering on the Item name!