business logic query APBalanceCurrent

Parameters

iiCompanyId

integer

Company id

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

field name	data type	db field	description
tdCInvoiceBalanceCC	decimal	CInvoice.CInvoiceBalanceCC	SC 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.
tdCInvoiceBalanceLC	decimal	CInvoice.CInvoiceBalanceLC	BC 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.
tcGLCode	character	GL.GLCode	A code identifying the GL account.

QadFinancials