I will configure sap business one fms, approvals, alerts, dtw and sql hana queries
Expert in SAP Business One, Power BI, and Integration
About this Gig
Struggling with SAP Business One configuration, reports, or automation?
I'm an SAP B1 functional consultant with 8+ years of expertise on SAP HANA & SQL Server, delivering 85+ projects across UK, Europe, Middle East & Asia.
What I deliver:
- FMS (Formatted Search) field auto-population & validations
- Approval Procedures multi-level PO, SO, AR/AP approvals
- Alert Management automated condition-based notifications
- Crystal Reports custom .rpt for Finance, Sales, Inventory
- Query Manager SQL/HANA reports & dashboards DTW master & transactional data migration
- UDF/UDT custom fields & tables on any document PLD invoice, PO & delivery note print layouts
- Transaction Notifications stored procedure automation
Modules: Finance | Sales (AR) | Purchase (AP) | Inventory | Manufacturing | MRP | CRM | Service
Why me? 8+ yrs SAP B1 | HANA & SQL Server | 2-day delivery | Secure VPN access | Post-delivery support included
Software type:
CRM
•
Other
My Portfolio
FAQ
Do you support both SAP HANA and SQL Server databases?
Yes! I work on both SAP HANA and SQL Server (MS SQL) databases across all SAP B1 versions including 9.x, 10.x and above. I write native HANA SQL and T-SQL queries for optimal performance.
Can you configure FMS (Formatted Search) queries in SAP B1?
Absolutely! I create FMS queries for auto-populating fields, dynamic validations, and filtering across SAP B1 modules - Sales, Purchase, Inventory, Finance using SQL and HANA.
Can you set up Approval Procedures and Alerts in SAP Business One?
Yes! I configure multi-level Approval Procedures and Alert Management for Purchase Orders, Sales Orders, AR/AP Invoices based on amount, user role, or document stage.
Do you work with DTW for SAP B1 data migration?
Yes! I use DTW (Data Transfer Workbench) to import Business Partners, Items, Invoices, Journal Entries, and other master/transactional data using correctly mapped SAP B1 templates.
Can you create Crystal Reports for SAP B1 manufacturing and finance?
Yes! I build Crystal Reports for all SAP B1 modules - AR Aging, Sales Analysis, Purchase Register, Stock Valuation, Production Orders, BOM, GL reports, Layouts and full financial statements.
How do you access my SAP B1 system safely?
I work via remote tools (AnyDesk, UltraViewer), secure VPN, or on a backup/test database. Your live system and business data remain fully secure and confidential at all times.
What information do you need to get started?
I need SAP B1 access (remote/VPN), your SAP B1 version, database type (HANA or SQL), and a clear brief of your requirement. I'll confirm scope and timeline before starting.

