Hi Everyone,
I'm looking for an idea on how to create an Excess Stock Report for our purchasing department.
the only idea ive come up with at the moment is to list every item in our warehouse and do the calculations from there,
but with over 10,000 SKU's in our warehouse it would result in an extremely large report that would be slow to run.
What i'm needing,
A: Bin Contents
B: Base Item Number
C: Variant Code
D: Item Description
E: Variant Description
F: Base UOM
G: Purchase Category Code (Customer Field on the Item Table)
H: Stock on hand (SKU table)
I: Unit Cost (Item table)
J: Vendor Number (Item Table)
K: Vendor Item Number (Item Table)
L: Excess Stock ( =(Safety Stock [SKU Table] *6)-Stock On Hand ) but we only need to show items where this value is Greater than 1 (i.e. we have excess stock)
Any starting ideas??
-Bromy
Date
Votes
3 comments
-
Jet Reports Historic Posts I haven't had any replies, but i'm sure Someone would have some ideas.
-Bromy -
Jet Reports Historic Posts I'm not really sure what you're asking… if you want your report per item you should run it per item…
Unless you can group them? -
Jet Reports Historic Posts Bromy,
I think I have a report that does something similar, if you were to attach your report I think I can add a formula so that only the excess stock items appear.
Don't fancy building your whole report from scratch though so if you can attach I will tweak.
Cheers,
Dean
Please sign in to leave a comment.