SAPlytics

For Distributors and Manufacturers Running SAP Business One

Free Review

Smarter Insights for SAP B1

Running SAP Business One, but Still:

  • Rebuilding Sales and Month-End Reports by Hand in Excel?
  • Getting Report Totals That Don't Match SAP?
  • Guessing What to Reorder While Cash Sits in Slow Stock?
  • Unsure of Real Margins After Cost, Freight and Tariff Changes?
  • Paying Import Duty You Could Be Claiming Back?

English & French · Remote, or On Site Within 300 km of Montréal

Executive Sales Overview dashboard in Power BI Customer Segmentation dashboard in Power BI

Results From Real Projects

Delivered In-House on SAP Business One.

  • 260Report Defects FoundIn a 93-query SAP reporting library, with every fix tracked in a remediation workbook. Read the case study.
  • ½ DayCut to MinutesSupplier price files merged into one master price list with AI-assisted tooling.
  • 2Countries, One PlanA demand-driven min/max model plans U.S. and Canadian replenishment.
  • 5+Years Professional ExperienceIncluding 3+ years on SAP Business One: reporting, master data and import compliance.

What I Do

Five Connected Practices, All Built on the Same SAP Business One Data.

PracticeToolsWhat It Solves
SAP B1 & SQLT-SQL, Query Manager, Crystal ReportsReports That Finally Match SAP
Power BIDAX, Power Query, Data ModellingOne Live View for Owners and Managers
Excel Report AutomationPower Query, Power AutomateNo More Rebuilding Reports by Hand
Trade & CustomsHTS, Landed Cost, CBSA K32Tariffs Priced In, Duty Claimed Back
AI & AutomationClaude Code, PythonHours of Manual Work Removed

Four Ways to Start

Built by a Working SAP Business One Analyst, Not a Generalist Agency.

01

Data Health Check

Full Scan of Your SAP Data and Saved Reports

  • Saved-Report Review
  • Price Lists
  • Item Master Data
  • Business Partner Master Data

Done: Findings Reviewed With You

Core Offer
02

Reporting Stack

Auto-Refresh Reports: Excel or Power BI

  • Sales by Rep, Customer and Item
  • Open SOs and BOs With PO ETA
  • AR/AP Aging Reports
  • Inventory Status Report
  • AI-Assisted Reporting

Done: Reconciled to SAP, Signed Off

03

Business Analytics

See Where Your Business Stands

  • Dynamic Min/Max, ROP
  • Dead and Slow Stock Analysis
  • Sales/Demand Analysis
  • Forecast PO Qty
  • GM by Customer and Item

Done: Signed Off After a Test Cycle

04

Trade & Customs

HTS Code and Tariffs

  • HTS Classification per Item
  • Tariff Rate and Duty Stack
  • Landed-Cost Calculation
  • CBSA Drawback Claims

Done: Reviewed With Your Broker

Every project is quoted in writing after the free review, before any work starts.

Quality Built In

  • Read-Only: I Never Write to Your SAP
  • Reconciled to SAP's Sales and Purchasing Analysis
  • Every Query Passes a QA Checklist Before Delivery
  • Least-Privilege Login: Access You Control and Can Revoke
  • Migrated? Old and New Databases in One View
  • Runs in SAP Query Manager, With Drill-Down to Documents
  • Documented and Handed Over: You Own Every Query
  • Performance-Tested Before It Runs on Live SAP

How It Works

From First Call to a Report Your Team Trusts.

  1. Free 30-Min Review

    On your own SAP screens, you show me the report that's off. I explain why, and what fixing it takes. No obligation.

  2. Read-Only Access

    You create a login for me with only the access the work needs.

  3. Build and Reconcile

    Totals are reconciled to SAP's own reports, within a tolerance agreed with you, before sign-off.

  4. Handover and Support

    You get the reports, the documentation and rollout support in English or French.

Case Studies

Projects Delivered on SAP Business One. Client Figures Kept Confidential.

Inventory Min/Max Model

SQL Server · Power BI · Demand Planning

Replenishment planned from real demand, warehouse by warehouse.

The Problem. Reorder points were typed in once and never updated, so stock ran out in one warehouse while it sat idle in another.

What I Built. Min/max per warehouse from 12-month demand, real lead times and the purchasing cycle, in SQL Server and Power BI over both the live and legacy SAP databases.

Multi-Level Pricing Model

Pricing · Landed Cost · Excel · AI-Assisted Tooling

Every customer price level calculated from one landed cost.

The Problem. Prices for warehouse distributors, OES and OEM customers were kept by hand, and supplier price files arrived in different formats.

What I Built. A single landed-cost base price that drives every level's price and margin automatically, plus a tool that merges multi-format supplier files into one master price list.

Price ladder: landed cost from FOB, freight and duty, and the price for OEM, warehouse distributor and OES customers at 30% and 55% tariff

HTS and Tariff Exposure

HTS / HS · Sections 232, 301, 338 · Landed Cost

HTS code, country of origin and landed cost kept complete on every active item.

The Problem. U.S. tariffs changed almost monthly in 2026. Quotes left out Chapter 99 duties, and goods shipped from Canada risked being declared Canadian origin by default.

