500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)
July 25, 2024
When using the Data Transfer Workbench (DTW) in SAP Business One, we often encounter challenges regarding the consistency of uploaded data. Sometimes, when using specific symbols in the data to be uploaded, the result may appear in a different symbol…
June 6, 2024
SAP Business One is a robust ERP solution that empowers businesses with powerful data analytics and visualization tools. Dashboards play a crucial role in providing real-time insights and helping users make informed decisions. However, while creating a new dashboard, you…
April 11, 2024
Every transaction you create in the SAP Business One system needs to be converted or printed into a hard copy format for business process purposes. You can use layouts that are available within the SAP system or create layouts using…
December 21, 2023
Sometimes companies need to issue invoice documents that are different for certain customers. Did you know, that in SAP Business One you can use different Crystal Reports for different Business Partners? To do that: Go to Administration > Setup…
November 30, 2023
In the other article, we have discussed that users can create custom reports within SAP Business One. In part 1 of the article, the steps for initializing the database have been explained. In this part 2, we will discuss the…
November 23, 2023
SAP Business One provides ready-to-use standard reports. However, users can also create custom reports according to their needs. One frequently used and highly beneficial custom report is the creation of reports using Cube. The discussion will be divided into several…
November 9, 2023
In SAP Business One for SQL Server, if you want to create an unlimited multilevel Bill of Material (BOM) report, you can use WITH Recursive query expressions. However, in HANA as stated in the documentation, the <with_clause> cannot support recursive…
November 2, 2023
SAP provides facilities for creating new objects in SAP B1 to accommodate the information needed by each company. Not only creating new objects, SAP B1 also provides facilities so that we can add new data to new objects using the…
September 28, 2023
When using SAP Business One, if you want to print the user name that is logged in to SAP when printing a Crystal Report, then this can be done by adding the “UserCode@” parameter to the Crystal Report. Here are…
August 31, 2023
While creating/editing a report, unwanted things may occur such as a blackout, BSOD (Blue Screen of Death), and so on which causes the report that we have created/modified before to disappear. Therefore, to prevent this from happening, we can use…
May 12, 2022
When the layout has many versions, usually the layout with the first version is very rarely reused. But what if one of your users is confused about which layout will use? Is it possible if only the layout with the…
November 25, 2021
In SAP Business One, we can save the query we already created to Query Manager. We can use that query again for multiple purposes such as : • Reporting • Custom Alert • Custom Approval • FMS (Formatted Search) Here,…
October 7, 2021
In SAP Business One, standard marketing documents such as A/R Down Payment Request and A/R Down Payment Invoice are using the same table (ODPI and DPI1). When you create a custom layout using Crystal Report Designer for those marketing documents,…
September 7, 2021
User Query gives you the ability to quickly display data from SAP Business One database tables. One of them, you can create reports that are not yet available on the standard SAP Business One based on the SAP Business One…
July 27, 2021
SAP Business One has a feature to add one or more fields to the system which can be called UDF. In addition, we can change the number of characters in the UDF that we have created. In this article, we…
copyright © 2016 Sterling Tulus Cemerlang - SAP Indonesia Gold Partner . all rights reserved
