So you know you are a redneck ... when ..... is the start of the punch line for many jokes ...
Time to start a new one -- you know you are an EXCEL GEEK when .... and this is aimed at Bob Miller from Walker Rd Auto ... Bob has now passed me to the next level of EXCEL GEEKdom
Yesterday he calls (Bob doesn't type as best I can figure - he rarely posts on the CARQUEST JOBBER Message Board ) -- but boy --does he have good idea's . .. anyways he asks if I am still dumping all the inventory into Excel. In J-Con you had to do this to get any good report but in EXPLORIS ( NexPart by WHI ) the reports are so crappy I have avoided this ... waiting for the universal report writer that may never happen ( the 2-20 screen in J-Con ). Aways he tells me he IS dumping the data and pulling quite a bit f good info
- the third column that is UNMARKED by some sku;s have an asterisk * --these parts are flagged as being REPLACED by something else - this allows you to sort and then look further on issues ... now if we had additional fields in the INVENTORY INFO report - we would look at te DESCRIPTION#2 (which is only available on a count list ) ,.... but this is the system we have now.
-Bob is also sorting on the sales for 12 and sales for 24 months to see dead stock ...
OK -he has shamed me into starting to run this report.
BUT --if that was not enough - he calls today and asks questions on the warranty returns - see REPORTS-FINANCIAL-Line Sales&Purchases ( that would be a 5-1-5 if someone had the vision to number the menus ) ... he is dumping this data and sorting for the bad lines -- now I have a lot of work ahead.
Good points Bob
No comments:
Post a Comment