• How to use Maximize Restore Grid in SAP Business One Financial Report - SAP Business One Tips

    How to use Maximize Restore Grid in SAP Business One Financial Report

    October 19, 2016

    How to use Maximize Restore Grid in SAP Business One Financial Report

    You can maximize screen to choose multiple GL account with tick mark in SAP Report Trial Balance and General Ledger, or another SAP Business One Financial Report that have tick mark GL Account matrix. It is quite helpful because you

    Read more ›

  • Split Journal Entry by Document Lines

    October 17, 2016

    Split Journal Entry by Document Lines

    In SAP Business One, Journal entry created from document transaction posting can be setting as your needs: Split in a journal entry previews only Split No Split So if you need to analyse the amount per lines, then you can

    Read more ›

  • How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One - SAP Business One Tips

    How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One

    October 14, 2016

    How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One

    In Crystal Report For SAP Business One, we can set how numeric field value displayed according to the number value itself. For example: 1. 1250.00 → will be displayed as 1250 (No decimal point) 2. 1250.65 → will be displayed as 1250.65

    Read more ›

  • How to Fit Column Width in SAP Business One

    October 12, 2016

    How to Fit Column Width in SAP Business One

    You can automatically fit column width on all SAP Business One grid. It will help you to quickly resize and fit all the column. Here is the step to Fit Column Width: Open any menu or report that has SAP grid

    Read more ›

  • Quick Addition of Total Field in User Query SAP Business One

    October 10, 2016

    Quick Addition of Total Field in User Query SAP Business One

    In SAP Business One, After you created a query using query manager, you want to sum the total of all values in a column without having to write an extra SQL statement or export the data into excel to get

    Read more ›

  • Alternative Way to Set UDF Value in Matrix for SAP Business One - SAP Business One Tips

    Alternative Way to Set UDF Value in Matrix for SAP Business One

    October 7, 2016

    Alternative Way to Set UDF Value in Matrix for SAP Business One

    In SAP Business One, Sometimes we set value UDF matrix with this way.   But, it’s have many weakness, such as slow (if you have more than 1 value to set) and if this column is disable we can’t directly

    Read more ›

  • How to See Active User in SAP Business One

    October 5, 2016

    How to See Active User in SAP Business One

    You are an It support in your company and need to update the system while need to make sure everyone is logged out from SAP Business One Client? Well don’t worry since this tips will make your work easier :

    Read more ›

  • How To Show and Hide SAP Business One Side Menu

    October 4, 2016

    How To Show and Hide SAP Business One Side Menu

    In SAP Business One, We can Hide or Show the Side Bar Menu, this is useful for a certain user who just want look the menu related to his/her job. This setting can be click on the wrench icon the

    Read more ›

  • Crystal Report SAP BUSINESS ONE HANA Special Parameter for Multiple Dynamic Database - SAP Business One Tips

    Crystal Report SAP BUSINESS ONE HANA Special Parameter for Multiple Dynamic Database

    October 2, 2016

    Crystal Report SAP BUSINESS ONE HANA Special Parameter for Multiple Dynamic Database

    As far as we know, SQL Query for Crystal Report in SAP BUSINESS ONE HANA must have Database variable as a prefix to procedure name. Needed to be written on every procedure, table or variable, really take times and patient.

    Read more ›

  • SAP Business One Keyboard Shortcut

    September 28, 2016

    SAP Business One Keyboard Shortcut

    It is important to know SAP Business One Keyboard ShortCut- this will increase our productivity using SAP B1 Here is the shortcut list: General Shortcut No Short Cut Notes 1 Ctrl + C Copy 2 Ctrl + F Change to find mode 3 Ctrl + L

    Read more ›

  • Set Up Your Budget For Multiple Cost Center in SAP Business One -SAP Business One Tips

    Set Up Your Budget For Multiple Cost Center in SAP Business One

    September 26, 2016

    Set Up Your Budget For Multiple Cost Center in SAP Business One

    If your company is applying ‘Budget’ for operational activities, you can easily create and monitor it with SAP Business One. You can have Budget per cost center by defining it on your budget scenario. From the SAP Business One Main Menu,

    Read more ›

  • Don’t Import RPT in AddOn Menu to Maximize SAP Performance - SAP Business One Tips

    Don’t Import RPT in AddOn Menu to Maximize SAP Performance

    September 21, 2016

    Don’t Import RPT in AddOn Menu to Maximize SAP Performance

    To stabilize SAP Business One performance, we have to prevent import crystal report file into menu created by add-on. The performance issue comes when we log in to SAP Business One. The more report files exist, the longer it takes.

    Read more ›

  • Procurement document from Sales Quotation or Sales Order in SAP Business One -SAP Business One Tips

    Procurement document from Sales Quotation or Sales Order

    September 19, 2016

    Procurement document from Sales Quotation or Sales Order

    In SAP Business One, we can create procurement document (Purchase Request, Purchase Quotation, Purchase Order or Production order), based on sales document (sales quotation or sales order) For Example: Because of system behaviour then in every sales order or quotation

    Read more ›

  • Change Log

    September 15, 2016

    Change Log

    In SAP Business One, You can trace the modification of a document with “Change Log” The Change Log will show previous and new information for all field that has been changed,  about whom modified the document, and time of changes.

    Read more ›

  • How To Set Your Own Default Font Style In Crystal Report for SAP Business One - SAP Business One Tips

    How To Set Your Own Default Font Style In Crystal Report for SAP Business One

    September 9, 2016

    How To Set Your Own Default Font Style In Crystal Report for SAP Business One

    In Crystal Report For SAP Business One, we can set “one time” configuration to make report more efficiently. By default, Crystal Report For SAP Business One font style will be set to: 1. “Arial” font type, “Regular” font style and

    Read more ›