SQL-Based MIS & Year-End Reporting (NAV + Excel)
Project Overview
SQL-Based MIS & Year-End Reporting (NAV + Excel): a Business Central / NAV implementation and support project delivered by Sumit Shede. Developed SQL reports for inventory matching and reconciliation. Industries: Manufacturing, Retail, Distribution, Finance.
My Role & Contributions
- Developed SQL reports for inventory matching and reconciliation
- Built customer and vendor ageing reports
- Created year-end reports for finance and audit requirements
- Integrated SQL queries with Excel for reporting and analysis
- Optimized queries for performance and accuracy
- Coordinated with users for validation and reporting needs