• Separate Journal Entry per Line in SAP B1 – Tip

    Separate Journal Entry per Line in SAP B1 – Tip

    October 17, 2016

    Separate Journal Entry per Line in SAP B1 – Tip

    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 ›

  • Dynamic Decimal Points in Crystal Reports

    Dynamic Decimal Points in Crystal Reports

    October 14, 2016

    Dynamic Decimal Points in Crystal Reports

    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 ›

  • Adjust Column Width in SAP B1 Easily

    Adjust Column Width in SAP B1 Easily

    October 12, 2016

    Adjust Column Width in SAP B1 Easily

    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 Way to Add Column Total in SAP Business One User Query

    Quick Way to Add Column Total in SAP Business One User Query

    October 10, 2016

    Quick Way to Add Column Total in SAP Business One User Query

    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 ›

  • Quick Alternative to Fill UDF Matrix Values in SAP Business One

    Quick Alternative to Fill UDF Matrix Values in SAP Business One

    October 7, 2016

    Quick Alternative to Fill UDF Matrix Values in 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 Check Active Users in SAP Business One

    How to Check Active Users in SAP Business One

    October 5, 2016

    How to Check Active Users 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 & Hide Menu in SAP Business One

    How to Show & Hide Menu in SAP Business One

    October 4, 2016

    How to Show & Hide Menu in SAP Business One

    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 ›

  • Special Parameter for Multiple Databases in Crystal

    Special Parameter for Multiple Databases in Crystal

    October 2, 2016

    Special Parameter for Multiple Databases in Crystal

    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 Shortcuts — Quick Tips

    SAP Business One Keyboard Shortcuts — Quick Tips

    September 28, 2016

    SAP Business One Keyboard Shortcuts — Quick Tips

    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 Budget for Multiple Cost Centers in SAP B1

    Set Budget for Multiple Cost Centers in SAP B1

    September 26, 2016

    Set Budget for Multiple Cost Centers in SAP B1

    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 — Maximize SAP B1 Performance

    Don’t Import RPT in AddOn — Maximize SAP B1 Performance

    September 21, 2016

    Don’t Import RPT in AddOn — Maximize SAP B1 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 ›

  • Generate Procurement Docs from Sales Order in SAP B1

    Generate Procurement Docs from Sales Order in SAP B1

    September 19, 2016

    Generate Procurement Docs from Sales Order in SAP B1

    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 ›

  • SAP Business One Change Log: Track System Changes

    SAP Business One Change Log: Track System Changes

    September 15, 2016

    SAP Business One Change Log: Track System Changes

    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 ›

  • Set Default Font in Crystal Report for SAP B1

    Set Default Font in Crystal Report for SAP B1

    September 9, 2016

    Set Default Font in Crystal Report for SAP B1

    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 ›

  • Fix SAP Login Error – Windows Update Security Cert

    Fix SAP Login Error – Windows Update Security Cert

    September 7, 2016

    Fix SAP Login Error – Windows Update Security Cert

    Please follow this steps to Fix Error Login SAP Business One with warning message security certificate. This error because after your PC run security update from Windows. It blocked some SAP connection certificate and ports to SAP Server. Fix Steps

    Read more ›