• Using Formula in Statement of Cash Flow Report

    July 5, 2017

    Using Formula in Statement of Cash Flow Report

    As we know, SAP Business One already provide us a standardize template Statement of Cash Flow. And, you can easily create new line item that consist of some formula.  But, this formula only can work with line items, not for

    Read more ›

    Tagged with:
  • Closing The Period From Any Transactions

    June 28, 2017

    Closing The Period From Any Transactions

    Usually, by the end of a month, the accounting department will validate all transactions created and maybe do some adjustment. Once the process is done, we can close the period so no transaction can be posted to that particular month.

    Read more ›

  • Journal Entry Refrence & Remark Information - SAP B1 Tips

    Journal Entry Reference & Remark Information

    April 27, 2017

    Journal Entry Reference & Remark Information

    For some documents, SAP will automatically create a journal entry with some information referred to the documents. You can setup the Journal Entry reference & remarks information with the information you need from the documents. To setup this, go to

    Read more ›

  • Your Customer = Your Vendor - SAP B1 Tips

    Your Customer = Your Vendor

    April 20, 2017

    Your Customer = Your Vendor

    It’s very common in business where our customer is also our vendor. We sell some of our products or services to them and at the same time we also buy some products or services from them. So we usually create

    Read more ›

    Tagged with:
  • Different Time Bucket for Aging Report

    Different Time Bucket for Aging Report

    April 10, 2017

    Different Time Bucket for Aging Report

    Every finance department in every company or even each finance people in a company, might have different time bucket when analyzing their aging report. So SAP Business One provides the flexibility by providing editable time bucket parameter when you want

    Read more ›

  • Past Date Customer / Vendor Aging Report - SAP B1 Tips

    Past Date Customer / Vendor Aging Report

    April 7, 2017

    Past Date Customer / Vendor Aging Report

    In SAP Business One, sometime you want to checking value GL Account Receivable (Financial – Chart Of Account) and Customer Receivable Aging (Business Partners – Business Partners Reports – Aging – Customer Receivable Aging) with past period or past month.

    Read more ›

  • Confirm Journal Creation Before Commiting Transaction - SAP B1 Tips

    Confirm Journal Creation Before Committing Transactions

    March 30, 2017

    Confirm Journal Creation Before Committing Transactions

    First time using a SAP Business one and totally afraid make an error when inputting transaction? Just use Icon Journal Entry preview (see red box screenshot below) before you add the transaction to avoid a mistake such as wrong Account,

    Read more ›

  • Split BP Line in Payments

    March 23, 2017

    Split BP Line in Payments

    In SAP Business One, journal entry of  customer / vendor payment is showed in one line as summary from many number of payment means used. To reflect the various payment means, and exchange rate differences in the journal entry, you

    Read more ›

  • Item Group Valuation Methods

    March 20, 2017

    Item Group Valuation Methods

    In SAP Business One, There are 3 Item Group Inventory Valuation Methods. They are :   Moving Average – the method is based on the calculation of an average cost for the item in each sales and purchasing transaction. Standard

    Read more ›

  • Only Allow Cash Account in Cash Payment Means

    March 13, 2017

    Only Allow Cash Account in Cash Payment Means

    When we do Incoming Payment in SAP Business one, sometimes we pick up wrong account number in cash payment means. Because SAP Business One give flexibility to choose which account we want to use. To minimize the mistake, we can filter

    Read more ›

    Tagged with:
  • Align Posting of Journal Entries with Marketing Documents – SAP Business One 9.2

    February 21, 2017

    Align Posting of Journal Entries with Marketing Documents – SAP Business One 9.2

    To Provide better audit, SAP Business One 9.2 add feature to Link One row in Marketing Documents to posted as One Row in Journal Entry. Document Settings : Split Journal Entry Posting by Document Lines : – No Split You

    Read more ›

  • Copy total in Balance Due field to Total field in Payment Means using shortcut Ctrl+B in SAP Business One - SAP Business One Tips

    Copy total in Balance Due field to Total field in Payment Means using shortcut Ctrl+B (SAP Business One)

    January 27, 2017

    Copy total in Balance Due field to Total field in Payment Means using shortcut Ctrl+B (SAP Business One)

    Save your time! You can copy the balance due amount in payment means windows to field Total by clicking “CTRL+B”  in SAP Business One Sub Menu Payment Means (Module Outgoing Payment and Incoming Payment). So you won’t miss value again

    Read more ›

  • Past date Report Aging Customer Receivable & Vendor Liabilities SAP Business One

    January 17, 2017

    Past date Report Aging Customer Receivable & Vendor Liabilities SAP Business One

    In SAP Business One, sometime you want to checking value GL Account Receivable (Financial – Chart Of Account) and Customer Receivable Aging (Business Partners – Business Partners Reports – Aging – Customer Receivable Aging) with past period or past month.

    Read more ›

  • Hide Confirmation Of Recurring Windows

    How To Hide Confirmation Of Recurring Windows

    December 8, 2016

    How To Hide Confirmation Of Recurring Windows

    Confirmation of Recurring Windows may not important for some user, however this window show up when the user login to SAP Business One. We can hide this windows by change the setting in the General Setting module. After we change

    Read more ›

    Tagged with:
  • How to Define your Financial Key Performance Indicator (KPI) Factor in SAP Business One - SAP Business One Tips

    How to Define your Financial Key Performance Indicator (KPI) Factor

    November 19, 2016

    How to Define your Financial Key Performance Indicator (KPI) Factor

    With SAP Business One you can define your Financial Key Performance Indicator (KPI) Factor. After defining the KPI, you can put this on Pervasive Analytic Designer and add the KPI on your widget (in Hana version)