立帳科目明細表在抓科目的时间抓错,立账的时间的会计科目是11410100但是却抓出来的是11910400.

开始以为是应收账款(TYPE:INVOICE, CLASS:INVOICE)所立的会计科目出错,因为应收账款现在的业务包括:应收账款(11410100),其他应收账款(11910400).所以,以为需要新加一个应收账款的会计科目.

但是后来通过查看程序,却发现不是这样的问题.测试过程如下:

(1) 查出会计科目为11410100看其于11910400的不同

(2) 找出不同点,然后查看页面中哪里出问题

(3) 经过比较是立账的时间CLASS选择错了,因为同样是应收账欵(TYPE:INVOICE,CLASS却有好多种)A:应收账款(从OM中抛过来的话TYPE 应该选择OE IMPORT-DIP,SMD,BLK,OTHER)B:其它应收款(TYPE应该选择INVOICE)
SELECT rcta.cust_trx_type_id
FROM ra_customer_trx_all rcta

WHERE rcta.trx_number = '00844400_47882'

' SELECT rcta.cust_trx_type_id
FROM ra_customer_trx_all rcta

WHERE rcta.trx_number = ‘ 20344896-224673'

SELECT * FROM ra_cust_trx_types_all rctta WHERE rctta.cust_trx_type_id =1163 1166 rctta.trx_number = '20344896-224673'

select SUBSTRB(rcta.trx_number,1,8) inv_no,
rc.customer_name cust_name,
gcc.segment1||'-'||gcc.segment2||'-'||gcc.segment3
||'-'||gcc.segment4||'-'||gcc.segment5 dr_subject,
gcc1.segment1||'-'||gcc1.segment2||'-'||gcc1.segment3
||'-'||gcc1.segment4||'-'||gcc1.segment5 cr_subject,
rcta.trx_date inv_date,
rcta.invoice_currency_code currency,
rctlgda.amount ore_amt,
rctlgda.amount*nvl(rcta.exchange_rate,1) ntd_amt,
rcta.customer_trx_id c_trx_id,
rctla.customer_trx_line_id c_trx_line_id
from ra_customer_trx_all rcta,
ra_customer_trx_lines_all rctla,
ra_cust_trx_types_all rctta,
ra_cust_trx_line_gl_dist_all rctlgda,
gl_code_combinations gcc,
gl_code_combinations gcc1,
ra_customers rc
where rcta.bill_to_customer_id = rc.customer_id
and rcta.customer_trx_id = rctla.customer_trx_id
and rcta.cust_trx_type_id = rctta.cust_trx_type_id
and rctla.customer_trx_line_id = rctlgda.customer_trx_line_id
and rctlgda.code_combination_id = gcc1.code_combination_id
and rctta.gl_id_rec = gcc.code_combination_id
and rctla.line_type = 'LINE'
AND RCTA.SET_OF_BOOKS_ID = 41
/*and trunc(rcta.trx_date) >= '&&1'
and trunc(rcta.trx_date) <= '&&2'
and rcta.trx_number >= nvl('&&3',rcta.trx_number)*/
/*and rcta.trx_number = '20344896-224673'*/
/* and rc.customer_name = nvl('&&5' ,rc.customer_name) */

SELECT rcta.cust_trx_type_id
FROM ra_customer_trx_all rcta

WHERE rcta.trx_number = '00844400_47882' '20344896-224673'

SELECT * FROM ra_cust_trx_types_all rctta WHERE rctta.cust_trx_type_id =1163 1166 rctta.trx_number = '20344896-224673'

[@more@]