Gross margin report
From UG
(→Filters) |
(→Filters) |
||
(14 intermediate revisions not shown) | |||
Line 15: | Line 15: | ||
=== Filters === | === Filters === | ||
- | Date: Month and Year or Date Range | + | Date: Month and Year or Date Range > From/To Calendar |
+ | *Date used should be the revenue recognition date:( http://ct.jaguarfreight.com/wiki/Revenue_Recognition_Date ) | ||
- | + | Mode Of Transport > Dropdown with multi-select option > no selection should default to all | |
- | + | E0. Client Company > Dropdown with multi-select option > no selection should default to all | |
=== Output === | === Output === | ||
- | The report should | + | The report should first display as an HTML version. |
+ | |||
+ | Then downloadable to excel. | ||
+ | *Once downloaded group shipments and CT records should be on separate tabs as listed below. | ||
+ | |||
====CT records tab==== | ====CT records tab==== | ||
CT# (as a hyperlink) | CT# (as a hyperlink) | ||
+ | |||
+ | Mode Of Transport | ||
Total Sales | Total Sales | ||
Line 35: | Line 42: | ||
E0. Client Company Name | E0. Client Company Name | ||
- | Sailing | + | Sailing Date |
Total Profit/loss amount for each office individual office | Total Profit/loss amount for each office individual office | ||
+ | *each office should list in its own column | ||
====Group Shipments tab==== | ====Group Shipments tab==== | ||
Line 43: | Line 51: | ||
CT # listed in one cell on the same row separated by comma's. | CT # listed in one cell on the same row separated by comma's. | ||
+ | |||
+ | Mode Of Transport | ||
Total Sales | Total Sales | ||
Line 54: | Line 64: | ||
Total Profit/loss amount for each office | Total Profit/loss amount for each office | ||
+ | *each office should list in its own column | ||
+ | |||
+ | ====Note==== | ||
Please make sure that for group shipments the total's include the total for the group, even if the charge (sales, purchase, or P/L)is applied to only one, multiple, or all. Also, please make sure the total is not added in multiple times. | Please make sure that for group shipments the total's include the total for the group, even if the charge (sales, purchase, or P/L)is applied to only one, multiple, or all. Also, please make sure the total is not added in multiple times. | ||
Line 63: | Line 76: | ||
The system will have to add the total P/L, for each individual office, of each CT record that is part of the group. The total for each office will be the total listed under the office P/L amount. | The system will have to add the total P/L, for each individual office, of each CT record that is part of the group. The total for each office will be the total listed under the office P/L amount. | ||
- | + | For Example: | |
- | + | Group 123 has CT# 123456, 789101, 789102. | |
- | + | Invoice # 1 is issued from 123456 only for $20.00 | |
+ | Invoice # 2 is issued from 123456 and 789101 $20.00 | ||
+ | Invoice # 3 is issued from all CT's (the whole group) for $20.00 | ||
+ | The total sales for the group should show as 60.00 | ||
- | === | + | ===Example of output === |
+ | ====CT Records Tab==== | ||
+ | [[File:The gross margin report example of output ct records.JPG]] | ||
- | ==== | + | ====Group Shipments tab==== |
+ | [[File:The gross margin report example output group shipment tab.JPG]] |
Current revision as of 13:44, 19 October 2011
Contents |
[edit] Info
Mantis 0003158: [Acc Misc] Create a way for accounting to run the Gross Margin Split report on their own for specified time frames
We have previously ran this report a fews time already as an "Urgent one time reports" under mantis 2925, 3148, and, 3161.
Accounting is just looking for the ability to run this report on their own.
[edit] Business requirements
Accounting needs to split the total gross margin between any offices involved in a particular shipment. In order for them to do that, they need this report that will show the total gross margin, broken down by office, for each shipment.
[edit] Filters
Date: Month and Year or Date Range > From/To Calendar
- Date used should be the revenue recognition date:( http://ct.jaguarfreight.com/wiki/Revenue_Recognition_Date )
Mode Of Transport > Dropdown with multi-select option > no selection should default to all
E0. Client Company > Dropdown with multi-select option > no selection should default to all
[edit] Output
The report should first display as an HTML version.
Then downloadable to excel.
- Once downloaded group shipments and CT records should be on separate tabs as listed below.
[edit] CT records tab
CT# (as a hyperlink)
Mode Of Transport
Total Sales
Total Purchases
E0. Client Company Name
Sailing Date
Total Profit/loss amount for each office individual office
- each office should list in its own column
[edit] Group Shipments tab
Group #
CT # listed in one cell on the same row separated by comma's.
Mode Of Transport
Total Sales
Total Purchases
E0. Client Company Name (if multiple E0. client Companies, list each name in one cell separated by comma's.
Sailing Date
Total Profit/loss amount for each office
- each office should list in its own column
[edit] Note
Please make sure that for group shipments the total's include the total for the group, even if the charge (sales, purchase, or P/L)is applied to only one, multiple, or all. Also, please make sure the total is not added in multiple times.
The system will have to add the total sales of each CT record that is part of the group. This total will be the total listed in the Total Sales Column.
The system will have to add the total purchases of each CT record that is part of the group. This total will be the total purchases listed in the total column.
The system will have to add the total P/L, for each individual office, of each CT record that is part of the group. The total for each office will be the total listed under the office P/L amount.
For Example: Group 123 has CT# 123456, 789101, 789102. Invoice # 1 is issued from 123456 only for $20.00 Invoice # 2 is issued from 123456 and 789101 $20.00 Invoice # 3 is issued from all CT's (the whole group) for $20.00 The total sales for the group should show as 60.00
[edit] Example of output
[edit] CT Records Tab