• SAP Business One Tips - STEM SAP Gold Partner Indonesia - Splitting Arrayed String into Table Function on HANA Database

    Splitting Arrayed String into Table Function on HANA

    April 22, 2019

    Splitting Arrayed String into Table Function on HANA

    Do you ever imagine how much struggle you have to go through, just for splitting long string into one column in table? Please take a look to this example: You have a string like this “AAA|BBB|CCC|DDD|EEE|FFF|GGG|HHH” And you want to

    Read more ›

  • Allowing Stock Release Without Item Cost

    April 18, 2019

    Allowing Stock Release Without Item Cost

    Sometimes, we need to deliver goods, but when you add that delivery order document, you’ll get an error like “Item Cost Not Found for one or more item“. In this case, you really need to deliver that order as soon

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - List of Document Type on SAP Business One

    List of Document Type on SAP B1

    April 15, 2019

    List of Document Type on SAP B1

    When you generate a financial reports, or inventory reports somehow you’ll find various document type on it, such as: IN, PU, PD, JE, DP, etc. Also read: List of Object Types On SAP BUSINESS ONE Query for List of Top

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - How To Set Up Pricing Hierarchy for Business Partners on SAP B1

    Set Up Price Hierarchy for Business Partner

    April 11, 2019

    Set Up Price Hierarchy for Business Partner

    Business nowadays is changing every time. Price lists, discounts and special sales are changing everyday every week or every month. In SAP Business One, a default price list accompanied by discount groups and special prices is assigned to a Business

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Change Your Column Width on SAP Business One

    Change Column Width on Rows

    April 8, 2019

    Change Column Width on Rows

    When we are open any documents on SAP Business One, sometimes we find the column size is not enough to display all of the words, some words are not full displayed, like displayed on picture below. So, don’t worry, you don’t

    Read more ›

  • SAP Business One Tips - SAP Gold Partner Indonesia - Upload with Excel Format to SAP Business One

    Import Business Partner Data from Excel

    April 4, 2019

    Import Business Partner Data from Excel

    There are many options to upload data to SAP Business One, you can use Copy Table feature, use Data Transfer Workbench, and also use Microsoft Excel. It will be easier if you using Microsoft Excel, that because you must be

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - How to Set Item Master Data to Inactive on SAP Business One

    Set Items to Inactive

    April 1, 2019

    Set Items to Inactive

    On SAP Business One‘s Item Master Data, there’s one important rules. If your item master data record was used in an accounting or inventory transaction (such as Journal Entry, A/P Invoice, A/R Invoice, etc.) or in a marketing document, it

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - How To Cancel Your Document on SAP B1

    Cancelling Your Documents

    March 28, 2019

    Cancelling Your Documents

    Are you making a mistakes in a document and want to cancel it? Don’t worry about it. After SAP Business One 9.0, SAP Business One allows you to cancel marketing document. In order to use this feature, you need full

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Full Backup Environment with HANA Studio

    Backup Full Environment with SAP HANA Studio

    March 26, 2019

    Backup Full Environment with SAP HANA Studio

    In case of any database failure, we need to prepare for the worst scenario, and prevent it as much as possible. There’s two type of database backup on SAP HANA: Backup schema This type of backup was specifically created for 1

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Production Issue Method Backflush vs Manual on SAP B1_

    Production Issue Method: Backflush vs Manual

    March 21, 2019

    Production Issue Method: Backflush vs Manual

    On SAP Business One, when we create the Production Order and we want to create Issue For Production , but the production order number that we just create is missing, and somehow not showing on the screen or choose from

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Find Your Pricing Details with Price Report

    Find Your Pricing Details with Price Report

    March 18, 2019

    Find Your Pricing Details with Price Report

    Using SAP Business One gives you a lot of advantages. You can get a lot of details for everything that displayed on your screen, especially about the price. There’s a Price Report. You can easily get a details from your

    Read more ›

  • SAP Business One Tips- STEM SAP Gold Partner Indonesia - Using Reference Footer on SAP B1

    Using Notification Bar as Reference Footer

    March 14, 2019

    Using Notification Bar as Reference Footer

    For maximizing a screen function on your SAP Business One, you can always set or custom an user-interface layout based on your own preference.  This time, we inform to you, the notification bar (on footer) can be useful too. It

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Journal Entry vs Journal Voucher on SAP B1

    Difference Between Journal Voucher and Journal Entry

    March 11, 2019

    Difference Between Journal Voucher and Journal Entry

    Have You Used a Journal Voucher? Are there some differences between Journal Entry and Journal Vouchers? And when is the right time to use the Journal Voucher or Journal Entry menu? Let’s take a look together. The difference between Journal

    Read more ›

  • Pick and Pack Manager on SAP B1

    Easier Pick & Pack Manager Without Non-Inventory Items

    February 25, 2019

    Easier Pick & Pack Manager Without Non-Inventory Items

    SAP Business One provides a Pick & Pack Manager feature for deliver goods and services to their customers with some simple steps. For example, when buying a new dishwasher, a technician comes, installs the machine and provides instructions for routine

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Easier Way to Add New Document Numbering

    Easier Way to Add New Document Numbering

    January 3, 2019

    Easier Way to Add New Document Numbering

    New year, and you realize that you must add new numbering series for various type of documents. It’s an easy job, but unfortunately, you have a lot of series. It will be wasting your time if you do it one

    Read more ›