• SAP Business One Tips - STEM SAP Gold Partner Indonesia - How To Cancel Deposit from Checks (Full or Partial) on SAP B1

    How to Cancel a Deposit from Checks

    May 2, 2019

    How to Cancel a Deposit from Checks

    When you cancel a deposits, it doesn’t cancel related checks or payments. But, if an incoming payment related to your canceled deposits were already canceled, it does cancel related checks. There are two procedures for canceling deposit from a check:

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia - Setup Automate Housekeeping on HANA Server with Phyton Script for SAP B1

    HANA Housekeeping Using Python Script

    April 29, 2019

    HANA Housekeeping Using Python Script

    The following tips will provides you a new knowledge about how to do an automated housekeeping job for your HANA server. These tips will be very useful for clean up your database logs, traces, alerts, internal events, etc. Please follow these

    Read more ›

  • SAP Business One Tips - STEM SAP Gold Partner Indonesia Find Your Price Source in Sales Document SAP B1

    Find Your Price Source for Sales Document

    April 25, 2019

    Find Your Price Source for Sales Document

    Pricing will always a popular topic when we talks about SAP Business One. After we set the price list and discount for the item, for example: set the volume and period discount or special business partner discount. We make the

    Read more ›

  • 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 ›