BI Enquiries
...
offer a range of standardised
...
...
PLEASE NOTE - THIS LIST IS UNDER CONSTRUCTION AND AS SUCH, THE LINKS MAY NOT ALL BE CORRECT.
THIS WILL BE COMPLETED AS SOON AS POSSIBLE.
- Customer - Invoice - First Invoice (1 0 1)
- Customer - Invoice - Last (1 0 2)
- Customer - Mailing List - Mailing List (1 0 3)
- Customer - Mailing List - Mailing List Detailed (1 0 4)
- Customer - Customer List (1 0 0)
- Product - Costing/Pricing - Product Prices (2 0 1)
- Product - Costing/Pricing - Customer Special Prices (2 0 2)
- Product - Costing/Pricing - Standard Cost Comparison (2 0 3)
- Product - Details (2 0 0)
- Stock - Movements - Audit Trail (3 0 7)
- Stock - Movements - Stock Turn Last X Days (3 0 8)
- Stock - Movements - Stock Turn Last X days By Product (3 1 5)
- Stock - Product Stock (no rotations) - Frozen Stock (3 0 1)
- Stock - Product Stock (no rotations) - Stock Status With Whse (3 0 3)
- Stock - Product Stock (no rotations) - Customer Unpaid Reserves (3 0 4)
- Stock - Product Stock (no rotations) - Total Stock Available (3 0 5)
- Stock - Product Stock (no rotations) - Warehouse Product Stock (3 0 6)
- Stock - Product Stock (no rotations) - Mixed Case Availability with Whse (3 1 3)
- Stock - Product Stock (no rotations) - Order Available Stock by Whse (3 1 4)
- Stock - Rotation Stock - Stock Record Card (3 0 0)
- Stock - Rotation Stock - Rotation Stock with Whse (3 1 1)
- Stock - Rotation Stock - Paid Reserve Rotation Stock with Whse (3 1 2)
- Stock - Valuation - Valuation by Product (3 0 9)
- Stock - Valuation - Valuation by Rotation (3 1 0)
- Stock - Stock Summary By Region (3 0 2)
- Stock - Total In Stock By Product (3 1 6)
- Purchases - Outstanding - PO Lines (4 0 0)
- Purchases - Outstanding - POs By Supplier (4 0 1)
- Purchases - Outstanding - POs by Product (4 0 2)
- Sales - En Primeur - Stock Allocation - By Customer (5 1 3)
- Sales - En Primeur - Stock Allocation - By Product (5 1 4)
- Sales - En Primeur - En Primeur Stock Not Landed (5 0 9)
- Sales - En Primeur - En Primeur Duty VAT Invoices (5 1 0)
- Sales - Outstanding - SO Lines (5 0 0)
- Sales - Outstanding - SO Lines By Customer (5 0 1)
- Sales - Outstanding - SO Lines By Product (5 0 2)
- Sales - Top - Customer (5 1 1)
- Sales - Top - Products (5 1 2)
- Sales - General Sales Report (5 0 3)
- Sales - Day Book (5 0 4)
- Sales - Salesman Report (5 0 5)
- Sales - Sales By Product (5 0 6)
- Sales - Sales By Customer Source (5 0 7)
- Sales - Accruals - En Primeur Cost of Sales (6 0 2)
- Sales - Accruals - GRN Accruals (6 0 3)
- Sales - Margins/Targets - Summary - Margin Summary (6 1 2)
- Sales - Margins/Targets - Summary - By Product (6 1 3)
- Sales - Margins/Targets - Summary - By EP Campaign (6 1 4)
- Sales - Margins/Targets - Summary - By Exclusion (6 1 5)
- Sales - Margins/Targets - Summary - Sales Rep Yearly Comparison (6 1 6)
- Sales - Margins/Targets - Summary - Margin Summary by Account (6 1 9)
- Sales - Margins/Targets - Summary - Margin Summary By Salesman (6 2 0)
- Sales - Margins/Targets - Summary - Sales Profit By Product_Grp Sales Price (6 2 1)
- Sales - Margins/Targets - Targets - Sales Rep Detailed (6 0 8)
- Sales - Margins/Targets -Targets - Division Summary (6 0 9)
- Sales - Margins/Targets - Targets - Customer Type Summary (6 1 0)
- Sales - Margins/Targets - Targets - Outlet Summary (6 1 1)
- Sales - Margins/Targets - Top 10 - Outlet 1 - Detailed (6 1 7)
- Sales - Margins/Targets - Top 10 - Outlet 1 - Summary (6 1 8)
- Sales - Margins/Targets - Detail Margin (6 0 4)
- Sales - Margins/Targets - Detail Margin By Product Type (6 0 5)
- Sales - Margins/Targets - Sales Margin (6 0 6)
- Sales - Margins/Targets - Sales Margin Exclusions (6 0 7)
- Sales - Credit Card Orders (6 0 0)
- Sales - Reconcile Sales with NL (6 0 1)
...
data outputs which can be filtered and used on screen or output to one of the available formats which can then be used in excel for further grouping or analysis or loading into a third party reporting tool.
The output provided in these enquiries is very granular although some summarised outputs do exist. The granular data can then be used in the report writer to create BI Reports which are the PDF style output.
When BI Enquiries opens you will see a form similar to the one on the right side
Click on the Enquiries and a menu of subject headings will open, you then select the area you wish to see the enquiry from and then you drill down through the different menu levels to the enquiry you wish to output.
Reports are all numbers so a 5xx report will be in the 5 menu.
Within the top menu level the reports are not sorted numerically as new outputs are added to their appropriate sub menus
| Tip |
|---|
If you have an issue with any of the outputs then we will ask for the enquiry number e.g. 125 or 411 |
VC Reporting Dates
Within the enquiries and reports many of them use a Start Date and End Date this is signified by the terms [[S]] and [[E]] being after the name.
It will then run the output based on the dates you set within the VC program.
For more information see :
| Info |
|---|
We have a request to move the reporting dates to be specific for the user, currently it is only set at the global system level for your entire organisation. |
Enquiry List
If you want to know anything more about the enquiries then find the enquiry you are looking for below, each enquiry has a number which corresponds to the number on the BI Enquiry Menu.
If you have an issue with any enquiry let us know the number in your ticket.
| Child pages (Children Display) | ||
|---|---|---|
|