500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)
January 22, 2018
Crystal Report formula generally used to Count, Summarize, or any other Arithmetic function in Crystal Report. Depends on query result, the value for one of the field either NULL or NOT NULL. The problems are: Formula in Crystal Report wouldn’t…
January 8, 2018
Everyone usually knows a common method for crystal report data source is using “Add command” feature. Now, we’ll explain another method to do the same thing on HANA version, so if you want to know a SQL version, please read…
December 25, 2017
Now we’ll let you know how to make the custom report with Crystal Report more easily. Crystal Report can have SAP Table as Data source beside Query via Add Command features. Table will display all fields available at those tables.…
December 12, 2017
When you need to create a custom report, or custom form. And your report or form contains a lot of data but need to be printed with simplest (short) layout, especially for Eco-friendly paperless purposes. Today we’ll give you some…
November 24, 2017
There’s so many benefits of using SAP HANA. As of SAP Business One 9.1, version for SAP HANA Patch Level 05, you can design HTML5 pervasive dashboards, by using the enhanced Dashboard Designer. On Tools – Pervasive Analytics, click New…
November 16, 2017
If you are using SAP HANA, you can have a lot of features on your dashboard. For example, a sidebar. On that sidebar, you’ll be find all related data without any further clicks. On default setting, your dashboard area related…
November 8, 2017
If you ever had a problem when you suddenly wondering why your “Inventory” menu name changed to “Stock Management”. And you not change anything on B1UP, so it doesn’t make sense if your main menu name become unfamiliar. So, this…
November 1, 2017
This feature is a sample of advantages using SAP HANA. Just a quick tips about how to activate your pervasive analytic feature. Open browser Google Chrome, and type this URL: https://hanab1h:40000/Enablement/ *) Customize [hanab1h] with your real production database server…
October 26, 2017
In the User Defined Tables – Setup window a new object type ‘No Object with Auto Increment’ is added in the drop-down list of the Object Type field. When you apply this type, the application created a user defined table…
October 23, 2017
As a routine for go live preparation, you always have a lot of master data to uploaded on the production database. And when you’re using Data Transfer Workbench (DTW), sometimes it will be an error if you use files that…
October 9, 2017
There’s always a common problem when you find your Inventory Cumulative Balance doesn’t match with your Inventory G/L Account Balance. So, the answer is you post a manual Journal Entries on SAP, and create using the Inventory G/L accounts. At…
September 18, 2017
SAP Business One Developer usually use UI/DI API to develop their solution. While they develop the solution, they will encounter errors without knowing the error details. This list below, will describe what the error code means. Code Details 0 Success.…
September 16, 2017
Sometimes, as an internal IT staff or a SAP consultant, you need to access Remote Support Platform for doing some common task, such as: checking DB consistency, backup DB, etc. If you want to use Remote Support Platform SAP Business…
September 14, 2017
Sometimes, you’ll need to create simple queries to preview and analyze data, you can use “Query Generator” feature, or create some validation with SP Transaction Notification, create another SP Post Notification on your database, with custom queries that directly created…
September 5, 2017
As we know, support consultant only need to log on to customers company once in a while. With a lot of enhancement on SAP Business One version 9.2, now when we need to access SAP as a support consultant, we…
copyright © 2016 Sterling Tulus Cemerlang - SAP Indonesia Gold Partner . all rights reserved
