Project Examples
Previously Implemented Solution Examples
ANALYTICS FRAMEWORK
Data warehousing and reporting solutions required for valuation and sale of a private $650M company to a publicly traded conglomerate.
- Week-over-week sales, orders, backlog, and margin reporting.
- D365 Business Central and Salesforce integration with end market data tied to revenue.
- Consolidated operating model and financial 3-statement for growth projections and valuation with Goldman Sachs.
STOCKROOM AND PRODUCTION ORDER BARCODES
Barcodes and UPC labels with integrated handheld scanners for identifying bins/items or executing inventory transactions.
- Add barcodes to RDLC reports and labels for registering warehouse activities.
- Add barcodes for clocking onto production orders and advancing through operations.
- Custom UPC labels for items/bins.
ORDER STATUS UPDATE EMAILS
Send email notifications to internal salespeople or customers upon systematic triggers/conditions.
- Emails to internal users and/or customers.
- Upon order confirmation, order packed, order shipped, back ordered, etc.
- Add timestamps to system for tracking on-time percentage and lead times.
ERP TO EMAIL REPORT DISTRIBUTION
Business Central to Power BI to Paginated Reports to Power Automate to Email/SharePoint.
- Automatically distribute or warehouse ERP data without SQL Server or extra Microsoft licensing.
- Perfect solution for organizations with many report consumers but few ERP users.
- Can be set up to run hourly, daily, monthly, or in response to a systematic trigger.
BULK PRINT SHIPPING DOCUMENTS
Custom action button and integration with cloud service for printing collated shipping documents.
- Multi-select warehouse shipments that are due today.
- Print collated warehouse picks, shipping labels, and packing slips.
- Add timestamp to system for tracking completion times and prevent double-picking.
TARIFF SURCHARGE CALCULATOR
Integrated tool for calculating tariff surcharge lines on quotes/orders upon release or on-demand.
- Regain the margin lost by tariffs without overcharging your customers.
- Extends the Item, Sales Header, and Sales Line tables to provide a tariff surcharge.
- Prevents manual calculation and user error by sensing when recalculation needs to occur.
CREDIT LIMIT NOTICES
Customization for identifying customers over their credit limit and applies prepayment percentages to new orders.
- Sums unpaid invoices with outstanding sales orders and compares to customer credit limit.
- Applies a prepayment percentage to new orders and automatically creates prepayment invoices.
- Easily tailored to meet the specific needs of your Finance Team.
FORECASTED INVENTORY REPORT
High visibility Power BI report for calculating projected inventory levels across any planning horizon.
- Considers demand forecast, sales orders, production orders, production consumption, purchase orders, etc.
- Nets sales orders against demand forecast to produce results that agree with MRP output.
- Identifies items at risk of stockout or falling below reorder point.
CASH FLOW REPORTING ENHANCEMENTS
Automatically sent customer statements, payment reminders, and A/P + A/R reports.
- Custom report objects for customer statements and payment reminders (dunning letters).
- Automatically send these reports to customers on a schedule or in response to a BC event.
- Evaluate and control cash flow with improved A/P and A/R reports.
Please schedule a free consultation with us to receive a demonstration or more information about any of these portfolio projects.
Frequently Asked Questions (FAQs)
Development time starts at $175 per hour.
We prefer to put together a project proposal and statement of work that outlines deliverables and expected development time. Simple extensions to existing tables/pages can be made in a few hours while creating custom applications and integrations takes weeks. We like to keep our projects focused and within scope, so typically the costs are between $500 to $10,000.
We also offer guided testing and post-go-live support at an hourly rate (usually cheaper than developer time). However, our objective is to release bug-free code and transfer ownership of the solution to the client so that we can move onto solving the next problem.
CentralFlow is a small team of highly technical, highly experienced professionals. We have three techno-functional consultants with 55+ total years of experience in manufacturing and ERP development.
You also have access to our vast network of Microsoft partners, ISVs, and business connections (whatever it takes to get the job done). We develop in AL code, Power BI DAX, Power Query M, Power Automate Fx, Python, T-SQL, and Excel.
We pride ourselves on being excellent communicators and possess a deep understanding of manufacturing, finance, and sales/marketing. We utilize active listening during initial consultations to assess the needs of the business and succinctly describe how we would address these needs in a proposal document (citing previous experience and required tools). Then we begin development with routine check-ins.
We prefer the flexibility of iterative development with user feedback as opposed to trying to build the entire module upfront only using internal testing (which is typical of larger consulting firms). We understand that requirements evolve, and users may desire a different experience after testing the original concept. Allowing this flexibility leads to higher adoption rates and a lower chance of returning to the same problem. See our full list of services for details.
Yes, we are a Microsoft Cloud Solution Provider indirect reseller with Velosio as our direct reseller partner. If you are unhappy with your current Microsoft partner’s level of support, we can help you evaluate your licensing needs, administer your M365 portal, and provide outstanding customer service. This option goes hand-in-hand with building solutions because we will understand how your business works and how your IT systems are structured.
If you contract with us, we will make ourselves available to you.
For projects, our Statement of Work will specify a timeline with scheduled check-ins that will ensure projects stay on schedule. This document will also have our email and phone contact information for incidental questions and issues. You are welcome to contact us at any time, and we will normally reply within 1 or 2 hours.
For a support or Microsoft licensing contract, we are bound by Microsoft’s Master Services Agreement to respond to any service issues within 24 hours, but we will normally respond within 1 or 2 hours for US time zones. Use the website contact form or send us an email at any time.
Unlike the megalithic consulting firms, we believe that you have the right to understand the code that is published to your production environment.
Because we are creating tailored solutions instead of reselling a proprietary, closed-source application, we feel very comfortable sharing our approaches with your technical employees. We want you to feel empowered at the end of a project cycle so that you can maintain the solution and even create your own in the future.
Transferring ownership usually means sending project files and source code to a repository of your choice. We can close-source the extensions in your production environment for security or to protect the intellectual property, but your technical stakeholders will still have access to the source.
Below is a small sample of the projects we have completed using Business Central development, Power BI reports/dataflows, Paginated Report Builder, Power Automate, SQL, and SharePoint. This is not meant to be an exhaustive list, but it should give you an idea of what kind of problems we could help you solve.