project QadFinancials > class BClosingPostingsReport > business logic query APBalanceCurrent


Parameters


iiCompanyIdintegerCompany id


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoiceIsInitialStatus = no AND
CInvoice.CInvoiceIsOpen = yes

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


query resultset tqAPBalanceCurrent


field namedata typedb fielddescription
tdCInvoiceBalanceCCdecimalCInvoice.CInvoiceBalanceCCSC 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.
tdCInvoiceBalanceLCdecimalCInvoice.CInvoiceBalanceLCBC 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.CreditorControlGLBalance