VISUAL ERP CUSTOM WORK

Spring Time Software has been doing custom work related to Visual ERP software since 2005 and have created multiple projects, crystal reports and web based applications. 

DASHBOARD

The dashboard of your car contains gauges and instruments that empower you to make informed decisions to successfully and safely reach your destination: turning data into information and Information into decisions.

Our web based DashBoard system puts your organization in the driver's seat by providing a similar console for various departments of the organization. 

Using Visual ERP Datbase and custom tables, DashBoard provides real time Explorer based Charts and Reportings on : 

  • Orders 
  • Sales
  • Budgets & Forecasts 
  • Back Logs
  • Inventory & Costing 
  • Gross Margins 

Given Below are list of reports / charts readily available for implementation, get in touch with us for pricing :

Charts readily Available:
  • By Month Sales Chart (Comparative with Budget / Forecast / Last Year) (selective Customer / Part)
  • Weekly Sales Chart (Comparative with Budget / Forecast / Last Year)  (selective Customer / Part)
  • Weekly/ Monthly Gross Margin Chart (% / $) (Comparative with Last Year / Budget / Forecast) (selective Customer / Part)
  • Weekly /Monthly Order Booked Chart (Comparative with Budget / Forecast / Last Year) (selective Customer / Part)
  • Top 4 Customers Sales Charts (Comparative with Budget / Forecast / Last Year)
  • Capacity Chart (Order Booked by Desired Shipped Date) – by Part Category / by Top n Customers (with Drill down – Quarterly – Monthly – Daily)
  • Forecast / Sales by Product Category (with Drill Down to Sub Category)
  • Shipped Completed and Shipped on Time Chart – By Month with Drill down to Week & Days
  • Dollar Lost Chart (Orders Closed) – By Month with Drill Down to Day
  • Sales per Employee Chart (By Month)
  • Standard Cost Deviation of Products (By Month)
  • Direct Labour Cost to Dollar Shipped (By Month) – (Selective Category / All)
  • Customizable Home page for Different users 
Ready Explorer based Reports:
  • Gross Margin Drill Down Report by Customer (Comparison with Budget / last Year) (Drill Down by Part à Further Drill Down to Transaction)
  • Gross Margin Drill Down Report by Part (Comparison with Budget / last Year) (Drill Down by Customer à Further Drill Down to Transaction)
  • Gross Margin Report by Part (Ordered by Ranking)
  • Gross Margin Drill Down Report by Part Category (Comparison with Budget / Last Year) (Drill down by Sub Category à Further Drill down to Customer à Further Drill down to Part)
  • Past Due Orders
  • Low / Out of Stock
  • Part Cost Report
  • Purchase Price Variation Report
  • Ansoff Matrix – Orders Booked (drill down by Customer / by Part – up to order level)
  • Gross Margin Report by Order
  • Gross Margin Overview (by Part)
  • Fill Rate Details Drill Down Report (Order Qty. vs. Shipped Qty) –Drill Down to Order Detail or Shipped Detail
  • Customer Order Search à By Customer / Order ID / PO Ref / Part ID / Store ID à For a Date Range (with Drill Down to Part Details)
  • Production Efficiency Report (by Part Category with Drill Down to Part à Further Drill Down to Transactions)
  • Profitability Report by Customer (Drill Down to Part à Further drill down to Order)
  • Production BackLog
  • Production hours report (by Line)
  • User Rights – Option to limit access for various users
  • Backlog Ageing
  • Backlog by Part 
  • RPA# or RPA Confirmation # not Entered for Orders  
  • Report Key Performance Metrics like Day / MTD / YTD Sales / Orders vs. Forecast, Top Inventory Values, Backlog, Shipped on Time %, Shipped Complete % etc.
  • Sales comparative Drill Down report by Customer (comparison with last year sales) (Includes Drill Down – by Part / by State, Further Drill Down by Market / by Store, Final Drill Down by Part
  • Sales comparative Drill Down report by Part Id (comparison with last year sales) (includes Drill Down – by Customer, Further Drill Down – to Transaction details)
  • Sales comparative report by sales rep Id (comparison with last year sales)
  • Sales comparative report by Territory  (comparison with last year sales)
  • All sales comparative reports by Sales rep.
  • Sales Rep. Commission Accrued Report
  • Sales Rep. Commission Paid Report
  • By Customer Gross Margin comparing with Budget/Last Yr. with Variance– drill down to order Level
  • By Part Gross Margin comparing with Budget / Last Yr. with Variance – drill down to order Level
  • Order Search
  • File Sharing – Upload / Download File facility for selected users
  • Site Statistics à Who is using which report

 

Forecast $ Budget Reports / Entry Options:
  • Forecast view / edit (Option to Add / Update Batch ) –Entry for Part / Customer / Week 
  • Forecast Detail Report
  • Monthly Forecast Report (with upto date actual & comparison)
  • Budget View / Edit
  • Budget Detail Report
  • Budget Upload to Visual / Download to Excel 

  

Special Utilities:
  • Auto Invoice E-Mailing utility : sends email with PDF attachment of Invoices created during the day or sends Email of Invoices based on Order / Customer /DateRange.
  • Blackberry based : searching of Current Stock, 16 Weeks Forecast for a particular part
  • Blackberry based : searching of Forecast, Purchase Order, Sales Order with QOH
  • PO Tracker Utility à Two Levels – Vendor / Sub Vendor can enter information in various fields
  • Daily Business summary (Email)
  • Past Due Order Email