SAP Business One Overview Demo

Here’s a great overview demo of SAP Business One.  It takes you through the key differentiators to really show you the strength of the solution. Features shown include: Alerts and Workflow Drag and Relate Document Flow and trace XL Reporter Dashboards Light Production CRM & Activity Management User Defined Fields and Tables Customized Forms and [...]

2010-07-08T13:12:39+00:00 July 8th, 2010|Queries, Reporting, SAP Business One|Comments Off on SAP Business One Overview Demo

See our New SAP Business One Resource and Demo Center!

We’ve just posted up a comprehensive sub-site at Clients First focusing around SAP Business One.  This site covers technical information, customer reference videos, demonstration and how-to videos, and business goal achievement. It also has information and materials on Crystal Reports and Xcelsius for true business intelligence.  Everything is wrapped up in an entertaining and visual [...]

2010-02-12T09:45:29+00:00 February 12th, 2010|Financials, Queries, Reporting, SAP Business One|Comments Off on See our New SAP Business One Resource and Demo Center!

SAP Business One 8.8 – Significantly Faster than 2007

Unlike the trend in most software, SAP just proved that their upcoming 8.8 release is significantly faster than the prior release, 2007a. Test were done on transaction entry, both standalone and chained.  Reporting performance was also tested.  In addition, changes to back end processing occurred so that much less data is ‘locked’ and for a [...]

2009-11-12T15:47:58+00:00 November 12th, 2009|Reporting, SAP Business One|Comments Off on SAP Business One 8.8 – Significantly Faster than 2007

SAP Business One Birthday List! (without the year)

A quick and easy query to give you a list of the birthdays from the Employee Master Data application in SBO. Copy and paste the lines below into the Query Generator tool. /*-----------------------*/ /* Displays a list of all the employees in SBO with their birthdays (without the year) */ SELECT lastname as 'Last Name' [...]

2009-02-11T11:46:52+00:00 February 11th, 2009|Financials, Queries, Reporting|Comments Off on SAP Business One Birthday List! (without the year)

SAP Business One: High Quantity on a Sales Order

Use this query to check for high order quantities on a Sales Orders. If you make an alert out of this query, then you can be notified when potential keying errors occur. /* Shows all sales orders where the qty ordered is greater */ /* than or equal to the amount within the WHERE Clause [...]

2009-02-11T11:45:51+00:00 February 11th, 2009|Queries, Reporting|Comments Off on SAP Business One: High Quantity on a Sales Order

SAP Business One: Query to Show Customers Without Sales Employees Assigned

Use the query to show all of the customers that do not have sales employees assigned. You can use this as an alert as well. SELECT CardCode as BP, CardName as 'Customer Name' FROM OCRD Where SLPCODE = -1 and CardType = 'C' FOR BROWSE Thanks to Ed Monk of SBONotes.com

2009-02-11T11:44:59+00:00 February 11th, 2009|Queries, Reporting|Comments Off on SAP Business One: Query to Show Customers Without Sales Employees Assigned

XL Reporter

I too a look at the sample report pack from SAP and I noticed that when they created a graph (even over expanding groups), they were selecting the cell below the value as well. When I first added the graph to the report, I selected the expanding row value (e.g., $B$6) only as the data [...]

2009-02-11T11:38:57+00:00 February 11th, 2009|Reporting|Comments Off on XL Reporter

Creating Custom Queries in SAP Business One

There are two tools for creating custom queries in SAP Business One, both of which will walk you through making your own query: Query Generator Query Wizard The end result of both tools listed above is a results window with the actual query statement in the top portion of the window and any data that [...]

2009-02-11T11:37:48+00:00 February 11th, 2009|Queries, Reporting|Comments Off on Creating Custom Queries in SAP Business One

SAP Business One How to Make a Print Layout (PLD) Report from an SBO Query

Follow these steps: Create a Query in SAP Business One Open the Query Manager Find your Report Highlight your report (single click) Click on the Create Report button at the bottom of the window. A window appears with the name of your query at the top of the window. Window is divided into two parts: [...]

2009-02-11T11:15:45+00:00 February 11th, 2009|Queries, Reporting|Comments Off on SAP Business One How to Make a Print Layout (PLD) Report from an SBO Query