ISTech Support Forum - Tables for Acknowledgement report

Welcome, Guest. Please Login.

	05/03/24 at 02:38:38 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›

Pages: 1

Tables for Acknowledgement report (Read 1305 times)

davson Browser I love YaBB 1G - SP1! Posts: 35	Tables for Acknowledgement report 09/09/04 at 11:53:28 I am attempting to create a acknowledgement report Access. Is BKARCUST the correct table to use to display customer details? Which table do I use to display the Bill address? Does any know which table holds this SO N.o which corresponds to the parts on SO? Thanks
Back to top	IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: Tables for Acknowledgement report Reply #1 - 09/09/04 at 12:29:53 There is a ms excel file that has a listing of DBA's tables and its colums http://www.istechsupport.com/ if you dont find it, message me with your email i will sent it to you. ciao Kelloggs 100% fat free PD: here http://www.istechsupport.com/dl/dbafile.zip
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Danimal

Member

Posts: 59
Gender: male

Re: Tables for Acknowledgement report
Reply #2 - 09/09/04 at 12:36:40

BKARCUST contains customer information; however, not linked to your sales order.

BKARINV contains sales order header infomation, including the fields for bill-to and ship-to customer details.

BKARINVL contains sales order line item information, such as fields for part codes, prices, quantities, and the like. It is linked to BKARINV through the sales order number, meaning that you have to create the appropriate relationship between those fields in Access.

One note of caution... Access doesn't like DBA's use of fields ending with a number enclosed by brackets.

Good Luck! Cheesy

IP Logged

davson

Browser

I love YaBB 1G -
SP1!

Posts: 35

Re: Tables for Acknowledgement report
Reply #3 - 09/10/04 at 07:59:24

Thanks for the info.
I've had a look at BKARINV but it only shows a handful of the customers that have SO N.o's. In DBA on SO-B lookup\search by SO N.o there are many more customers which do not appear in BKARINV.
All of the customers are listed in BKARCUST but as you stated there is no SO is unable to create a relationship. Is there another table holds all of the customer information with the SO N.o?

IP Logged

davson Browser I love YaBB 1G - SP1! Posts: 35	Re: Tables for Acknowledgement report Reply #4 - 09/10/04 at 08:10:23 No need to respond to my previous comments I figured out the problem. Thanks once again for all your comments.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›