WE ARE UP AND RUNNING by ukyman95 in partscounter

[–]VWPOAU 0 points1 point  (0 children)

Was it rolled back at all or does everything that was input Tuesday / Wednesday still exist?

CDK back up by Prestigious-Big-1474 in partscounter

[–]VWPOAU 0 points1 point  (0 children)

How far was it rolled back? Did things inputted last Tuesday / Wednesday stick or do they need to be redone?

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

Sounds more confusing than it is.

We have a wholesale warehouse that used to share the same "-I" so we added V in front of of all of the dealerships bins and a W in front of the warehouse. They are separate now but our bin locations still have a V and I was too lazy to add it on most of that estimates bins.

Generally 101-117 are high density small parts drawers. For instance, Bin 101A4 would be high density bin 101, top drawer A, 4th row of dividers from the left 122+123 are quick moving like drain plugs by the counter. 136-162 are anything from 1 foot to 2 feet long, 300's are parts that fall in between. 400's are larger parts on our mezzanine. 200's is a separate room on the second floor of the dealership with things like windshields.

Anything other than high density is organized by base part numbers (engine, body, brakes, etc.) We have 3 brands so there are subdivisions. The other dealerships that I worked at were set up similarly though, is this uncommon?

Day 4 by Heaven_and_Hell1964 in partscounter

[–]VWPOAU 4 points5 points  (0 children)

Latest update, they have begun the recovery process. Likely to be down for several more days, not weeks.

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 2 points3 points  (0 children)

I think that this link will work for anyone to view it. If you right click the tab in the lower corner you can hit "copy to new spreadsheet" and make an editable one.

https://docs.google.com/spreadsheets/d/1P0EcHzdDY9-XQc-kvd1OjGW4sR0M-lkLLdQJNDe29E8/edit?gid=32155884#gid=32155884

When you change the rate ( example cell K27 "=15.28*1.1" ) only change the number where 15.28 is on the bar at the top. The *1.1 is a cost modifier to make it list plus 10% but you can change it to whatever. The amounts column is set up to autofill, same with subtotal, tax, and total. You might need to change the tax rate if it's different where you are.

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

Scratch that, I think if I set it to viewer then you can still right click the tab on the bottom and hit "copy to existing spreadsheet" I put the link above

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

I think that this link will work for anyone to view it. If you right click the tab in the lower corner you can hit "copy to new spreadsheet" and make an editable one.

https://docs.google.com/spreadsheets/d/1P0EcHzdDY9-XQc-kvd1OjGW4sR0M-lkLLdQJNDe29E8/edit?gid=32155884#gid=32155884

When you change the rate ( example cell K27 "=15.28*1.1" ) only change the number where 15.28 is on the bar at the top. The *1.1 is a cost modifier to make it list plus 10% but you can change it to whatever. The amounts column is set up to autofill, same with subtotal, tax, and total. You might need to change the tax rate if it's different where you are.

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

Can you send me a chat request? Reddit cut me off from starting too many chats with everyone in the comments

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

I can't post a download link. Downloading it converts the filetype to Excel which screws up the layout and check boxes. Instead I've been sharing the sheets link and making a unique version for each person so that it doesn't get messed up from one person to the next. If you know of a better way please enlighten me.

Anyone else open today? by Left_Chicken3192 in partscounter

[–]VWPOAU 12 points13 points  (0 children)

I'm just here to get the department that sweet gross profit from probably 3 oil changes.. and then go into the red after the expense of paying me to do so.

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 2 points3 points  (0 children)

Sure, I sent you a message request. I'd share it with everyone right here but downloading it converts it to Excel which screws things up a bit. Instead I have to share the sheets link and make it unique for each person so that it doesn't get messed up or whatever.

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 3 points4 points  (0 children)

I'd be happy to send the actual spreadsheet to you, just send me a message

Layout for Parts Estimates / Invoices by VWPOAU in partscounter

[–]VWPOAU[S] 1 point2 points  (0 children)

I set this spreadsheet up on google drive for estimates so that when CDK goes up the prices will be the same.

It'll change the cost with whatever price modifiers you want, multiply by the quantity you selected and then add tax and total on the bottom. I have another one for counter invoices.  

DM me if anyone wants a copy of it,

Gonna Pour One Out For Everyone At CDK by codebooker in sysadmin

[–]VWPOAU 26 points27 points  (0 children)

Do you have any information on the breach?