• SAP Business One Tips Monitoring Last Purchase And Last Selling Price

    Monitoring Last Purchase Price and Last Selling Price in SAP B1

    October 27, 2020

    Monitoring Last Purchase Price and Last Selling Price in SAP B1

    The purchase price in every supplier/vendor maybe can different, including the Selling Price can differ in every customer too. Did you have a problem with monitoring the Last Purchase price and the Last Selling Price? With SAP Business One, you

    Read more ›

  • SAP Business One Tips Easy way to input date in sap b1

    Easy Way to Input Date in SAP Business One

    October 22, 2020

    Easy Way to Input Date in SAP Business One

    Starting with the SAP Business One 9.3 version, you can add several features that make it easier for you to enter dates. Feature You can use the up/down arrow button on the Keyboard to increase/decrease the date. You can use

    Read more ›

  • SAP Business One Tips Shortcut to see the last price

    Shortcut to See the Last Price

    October 20, 2020

    Shortcut to See the Last Price

    In the previous article, in SAP Business One You can see The Last Price from Inventory Menu → Inventory Reports → Last Prices Report. Did you know, SAP Business One also provides a Shortcut to see the Last Price? When

    Read more ›

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