SAP Business One SQL Query Training SQL

Join B1 Consultant Claudia Nino of Clients First Business Solutions as she discusses how to create basic Queries in SAP Business One.

Queries are very useful when it comes to the existing Out-Of-The-Box reporting tools available in Business One. Often, it presents data in a way that you want to view differently. For example, if users are frequently generating Profit and Loss (P&L) reports, Balance Sheets, Sales Analyses or Purchasing Analyses, your information is presented in a rather static context.

This often leaves very little for users to change, modify or visualize in a different fashion. When you want to see your items in a new light, or require more information, you can recreate the existing report as a Query.

Queries are also beneficial when helping set up alerts and approvals for your staff. It's possible to create them for specific circumstances, for instance Past Due Balances, along with the links and connectivity to those would be notified both internally and externally.

Part of an ongoing series of video sessions spotlighting different ERP solutions and their features by technicians with years of experience, Clients First Business Solutions is dedicated to giving customers and users the fullest possible overview of what's available in today's ERP marketplace.

For More On SAP Business One:

Follow Us:

For More Information:

[vanhiennguyen]

Dear author, Can you teach me how to insert all SQL query to "Queries generator" in SAP or something in SAP? I want to declare some variable before select. Hope you got my point. Thanks so much!

[sapbtamil]

guys please put working process video dont do basics video