project QadFinancials > class BClosingPostingsReport > business logic query ARBalanceCurrent


Parameters


iiCompanyIdintegerCompany id


query condition


  each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoiceIsOpen = yes

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DInvoice.ControlGL_ID AND


query resultset tqARBalanceCurrent


field namedata typedb fielddescription
tdDInvoiceBalanceCCdecimalDInvoice.DInvoiceBalanceCCSC Balance. This field displays the sum of the debit and credit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Balance and the SC rate.
tdDInvoiceBalanceLCdecimalDInvoice.DInvoiceBalanceLCBC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency.
This field is calculated by the system using the TC Balance and the Exchange rate.
tcGLCodecharacterGL.GLCodeA code identifying the GL account.


Internal usage


QadFinancials
method BClosingPostingsReport.DebtorControlGLBalance