Karan Chhatrala
SAP BusinessOne | Power BI | Data Analyst | Business Analyst
New to Contra
Karan is ready for their next project!
Crystal Reports Suite for SAP B1 HANA | BP Ledger & Financial Reports
Developed a complete set of Crystal Reports for a SAP Business One HANA environment, connected directly through SAP Crystal Reports and HANA Studio. This BP (Business Partner) Ledger Report shows a running-balance statement with opening balance, transaction-level detail (date, document number, narration, debit/credit), and an auto-calculated running total the kind of report finance teams rely on for balance confirmations and reconciliation.
What the report package includes (visible across the open tabs):
BP Ledger Report : running-balance statement with opening balance carried forward, per-transaction debit/credit, and a live running total, filterable by date range
Ledger Report – Party-wise : the same ledger logic segmented by business partner, for multi-party reconciliation
Ledger Report : a general-purpose ledger view
Stock Statement : inventory position reporting
Purchase Order report : procurement-side documentation
Technical approach:
Built and queried directly against SAP B1 HANA using HANA Studio and native Crystal Reports connectivity, not a flattened export
Running totals calculated natively in Crystal Reports (Running Total Fields) so balances stay accurate as new transactions are added, with no manual re-calculation
Parameterized date-range filtering (Balance Confirmation From/To) so the same report serves any period without rebuilding
Clean, print-ready formatting suitable for sending directly to a customer or vendor for balance confirmation
Why this matters to a client:
A BP ledger with a running balance sounds simple, but getting the running total to calculate correctly against opening balances, filtered date ranges, and grouped by party takes real Crystal Reports and HANA query experience. This is a day-to-day report almost every SAP B1 finance team needs, and I can build the full set ledger, stock, purchase, and party-wise views as one connected package rather than one-off reports.
#CrystalReports #SAPHANA #HANAStudio #SAPBusinessOne #FinancialReporting #LedgerReports #RunningBalance #Accounting #BusinessConsulting #FinancePlanning #FinanceAnalysis #DataModeling
0
13
SAP Business One (HANA) Native Dashboards & KPIs
Built native SAP Business One HANA dashboards directly inside the SAP B1 client real-time KPI widgets running on live HANA data, with no separate BI tool required. This gives users instant visual insight the moment they log into SAP B1, right on their home screen.
What the dashboard delivers:
Customer-wise sales KPI : a ranked table of top customers by total sales amount, pulled live from SAP B1 sales data
Year-over-year comparison chart : Current FY vs. Previous FY vs. Prev-of-Previous FY, broken down by month, so trend analysis is available without exporting to Excel
Monthly sales bifurcation : a bar chart tracking total sales amount by month across the fiscal year for quick pattern spotting
Item-group-wise Sales Order totals : both a pie chart (proportional share by item group) and a horizontal bar chart (absolute SO totals), giving two views of the same data for different reporting needs
Purchase order tracking widget : a live count of "My Purchase Orders Not Received," turning a report that used to require manual checking into an always-visible alert
Built entirely on HANA calculation views : meaning the dashboards refresh against live transactional data with strong performance, not batch-refreshed extracts
Why this matters to a client:
Most SAP B1 users only see this kind of visibility if they buy and connect a separate BI tool. I build the same KPI/dashboard experience natively inside SAP B1 using HANA views and the built-in dashboard framework so there's no extra license, no separate login, and no data-sync lag. It's the fastest way for a SAP B1 HANA client to get real-time visual reporting without adding another system.
Suggested tags: SAP Business One SAP HANA HANA Calculation Views KPI Dashboard Native Dashboard Development Sales Analytics
One-line hook for the service card (under 100 chars):
Native SAP B1 HANA dashboards - real-time KPIs with no separate BI tool needed.
One more thing worth doing now that you have 4 solid samples (ELN/pharma, manufacturing job card, Power BI sales dashboard, also work with different industries, and this HANA dashboard): they span your 3 services nicely, this one and the Power BI one go under Service 1 (Reporting & Power BI Dashboards), and it's worth explicitly adding "native HANA dashboard development" to that service's tags/description too, since it's a distinct enough skill that clients may search for it specifically.
0
29
Power BI Sales Dashboard | Multi-Year Day-Range Analysis
Built a fully interactive Power BI sales dashboard that breaks down revenue not just by the usual year/month/product view, but by a custom "day-range" pattern (0–10, 11–20, 21–31 days) giving management visibility into when within the month sales actually happen, which is critical for cash flow and production planning in trading/manufacturing businesses.
What the dashboard delivers:
5-year trend view : one-click tabs to switch between FY20-21 through FY24-25, with a running "Total" row and column so leadership sees both period and cumulative performance instantly
Quarter and month drill-down: Q1/Q2/Q3 buttons plus a 1–9 month strip let users move from annual to monthly granularity without leaving the page
Day-range breakdown by month : a dedicated matrix showing 0–10/11–20/21–31-day sales split for every month of the year, so seasonal and mid-month sales patterns are visible at a glance
Multi-dimensional filtering : global slicers for Item Group, Sales Employee, and State, so any table or chart on the page can be sliced by product line, individual salesperson, or region in real time
Item Group and Sales Employee performance matrices : day-range sales broken out per product category and per salesperson, useful for both inventory planning and sales incentive tracking
Visual summary charts : a horizontal bar chart totaling sales by day-range, and a color-coded combo chart showing the month-by-month day-range split side by side, so non-technical stakeholders get the story without reading tables
Consistent, presentation-ready formatting : currency in lakhs (₹L), color-coded day-range categories, and a clean header/navigation bar that makes the report feel like a finished product, not a raw data dump
Why this matters to a client:
This isn't just a report that shows totals : it's built to answer a specific business question (when in the month are we actually making money, and who/what is driving it) that standard "sales by month" dashboards miss. I design Power BI dashboards this way: starting from the business question a client actually needs answered, not just wiring up default visuals.
0
33
Crystal Reports for Production & Manufacturing (Job Card / Job Sheet)
Designed a Crystal Reports job sheet for a manufacturing/production environment on SAP Business One, giving management a single-page view of an entire job card lifecycle from sales order through material consumption, production, dispatch, process cost, and labour cost.
The report pulls together: job card quantity vs. processed vs. dispatched quantity with automatic wastage % calculation, linked sales order and customer order details, a full material consumption table (item, lot number, projected vs. actual quantity), production details tied to MRQI numbers, a dispatch summary reconciled against production output, and a detailed process cost breakdown by machine, operator, shift timing, and duration.
This is exactly the kind of multi-section, data-heavy report I build for manufacturing clients on SAP B1 reports that replace manual Excel reconciliation with one accurate, auto-refreshing document tied directly to live SAP data, so production, dispatch, and cost figures never fall out of sync.
0
36