Skip to product information
1 of 1

ERP Connect Consulting

History and Statistics

History and Statistics

Regular price $900.00 / Year
Regular price Sale price $900.00 USD
Sale Sold out
Buy Now
View full details

History and Statistics

The History and Statistics tool is perfect for anyone looking to gain additional insights into their Vendor, Customer, and Item data. Track trends, statistics, and analytics into your Customer, Vendor, and Item data with this application to make more educated decisions around sales and purchasing for your organization. Additionally, this enables you to more easily work with change log records across these various modules.


Item Statistics

  • Quantity on Hand
  • Quantity Available
  • Average Lead Time
  • Days Supply
  • Average Age of Inventory
  • Sales and Purchase Trends
  • Inventory Level Trends
  • Purchase Price Trends
  • Sales Price Trends
  • List of Open Sales/Purchase Quotes
  • List of Open Sales/Purchase Orders
  • List of Open Sales/Purchase Returns
  • List of Open Jobs and Production Orders
  • Inventory by Location
  • Inventory by Bin Location
  • Inventory Aging and Valuation Chart
  • Change Logs



Vendor Statistics

  • Purchases last 12 months
  • Vendor Balance
  • Average Lead time over the last 90 days
  • Return Percentage over the last 90 days
  • On Time Delivery over the last 90 days
  • Vendor Delivery Performance
  • Inventory Levels
  • Purchases by Item Category
  • Monthly Purchases
  • AP Aging
  • Top Item Purchases
  • Vendor Items List
    • Everything you have purchased from this vendor
  • Open Purchase Orders, Quotes, and Returns
  • Change Logs


Customer Statistics

  • Sales over the last 12 months
  • Customer Balance
  • Average Pay Days
  • Average Fulfillment Days
  • On Time Delivery Percentage
  • Customer Sales by Item Category
  • Monthly Customer Sales
  • Customer AR Aging
  • Customer AR Balance History and Trends
  • Top Items Sales for last 90 days
  • Customer Map
  • Customer Items List
    • Everything they have purchased from you in the last 12 months)
  • Open Sales Orders, Quotes, and Returns
  • Open Job Planning Lines
  • Posted Invoices
  • Change Logs


Enhanced Change Logs

  • Customers
  • Vendors
  • Bank Accounts
  • Vendor Bank Accounts
  • Items
  • Sales Quotes
  • Sales Orders
  • Sales Return Orders
  • Purchase Quotes
  • Purchase Orders
  • Purchase Return Orders
  • Jobs
  • Field Monitoring


Sales Document Search

  • Globally Search your Business Central Database across all sales records types including posted and unposted documents
  • Search ability on both Header and Line data elements
  • View filtered records in a tree view with headers and lines with the ability to sort and add additional filters in your data grid
  • Drill down directly to the documents from your search results
  • Create and save views for quick reporting in the future from your favorite presets
  • Your one stop shop for finding any sales document you need





   Download from AppSource      Access Setup and User Guide

The AppSource download includes a 30-day evaluation license automatically installed at no charge. If you would prefer to download a PTE version of this extension, please reach out to support@erpconnectconsulting.com.

History and Statistics - Setup and Overview


 

History and Statistics - Toolbox Tuesday Episode 20


 

Sales Document Search for D365 Business Central



Toolbox Tuesday - Episode 15: Dashboard Bundle

 

 

Dashboard Configuration for D365 Business Central




Customer Statistics

  • Sales over the last 12 months
  • Average Pay Days
  • Average Fulfillment Days
  • On Time Delivery Percentage
  • Customer Sales by Item Category
  • Monthly Customer Sales
  • Customer AR Aging
  • Customer AR Balance History
  • Top Items Sales for last 90 days
  • Customer Map
  • Customer Items List
  • Open Sales Orders, Quotes, and Returns
  • Posted Invoices
  • Change Log





Item Statistics

  • Quantity on Hand
  • Quantity Available
  • Average Lead Time
  • Days Supply
  • Average Age of Inventory
  • Sales and Purchase Trends
  • Inventory Level Trends
  • Purchase Price Trends
  • Sales Price Trends
  • List of Open Sales/Purchase Quotes
  • List of Open Sales/Purchase Orders
  • List of Open Sales/Purchase Returns
  • Value by Item Category
  • Inventory by Bin Location
  • Inventory Aging and Valuation Chart
  • Change Log





Vendor Statistics

  • Purchases last 12 months
  • Average Lead time over the last 90 days
  • Return Percentage over the last 90 days
  • On Time Delivery over the last 90 days
  • Vendor Delivery Performance
  • Inventory Levels
  • Purchases by Item Category
  • Monthly Purchases
  • AP Aging
  • Top Item Purchases
  • Vendor Items List
  • Open Purchase Orders, Quotes, and
  • Returns
  • Change Log