REPORTS AUTOMATICALLY DISTRIBUTED TO INBOXES

Suman Ind Agro

Suman Ind Agro is an industrial equipments supplier which uses SAP Business One as their ERP and have a core team of 15 people.

Like many small businesses, this team had the analytical capability to write their own queries — but not IT capacity to setup complex reporting systems. Every recurring report meant either a manual run or a request to technical staff, creating delays and bottlenecks that slowed down decision-making.

Automated finance, sales and purchasing reports in minutes

Configuration took minutes, not days. The team connected directly to SQL Server of SAP Business One via ODBC, wrote their queries, and had automated delivery running the same day.

Once set up, AutoSQL became the backbone of their entire reporting workflow across finance and operations:

  1. General ledger (GL) extracts delivered automatically on a scheduled basis
  2. GST-related reports generated and distributed without manual intervention
  3. Periodic sales and purchase summaries sent to relevant team members
  4. Management-level decision reports delivered directly to leadership inboxes on schedule

AutoSQL’s simplicity and ease of configuration have proven to be extremely valuable.

Automatically keeping business partners up to date

Next to the internal reports, AutoSQL is also used to automatically push information to business partners.

When certain events are detected in Business One, mails are sent automatically. Eg when a purchase order is over due, the vendor gets an email about it automatically.

Results: reliability, speed, and independence from IT

“The biggest advantage for us is reliability and time savings — eliminating manual report generation and reducing dependency on technical intervention."

The impact was immediate. Reports that previously required a manual trigger — or a request to a technical colleague — now run automatically and arrive in inboxes without anyone having to think about it.

SAP Business One Report Automation