Notification for new price on specific part number

Yahoo Archive
1
Of course, the easiest way would be to just put a CheckBox on the part and create a BPM to check that at order/quote entry.


--- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@...> wrote:
>
> Hi Emily,
>
> Rob's idea would (I think) be much easier to implement from a Vantage point of view, but if you really want to go down the Excel route:
>
> Have a look at this message in the Group: http://tech.groups.yahoo.com/group/vantage/message/60624
>
> The code in that shows how to save to a csv file. Looking at the 4GL Reference Book, there is an opposing command "INPUT FROM" to pull data in from a file. You may be able to change the code to pull in the spreadsheet line-by-line and check for the partnum. I reckon the file would have to be csv, though - not Excel, I know, but it might do you.
>
>
> HTH,
>
> Nigel.
>
> --- In vantage@yahoogroups.com, "emverbeke" <emverbeke@> wrote:
> >
> > I'm sure we're not the only one that has this situation. A customer sent us an order and after reviewing some of the pricing we realize that the next time they order the part we need to increse our price or at least review the pricing. Could you set up something to look at excel spreadsheet and if the part number entered in a quote or an order equals a part number in the spreadsheet then it would send a notification that said "Review the pricing before confirming the order". So in essence I need a BAM or BPM that would look at excel spreadsheet on our server. Thanks for the ideas.
> >
> > Emily
> >
>
2
I'm sure we're not the only one that has this situation. A customer sent us an order and after reviewing some of the pricing we realize that the next time they order the part we need to increse our price or at least review the pricing. Could you set up something to look at excel spreadsheet and if the part number entered in a quote or an order equals a part number in the spreadsheet then it would send a notification that said "Review the pricing before confirming the order". So in essence I need a BAM or BPM that would look at excel spreadsheet on our server. Thanks for the ideas.

Emily
3
Import that data to a UD table and maintain it there...that would work
just as well...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of emverbeke
Sent: Thursday, July 23, 2009 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Notification for new price on specific part number





I'm sure we're not the only one that has this situation. A customer sent
us an order and after reviewing some of the pricing we realize that the
next time they order the part we need to increse our price or at least
review the pricing. Could you set up something to look at excel
spreadsheet and if the part number entered in a quote or an order equals
a part number in the spreadsheet then it would send a notification that
said "Review the pricing before confirming the order". So in essence I
need a BAM or BPM that would look at excel spreadsheet on our server.
Thanks for the ideas.

Emily





[Non-text portions of this message have been removed]
4
Hi Emily,

Rob's idea would (I think) be much easier to implement from a Vantage point of view, but if you really want to go down the Excel route:

Have a look at this message in the Group: http://tech.groups.yahoo.com/group/vantage/message/60624

The code in that shows how to save to a csv file. Looking at the 4GL Reference Book, there is an opposing command "INPUT FROM" to pull data in from a file. You may be able to change the code to pull in the spreadsheet line-by-line and check for the partnum. I reckon the file would have to be csv, though - not Excel, I know, but it might do you.


HTH,

Nigel.

--- In vantage@yahoogroups.com, "emverbeke" <emverbeke@...> wrote:
>
> I'm sure we're not the only one that has this situation. A customer sent us an order and after reviewing some of the pricing we realize that the next time they order the part we need to increse our price or at least review the pricing. Could you set up something to look at excel spreadsheet and if the part number entered in a quote or an order equals a part number in the spreadsheet then it would send a notification that said "Review the pricing before confirming the order". So in essence I need a BAM or BPM that would look at excel spreadsheet on our server. Thanks for the ideas.
>
> Emily
>