2651 rfsa

From UG

(Difference between revisions)
Jump to: navigation, search
(Report Filters)
Line 48: Line 48:
Client Company
Client Company
 +
Shipper
Shipper
 +
Consignee
Consignee
 +
Bill to Party
Bill to Party
 +
Vendor
Vendor
 +
Transportation mode
Transportation mode
 +
Receiving office
 +
 +
Issuing office
 +
 +
Charge Codes (this needs to be multi-select)
===Examples===
===Examples===

Revision as of 18:41, 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

Receiving office

Issuing office

Charge Codes (this needs to be multi-select)

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:

Personal tools