• Import Stock Count into SAP Business One Effortlessly

    Import Stock Count into SAP Business One Effortlessly

    March 4, 2022

    Import Stock Count into SAP Business One Effortlessly

    Inventory Counting (Stock Taking) is a very important activity for every company to always manage existing inventory in the warehouse either perpetually or periodically. By matching existing inventory with the amount stored in the database, companies can make adjustments to

    Read more ›

  • Block Duplicate Cust. Reference No. in SAP B1

    Block Duplicate Cust. Reference No. in SAP B1

    February 24, 2022

    Block Duplicate Cust. Reference No. in SAP B1

    In SAP Business One, it allows you to use the customer reference number once for the same document. This can be used to reduce duplication when the user inputs documents. To enable duplication block Cust. Reference No., follow these steps:

    Read more ›

  • iREAP STOCK COUNT (STOCK TAKE)

    FREE Mobile Android iREAP Stock Count (Stock Take)

    February 17, 2022

    FREE Mobile Android iREAP Stock Count (Stock Take)

    Do you currently have problems with Stock/Inventory accuracy and take days when doing your weekly, monthly or yearly stock counting & checking (physical inventory / cycle count) in your Retail Store or in your Warehouse? Stock Count (Stock Take) is

    Read more ›

  • create profit and loss statement templates

    Create Profit and Loss Statement Templates without Inactive Drawer

    February 4, 2022

    Create Profit and Loss Statement Templates without Inactive Drawer

    Since SAP version 9.3, the drawer on the chart of accounts consists of up to 10 drawers that can be used, and mostly drawers 9 and 10 are not used. Even if not used, drawers 9 and 10 still appear

    Read more ›

  • Fixing Permission Error in SAP B1 Customer Aging Report

    Fixing Permission Error in SAP B1 Customer Aging Report

    January 13, 2022

    Fixing Permission Error in SAP B1 Customer Aging Report

    In each company, it is possible to make transactions with customers in several foreign currencies and to find out the balance of each customer’s receivables, you can access the customer receivable aging report. For customers who use foreign currencies at

    Read more ›

  • Layout Preview Authorization in SAP Business One (Guide)

    Layout Preview Authorization in SAP Business One (Guide)

    December 23, 2021

    Layout Preview Authorization in SAP Business One (Guide)

    In SAP Business One, each marketing document can have more than 1 layout, and the user can access it from menu File > Preview Layout, and any layout that can be used for each document will appear, where the designation

    Read more ›

  • Substitute Authorizer in SAP B1: Faster Approval Process

    Substitute Authorizer in SAP B1: Faster Approval Process

    December 9, 2021

    Substitute Authorizer in SAP B1: Faster Approval Process

    In office operations, a supervisor or manager sometimes has to take time off, whether it is planned or for personal reasons. At that time the manager may have difficulty do approval for some documents. SAP Business One recognizes this and

    Read more ›

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