project QadFinancials > class BDInvoice > method CalcOverdueWeeksForSales1

query calculated fields procedure

Description

Assign a value to query calculated field tqDInvoiceByDebtor.tiOverdueWeeksForSales (available in preprocessor {&tiOverdueWeeksForSales})


Parameters


iiCompanyIdinputintegerCompany id
iiDebtorIDinputinteger
itInvoicStartDateinputdate
itInvoiceEndDateinputdate
ilDInvoiceIsOpeninputlogical
icCompanyListIDinputcharacter
icInvoiceTypeinputcharacter
icCurrencyCodeinputcharacter
oiReturnStatusoutputintegerReturn status of the method.


Internal usage


QadFinancials
query DinvoiceByDebtorITypeCurr


program code (program1/bdinvoice.p)

assign {&tiOverdueWeeksForSales} =  truncate({&tiOverdueDaysForSales} / 7 , 0).