I NEED TO GET THE QUERY THE QUERY OF REPORT LIST OF OPEN ACCOUNTS BALANCE,
I searched the forums but have not found anything,
IS A REPORT OF ACCOUNTS PAYABLE AND MUST Bring me 8 SEGMENTS OF THE ACCOUNTS OF GL_CODE_COMBINATIONS TABLE WITH BALANCE ACCOUNTING, ORIGINAL AMOUNT AND rEMAINING AMOUNT
FOR EXAMPLE, This is the report generated and which need to get the query that I bring these values
Definición de Informe: GFE_BALANCE
Origen de Asiento: Cuentas a Pagar
Fecha Inicial: 1/06/2012
A Partir de: 30/06/2012
Cuenta Saldo Contable Importe Original Importe Restante
(account) (balancing) (original amount) (remaining)
16-042-2001-2601-0000-00-0000-000 34058564.10 3494865.77 -2949034.67
16-050-2001-2601-0000-00-0000-000 37814992.82 0.00 -2392616.50
I apologize for my English as I can, I hope I helped.
in fact if the ebs shows me that unpaid bills, however, the report reflects a Remaining amount, I thought it is because they have been partially paid, so maybe this taking this Remaining amount of GL, but I do not know.
the report that generated is "Open Account Balances Listing"
EBS verison 12
If the report shows a Remaining Amount diffrent from the Invoice Amount it is because partial payments have been made.
And yes, in that case, the remaining amount reflects to GL, on the corresponding account defined as Liability Account.