Registered Forum Members Can Vote! Forum members respond to business & software questions

P.O. Ref/Inv# field usage in my shop is

1) Entering vendor invoice # into part lines manually, auto-fill would be great
12
75%
2) Using Ref/Inv# for different data (cust, veh, license#, etc) and I do not want to lose this data
0
No votes
3) Not using Ref/Inv # fields but we have it with Manager Plus / SK Mgmt
0
No votes
4) Not using Ref/Inv # fields because we use Manager/Service Writer only (no PO functions)
4
25%
 
Total votes : 16

POLL: Vendor Inv# @ PO Receive

POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Thu Jun 10, 2010 6:07 am

This is a programming question I posed the other day. Polling of how you actually use it will help shape the response.

NOTE: There is no committment yet to make this a reality, but I would like to get it on the table for internal discussion.

When you order parts, you don't know what the vendor invoice is (unless the vendor tells you over the phone?). Later you are tasked with entering the vendor invoice # into each Ref/Inv# field of the PO parts on various orders, if you want to get that data stored into history.

What if on the PO screen to receive PO parts that just arrived, you could enter the vendor invoice as shown below and then it would fill all of the Ref/Inv# part fields when you finished receiving?

This creates a question; should the PO entry data always REPLACE any user entered data in the part item edit Ref/Inv#? Please choose the option that best describes how you use it and what you'd like to see in this regard. Thanks
Attachments
PO#1b.png
 
PO#2b.png
 
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: POLL: Vendor Inv# @ PO Receive

Postby fortknoxx » Thu Jun 10, 2010 6:12 am

i don't use po's, but i use the inv# in that field

haha I'm first!
T-N-T (Tina Nuse-Tolar)
Camper Bob's

609-760-7079 Cell
User avatar
fortknoxx
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
 
Posts: 1995
Joined: Wed Sep 13, 2006 6:09 am
Location: High Point, NC

Re: POLL: Vendor Inv# @ PO Receive

Postby Chris W. » Thu Jun 10, 2010 6:52 am

Here is a program question, What if you only rec one part from your PO at a time and the second part comes in on a new vender invoice# we are back to where you were manual enter twice.
But what if you move that data entry to the Receive and the Receive All button?
If you use the RO# in the system it sticks to the PO.
just a thought.
Chris W.
See you on the other side (someday) knowledge is waiting for us.
Chris W.
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 88
Joined: Fri May 20, 2005 8:14 am
Location: .........On this side.........

Re: POLL: Vendor Inv# @ PO Receive

Postby ricmorin » Thu Jun 10, 2010 7:29 am

We manually enter the invoice number on the PO. IT WOULD BE AWESOME TO HAVE THE SAME FIELD AUTO-POPULATE ON THE PART RECORD.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5272
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: POLL: Vendor Inv# @ PO Receive

Postby Pauls Automotive » Thu Jun 10, 2010 8:41 am

We manually enter all our vendor invoice numbers into that field so having that automated would be a wonderful thing.
Paul
Pauls Automotive
6320 Falls Road
Baltimore, Md 21209
410-825-2224
paul@paulsauto.com
TRUE HAPPINESS IS WITHIN YOU
User avatar
Pauls Automotive
1000 Club: Interstellar
1000 Club: Interstellar
 
Posts: 1324
Joined: Wed May 24, 2006 6:32 am
Location: Baltimore Maryland

Re: POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Thu Jun 10, 2010 8:50 am

Chris W. wrote:What if you only rec one part from your PO at a time and the second part comes in on a new vender invoice# we are back to where you were manual enter twice.


So a back-ordered item doesn't reference the same inv # and later shows up with a new one? Is that accounted for on the vendor side? (ie cancel the BO off 1234 and now ship it on 6789, delete the BO ref from 1234 as now fulfilled by 6789)

Chris W. wrote:But what if you move that data entry to the Receive and the Receive All button?


ISSUES
Requires third Receive checkbox, defaulted as checked to use the master vendor inv #, unchecked to enter a diff vendor invoice #?
Would require an input box to feed down to that part on the order
Storing and displaying more than one invoice #

Chris W. wrote: If you use the RO# in the system it sticks to the PO.


Eh?
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: POLL: Vendor Inv# @ PO Receive

Postby Chris W. » Thu Jun 10, 2010 9:43 am

timbre4 wrote: So a back-ordered item doesn't reference the same inv # and later shows up with a new one? Is that accounted for on the vendor side? (ie cancel the BO off 1234 and now ship it on 6789, delete the BO ref from 1234 as now fulfilled by 6789)

Correct part shipped with new vender invoice#

Chris W. wrote:But what if you move that data entry to the Receive and the Receive All button?


ISSUES
Requires third Receive checkbox, defaulted as checked to use the master vendor inv #, unchecked to enter a diff vendor invoice #?
Would require an input box to feed down to that part on the order
Storing and displaying more than one invoice #

