2651 rfsa
From UG
(→Business requirements) |
|||
| Line 25: | Line 25: | ||
Adding Charge Code's filter | Adding Charge Code's filter | ||
| + | |||
| + | |||
| + | ===Report Filters=== | ||
| + | Invoice Type | ||
| + | |||
| + | *Purchase Invoices | ||
| + | *Sales Invoices | ||
| + | *Internal Invoices | ||
| + | |||
| + | Date type filter | ||
| + | *Point of revenue recognition date | ||
| + | *Invoice issued date | ||
| + | *CT created date | ||
| + | |||
| + | Date | ||
| + | *Month and year | ||
| + | *date range | ||
| + | |||
| + | Output Type | ||
| + | *summary | ||
| + | *detailed | ||
| + | |||
| + | Client Company | ||
| + | Shipper | ||
| + | Consignee | ||
| + | Bill to Party | ||
| + | Vendor | ||
| + | Transportation mode | ||
| + | |||
===Examples=== | ===Examples=== | ||
Revision as of 18:40, 17 January 2011
Contents |
Info
Mantis 0002651 (Acc Report: Misc) Add feature to filter by charge codes
Accounting MO would like to be able to run a report by charge codes.
Business requirements
The report should be able to run a single charge code or multiple charge codes
It should be able to be run for sales invoices, purchase invoices, and internal invoices.
The report should be downloadable to excel.
The filers and output that should be offered are the similar to Main Menu > Acc > Reports > Profit/Loss for Multiple CTs and Main Menu > Acc > Reports > Search Invoices together.
Changing the following
Profit/Loss for Multiple CTs > Date Type - Instead of sailing date - Point of revenue recognition date.
Profit/Loss for Multiple CTs > Date Type - Instead of issued date - Invoice issued date
Adding Charge Code's filter
Report Filters
Invoice Type
- Purchase Invoices
- Sales Invoices
- Internal Invoices
Date type filter
- Point of revenue recognition date
- Invoice issued date
- CT created date
Date
- Month and year
- date range
Output Type
- summary
- detailed
Client Company Shipper Consignee Bill to Party Vendor Transportation mode
Examples
Accounting wants to run a report to see how many sales invoices were issued using charge codes 1101 - airfreight and 1102 airfreight fuel surcharge, for client company Coty Sanford, for all invoices issued from 12/01/10 to 12/29/10.
They would set filters for
- Sales Invoices
- issuing office - all
- Charge code - 1101 and 1102
- Client Company - Coty Sanford
- Invoice issued date range: 12/01/10 to 12/29/10
Output would be shown:
