ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Invoice Number
http://www.istechforum.com/YaBB.pl?num=1239817720

Message started by Kelloggs on 04/15/09 at 10:48:40

Title: Invoice Number
Post by Kelloggs on 04/15/09 at 10:48:40

When invoicing a PO (AP-C) where the Invoice Number is save (which table/field)?

:-[

Kelloggs

Title: Re: Invoice Number
Post by GasGiant on 04/15/09 at 12:16:26

Your invoice number is in BKAPINVT, but I bet you are asking about the vendor invoice number, eh? One of the many mysteries of life. For some reason they are hidden away in MKICLASS.

Title: Re: Invoice Number
Post by NovaZyg on 04/15/09 at 12:25:16

Reason for the mystery.. APINVT invoice was Alpha 10, Not big enough... So we moved it (using a reference number) to MKICLASS that is Alpha 20.

Mystery solved...
;)

Title: Re: Invoice Number
Post by Kelloggs on 04/15/09 at 12:28:46

Yes it is on the MKICLASS table.

can we link tables MKICLASS and BKAPCHKH with fields: MKECLASS_NUM and BKAP_CHK_INVNUM ?

:'(

Kelloggs

Title: Re: Invoice Number
Post by NovaZyg on 04/15/09 at 12:47:58

I made do with what I had...

yes MKECLASS.NUM is numeric, and the VAL(BKAP.CHK.INVNUM) will match

Title: Re: Invoice Number
Post by Kelloggs on 04/16/09 at 10:48:25

DBA tables are wayyyy to complicate. Glad to know that you guys are changing them little by little.

Sooo to get an AP Listing ( I have to create my onw tables due to the BKAP_INVT_CODE data type):

DELETE FROM UMC_AP_BKAPINVT
DELETE FROM UMC_AP_BKAPCHKH
DELETE FROM UMC_AP_MKECLASS

INSERT INTO UMC_AP_MKECLASS
select
MKECLASS_NUM,
MKECLASS_DESC
FROM UMCORP.MKECLASS

INSERT INTO UMC_AP_BKAPINVT
SELECT
BKAP_INVT_CODE,
BKAP_INVT_DATE,
BKAP_INVT_NUM,
BKAP_INVT_AMT,
BKAP_INVT_AMTRM,
BKAP_INVT_DESC,
BKAP_INVT_TYPE
FROM UMCORP.BKAPINVT
WHERE BKAP_INVT_CODE = 'APLMAC0100'

INSERT INTO UMC_AP_BKAPCHKH
SELECT
BKAP_CHK_INVNUM,
BKAP_CHK_NUM
FROM UMCORP.BKAPCHKH
WHERE BKAP_CHK_VNDCOD= 'APLMAC0100'

SELECT
UMC_AP_BKAPINVT.BKAP_INVT_CODE,
UMC_AP_BKAPINVT.BKAP_INVT_DATE,
UMC_AP_BKAPINVT.BKAP_INVT_NUM,
UMC_AP_BKAPINVT.BKAP_INVT_AMT,
UMC_AP_BKAPINVT.BKAP_INVT_AMTRM,
UMC_AP_BKAPINVT.BKAP_INVT_DESC,
UMC_AP_BKAPINVT.BKAP_INVT_TYPE,
UMC_AP_MKECLASS.MKECLASS_DESC,
UMC_AP_BKAPCHKH.BKAP_CHK_NUM
FROM UMC_AP_BKAPINVT LEFT JOIN
UMC_AP_MKECLASS ON UMC_AP_BKAPINVT.BKAP_INVT_NUM = UMC_AP_MKECLASS.MKECLASS_NUM
LEFT JOIN UMC_AP_BKAPCHKH ON UMC_AP_BKAPINVT.BKAP_INVT_NUM = UMC_AP_BKAPCHKH.BKAP_CHK_INVNUM

8-)

Kelloggs