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

Getting more from SAP Business One Distribution

Sales (Marketing Document) features of SAP Business One In Part one of this blog I would like to explore the automatic availability check and alternative items features offered by SAP Business One within marketing documents. We will use the SAP Business One sales order to illustrate these features. In the scenario pictured below I have

Read more…

SAP Business One Bank Reconciliation Reporting

This blog demonstrates the use of SAP Crystal Reports and MS SQL to offer an alternative bank reconciliation report for SAP Business One. The technical team at Leverage put this report together. A good demonstration of the flexibility of SAP Business One and SAP Crystal Reports. The Leverage Technologies bank reconciliation report allows you to

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…

Creating a query in SAP Business One – Part two

Part 2 of my blog – creating a query in SAP Business One. I hope you find the information useful. When the wizard screen appears press next to move to step 2 of the wizard. Type the name of the table noted earlier in the field as shown below. You will see that the wizard

Read more…

Creating a SAP Business One SQL Query – Part One

This is part one of my two-part series on creating a basic query in SAP Business One. Over the next few months, I will be providing regular tips and tricks on some of the great functions and features available to users. Many users of SAP Business One (SBO) are unaware that there is a powerful

Read more…