Talking with Bob Miller - he has been dumping ( exporting ) the entire inventory INFO report for his store for more than a year on a monthly basis ... sure put a shame on me ...
Points
-remember to save as Excel data only
-the file will cut into 62,000 records on sheet #1 - then continue to sheet#2 - and if you have a HUGE amount of stock - to sheet #3 ( we have only been live for 10 mths - so we have approx 120,000 records - you will find a HUGE amount of crap ..remember in J-Con we could only have 62,000 records -- heck - you have 40,000 parts o f sheer junk - too bad you can't delete
-handy way to change TEXT to NUMBERS - do a google search - you can add a 1 to empty cell - copy and then paste special to all cells you want to change - paste special - Multiply -- neat ... first time I have done it that way ( Bob tells me that latest Windoze version has an even better way - but I have Mac version )
-we added a couple of columns - Sales in Dollars ( sold 12 months x cost )
- total Inv $$ ( qty on hand X cost ) ...these columns will help you sort out your problems to the top or bottom on Excel
-sort out the inactive parts and move to new sheet - consolidate remaining data into one sheet -and start sorting
So I have some learning on this report. The first pass we sorted on ascending sales ( looking for ZERO sales $$ ) and descending Inv $$ .... so we can see what we have NOT SOLD in 12 ( or 24 )months ... and look for problems
Stay tuned - and thanks Bob for the 'gentle' reminder to do this .... . smile
No comments:
Post a Comment