In the ‘Biz Intelligence’ section click the icon for BI Enquiry, which opens a new application ‘Vision Business Intelligence’. There is a menu within ‘Enquiries’ which has sections for the different reporting areas.
The following table has listed all the BI Enquiry Reports available in the Vision Business Intelligence window of Vision Distribution:
Main Option | Sub Option | Column Names |
|---|---|---|
1 Delivery Information | 100 ePOD | DeliveryUID Load Depot LStatus T_Item Customer DocRef ET1 LT1 ET2 LT2 Name Add1 Postcode O_ETA R_ETA |
101 Site Manifest Deliveries | DeliveryID Customer SiteCode Default_Location Load Date Doc Ref Pick UID Ordered on Transport TransportItem FirstName Manifest Phy Cs Inv Cs Date Picked | |
102 Delivery ETA issues | Manifest No Kind Customer Site DeliveryNo Status Consignee Doc Ref Phy Case Inv Case Weight Cost Drop Point Depot Departure Window 1 Window 2 Original ETA Revised ETA Arrived Actual Delivery Manifest Issues | |
103 Depot Planned Deliveries | Filter option - Delivery Depot | |
104 Unplanned Deliveries | DeliveryDepotCode ManifestPlanDate SiteCode Cust ManifestNo ManifestDriver PickUID DatePicked DatePickConfirmed BookedDate DocRef Lines PCase Dname DPC | |
2 Revenue Information | 200 Revenue Report Last Month | PKLoad DeliveryDepotCode FKLoadStatus Carrier Driver_Code Driver_Name Expr1 Exp2 CompletedBy Manifest_Cost Manifest_CostOption Manifest_FVC Manifest_POI Manifest_DepotTransferCosts Revenue |
201 Delivered Not in Invoicing | Act_Del_Date Manifest_UID PlannedLoadDate Pick_UID StockCust StockSite InvCust InvSite DocRef DelName DelPostcode PCases ICases AreaBand DelArea Pickup IgnoreMin AdditionalCharge TotalCharge | |
3 Maintenance Information | 300 Carrier driver check | Transport Address1 Address2 Address3 Address4 Postcode Country Insurance Expires Date Approved Product Type Restrictions Product Group Restrictions Archived |
| Tip |
|---|
You can export these reports as CSV, EXCEL, and PDF using the separate buttons. For PDF export, you can select the size of PDF format from A0 to A5. Also, a Refresh button is available to refresh the list. |