What if you feed the SQL by placeing the field as below. So if you rec one part or the whole PO the field would be placed on the RO parts field.
po3s.png
 
Chris W.
See you on the other side (someday) knowledge is waiting for us.
Chris W.
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 88
Joined: Fri May 20, 2005 8:14 am
Location: .........On this side.........

Re: POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Thu Jun 10, 2010 10:19 am

I think we're on the same page for the most part. My concerns are:

Storing more than one Vendor invoice # [additional field(s) reqd in db]
Displaying more than one Vendor invoice # [additional field(s) reqd in PO screen?]
How/where to control writing exceptions

I'm thinking the way to manage this is to:

1. Use the Ref/Inv # field in the existing location (nearly all the time)
2. Then also display that vendor # in the Receive window (dimmed and checked)
3. Unchecking the box allows overwriting with diff # (to be stored along with the original vendor # that applies to other parts)

po3x.png
 
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: POLL: Vendor Inv# @ PO Receive

Postby Chris W. » Thu Jun 10, 2010 11:44 am

timbre4 wrote:I think we're on the same page for the most part. My concerns are:

Yes we are :wink:
You wouldn't be storing any new data just a new data entry field for an existing information at the parts record level
I't just looks like an added step with the check box. When if you don't revc the part on that venders invoice the # is going to change when he bills it out on your next parts run.
Chris W.
See you on the other side (someday) knowledge is waiting for us.
Chris W.
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 88
Joined: Fri May 20, 2005 8:14 am
Location: .........On this side.........

Re: POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Thu Jun 10, 2010 12:04 pm

This is what I see:

1. Receive All PO parts process (5 parts)
2. Enter the Vendor inv # on main screen, noting 4th item is BO
3. 1st part OK
4. 2nd part OK
5. 3rd part OK
6. 4th part enter Q in BO, uncheck box to blank out (disassociate) vendor inv #
7. 5th part OK

PO remains open with original vendor inv # entered, stored and transmitted down to appropriate order part lines

8. BO part arrives and return to PO screen; highlight 4th part line
9. Receive part and now enter the new vendor inv # and close PO

I am storing more than one vendor invoice in this scenario and the current design reflects using one; so the rules for the Ref/Inf# field are changed to accomodate more than one entry.

I'd also like to see Ref/Inv# added to PO Search screen so have to be aware of how future search results would work with more that a single vendor invoice # stuffed into that field. (make it loose like Tire Package Description field I guess)
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: POLL: Vendor Inv# @ PO Receive

Postby Chris W. » Thu Jun 10, 2010 12:15 pm

Looks like a plan push it to the top. :)
Chris W.
See you on the other side (someday) knowledge is waiting for us.
Chris W.
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 88
Joined: Fri May 20, 2005 8:14 am
Location: .........On this side.........

Re: POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Thu Jun 10, 2010 12:18 pm

I'm going to try, need to see some more votes on this. :idea:
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Re: POLL: Vendor Inv# @ PO Receive

Postby Pauls Automotive » Fri Jun 11, 2010 2:57 am

I can tell you I like what you have come up with. Makes a lot of sense and would seem to work well if the programmers can make it happen.
Paul
Pauls Automotive
6320 Falls Road
Baltimore, Md 21209
410-825-2224
paul@paulsauto.com
TRUE HAPPINESS IS WITHIN YOU
User avatar
Pauls Automotive
1000 Club: Interstellar
1000 Club: Interstellar
 
Posts: 1324
Joined: Wed May 24, 2006 6:32 am
Location: Baltimore Maryland

Re: POLL: Vendor Inv# @ PO Receive

Postby steven kiser » Sat Jun 12, 2010 1:49 am

off the point but still on the subject. how do you group delete all the po's. i thought of using the po option but seeing as i'm a bit mmmmmmm o.c.d.ish or just a virgo i feel the need to start from scratch.
never argue with a fool, they'll drag you down to their level and beat you with experience
User avatar
steven kiser
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 6297
Joined: Fri Jul 06, 2007 4:58 am
Location: eastern ma.

Re: POLL: Vendor Inv# @ PO Receive

Postby timbre4 » Sat Jun 12, 2010 7:47 am

There is no mass delete function; it's a dangerous proposition. Wally, you clicked what?!

POs are designed to go through the Receive All process and then they're closed as part of that process.
Tim McDonnell -
Sr. Product Market Mgr / Forum Moderator / Mitchell 1 Media Developer
User avatar
timbre4
System Guru / Moderator
System Guru / Moderator
 
Posts: 4514
Joined: Tue May 25, 2004 5:47 pm
Location: TN - Volunteer State

Return to POLLS

Who is online

Users browsing this forum: No registered users and 1 guest