SAP Business One Reporting Blog
Practical fixes for SAP B1 reports, Power BI and Excel, written for owners, controllers and the people who run the numbers.
-
Case Study · November 2, 2026
Automating CBSA Duty Drawback Claims From SAP Business One
A case study: replacing a manual spreadsheet drawback process with a SQL pipeline that matches export lines to import entries and applies the CUSMA rule.
Read the Article → -
Case Study · November 2, 2026
Auditing an SAP Business One Reporting Library: 93 Queries, 260 Issues
A case study: reviewing 93 saved SAP Business One queries for correctness and performance, the issues found, and the standard that keeps new reports clean.
Read the Article → -
Power BI & Excel · November 1, 2026
Power BI or Excel for SAP Business One Reporting?
When Excel is the right tool for SAP B1 reporting, when Power BI is, and why most distributors and manufacturers end up using both on the same data.
Read the Article → -
SAP B1 Reporting · November 1, 2026
Why Your SAP Business One Sales Report Doesn't Match
Seven reasons SAP B1 sales reports disagree with Sales Analysis: cancellations, credit memos, freight, discounts, currency, dates and service lines.
Read the Article →