Vendor part numbers/price list

Yahoo Archive
1
I agree that supplier part and part should be separate though I would argue making the primary available in the part master would be handy.


Same as you describe, support told me to export one part from price list and then use that format to import, but I didn't try it yet. I'll let you know if I have any success.

-Ramsey

--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> Vantage is set-up correctly in that the supplier's part number is tied
> to the supplier and not your part number. After all, you may have
> multiple suppliers of a Lock Washer and each of them will have their own
> number.
>
>
>
> The problem with Vantage is they took away the easy cut & paste option
> of entering supplier price lists with 8.03.407. They want you to import
> from a csv. File, but no one at vantage can tell me what the specific
> format needs to be. I can only make the import function work if I
> export a specific part and then change the price and then import it. If
> I try multiple parts or adding new parts or supplier part numbers, then
> it just errors out. They have succeeded in breaking a feature that was
> actually a highlight of Vantage.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
> Kice Industries, Inc.
>
> P(316)744-7151
>
> F(316)295-2412
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of alldoneprojects
> Sent: Monday, March 02, 2009 10:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vendor part numbers/price list
>
>
>
> Hello,
>
> I am a complete newbie to Epicor so please forgive me. I've looked
> through the archives and talked to support but no help at all on this.
>
> My problem is I want a simple way to enter my supplier part number and
> price level. As I understand it, once I have entered in all my
> purchased parts (I have thousands) I can:
>
> -open Supplier Price list and bring in each part number by hand and
> then enter the desired information. Without phenomenal memory skills
> this seems a very bad option and time consuming due to massive number
> of keystrokes required.
>
> or
>
> -Import a list of My PN/Supplier PN. This is probably what we will
> do, but also doesn't seem that there is any good way to export all the
> parts already in the system.
>
> Overall I'm just wondering if there is not a better way to do this as
> the whole thing seems a bit clumsy. Seems I should be able to pull up
> all parts where a certain vendor is the Primary Supplier (as specified
> in Part Master) and then scroll through these and assign P/N and price
> (or export and work on it and re-import).
>
> Thanks in advance for any input,
>
> Ramsey Burns
>
> All Done Projects
> (for Apollo Sec. Sales)
> ramsey@... <mailto:ramsey%40alldonecomputers.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Hello,

I am a complete newbie to Epicor so please forgive me. I've looked
through the archives and talked to support but no help at all on this.

My problem is I want a simple way to enter my supplier part number and
price level. As I understand it, once I have entered in all my
purchased parts (I have thousands) I can:

-open Supplier Price list and bring in each part number by hand and
then enter the desired information. Without phenomenal memory skills
this seems a very bad option and time consuming due to massive number
of keystrokes required.

or

-Import a list of My PN/Supplier PN. This is probably what we will
do, but also doesn't seem that there is any good way to export all the
parts already in the system.

Overall I'm just wondering if there is not a better way to do this as
the whole thing seems a bit clumsy. Seems I should be able to pull up
all parts where a certain vendor is the Primary Supplier (as specified
in Part Master) and then scroll through these and assign P/N and price
(or export and work on it and re-import).

Thanks in advance for any input,

Ramsey Burns

All Done Projects
(for Apollo Sec. Sales)
ramsey@...
3
Write a BAQ that does just that and then copy the results to an excel
spreadsheet.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of alldoneprojects
Sent: Monday, March 02, 2009 11:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vendor part numbers/price list



Hello,

I am a complete newbie to Epicor so please forgive me. I've looked
through the archives and talked to support but no help at all on this.

My problem is I want a simple way to enter my supplier part number and
price level. As I understand it, once I have entered in all my
purchased parts (I have thousands) I can:

-open Supplier Price list and bring in each part number by hand and
then enter the desired information. Without phenomenal memory skills
this seems a very bad option and time consuming due to massive number
of keystrokes required.

or

-Import a list of My PN/Supplier PN. This is probably what we will
do, but also doesn't seem that there is any good way to export all the
parts already in the system.

Overall I'm just wondering if there is not a better way to do this as
the whole thing seems a bit clumsy. Seems I should be able to pull up
all parts where a certain vendor is the Primary Supplier (as specified
in Part Master) and then scroll through these and assign P/N and price
(or export and work on it and re-import).

Thanks in advance for any input,

Ramsey Burns

All Done Projects
(for Apollo Sec. Sales)
ramsey@... <mailto:ramsey%40alldonecomputers.com>





[Non-text portions of this message have been removed]
4
So let me ask, all you want is a place to enter the supplier part number
and the price so that when you create a PO they both pop in
automatically?




M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of alldoneprojects
Sent: Monday, March 02, 2009 10:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vendor part numbers/price list



