Tuesday, December 30, 2008

GP ERROR ON PN CODE REPORT


Talk to Exploris on this and they say it is the wrong calculation. And here I thought I was getting rich. No scheduled release to fix the problem.

OH WHERE, OH WHERE HAS MY 8.18 GONE


Just can't believe Im walking blind to all of my weblink customers. In J-con we had a report called 8.18 that you could access anytime to see what your customers were doing/hits/Po's etc. Exploris does not have this function and from what I hear there is no future release with it. Now I have to depend on CQ to get me the reports from data warehouse, which is very slow. Well I just got a report yesturday showing that some people have been abusing it for four months, this is unacceptable!!!!! CAULK ONE UP FOR J-CON!!!!!!!!

SOME IMAGES FOR INV MASS UPDATE







If anybody as done forecasting that was not aware of the DNR bug, then I would do this for all lines. It takes about 10 minutes and it may seem that your computer is locking up but just let it run and go grab a coffee. But beware this tool can be very Dangerous and you can never go back SO BE CAREFUL!!!!

A MUST KNOW ABOUT EXPLORIS FORECASTING


If anybody uses Exploris forecasting you need to know that any of these non-sku part numbers highlighted in red are added to your system through forecasting it will NOT take the DNR flag of the part. There is a way to remove all the flags to a line or multiple lines all at once by using INV MASS UPDATE which Ian as mentioned on Dec 15th. Makesure if any AE's are doing your forcasting that they are aware of this because I would bet many are not.

WHY WAREHOUSE SALES DATA IS IMPORTANT




Well about a month ago I might of put these number into my inventory, but as you can see it is bad data because the warehouse hasn't sold any. This raises another question, Why is the part number data wrong? I find any part in exploris that has a PN code .0 is like this. And they say why do we need warehouse sales data?


======= note -- updated by Greg ========
Hi It is 1-8-09 and Bob is on his way to London (yeh - that London ) for 10 days - I do not know if he had a chance to figure out the reply from Mike Deal ... but here is Mike's reply ..... I don't understand it ...it does seem to say that we will TRY to get the caliper but the warehouse won't have it -- so we just make a bit more work for everyone ...

--reply follows ---
I can "sort of" help with this. These 2 caliper numbers were marked for deletion in our Adis system, which means they were discontinued by our
supplier and our Product Manager placed an X in our status field. The X means delete this part number from our system on the next purge. The
problem is a part is NOT supposed to be marked for deletion before the movement code is changed to 0 because the Progress Database stops updating
all numbers marked for deletion. The movement code was 4 when these numbers were marked for deletion, but changed to movement code 0 later. Since
Progress stopped updating these numbers, Exploris still thinks that they are movement code 4.

Mike Deal
Director - Classification
General Parts International / CARQUEST

====== note -- updated by Greg -- after talking with Mike Deal ========

Ok --think I have it now -- there are steps and if a step get done out of order we get the above problem
1) part is identified as 'going to be obsolete'
2) part mvt code must be set to ZERO first
3) then the column can be set to X for delete part (probably after all stock gone)

Here the X was marked before the mvt code was set to zero - and this will cause problems for EXPLORIS users -- as the new data base .. called the Progress Data Base is==will not update ... this is NOT a problem for J-Con users as J-Con is updated from ADIS -- not this new data base ( Progress Data Base).

It does hi-light the complexity of the issues and reinforce the need for GROUP meetings to solve problems

I run into many examples in Canada of the part NOT having a ZERO movement code -- when it is a obsolete part .... For example since we in our 3 stores dump all data into excel --we don't use the product recall sheets --we just sort all parts to see what matches -- this is how we know some parts are NOT moved to mvt code 0. This will; have to be solved ... or annoy BOTH the Exploris users and the WAREHOUSE as these parts will try to order and the warehouse won't have them...

Monday, December 15, 2008

I was just told how to fix a setting problem like the one we had for ecc. I had in several part numbers the display item flagged ( this then produces price stickers for that part number) , many of which should not have been flagged. You can do a mass update to remove that flag. You need to be careful as this tool could create some havoc in your system if used incorrectly. To remove the flag go to invoice, then to part utility, to inventory mass update. This goes to a new screen, enter your line code, click on the first number bean ( then choose the top number, as this is the first number in the file), click on the last number bean ( choose the top number it is the last part number in the file). On the right hand side there is a bean that says update or if you click on it changes to " clear mode". Click on clear mode, check off the do not display box, then click on the update button. The system will ask if you want to update this file, click OK, spacebar and you are done

Monday, December 8, 2008

the BET is on


there is a $10 ( US funds too boot ) bet on with Normand (head of IT in Canada ) and Greg H --that the J-Con f-9 type warehouse sales will NOT be in Exploris by Dec 31,2008

Greg thought this was a pretty safe bet when made at the London Owners Meeting recently --any side bets ?

************* L A T E B R E A K I N G ****************

damm -I lost the bet -- money has been paid ...knew I should bet on the billing schedule "gross profit' program -that was delayed until 1st qtr of 2009 .... so if you see busy Jobbers -it is because they have to do SO MUCH work to adjust pricing plans in Exploris ( and it still is so easy in J-Con )