business logic query DInvoiceForInvCertification

Description

This query will return the invoices with the same company ID and Journal ID. It's sorted on company, journal, posting year and voucher so we can easily retrieve the last invoice.

Parameters

iiCompanyId	integer	Company id
iiJournalID	integer	Journal ID

query condition

each DInvoice where

DInvoice.Company_ID = iiCompanyId AND
DInvoice.Journal_ID = iiJournalID

query sort order

DInvoice.Company_ID (ascending)
DInvoice.Journal_ID (ascending)
DInvoice.DInvoicePostingYear (ascending)
DInvoice.DInvoiceVoucher (ascending)

query resultset tqDInvoiceForInvCertification

field name	data type	db field	description
tiCompany_ID	integer	DInvoice.Company_ID	Link to Company
tiDInvoice_ID	integer	DInvoice.DInvoice_ID	Record ID
tcDInvoiceInvCertSignatureCurr	character	DInvoice.DInvoiceInvCertSignatureCurr	Signature Current Invoice
tiDInvoicePostingYear	integer	DInvoice.DInvoicePostingYear	Year.This field indicates the accounting year for the invoice. If you modify these fields, the posting and tax dates are changed correspondingly.
	api annotation:		This field defaults to the accounting year associated with the posting date.
tiDInvoiceVoucher	integer	DInvoice.DInvoiceVoucher	Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(after transfer), the voucher is cleared. Voucher must be unique in one GL period. When the user input is zero, the system automatically assign a value not used yet for this field.
tiJournal_ID	integer	DInvoice.Journal_ID	Daybook Code

Internal usage

QadFinancials

method BDInvoice.PreSave