• Get Login User Code in SAP B1 Query Manager

    Get Login User Code in SAP B1 Query Manager

    November 25, 2021

    Get Login User Code in SAP B1 Query Manager

    In SAP Business One, we can save the query we already created to Query Manager. We can use that query again for multiple purposes such as : • Reporting • Custom Alert • Custom Approval • FMS (Formatted Search) Here,

    Read more ›

  • Authorization for Custom Crystal Reports in SAP B1

    Authorization for Custom Crystal Reports in SAP B1

    October 28, 2021

    Authorization for Custom Crystal Reports in SAP B1

    In most of the company, you need to set access not only by menu, but you also need to limit who can access the reports. You can define permissions for users in SAP Business One who will be running reports

    Read more ›

  • Single Crystal Report Layout for A/R DP Request & Invoice

    Single Crystal Report Layout for A/R DP Request & Invoice

    October 7, 2021

    Single Crystal Report Layout for A/R DP Request & Invoice

    In SAP Business One, standard marketing documents such as A/R Down Payment Request and A/R Down Payment Invoice are using the same table (ODPI and DPI1). When you create a custom layout using Crystal Report Designer for those marketing documents,

    Read more ›

  • Credit Memo from Closed AR Invoice | SAP B1 Tip

    Credit Memo from Closed AR Invoice | SAP B1 Tip

    September 30, 2021

    Credit Memo from Closed AR Invoice | SAP B1 Tip

    There are main correction documents for the sales process in SAP Business One, one of them is the A/R Credit Memo. The A/R Credit Memo (credit note) is the document used to process returned items or to give a pricing

    Read more ›

  • SAP B1 Journal Entry Cash Flow Error Fix

    SAP B1 Journal Entry Cash Flow Error Fix

    September 23, 2021

    SAP B1 Journal Entry Cash Flow Error Fix

    When You create the Journal Entry with two or more accounts that are relevant to Cash Flow in Primary Form Item, and you add this document, an error message “Cash flow assignment is mandatory” appears and the selected Primary Form

    Read more ›

  • Allow Journal Entry Update in Locked Posting Period

    Allow Journal Entry Update in Locked Posting Period

    September 16, 2021

    Allow Journal Entry Update in Locked Posting Period

    When posting periods are set to the status “Locked”, users cannot update the journal entry documents to prevent users make modifications. But what if some users need very important changes or updates to these documents? Of course, SAP Business One

    Read more ›

  • SAP B1 Tip Set User Query to SAP Menu

    Set User Query to SAP Business One Main Menu

    September 7, 2021

    Set User Query to SAP Business One Main Menu

    User Query gives you the ability to quickly display data from SAP Business One database tables. One of them, you can create reports that are not yet available on the standard SAP Business One based on the SAP Business One

    Read more ›

  • SAP B1 Tips Automatic Generation of Warehouse Sublevels

    How to Automatic Generation of Warehouse Sublevels in SAP Business One

    August 24, 2021

    How to Automatic Generation of Warehouse Sublevels in SAP Business One

    In the previous article, it was explained how to create a Warehouse Sublevel. But what if there are too many sublevels you want to create? so it can be confusing if inputted one by one. Did you know SAP Business

    Read more ›

  • Locked Function in Warehouse List of Item Master Data

    Locked Function in Warehouse List of Item Master Data

    August 17, 2021

    Locked Function in Warehouse List of Item Master Data

    There are times when there are some items that should not be placed in a particular warehouse, and in SAP there are functions that can help with these conditions. In the item master data there is a list of active

    Read more ›

  • How to Extend UDF Character Length in SAP Business One

    How to Extend UDF Character Length in SAP Business One

    July 27, 2021

    How to Extend UDF Character Length in SAP Business One

    SAP Business One has a feature to add one or more fields to the system which can be called UDF. In addition, we can change the number of characters in the UDF that we have created. In this article, we

    Read more ›

  • SAP B1 Tips Running SSR Manual Upload

    Running SSR Manual Upload in SAP Business One

    July 13, 2021

    Running SSR Manual Upload in SAP Business One

    In the previous article, we can find out how to check the Task Upload System Status Report has been uploaded successfully. In this article, we will provide brief information on how to run the SSR upload task. Follow these steps:

    Read more ›

  • SAP B1 Tips Error Update Document Numbering

    Error Update Document Numbering

    June 29, 2021

    Error Update Document Numbering

    If you adding document numbering to a series of documents, then an error message appears “Numeric value deviates from legal range”, as shown below : then the cause of the error message is because the data type for the numbering

    Read more ›

  • SAP B1 Landed Cost Quantity Different

    Landed Cost Quantity Different with In Stock Quantity

    June 22, 2021

    Landed Cost Quantity Different with In Stock Quantity

    In some companies that use SAP Business One, there are some cases that might occur, where when purchasing items and require additional landed costs, the items have been used first before additional costs were added. Now, we will explain what

    Read more ›

  • SAP Business One Tips Error Add Landed Cost

    Error Add Landed Cost

    June 15, 2021

    Error Add Landed Cost

    In companies that purchase imported goods, it requires recording the value other than the price of the purchased item, such as import taxes, handling at the port, insurance, and others. In SAP, the input of the value uses the landed

    Read more ›

  • Boost Speed & Accuracy: Stock Count App for SAP B1

    Boost Speed & Accuracy: Stock Count App for SAP B1

    June 1, 2021

    Boost Speed & Accuracy: Stock Count App for SAP B1

    What is Stock Count? Stock Count (Stock Take) is a FREE Android application to help calculate and check physical Stocks. By using an android phone and Barcode Scanner, Stock Count can help to calculate the amount of physical stock quickly,

    Read more ›