Differences
This shows you the differences between two versions of the page.
|
userdocs:travelwise:reporting:other:security_fund [2014/02/03 19:54] dokuwiki_sync created |
userdocs:travelwise:reporting:other:security_fund [2014/02/11 12:15] (current) tt |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| **Navigation:** //Reports -> Other Reports -> 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 ===== | ===== Selection Criteria ===== | ||
| - | Invoice.InvoiceDate BETWEEN @DateFrom AND @DateTo | + | Invoice Date within the selected period. |
| - | + | ||
| - | тотал селл прайс: SUM(InvoiceLine.Units * UnitSellPrice) AS TotalSellPrice | + | |
| - | условия выборки: | + | Following invoices are taken: |
| - | Customer.HasSecurityFund = 1(на кастомере на табе Finance есть такое) | + | * related with Customer -> Finance: //'Has security find'// is enabled and |
| - | AND Product.Code = 'SI' | + | * invoiced product code is 'SI' (Sikkerhedsfond). |
| - | * . | + | |
| {{:userdocs:travelwise:reporting:other:security_fund.png?nolink|}} | {{:userdocs:travelwise:reporting:other:security_fund.png?nolink|}} | ||
| ===== Output ===== | ===== Output ===== | ||
| - | * . | + | * Selection criteria (from/to); |
| + | * Customer; | ||
| + | * Invoice number; | ||
| + | * Destination; | ||
| + | * Total Sell and Total Exp for a customer. | ||
| ===== Report Preview ===== | ===== Report Preview ===== | ||
| {{:userdocs:travelwise:reporting:other:security_fund_r.png?nolink|}} | {{:userdocs:travelwise:reporting:other:security_fund_r.png?nolink|}} | ||
