• Direct vs Indirect Method in Cash Flow part 2

    Direct vs Indirect Method in Statement of Cash Flow (Part 2)

    December 14, 2023

    Direct vs Indirect Method in Statement of Cash Flow (Part 2)

    In the previous discussion, we discussed the Direct Method in the Statement of Cash Flow in SAP Business One. In part 2, we will continue discussing the Indirect Method. In this method, statement of cash flow is generated by utilizing

    Read more ›

  • Direct vs Indirect Method part 1

    Direct vs Indirect Method in Statement of Cash Flow (Part 1)

    December 7, 2023

    Direct vs Indirect Method in Statement of Cash Flow (Part 1)

    In SAP Business One, there are 2 methods for recording company cash flows, namely the Direct and Indirect methods. We will discuss the Direct method in Part 1. In the Direct method, each transaction that is relevant to cash flow

    Read more ›

  • setup cube with query in sap hana part 2

    Setup Cube with Query in SAP HANA – Part 2

    November 30, 2023

    Setup Cube with Query in SAP HANA – Part 2

    In the other article, we have discussed that users can create custom reports within SAP Business One. In part 1 of the article, the steps for initializing the database have been explained. In this part 2, we will discuss the

    Read more ›

  • setup cube with query in sap hana part 1

    Setup Cube with Query in SAP HANA – Part 1

    November 23, 2023

    Setup Cube with Query in SAP HANA – Part 1

    SAP Business One provides ready-to-use standard reports. However, users can also create custom reports according to their needs. One frequently used and highly beneficial custom report is the creation of reports using Cube. The discussion will be divided into several

    Read more ›

  • Determine Holiday Dates in SAP Business One

    Determine Holiday Dates in SAP Business One

    November 16, 2023

    Determine Holiday Dates in SAP Business One

    In SAP Business One, there is a function to define the holiday date which is used to determine the dates of national holidays that will be applied in the work calendar. You can define holidays for future years and ensure

    Read more ›

  • unlimited bom query for hana sap b1 tips

    Unlimited Multilevel Bill of Material (BOM) Query in SAP Business One for HANA

    November 9, 2023

    Unlimited Multilevel Bill of Material (BOM) Query in SAP Business One for HANA

    In SAP Business One for SQL Server, if you want to create an unlimited multilevel Bill of Material (BOM) report, you can use WITH Recursive query expressions. However, in HANA as stated in the documentation, the <with_clause> cannot support recursive

    Read more ›

  • generate udo templates for dtw

    Generate User Defined Object (UDO) Templates for Data Transfer Workbench (DTW)

    November 2, 2023

    Generate User Defined Object (UDO) Templates for Data Transfer Workbench (DTW)

    SAP provides facilities for creating new objects in SAP B1 to accommodate the information needed by each company. Not only creating new objects, SAP B1 also provides facilities so that we can add new data to new objects using the

    Read more ›

  • preview external crystal report

    Preview External Crystal Reports in SAP Business One

    October 26, 2023

    Preview External Crystal Reports in SAP Business One

    SAP Business One provides standard reports that provide informative and structured information as part of its core functionality. However, sometimes companies needs additional information that is not covered in the standard reports provided by SAP Business One. Therefore, there is

    Read more ›

  • generate-pick-list-in-sap-b1

    Generate Pick List in SAP Business One

    October 19, 2023

    Generate Pick List in SAP Business One

    Pick List is a document that contains a list of items to be taken from the warehouse for further packing and shipping. In SAP, you can create a pick list directly from related documents with just a click. Here are

    Read more ›

  • ctrl tab on warehouse

    CTRL + TAB Function on Warehouse in SAP Business One

    October 12, 2023

    CTRL + TAB Function on Warehouse in SAP Business One

    Previously, you may often feel confused about determining which warehouse has stock availability of an item when making a transaction, be it a sales order transaction, purchase order, A/P Invoice, or A/R Invoice. You usually need to check the stock

    Read more ›

  • add-multiple-bp

    Add Multiple Business Partners to an Equipment Card

    October 5, 2023

    Add Multiple Business Partners to an Equipment Card

    In SAP Business One, if there are items that involve more than one business partner, all these business partners can be added to the Equipment Card. For example, the provision of facilities in the form of projectors that are shared

    Read more ›

  • Print Login User Name in SAP Business One Crystal Report

    How to Print Login User Name in SAP Business One Crystal Report

    September 28, 2023

    How to Print Login User Name in SAP Business One Crystal Report

    When using SAP Business One, if you want to print the user name that is logged in to SAP when printing a Crystal Report, then this can be done by adding the “UserCode@” parameter to the Crystal Report. Here are

    Read more ›

  • disable-user-defined-field

    Disable User-Defined Field

    September 21, 2023

    Disable User-Defined Field

    In SAP Business One, you can add user-defined fields (UDF) when a field is required for certain inputs. The UDF can be saved in the desired view by using Edit Form UI (from the menu bar Tools > Edit Form

    Read more ›

  • disable-auto-open-excell

    Disable Auto Open Saved Excel Export Files

    September 14, 2023

    Disable Auto Open Saved Excel Export Files

    In SAP Business One, there is a function to export reports into Excel files by clicking the Excel icon in SAP. After saving successfully, the Excel file will automatically open. Sometimes, the user just wants to save it, without opening

    Read more ›

  • Resolving Date Deviates Error

    Resolving Date Deviates Error

    September 7, 2023

    Resolving Date Deviates Error

    If a document has a date that is far from the Posting Period, an error will occur with the message “Date deviates from permissible range“. For example, several documents have a Due Date of up to 2024. To be able

    Read more ›