2651 rfd
From UG
(Difference between revisions)
m (→Filter) |
m (→Filter) |
||
| Line 13: | Line 13: | ||
=== Filter === | === Filter === | ||
* Template should contain option to include/exclude Charge Code ('''CC''') filter. | * Template should contain option to include/exclude Charge Code ('''CC''') filter. | ||
| - | * CC filter should allow [http://ct.jaguarfreight.com/wiki/Reports_Filters#Multiselect multiple selections] of Charge Codes. | + | * CC filter should allow [http://ct.jaguarfreight.com/wiki/Reports_Filters#Multiselect multiple selections] of [http://ct.jaguarfreight.com/wiki/Charge_Code_Admin Charge Codes]. |
** If charge code filter is activated and no selection is made (filter is empty), then the report should display a charge code column for every charge code used within each CT record. | ** If charge code filter is activated and no selection is made (filter is empty), then the report should display a charge code column for every charge code used within each CT record. | ||
Revision as of 17:01, 27 January 2011
Contents |
Info
- mantis: 2651 ((Acc Report: Misc) Add feature to filter by charge codes
Requirements and Solutions
- Task type: Change.
- Where: Accounting report Profit/Loss for Multiple CTs.
- What: Adding an option to include a charge code filter within this report.
Filter
- Template should contain option to include/exclude Charge Code (CC) filter.
- CC filter should allow multiple selections of Charge Codes.
- If charge code filter is activated and no selection is made (filter is empty), then the report should display a charge code column for every charge code used within each CT record.
Output
- Each selected CC should be displayed in the own output column.
- Each selected CC should have columns for each kind of Invoice: Purchase, Sales and Internal.
- CC columns should display USD amounts billed using the specified charge code.
- These amounts are only required for viewing and should not interfere with calculating of USD Profit/Loss.
- CC columns need to be placed on the spreadsheet before the invoice amounts.
- CC total should be calculated for each CC column.
- Format of CC column header: CC XXXX, where XXXX - 4 digit charge code number.
