Billing Required Report
From UG
(Difference between revisions)
(→Business requirements - Phase 1) |
|||
| Line 12: | Line 12: | ||
Report should have email and dashboard option | Report should have email and dashboard option | ||
| + | <font color="red"> | ||
Include all shipments that have a P/L of 0 or less | Include all shipments that have a P/L of 0 or less | ||
| Line 19: | Line 20: | ||
*CT's with no sales invoices, but with purchases invoices. | *CT's with no sales invoices, but with purchases invoices. | ||
**Basically the only shipments that should '''NOT''' included on the report are shipments that the sales invoices are greater then the purchase invoices. | **Basically the only shipments that should '''NOT''' included on the report are shipments that the sales invoices are greater then the purchase invoices. | ||
| + | </font> | ||
Exclude any shipments that do not have an actual arrival date confirmed | Exclude any shipments that do not have an actual arrival date confirmed | ||
| Line 32: | Line 34: | ||
*Report Name | *Report Name | ||
<font color="red"> | <font color="red"> | ||
| - | |||
*Counter = the total amount of loss in USD. | *Counter = the total amount of loss in USD. | ||
**The number should be a hyperlink to the next level. | **The number should be a hyperlink to the next level. | ||
| Line 46: | Line 47: | ||
The dashboard should show: | The dashboard should show: | ||
Billing Required Report: -145.00 | Billing Required Report: -145.00 | ||
| - | |||
| - | |||
| - | |||
| - | |||
====Level Two==== | ====Level Two==== | ||
Revision as of 15:19, 21 October 2011
Contents |
Info
Mantis 0003192: (OpsRep): Billing Required Report
Operators are responsible to check the gross margin of each shipment. To assist with this, it is requested a dashboard report (or email option) be created that can alert operators of any shipments showing no profit or a negative profit.
Business requirements - Phase 1
Report should be added to the report scheduler - action required reports
Report should have email and dashboard option
Include all shipments that have a P/L of 0 or less
- This should be:
- CT's with no sales invoices and no purchase invoices.
- CT's that the total sales invoices are lower then the total purchases invoices.
- CT's with no sales invoices, but with purchases invoices.
- Basically the only shipments that should NOT included on the report are shipments that the sales invoices are greater then the purchase invoices.
Exclude any shipments that do not have an actual arrival date confirmed
Filters
Filters are to be defined in next phase
Output
Level One
Dashboard to display
- Report Name
- Counter = the total amount of loss in USD.
- The number should be a hyperlink to the next level.
For example If the report lists: CT# 123456 P/L -123.00 CT# 234567 P/L 0.00 CT# 345678 P/L 0.00 CT# 456789 P/L -22.00 CT# 567891 P/L 0.00 Total loss: -145.00 The dashboard should show: Billing Required Report: -145.00
Level Two
To be defined in next phase
Level Three
In first phase, clicking the hyperlink should open html report.
- This report should be downloadable to excel
Report Output Columns
- CT number
- as a hyperlink to the CT record
- CT created on date
- E0. Client Company
- Origin Country
- Destination Country
- Mode Of Transport
- Actual Arrival date
- Total Profit/Loss amount
Example of output
Level One Output
Level Two Output
To be defined in next phase
Level Three Output
HTML Version
To be added
Excel Version
