Need Query that will work fater for fetching data
Issue - Trial balance shows 0.01 positive or negative balance in trial balance as per below. There could be more than 1000 such records in the data at present.
I want for now to select only say 10 or 50 records in a table to work on correction of these records.
Can some one please help with a query to fetch and gather the data in a table?
Accounts Payable Trial Balance
Invoice
Invoice Number Date Curr Amount Remaining Amount Invoice Description
-------------------- --------- ---- ------------------ ------------------ ----------------------------------------------------
Supplier Name: XYZ
575 06-NOV-07 BRL 5,201.97 (0.01) Tipo de Nota: SERVICOS - REC: 4912 (Nota Fiscal)
620 07-FEB-08 BRL 3,698.01 0.01 Tipo de Nota: SERVICOS - REC: 33727 (Nota Fiscal)