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.

Possible Outputs

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.

Enquiry Fields

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

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

BI Enquiry

Possible Outputs

Enquiry Fields

1 Delivery Information

100 ePOD

101 Site Manifest Deliveries

102 Delivery ETA issues

103 Depot Planned Deliveries

104 Unplanned Deliveries

2 Revenue Information

200 Revenue Report Last Month

201 Delivered Not in Invoicing

3 Maintenance Information

300 Carrier driver check