What I Built. A classification audit in SAP, a duty stack per item, an origin check for re-exported goods, a Section 232 flag for steel and aluminum content, and a landed-cost check on every purchase order line.

Sales Analytics in Power BI

SQL · Power BI · DAX · Power Query

Leadership sees sales, inventory and margin directly, in numbers that match SAP.

The Problem. Sales reports overstated revenue: cancelled invoices and their reversals were both counted, credit memos were ignored and freight repeated on every line.

What I Built. A line-level SAP B1 → Power BI model: invoices minus credit memos, freight at document level, same-pace year-to-date versus last year, and a customer bridge so one customer can sit in several segments.

Product and rep performance in Power BI: net sales by item group and by sales rep, 2026 year to date

More case studies on the blog: SAP Reporting Library Audit · CBSA Duty Drawback Automation

Rishad Ahmed
Role
BI & SAP Data Analyst
Languages
English & French
Based in
Montréal, Québec, Canada
Service Area
Remote, or On Site Within 300 km, Including Ottawa
Databases
SAP B1 on SQL Server or HANA

About Rishad Ahmed

SAPlytics is how I package what I do: turning a live SAP Business One database into reporting people actually make decisions with.

For more than three years I have owned SAP reporting, master data and import compliance data for distribution and manufacturing companies, as the person the CEO, finance, purchasing, sales and operations teams all come to for numbers. I document how things work today, find the gaps, and replace manual work with SQL, Power BI, Excel and Power Automate, then support people until the new way sticks.

Experience

  • Trux AccessoriesBI & SAP Data Analyst, Jul 2025 – Present
  • Café Mystique Coffee Inc.SAP Business Analyst, Sep 2023 – Jun 2025
  • First Capital University of BangladeshLecturer, EEE, Feb 2016 – Aug 2017

Education

  • AEC, Business Intelligence AnalystCollege Canada, Montréal · 2023
  • M.Eng., Computer Science & TechnologyUniversity of Jinan, China · 2020
  • B.Sc., Applied Physics & Electronic Eng.University of Rajshahi, Bangladesh · 2013

Questions Owners Ask

What You Get, How, When, and How Your Data Stays Safe.

What Do I Get at the End?

Working reports your team uses every day: SAP queries, Excel workbooks that refresh themselves, Power BI dashboards, or all three. Each one comes with documentation and a reconciliation that shows its totals match SAP. You own all of it.

How Much Does It Cost?

Every project is different, so it is quoted after a short assessment. After the free review, you get a written scope and a quote covering what you will receive and when, before any work starts. No obligation.

How Long Does It Take?

It depends on the scope: a Data Health Check is quicker than a full reporting stack. After the free review you get a short written scope with what you'll receive and an estimated timeline, before any work starts.

How Does the Work Happen?

Free review, then a read-only login, then build and reconcile, then handover with rollout support. I work remotely anywhere, or on site in Montréal and within about 300 km, including Ottawa, in English or French.

Is My SAP Data Safe?

Yes. You create the login, with only the access the work needs, and you can switch it off at any time. I only read from SAP; nothing is ever written back, and every query is checked for performance before it runs on your live database.

Do You Work With SAP B1 on HANA?

Yes. SAP Business One on SQL Server or HANA, as long as I can connect to a valid company database.

Migrated to a New Database. Can We Still Report on History?

Yes. Your old and new SAP databases, or several company databases, are combined in the same report, so history and current data sit side by side. Open orders and backorders are rebuilt across the changeover, so nothing is lost or counted twice.

Who Maintains the Reports Afterwards?

Your team can. Every query and model is documented and handed over, and I stay available for changes and support when you need them.

For Your IT Team

SQL Your Team Can Review, Validate, and Maintain.

  • Environment CompatibilityQueries tailored to your SAP Business One version and DB platform.
  • Controlled AccessUses approved reporting permissions and read-only queries.
  • Performance-Conscious DesignScoped date ranges, deliberate joins, and appropriate aggregation.
  • Traceable Business LogicDocumented tables, filters, and calculated results.
  • Maintainable DeliveryClear naming, comments, and configurable filters.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET NOCOUNT ON;

SELECT YEAR(H.DocDate)  AS [Year],
       SUM(L.Quantity)  AS [Sales Qty],
       SUM(L.LineTotal) AS [Sales $]
FROM OINV H
JOIN INV1 L ON L.DocEntry = H.DocEntry
WHERE H.CANCELED = 'N'
  AND H.DocDate >= '2025-01-01'
  AND H.DocDate <  DATEADD(DAY, 1,
                   CAST(GETDATE() AS date))
GROUP BY YEAR(H.DocDate);
Sales Qty and $ by Year: 2025 and 2026 to Date, Cancelled Excluded

Name an SAP B1 Table

Type a table code to see what it holds and how I use it.

Try
OINVA/R invoices, header

One row per customer invoice: customer, dates, totals, currency and status.

How I use it: the base of every sales figure, joined to INV1 for lines and netted against ORIN credit memos. Cancelled documents are filtered out, a common reason SAP sales reports overstate revenue.

Numbers Off? Let's Fix Them

Show me which report doesn't match and what it should say; I'll show you why, on your own SAP screens.

Free, No Obligation · Or Connect on LinkedIn