BI Enquiry

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

 

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.