project QadFinancials > class BDInvoice > method CalcOpenAmountTCForSales1

query calculated fields procedure

Description

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


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 {&tdOpenAmountTCForSales} = {&tdDInvoiceBalanceDebitTC} - {&tdDInvoiceBalanceCreditTC}.