Accounts Payable Trial Balance Issue

Issue: Invoice still lists on 'Accounts Payable Trial Balance' request, that was cancelled.

 

pls refer to the attached file.

New version

文件:	Invoice_Accounting_Issue.rar
大小:	272KB
下载:	下载

 

old version

文件:	Invoice_Accounting_Issue.rar
大小:	250KB
下载:	下载

 

 

In fact, you can run the scripts attached to generate HTML file.

 

文件:	284047.rar
大小:	91KB
下载:	下载

Note:

1>The APList requires SQL*Plus version 8.1.7 or higher;

2>Modify 'define outputfilename = APListh_&v_invoice_id._&v_date._diag.html' to

'define outputfilename = D:\APListh_&v_invoice_id._&v_date._diag.html';