Wednesday, October 19, 2011

How to write about something you swore not to disclose ?

Read the title --ok - here goes .... walking a tight rope of ethics - want to remind you about something that we can't tell you how we know ....

Background .... a good buddy and local CARQUEST Jobber - Bob from Walker Rd - constantly impresses me with the points he finds and solves ... we rag on him ( a term of endearment ? ) to post some info on THIS BLOG ..well guess what ..he reminded me of a few posts from 2008 .... remember we didn't get our Exploris machine in operation until 2010.

Click Here
 and Click Here

Some day you will get a way to list the parts on hand with a stocking qty and that you have (for whatever reason ) in system with a DNR ( do not re-order ) flag checked ....

Bob reminds me that once you master theMass Update screen -- use the CLEAR BUTTON -- check the DNR box --then click YES for the STOCKED - the REAL and the ACTIVE -- and then UPDATE.   A caution - as I remind my partners -- if you are too quick and you clear your ON HAND stock qty -- that will result in hundreds of hours in panic while you correct ...so think and be careful.

Bob does this action a couple times a year - and can stop once we all can get the report of parts effected .... some day ....

Hey Bob - more posts please ....

Thursday, October 13, 2011

DFIU -- what a MESS for importing data into EXPLORIS

The DFIU utility was written by some brain dead programmer - there are numerous issues that 'could have been better" -- here is just ONE example ....

Instead of common sense -- the utility demands you have TWO DECIMAL PLACES for every price ... so if you are not careful your excel may trim a price like $1731.1 into $171.31 -- and you sell it for a HUGE LOSS .... see the image .....   what DFIU  does is to ignore any decimal and assumes the two RIGHT HAND numbers are pennies .... regardless .... one way to cull out the stupid --I guess .... I would never  accept this as a company ... but then ....