Hello,

I am a complete newbie to Epicor so please forgive me. I've looked
through the archives and talked to support but no help at all on this.

My problem is I want a simple way to enter my supplier part number and
price level. As I understand it, once I have entered in all my
purchased parts (I have thousands) I can:

-open Supplier Price list and bring in each part number by hand and
then enter the desired information. Without phenomenal memory skills
this seems a very bad option and time consuming due to massive number
of keystrokes required.

or

-Import a list of My PN/Supplier PN. This is probably what we will
do, but also doesn't seem that there is any good way to export all the
parts already in the system.

Overall I'm just wondering if there is not a better way to do this as
the whole thing seems a bit clumsy. Seems I should be able to pull up
all parts where a certain vendor is the Primary Supplier (as specified
in Part Master) and then scroll through these and assign P/N and price
(or export and work on it and re-import).

Thanks in advance for any input,

Ramsey Burns

All Done Projects
(for Apollo Sec. Sales)
ramsey@... <mailto:ramsey%40alldonecomputers.com>






[Non-text portions of this message have been removed]
5
Essentially yes. The only other issue on the horizon is that in case
one supplier is out of stock another supplier should be able to be
selected (with different Supplier P/N).


--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> So let me ask, all you want is a place to enter the supplier part
number
> and the price so that when you create a PO they both pop in
> automatically?
>
>
>
>
> M. Manasa Reddy
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of alldoneprojects
> Sent: Monday, March 02, 2009 10:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vendor part numbers/price list
>
>
>
> Hello,
>
> I am a complete newbie to Epicor so please forgive me. I've looked
> through the archives and talked to support but no help at all on
this.
>
> My problem is I want a simple way to enter my supplier part number
and
> price level. As I understand it, once I have entered in all my
> purchased parts (I have thousands) I can:
>
> -open Supplier Price list and bring in each part number by hand and
> then enter the desired information. Without phenomenal memory skills
> this seems a very bad option and time consuming due to massive
number
> of keystrokes required.
>
> or
>
> -Import a list of My PN/Supplier PN. This is probably what we will
> do, but also doesn't seem that there is any good way to export all
the
> parts already in the system.
>
> Overall I'm just wondering if there is not a better way to do this
as
> the whole thing seems a bit clumsy. Seems I should be able to pull
up
> all parts where a certain vendor is the Primary Supplier (as
specified
> in Part Master) and then scroll through these and assign P/N and
price
> (or export and work on it and re-import).
>
> Thanks in advance for any input,
>
> Ramsey Burns
>
> All Done Projects
> (for Apollo Sec. Sales)
> ramsey@... <mailto:ramsey%40alldonecomputers.com>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
So you can do two things in conjunction of each other...there are
approved suppliers you can associate to each part (but which you have to
do manually!). This allows you to only purchase from those suppliers.

Then once that is set up, go to Supplier price list.

Here you can import because there is a list grid which will let you copy
and paste from an excel sheet. First add one part to a supplier then go
to the list view, copy the selection and paste into excel. you will
have the format to import from the excel sheet once you have filled it
out.

Play with it and see, if you need more help let us know.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of alldoneprojects
Sent: Monday, March 02, 2009 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vendor part numbers/price list



Essentially yes. The only other issue on the horizon is that in case
one supplier is out of stock another supplier should be able to be
selected (with different Supplier P/N).

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> So let me ask, all you want is a place to enter the supplier part
number
> and the price so that when you create a PO they both pop in
> automatically?
>
>
>
>
> M. Manasa Reddy
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of alldoneprojects
> Sent: Monday, March 02, 2009 10:06 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vendor part numbers/price list
>
>
>
> Hello,
>
> I am a complete newbie to Epicor so please forgive me. I've looked
> through the archives and talked to support but no help at all on
this.
>
> My problem is I want a simple way to enter my supplier part number
and
> price level. As I understand it, once I have entered in all my
> purchased parts (I have thousands) I can:
>
> -open Supplier Price list and bring in each part number by hand and
> then enter the desired information. Without phenomenal memory skills
> this seems a very bad option and time consuming due to massive
number
> of keystrokes required.
>
> or
>
> -Import a list of My PN/Supplier PN. This is probably what we will
> do, but also doesn't seem that there is any good way to export all
the
> parts already in the system.
>
> Overall I'm just wondering if there is not a better way to do this
as
> the whole thing seems a bit clumsy. Seems I should be able to pull
up
> all parts where a certain vendor is the Primary Supplier (as
specified
> in Part Master) and then scroll through these and assign P/N and
price
> (or export and work on it and re-import).
>
> Thanks in advance for any input,
>
> Ramsey Burns
>
> All Done Projects
> (for Apollo Sec. Sales)
> ramsey@... <mailto:ramsey%40alldonecomputers.com>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
7
Okay, that gives me more of an idea what stick to poke it with. Along
with BAQ I should be able to get all my existing stuff in there.

