• SAP Business One Tips Custom Report Query PR vs PO vs GRPO

    Custom Report – Query PR VS PO VS GRPO

    October 15, 2020

    Custom Report – Query PR VS PO VS GRPO

    As we know, SAP Business One provides facilities/features to make it easier for us to retrieve data from the system by the query to the database. Like this example, sometimes you need a comparison between a Purchase Request (PR), Purchase

    Read more ›

  • SAP Business One Tips Manually Backup Restore SAP Hana Database

    Manually Backup & Restore Specific SAP HANA Database 📒

    October 13, 2020

    Manually Backup & Restore Specific SAP HANA Database 📒

    Now many companies have felt the benefits gained by using the SAP HANA database on SAP Business One. Many features and functions are only available when using the SAP Hana database. This is because the SAP HANA database uses the concept

    Read more ›

  • SAP Business One Tips How to Change Crystal Report to MS SQL

    How to Change Crystal Report from HANA Version to Ms SQL Version

    October 8, 2020

    How to Change Crystal Report from HANA Version to Ms SQL Version

    There are some conditions when you only get Crystal Reports with HANA Versions Query, and later those Crystal Reports want to be used on SQL Version Query, and you don’t need to change any value or field, you just need

    Read more ›

  • SAP Business One Tips Cancel Landed Cost Document

    Cancel Landed Cost Document

    October 6, 2020

    Cancel Landed Cost Document

    Nowadays, many companies are using a third-party vendor when purchasing inventories especially when they’re purchasing from overseas. And we must pay an additional cost for the services that the third-party vendor provided such as shipping cost, trucking, freight, insurance, etc.

    Read more ›

  • Using the Last Price Report

    October 1, 2020

    Using the Last Price Report

    Last Prices Report in SAP B1 is used to view the last selling price/purchase price of a particular item. Usually used by Sales or Purchasing to make it faster to process sales/purchases and use the latest prices in force. There

    Read more ›

  • SAP Business One Tips Change Display on Choose From List

    Change Display on Choose From List Using Display Description

    September 28, 2020

    Change Display on Choose From List Using Display Description

    In the Choose From List view, you can usually see a list of master data such as a list of item master, a list of vendors, or customers, wherein the list usually the code and name information will appear instead

    Read more ›

  • Shortcut on Crystal Report

    September 24, 2020

    Shortcut on Crystal Report

    After we have learned shortcuts in sap business one, now will also learn shortcuts in crystal report, to make it easier for you to work with Crystal Report. Here is the shortcut list: General Shortcut No Shortcut Notes 1 Ctrl

    Read more ›

  • SAP Business One Tips Create Validation Using Transaction Notification

    Create Validation using Transaction Notification

    September 22, 2020

    Create Validation using Transaction Notification

    In SAP Business One (SAP B1) either you are using SAP Hana or Microsoft SQL Database, we can add simple validation using store procedure in the database. For example, when users create a new Business Partner Master Data (vendor or

    Read more ›

  • SAP Business One Tips Invalid Currency When Input Jounal Entry

    Invalid Currency when Input Journal Entry

    September 17, 2020

    Invalid Currency when Input Journal Entry

    Have you ever had a problem when entering Journal Entry which uses foreign currency and the error message “Invalid Currency” appears? As seen in the picture below: This happens because you input in the Foreign Currency (200 USD), but you

    Read more ›

  • SAP Business One Tips Balance Due on Invoice

    Balance Due Field on Invoice

    September 15, 2020

    Balance Due Field on Invoice

    In SAP Business One, the A/P Invoice or A/R Invoice document contains a Balance Due Field which informs you how much the remaining bill has not been paid. So, if you are currently making a custom report for the remaining

    Read more ›

  • SAP Business One Tips Requirements for Changing Decimals Digit

    Requirements for Changing Decimal Digits in SAP Business One

    September 10, 2020

    Requirements for Changing Decimal Digits in SAP Business One

    In the previous article, it was discussed that you can adjust the display of digit decimal in SAP Business One according to company needs. But, over time, the company may experience changes so that the company’s needs change or the

    Read more ›

  • SAP Business One Tips Decimal Display Format

    Decimal Display Format in SAP Business One

    September 8, 2020

    Decimal Display Format in SAP Business One

    Every company, of course, has different needs in presenting data / reports. In SAP Business One, you can adjust the decimal display according to your company’s needs. This decimal display setting can be done in the General Settings Menu, namely:

    Read more ›

  • SAP Business One Tips Depreciation Method in Depreciation Type

    Depreciation Method in Depreciation Type

    September 3, 2020

    Depreciation Method in Depreciation Type

    Not only to help the system to be integrated properly and quickly, SAP B1 also allows users to be able to depreciate their assets. There are several types of Depreciation that can be made by the user or that has

    Read more ›

  • SAP Business One Tips How to Change Date Format

    How To Change Date Format

    September 1, 2020

    How To Change Date Format

    In general, date format that we always use when using SAP Business One is Date / Month / Year or Month / Date / Year. But for those who don’t know it, SAP has several date formats option that we

    Read more ›

  • SAP Business One Tips Bill of Material BOM Description Enhancement

    Bill of Materials (BoM) Description Enhancement

    August 27, 2020

    Bill of Materials (BoM) Description Enhancement

    In SAP Business One version 10, there is an enhancement in Product Description in the Bill of Materials. Prior to SAP Business One version 10, when you already had a Bill of Material for an item, after some time you

    Read more ›