This is an old revision of the document!

Table of Contents

Security Fund

Navigation: Reports → Other Reports → Security Fund

Note

Report was called as needed, but recent data which is counted is dated 2010 year.

Selection Criteria

Invoice.InvoiceDate BETWEEN @DateFrom AND @DateTo

тотал селл прайс: SUM(InvoiceLine.Units * UnitSellPrice) AS TotalSellPrice

условия выборки:
Customer.HasSecurityFund = 1(на кастомере на табе Finance есть такое) 

	AND Product.Code = 'SI'
* .

Output

  • .

Report Preview

Trace: • Security Fund