'Receipt Write-off' 用于冲销帐务,不是oracle的bug,是财务上的处理,你问你们的财务人员就知道了。
做错了一笔业务均可使用该功能冲销,比如 发票录入错误。
一下SQL可以查处某个客户下的所有这种发票:
select tt.customer_id,
tt.customer_name,
tt.customer_number,
tt.gl_date as shoukuan_date,
t.GL_DATE as tuikuan_date,
t.AMOUNT_APPLIED,
t.TRX_NUMBER,
tt.receipt_number
from AR_RECEIVABLE_APPLICATIONS_V t, AR_CASH_RECEIPTS_V tt
where t.TRX_NUMBER = 'Receipt Write-off'
and t.CASH_RECEIPT_ID = tt.cash_receipt_id
and tt.customer_number = 'XXXXX';
[此贴子已经被作者于2005-7-25 8:43:50编辑过]
|