Welcome, Guest. Please Login.
05/11/24 at 09:32:44
News:
Home Help Search Login


Pages: 1
Send Topic Print
Sales Quote Table? (Read 973 times)
arcticwolf1
Ex Member



Sales Quote Table?
01/07/05 at 06:48:35
 
undecided 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!
Back to top
 
 
  IP Logged
sharon krewson
Ex Member



Re: Sales Quote Table?
Reply #1 - 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. Smiley
Back to top
 
 
  IP Logged
arcticwolf1
Ex Member



Re: Sales Quote Table?
Reply #2 - 01/13/05 at 09:21:37
 
Thanks but I already have it. I just can't find the right info in it..
Back to top
 
 
  IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: Sales Quote Table?
Reply #3 - 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
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print