• Hidden Option for Manage Item by Batch/Serial

    Can’t Find Manage Option for Manage Item by Batch/Serial

    February 5, 2018

    Can’t Find Manage Option for Manage Item by Batch/Serial

    Have you ever find, that there’s no option for change manage item with batch or serial number on Item Master Data menu? Here’s the scenario: You have few items that you want to add, and that items will be managed

    Read more ›

  • Add New Tab to Your Screen Without UI API (AddOn)

    Add New Tab to Your Screen Without UI API

    February 1, 2018

    Add New Tab to Your Screen Without UI API

    You have a lot of UDF (User Defined Fields) to manage and some of them must be dragged into the main screen for some reason? And the standard tab was already full with various fields, so you will need new

    Read more ›

  • Setup Incoming & Outgoing Differences Allowed

    January 29, 2018

    Setup Incoming & Outgoing Differences Allowed

    You have a lot of reconciliations to do because of miscellaneous outstanding invoice that still open because of small amount of decimals left?? SAP can make your daily job become easier. With “Incoming & Outgoing Differences Allowed” feature on Currencies

    Read more ›

  • Default UoM Details for Length and Weight

    Default Unit of Measure on Item Master Data

    January 25, 2018

    Default Unit of Measure on Item Master Data

    There’s a lot of unit of measure (UoM) types that must be set on SAP. There’s Inventory UoM, Inventory Counting UoM, Sales UoM, Purchase UoM, UoM Group. But first of all, just make sure that you already set for a

    Read more ›

  • Crystal Report Formula Default Value for NULL

    January 22, 2018

    Crystal Report Formula Default Value for NULL

    Crystal Report formula generally used to Count, Summarize, or any other Arithmetic function in Crystal Report. Depends on query result, the value for one of the field either NULL or NOT NULL. The problems are: Formula in Crystal Report wouldn’t

    Read more ›

  • Cancelling Your Closed Credit Memo

    Cancelling Closed A/R Credit Memo

    January 18, 2018

    Cancelling Closed A/R Credit Memo

    Do you know, A/R Credit Memo status will always “Closed” if you created with ‘copy-from’ method, but you can still cancel that document? So, here is an example: You have an A/R Invoice, and linked to A/R Credit Memo to

    Read more ›

  • Incorrect Discount on SO or PO Service Details

    Hidden Discount on PO or SO Service Details

    January 15, 2018

    Hidden Discount on PO or SO Service Details

    When you print your Purchase Order Document, or while creating some A/P Invoice service, and you suddenly find, that there’s a discount on your printed PO or print preview invoice. And, you realize it was a mistake, that PO document

    Read more ›

  • Invoice for Tax-Only Items

    January 11, 2018

    Invoice for Tax-Only Items

    Sometimes, you want to give your customer free-items, but that items still need to be calculated for the tax, depends on your country rules. You don’t need to create a separate invoice, just follow these simple steps: Open A/R Invoice

    Read more ›

  • SAP Tables as Data Source on SAP HANA

    SAP Table as Crystal Report Data Source on HANA Version

    January 8, 2018

    SAP Table as Crystal Report Data Source on HANA Version

    Everyone usually knows a common method for crystal report data source is using “Add command” feature. Now, we’ll explain another method to do the same thing on HANA version, so if you want to know a SQL version, please read

    Read more ›

  • Option for Setting G/L Account on Your SAP

    January 5, 2018

    Option for Setting G/L Account on Your SAP

    As an integrated system, SAP always enabled automatic posting for any transactions, so you need to determine a default G/L account for enabled that automatic posting feature. If you open menu Administration – System Initialization – General Setting, there are

    Read more ›

  • Start a New Year: Create New Posting Period

    January 1, 2018

    Start a New Year: Create New Posting Period

    Happy New Year !! It’s time to create a new posting period on your SAP system. But first, make sure that you already finished customizing your G/L Account Determination and had a period indicator for a next year (you can

    Read more ›

  • Period End Closing on SAP B1

    December 29, 2017

    Period End Closing on SAP B1

    There are 2 types of Period End Closing on SAP B1: Monthly Closing and Year End Closing. IMPORTANT: Please backup your current database first, before you doing this steps for Period End Closing and Fiscal Year Changes. Open the Exhange

    Read more ›

  • SAP Table as Crystal Report Data Source

    December 25, 2017

    SAP Table as Crystal Report Data Source

    Now we’ll let you know how to make the custom report with Crystal Report more easily. Crystal Report can have SAP Table as Data source beside Query via Add Command features. Table will display all fields available at those tables.

    Read more ›

  • Backorder Qty Vs Open Order Qty

    December 21, 2017

    Backorder Qty Vs Open Order Qty

    If you look closely on Sales Order table detail (RDR1), there are multiple columns that show about your quantities. Sometimes it will make you confused, what’s the differences between that columns. Backorder Qty always showing the open quantities of your

    Read more ›

  • Cancelling Your SO or PO with Open Item List

    December 18, 2017

    Cancelling Your SO or PO with Open Item List

    Open Item List Reports as one of the most viewed reports in SAP Business One, comes with a lot of enhancement on SAP version 9.2 patch level 05. Now, you can easily cancel or close multiple documents at once by

    Read more ›