Many thanks.

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> So you can do two things in conjunction of each other...there are
> approved suppliers you can associate to each part (but which you
have to
> do manually!). This allows you to only purchase from those
suppliers.
>
> Then once that is set up, go to Supplier price list.
>
> Here you can import because there is a list grid which will let you
copy
> and paste from an excel sheet. First add one part to a supplier
then go
> to the list view, copy the selection and paste into excel. you will
> have the format to import from the excel sheet once you have filled
it
> out.
>
> Play with it and see, if you need more help let us know.
>
>
>
> M. Manasa Reddy
> manasa@...
> P: 630-806-2000
> F: 630-806-2001
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of alldoneprojects
> Sent: Monday, March 02, 2009 10:26 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vendor part numbers/price list
>
>
>
> Essentially yes. The only other issue on the horizon is that in case
> one supplier is out of stock another supplier should be able to be
> selected (with different Supplier P/N).
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > So let me ask, all you want is a place to enter the supplier part
> number
> > and the price so that when you create a PO they both pop in
> > automatically?
> >
> >
> >
> >
> > M. Manasa Reddy
> > manasa@
> > P: 630-806-2000
> > F: 630-806-2001
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
On
> Behalf
> > Of alldoneprojects
> > Sent: Monday, March 02, 2009 10:06 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Vendor part numbers/price list
> >
> >
> >
> > Hello,
> >
> > I am a complete newbie to Epicor so please forgive me. I've looked
> > through the archives and talked to support but no help at all on
> this.
> >
> > My problem is I want a simple way to enter my supplier part number
> and
> > price level. As I understand it, once I have entered in all my
> > purchased parts (I have thousands) I can:
> >
> > -open Supplier Price list and bring in each part number by hand
and
> > then enter the desired information. Without phenomenal memory
skills
> > this seems a very bad option and time consuming due to massive
> number
> > of keystrokes required.
> >
> > or
> >
> > -Import a list of My PN/Supplier PN. This is probably what we will
> > do, but also doesn't seem that there is any good way to export all
> the
> > parts already in the system.
> >
> > Overall I'm just wondering if there is not a better way to do this
> as
> > the whole thing seems a bit clumsy. Seems I should be able to pull
> up
> > all parts where a certain vendor is the Primary Supplier (as
> specified
> > in Part Master) and then scroll through these and assign P/N and
> price
> > (or export and work on it and re-import).
> >
> > Thanks in advance for any input,
> >
> > Ramsey Burns
> >
> > All Done Projects
> > (for Apollo Sec. Sales)
> > ramsey@ <mailto:ramsey%40alldonecomputers.com>
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
Vantage is set-up correctly in that the supplier's part number is tied
to the supplier and not your part number. After all, you may have
multiple suppliers of a Lock Washer and each of them will have their own
number.



The problem with Vantage is they took away the easy cut & paste option
of entering supplier price lists with 8.03.407. They want you to import
from a csv. File, but no one at vantage can tell me what the specific
format needs to be. I can only make the import function work if I
export a specific part and then change the price and then import it. If
I try multiple parts or adding new parts or supplier part numbers, then
it just errors out. They have succeeded in breaking a feature that was
actually a highlight of Vantage.



Regards,





Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of alldoneprojects
Sent: Monday, March 02, 2009 10:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vendor part numbers/price list



Hello,

I am a complete newbie to Epicor so please forgive me. I've looked
through the archives and talked to support but no help at all on this.

My problem is I want a simple way to enter my supplier part number and
price level. As I understand it, once I have entered in all my
purchased parts (I have thousands) I can:

-open Supplier Price list and bring in each part number by hand and
then enter the desired information. Without phenomenal memory skills
this seems a very bad option and time consuming due to massive number
of keystrokes required.

or

-Import a list of My PN/Supplier PN. This is probably what we will
do, but also doesn't seem that there is any good way to export all the
parts already in the system.

Overall I'm just wondering if there is not a better way to do this as
the whole thing seems a bit clumsy. Seems I should be able to pull up
all parts where a certain vendor is the Primary Supplier (as specified
in Part Master) and then scroll through these and assign P/N and price
(or export and work on it and re-import).

Thanks in advance for any input,

Ramsey Burns

All Done Projects
(for Apollo Sec. Sales)
ramsey@... <mailto:ramsey%40alldonecomputers.com>





[Non-text portions of this message have been removed]