Billing Required Report

From UG

Contents 1 Info 2 Summary 3 Business requirements 4 Filters 5 Output 5.1 Level One 5.2 Level Two 5.3 Note 6 Example of output 6.1 Level One Output 6.2 Level Two Output

Info

Mantis 0003192: (OpsRep): Billing Required Report

Summary

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

Report should be added to the report scheduler - action required reports

Report should have email and dashboard option

Include all shipments that the total purchases are equal to OR exceeds the total sales 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

Level Two

Note

Example of output

Level One Output

Level Two Output