FA

SAP Business One

Enterprise Resource Planning (ERP) Projects

Available
Check Entry

Check Entry

Check Payments Automation

Desktop tool for SAP Business One that enables batch posting of incoming checks (draft or final) with direct Shamsi-to-Gregorian date conversion via Service Layer (HANA & SQL).

  • Direct Service Layer integration
  • Automatic Shamsi to Gregorian date conversion
  • Batch processing with validation and reporting
Landing Page
Intelligent Sales Automation

Intelligent Sales Automation

n8n Workflow

Intelligent sales automation for SAP Business One that connects ERP data with AI models to generate insights with n8n, automated reports in Google Sheets, and real-time notifications via Telegram.

  • Daily sales summaries with AI trend analysis
  • Automated Telegram reports
LinkedIn GitHub SAP
Custom Sales Blocklist

Sales Blocklist

Custom Sales Restriction Tool

SQL-based validation system for SAP Business One that blocks specific items from being sold to certain customers during defined time periods via transaction notifications.

  • Customer-specific item restrictions by date range
  • Sales validation at document save
LinkedIn GitHub SAP
Available-to-Promise

Available-to-Promise (ATP)

Delivery Schedule Management

SQL solution for tracking inventory availability in SAP Business One. Calculates Available-to-Promise quantities across warehouses to support order fulfillment decisions.

  • Real-time ATP calculation across warehouses
  • Multi-warehouse allocation and delivery scheduling
LinkedIn GitHub Power BI SQL
Cash Flow Analysis

Cash Flow Analysis

A practical guide to SAP Business One cash flow tools, covering configuration, report types, and financial reporting methods most users overlook.

  • Cash Account vs. Cash Flow Relevant flags
  • Cash Flow Report and Forecast
  • Cash Flow Statement
  • Direct vs Indirect methods
LinkedIn SAP

SQL Reporting & Query Practice

with SAP Business One Database

Interactive SQL training for building sales reports on real SAP ERP table structures.

  • 12 query challenges on business partners, items, and invoice tables
  • Practice with real SAP B1 table structures and columns
SQL SQL Playground

Connected Business Partners

SQL-driven Connected BP management for SAP B1 with live balances, alerts, and payment validation to reduce financial risk and improve reconciliation workflows.

  • Connected Vendor Customer Accounts
  • Blocking payments when linked BP is overdue
LinkedIn GitHub SAP

Customer Purchase History

Customer's top sales items with stock availability during order entry External

Leveraging PCF for ERP Success

Cross-industry APQC framework for successful ERP implementations External