Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 29 Next »


BI Enquiries offers a range of standardised reports.
  • Click on Enquiries (top left of the window) and navigate through the menus to the report that fits your needs.

  • Each menu option is numbered - the final report can be identified by the number on each menu item passed through to reach the required report.
    • for example in the screen shot below the user has navigated through 5 General Sales and TOP and can choose from Customers or Products
    • These report names are preceded by 5 1 1 and 5 1 2 - these numbers can be used to uniquely identify the reports when discussing with your colleagues or the Vision Team.


The following links describe using the BI Enquiries in general and each report in more detail:



Customer - Customer List (1 0 0)

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)

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 - Stock Record Card (3 0 0)

Stock - Frozen Stock (3 0 1)

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 - Stock Status (3 0 3)

Stock - Customer Unpaid Reserves (3 0 4)

Stock - Total Stock Available (3 0 5)

Stock - Stock List (3 9)

Stock - Rotation Stock (3 1 1)

Purchases - Outstanding - PO Lines (4 0 0)

Purchases - Outstanding - POs By Supplier (4 0 1)

Purchases - Outstanding - POs by Product (4 0 2)

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 - 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 - Accruals - En Primeur Cost of Sales (6 0 2)

Sales - Accruals - GRN Accruals (6 0 3)

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 - 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 - 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 - Top - Customer (5 1 1)

Sales - Top - Products (5 1 2)

Sales - General Sales Report (5 0 3)

Sales - Credit Card Orders (6 0 0)

Sales - Day Book (5 0 4)

Sales - Reconcile Sales with NL (6 0 1)


  • No labels