• Add Text & Subtotal in SAP B1 Marketing Document

    Add Text & Subtotal in SAP B1 Marketing Document

    October 21, 2016

    Add Text & Subtotal in SAP B1 Marketing Document

    Do you know, if we can add subtotal and or text for additional remarks in All Marketing document SAP Business One with item type by choosing type in line item? For example: Purchase order – item type as below T:

    Read more ›

  • How to Maximize & Restore Grid in SAP B1 Reports

    How to Maximize & Restore Grid in SAP B1 Reports

    October 19, 2016

    How to Maximize & Restore Grid in SAP B1 Reports

    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 ›

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