Sales Price Lists (Vantage 6.0)

Yahoo Archive
1
Hi Richard



You will find them in the 'Oprice' table



Regards



Gary



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Richard Bailey
Sent: 31 July 2006 13:13
To: UserGroup
Subject: [Vantage] Sales Price Lists (Vantage 6.0)



Todays dumb question is "Where are the part price breaks held"?

Extracting via ODBC, "PriceLst" appears to hold the list header info,
"PriceLstParts" appears to hold the part and base price info but the 5
element array for quantity and price shows as comma separated zero
values.

I must be missing something simple. Can anyone see what it is?

Regards,
Richard

Richard Bailey
Dudley Industries
Mailto: rbailey@...
<mailto:rbailey%40dudleyindustries.co.uk>
Tel: +44(0)1253 738311
Mob: +44(0)7836 550360
Fax: +44(0)870 7628173





This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.



[Non-text portions of this message have been removed]
2
Todays dumb question is "Where are the part price breaks held"?

Extracting via ODBC, "PriceLst" appears to hold the list header info,
"PriceLstParts" appears to hold the part and base price info but the 5
element array for quantity and price shows as comma separated zero values.

I must be missing something simple. Can anyone see what it is?

Regards,
Richard

Richard Bailey
Dudley Industries
Mailto: rbailey@...
Tel: +44(0)1253 738311
Mob: +44(0)7836 550360
Fax: +44(0)870 7628173