Sales Price List Query

Just checking....since this is an array type field how are you parsing out the components? If you have not worked with array fields (like with the commissions type fields) and you aren't getting the right part of the field it can provide strange results - including zero. If the same seperator was used as for commissions it will be the "~" (tilde) character - CHAR(126). I usually create a function field called Tilde = CHAR(126) and then use this in the ENTRY function to grab out Entry1, Entry2, Entry3, etc.... So that QtyBreak1 would correspond to DiscountPercent1.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Stuart Noble
Sent: Thursday, March 09, 2006 12:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Price List Query



My problem is this. I have written a report to print out one of our
price lists. We require the discount to print out on the report. In the
table PriceLstParts, there are 5 discount fields which are discounts for
each price break. Unfortunately, all these fields are returning the
value zero, even thought the part has got a discount in the price list.

I must be missing something. Can anyone help?

Thank you.

Stuart



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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* 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]
My problem is this. I have written a report to print out one of our
price lists. We require the discount to print out on the report. In the
table PriceLstParts, there are 5 discount fields which are discounts for
each price break. Unfortunately, all these fields are returning the
value zero, even thought the part has got a discount in the price list.

I must be missing something. Can anyone help?

Thank you.

Stuart
Try to use table plpartbrk.
I think you will find there your data.




Kapetanakis Vaggelis


ERP Consultant


E-mail <<<<mailto:v.kapetanakis@…>>>>


This e-mail correspondence is confidential and intended for the named recipient(s) only. The information contained in this e-mail and any attachments may be confidential and/or protected by copyright. If the reader of this e-mail is not intended recipient or the person responsible for delivering it to the intended recipient, any copying, distribution, publication or other use of, or taking of any action in reliance upon, this e-mail is strictly prohibited. Should you have received this e-mail in error, you are requested to notify ATC S.A. and to delete this message and any attachments immediately



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Stuart Noble
Sent: Thursday, March 09, 2006 8:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Price List Query



My problem is this. I have written a report to print out one of our
price lists. We require the discount to print out on the report. In the
table PriceLstParts, there are 5 discount fields which are discounts for
each price break. Unfortunately, all these fields are returning the
value zero, even thought the part has got a discount in the price list.

I must be missing something. Can anyone help?

Thank you.

Stuart



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
I would check your joins.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Stuart Noble
Sent: Thursday, March 09, 2006 1:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Price List Query



My problem is this. I have written a report to print out one of our
price lists. We require the discount to print out on the report. In the
table PriceLstParts, there are 5 discount fields which are discounts for
each price break. Unfortunately, all these fields are returning the
value zero, even thought the part has got a discount in the price list.

I must be missing something. Can anyone help?

Thank you.

Stuart



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