• How to Manage Drop Ship Warehouse in SAP B1

    How to Manage Drop Ship Warehouse in SAP B1

    January 18, 2024

    How to Manage Drop Ship Warehouse in SAP B1

    There are times when companies work with suppliers to send products directly to customers without needing to go through the company’s warehouse. The company receives orders from customers, then forwards them to suppliers who will send the products directly to

    Read more ›

  • How to Add Notes to Journal Entry in SAP Business One

    How to Add Notes to Journal Entry in SAP Business One

    January 11, 2024

    How to Add Notes to Journal Entry in SAP Business One

    In SAP Business One, you can add notes to the journal entries that have been created to help explain or provide context for certain transactions so that they can help increase audit efficiency and reduce the risk of errors or

    Read more ›

  • Delete Chat History in Live Collaboration

    Delete Chat History in Live Collaboration

    December 28, 2023

    Delete Chat History in Live Collaboration

    SAP Business One provides a Live Collaboration feature that sends a message, which is used to communicate between users who are logged in to the SAP system. All user communications are usually stored in conversation history. If this feature is

    Read more ›

  • Customize Crystal Report per Business Partner

    Customize Crystal Report per Business Partner

    December 21, 2023

    Customize Crystal Report per Business Partner

    Sometimes companies need to issue invoice documents that are different for certain customers. Did you know, that in SAP Business One you can use different Crystal Reports for different Business Partners?   To do that: Go to Administration > Setup

    Read more ›

  • Cash Flow Methods: Direct vs Indirect (Part 2)

    Cash Flow Methods: Direct vs Indirect (Part 2)

    December 14, 2023

    Cash Flow Methods: Direct vs Indirect (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 Cash Flow in SAP B1 Guide

    Direct vs Indirect Cash Flow in SAP B1 Guide

    December 7, 2023

    Direct vs Indirect Cash Flow in SAP B1 Guide

    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 ›

  • Create Cube with Query in SAP HANA (Part 2)

    Create Cube with Query in SAP HANA (Part 2)

    November 30, 2023

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

  • Create a Cube Using Query in SAP HANA (Part 1)

    Create a Cube Using Query in SAP HANA (Part 1)

    November 23, 2023

    Create a Cube Using 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 ›

  • How to Set Public Holidays in SAP Business One

    How to Set Public Holidays in SAP Business One

    November 16, 2023

    How to Set Public Holidays 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 Multi-Level BOM Query in SAP B1 for HANA

    Unlimited Multi-Level BOM Query in SAP B1 for HANA

    November 9, 2023

    Unlimited Multi-Level BOM Query in SAP B1 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 ›

  • How to Create UDO Template for SAP B1 Data Import

    How to Create UDO Template for SAP B1 Data Import

    November 2, 2023

    How to Create UDO Template for SAP B1 Data Import

    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 ›

  • How to Preview External Crystal Reports in SAP B1

    How to Preview External Crystal Reports in SAP B1

    October 26, 2023

    How to Preview External Crystal Reports in SAP B1

    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 ›

  • How to Generate Pick List in SAP Business One

    How to Generate Pick List in SAP Business One

    October 19, 2023

    How to 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 Function in SAP Business One Warehouse

    Ctrl+Tab Function in SAP Business One Warehouse

    October 12, 2023

    Ctrl+Tab Function in SAP Business One Warehouse

    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 ›

  • SAP B1 Equipment Card: Add Multiple Business Partners

    SAP B1 Equipment Card: Add Multiple Business Partners

    October 5, 2023

    SAP B1 Equipment Card: Add Multiple Business Partners

    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 ›