ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Sales Quote Table?
http://www.istechforum.com/YaBB.pl?num=1105109315

Message started by arcticwolf1 on 01/07/05 at 06:48:35

Title: Sales Quote Table?
Post by arcticwolf1 on 01/07/05 at 06:48:35

:-/ I am trying to create a customizable report in CR 8.5 for sales quotations and was wondering if anyone could please tell me which table(s) I need to use to extract the data.

Thanks!

Title: Re: Sales Quote Table?
Post by sharon krewson on 01/07/05 at 09:48:39

I am not sure about where all of the quote data is but you can find a excel spreadsheet on the IStechsupport website that lists all of the file names along with a description. Click the Services tab and go to the free downloads.

I have used it for many of my reports. Please note that this is a an old file and some info may be out of date now that we have all of these handy upgrades. :)

Title: Re: Sales Quote Table?
Post by arcticwolf1 on 01/13/05 at 09:21:37

Thanks but I already have it. I just can't find the right info in it..

Title: Re: Sales Quote Table?
Post by kevind on 01/13/05 at 12:29:22

I wrote up a 'Customer Quote Margin Analysis' report.
It used:

BKESTQT - Quote Header
BKESTQTL - Quote Line Item
BKQTNOTE - Quote Notes
BKARCUST - Customer File
BKICMSTR - Inventory Master
MTICMSTR - Inventory Master
BKICPMAT - Pricing

Hope that helps