Using ODBC to do Mass Change on Unit Price

Yahoo Archive
1
Mario,

We don't use price lists. When you say you've done this, did you do
it with price lists or the way I'm trying to do it?

Thanks,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, Mario Aguirre <maguirre@l...> wrote:
> Brian,
>
> I have done this on 5.1 and 6.1 without a problem. The question is:
Do you
> have price lists associated with these customers? If so, you will
be better
> off exporting, changing and importing the price list. The price
list will
> overwrite any pricing. Check Epicor support for pricing hiearchy.
>
> Mario Aguirre
> Lakin General Corporation, Inc.
>
>
> _____
>
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, February 21, 2005 8:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Using ODBC to do Mass Change on Unit Price
>
>
>
> We have a customer with over 600 PN's. They've agreed to new
pricing
> and we need to change the price on all open orders effective 2/28.
> All of the new prices are in an Access DB. My idea is to use ODBC
to
> write those new prices to the Vantage DB with an Update Query.
I've
> done it on the test side and it appears to work wonderfully. The
> only field being changed is the OrderDtl.UnitPrice field.
>
> I'm just asking for any advice from others who have done this kind
of
> thing. Is there any thing that could be a problem behind the
scenes
> that I'm not thinking about? I know there have have been warnings
> about writing to the DB, but I think this is a really straight
> forward application and a huge time saver. I'd appreciate any
> opinions before I do it for real this weekend.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.300117
6/D=gr
>
oups/S=1705007183:HM/EXP=1109082762/A=2343726/R=0/SIG=12ib70fl4/*http:
//clk.
>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323>
>
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.300117
6/D=gr
>
oups/S=1705007183:HM/EXP=1109082762/A=2343726/R=1/SIG=12ib70fl4/*http:
//clk.
>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323>

>
>
> Get unlimited calls to
>
> U.S./Canada
>
>
>
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=11
089963
> 62108323>
>
> <http://us.adserver.yahoo.com/l?
M=324658.6070095.7083352.3001176/D=groups/S=
> :HM/A=2343726/rand=243415911>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
2
We have a customer with over 600 PN's. They've agreed to new pricing
and we need to change the price on all open orders effective 2/28.
All of the new prices are in an Access DB. My idea is to use ODBC to
write those new prices to the Vantage DB with an Update Query. I've
done it on the test side and it appears to work wonderfully. The
only field being changed is the OrderDtl.UnitPrice field.

I'm just asking for any advice from others who have done this kind of
thing. Is there any thing that could be a problem behind the scenes
that I'm not thinking about? I know there have have been warnings
about writing to the DB, but I think this is a really straight
forward application and a huge time saver. I'd appreciate any
opinions before I do it for real this weekend.

Thanks,

Brian Stenglein
Clow Stamping Co.
3
Brian,

In the company configuration under order management do you have bookings
checked. Do you use the bookings table for reporting. If so you should
monitor the effects of this transaction table in your training database.
This could be one possible database trigger you would miss by updating the
price field outside vantage programs.


Patrick Winter


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, February 21, 2005 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Using ODBC to do Mass Change on Unit Price



We have a customer with over 600 PN's. They've agreed to new pricing and we
need to change the price on all open orders effective 2/28.
All of the new prices are in an Access DB. My idea is to use ODBC to write
those new prices to the Vantage DB with an Update Query. I've done it on
the test side and it appears to work wonderfully. The only field being
changed is the OrderDtl.UnitPrice field.

I'm just asking for any advice from others who have done this kind of thing.
Is there any thing that could be a problem behind the scenes that I'm not
thinking about? I know there have have been warnings about writing to the
DB, but I think this is a really straight forward application and a huge
time saver. I'd appreciate any opinions before I do it for real this
weekend.

Thanks,

Brian Stenglein
Clow Stamping Co.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
4
Brian,
Just a thought but is the extended order value stored anywhere for A/R such as for credit limits? In theory this would be a violation of database normalization and the value shold be recalculated from the source records (OrderDtl) but who knows how Epicor designed it. I'm thinking the value used for outstanding orders for credit limit checking when enteirng new orders could be stored somwhere and thus get out of synch if the order detail value was slammed in. For that matter does the G/L potentially have any accounts for outstanding order values?
-Todd C.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, February 21, 2005 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Using ODBC to do Mass Change on Unit Price



We have a customer with over 600 PN's. They've agreed to new pricing
and we need to change the price on all open orders effective 2/28.
All of the new prices are in an Access DB. My idea is to use ODBC to
write those new prices to the Vantage DB with an Update Query. I've
done it on the test side and it appears to work wonderfully. The
only field being changed is the OrderDtl.UnitPrice field.

I'm just asking for any advice from others who have done this kind of
thing. Is there any thing that could be a problem behind the scenes
that I'm not thinking about? I know there have have been warnings
about writing to the DB, but I think this is a really straight
forward application and a huge time saver. I'd appreciate any
opinions before I do it for real this weekend.

Thanks,

Brian Stenglein
Clow Stamping Co.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.3001176/D=groups/S=1705007183:HM/EXP=1109082762/A=2343726/R=0/SIG=12ib70fl4/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323> <http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.3001176/D=groups/S=1705007183:HM/EXP=1109082762/A=2343726/R=1/SIG=12ib70fl4/*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323>


Get unlimited calls to

U.S./Canada

<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1108996362108323>
<http://us.adserver.yahoo.com/l?M=324658.6070095.7083352.3001176/D=groups/S=:HM/A=2343726/rand=243415911>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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

I have done this on 5.1 and 6.1 without a problem. The question is: Do you
have price lists associated with these customers? If so, you will be better
off exporting, changing and importing the price list. The price list will
overwrite any pricing. Check Epicor support for pricing hiearchy.

Mario Aguirre
Lakin General Corporation, Inc.


_____

From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, February 21, 2005 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Using ODBC to do Mass Change on Unit Price



We have a customer with over 600 PN's. They've agreed to new pricing
and we need to change the price on all open orders effective 2/28.
All of the new prices are in an Access DB. My idea is to use ODBC to
write those new prices to the Vantage DB with an Update Query. I've
done it on the test side and it appears to work wonderfully. The
only field being changed is the OrderDtl.UnitPrice field.

I'm just asking for any advice from others who have done this kind of
thing. Is there any thing that could be a problem behind the scenes
that I'm not thinking about? I know there have have been warnings
about writing to the DB, but I think this is a really straight
forward application and a huge time saver. I'd appreciate any
opinions before I do it for real this weekend.

Thanks,

Brian Stenglein
Clow Stamping Co.





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.3001176/D=gr
oups/S=1705007183:HM/EXP=1109082762/A=2343726/R=0/SIG=12ib70fl4/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323>
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.3001176/D=gr
oups/S=1705007183:HM/EXP=1109082762/A=2343726/R=1/SIG=12ib70fl4/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1108996362108323>


Get unlimited calls to

U.S./Canada


<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=11089963
62108323>

<http://us.adserver.yahoo.com/l?M=324658.6070095.7083352.3001176/D=groups/S=
:HM/A=2343726/rand=243415911>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
Good points Patrick. We do have the bookings checked, but we aren't
using the tables for any reports. My change did not get reflected in
that table, I also looked at the Change Log, which we do use, and
that is not updated either. The way I see it, neither of these
problems are critical, but I will certainly make management aware of
them and let them decide which way they want to go. Do you see any
problem with the bookings table not containing those changes if we
don't use it for reporting?

Thanks,

Brian Stenglein


--- In vantage@yahoogroups.com, pjw@s... wrote:
> Brian,
>
> In the company configuration under order management do you have
bookings
> checked. Do you use the bookings table for reporting. If so you
should
> monitor the effects of this transaction table in your training
database.
> This could be one possible database trigger you would miss by
updating the
> price field outside vantage programs.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, February 21, 2005 8:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Using ODBC to do Mass Change on Unit Price
>
>
>
> We have a customer with over 600 PN's. They've agreed to new
pricing and we
> need to change the price on all open orders effective 2/28.
> All of the new prices are in an Access DB. My idea is to use ODBC
to write
> those new prices to the Vantage DB with an Update Query. I've done
it on
> the test side and it appears to work wonderfully. The only field
being
> changed is the OrderDtl.UnitPrice field.
>
> I'm just asking for any advice from others who have done this kind
of thing.
> Is there any thing that could be a problem behind the scenes that
I'm not
> thinking about? I know there have have been warnings about writing
to the
> DB, but I think this is a really straight forward application and a
huge
> time saver. I'd appreciate any opinions before I do it for real
this
> weekend.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
7
Brian,

If you don't use the bookings table, I would uncheck the check box then
recheck it say at the start of the fiscal year or something or use leave it
unchecked.


Patrick Winter


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Monday, February 21, 2005 9:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Using ODBC to do Mass Change on Unit Price



Good points Patrick. We do have the bookings checked, but we aren't using
the tables for any reports. My change did not get reflected in that table,
I also looked at the Change Log, which we do use, and that is not updated
either. The way I see it, neither of these problems are critical, but I
will certainly make management aware of them and let them decide which way
they want to go. Do you see any problem with the bookings table not
containing those changes if we don't use it for reporting?

Thanks,

Brian Stenglein


--- In vantage@yahoogroups.com, pjw@s... wrote:
> Brian,
>
> In the company configuration under order management do you have
bookings
> checked. Do you use the bookings table for reporting. If so you
should
> monitor the effects of this transaction table in your training
database.
> This could be one possible database trigger you would miss by
updating the
> price field outside vantage programs.
>
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, February 21, 2005 8:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Using ODBC to do Mass Change on Unit Price
>
>
>
> We have a customer with over 600 PN's. They've agreed to new
pricing and we
> need to change the price on all open orders effective 2/28.
> All of the new prices are in an Access DB. My idea is to use ODBC
to write
> those new prices to the Vantage DB with an Update Query. I've done
it on
> the test side and it appears to work wonderfully. The only field
being
> changed is the OrderDtl.UnitPrice field.
>
> I'm just asking for any advice from others who have done this kind
of thing.
> Is there any thing that could be a problem behind the scenes that
I'm not
> thinking about? I know there have have been warnings about writing
to the
> DB, but I think this is a really straight forward application and a
huge
> time saver. I'd appreciate any opinions before I do it for real
this
> weekend.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
8
Thanks for the thoughts Todd. I think the credit limit is
recalculated each time you enter that screen, at least it appears the
system is doing that. I don't think the G/L is affected by
outstanding orders, any Accountants want to clarify?

Thanks,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> Brian,
> Just a thought but is the extended order value stored anywhere for
A/R such as for credit limits? In theory this would be a violation
of database normalization and the value shold be recalculated from
the source records (OrderDtl) but who knows how Epicor designed it.
I'm thinking the value used for outstanding orders for credit limit
checking when enteirng new orders could be stored somwhere and thus
get out of synch if the order detail value was slammed in. For that
matter does the G/L potentially have any accounts for outstanding
order values?
> -Todd C.
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Monday, February 21, 2005 8:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Using ODBC to do Mass Change on Unit Price
>
>
>
> We have a customer with over 600 PN's. They've agreed to new
pricing
> and we need to change the price on all open orders effective 2/28.
> All of the new prices are in an Access DB. My idea is to use ODBC
to
> write those new prices to the Vantage DB with an Update Query.
I've
> done it on the test side and it appears to work wonderfully. The
> only field being changed is the OrderDtl.UnitPrice field.
>
> I'm just asking for any advice from others who have done this kind
of
> thing. Is there any thing that could be a problem behind the
scenes
> that I'm not thinking about? I know there have have been warnings
> about writing to the DB, but I think this is a really straight
> forward application and a huge time saver. I'd appreciate any
> opinions before I do it for real this weekend.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
> Yahoo! Groups Sponsor
>
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.300117
6/D=groups/S=1705007183:HM/EXP=1109082762/A=2343726/R=0/SIG=12ib70fl4/
*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11089
96362108323>
<http://us.ard.yahoo.com/SIG=129vqdub9/M=324658.6070095.7083352.300117
6/D=groups/S=1705007183:HM/EXP=1109082762/A=2343726/R=1/SIG=12ib70fl4/
*http://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11089
96362108323>
>
>
> Get unlimited calls to
>
> U.S./Canada
>
>
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=11
08996362108323>
> <http://us.adserver.yahoo.com/l?
M=324658.6070095.7083352.3001176/D=groups/S=:HM/A=2343726/rand=2434159
11>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]