LinedIn Code

Everything ERP ...and a bit more!

Want product updates, industry news and trends, helpful case studies and more? You'll find it here

SAP Business One Dashboards – KPI Reporting when and where you want

SAP Business One offers Dashboard Reporting standard in the version 8.8+ SAP Business One Cockpit. SAP Business One delivers a number of standard dashboards and you can also write your own user defined SAP dashboards. The dashboards present graphical KPI (Key Performance Indicator) information. Dashboards currently available include:  – customer receivables ageing,  – cash flow forecast,

Read more…

SAP Business One Reporting – pivot tables with drill down to source transaction

SAP Business One offers multiple reporting options. Our previous blog which SAP Business One Reporting options are right for my business spoke about SAP Business One Crystal Reports, SAP Business One Query Manager and Excel Pivot Tables for SAP reporting. A cost-effective way of displaying data from SAP Business One is to present information in

Read more…

SAP Business One 8.82 Stock Turnover Analysis Report

SAP has delivered a new stock turnover analysis report in SAP Business One 8.82. You can access this SAP Crystal Report from the Inventory, Inventory Reports section of SAP Business One.   Choose your date range, items and warehouses and run the report to get your SAP Business One Stock Turnover Analysis. The report provides

Read more…

SAP Business One Bank Reconciliation Report

SAP Business One 8.81 and 8.82 includes a new Bank Reconciliation Report. This report, written by SAP is based on SAP Crystal Reports. The report can be found on the banking menu under banking reports, external reconciliation. Once you select your account code and bank reconciliation number SAP Business One will produce a Bank Reconciliation

Read more…

Which SAP Business One reporting options are right for my business?

SAP Business One offers several reporting options – standard reports, drill down to source transaction, SAP Drag and Relate, SAP Reporting Dashboards, Crystal Reporting, Excel Pivot Tables, BI on Demand, SAP Query Manager / SAP Query Generator and SAP Analytics powered by HANA. The question most SAP Business One customers and prospective customers ask is

Read more…

SAP Business One – Crystal Reports Drill Down to Source Transaction

In this blog we will look at functionality in Crystal Reports 2008 which allows the creation of the well-known yellow “drill down” arrows that can be found in SAP business one and that makes navigation between different areas in SAP so easy.When developing the SAP Business One Crystal Report the areas where navigation to source transaction is required are linked

Read more…

Creating a query in SAP Business One – Part three

Part three- the final part of my blog –  Creating a query in SAP Business One: Press the next button to move to step 5 of the wizard. This section shows the SQL syntax created by the wizard which will be used to interrogate the database. As users become more advanced with SQL queries, the

Read more…