• SAP-Business-One-Tips-Set-Exchange-Rate-for-purchasing-document

    How to Set Exchange Rate for Purchasing in SAP B1

    April 7, 2020

    How to Set Exchange Rate for Purchasing in SAP B1

    Foreign currencies always raise the level of complexity in business. There are the initial settings of currencies, accounts, and business partners, the ongoing maintenance of exchange rate table, an much more. Since exchange rates can be very dynamic, the dates…

    Read more ›

  • SAP Business One Tips Attach Document to Project

    SAP B1 Document Attachment in Project Management

    April 2, 2020

    SAP B1 Document Attachment in Project Management

    Did you know, every time we make a SAP Business One document for a project and we include information / name of the project when making a document, then SAP Business One will automatically suggest you to link the document…

    Read more ›

  • SAP Business One Tips Multiple Landed Cost in GRPO

    SAP B1 Multiple Landed Cost in GRPO Guide

    March 31, 2020

    SAP B1 Multiple Landed Cost in GRPO Guide

    Some companies that purchase inventory with the help of third-party vendors usually have additional costs for services provided that affect the item cost of the purchased inventory. By default landed cost for goods receipt PO (GRPO) can only be done…

    Read more ›

  • SAP Business One Tips Cash Discount in Payment

    Cash Discount in Payment Terms: Definition & Examples

    March 26, 2020

    Cash Discount in Payment Terms: Definition & Examples

    In a business, there are several ways to increase cash inflows to the company, one of which is by giving offers to customers and luring them to make early payments. Frequently used offers are special discounts for customers who make…

    Read more ›

  • SAP Business One Tips Accessing Menu Using Lookup Menu

    Efficient SAP B1 Menu Access via Lookup Search

    March 24, 2020

    Efficient SAP B1 Menu Access via Lookup Search

    When you forget navigation to a menu in SAP Business One because you rarely use it or you don’t know where the menu is, you can use “Lookup Menu” feature in SAP Business One. This is a simple feature that…

    Read more ›

  • SAP Business One Tips Update Manual Journal Entry

    How to Update Manual Journal Entry Numbering for Accurate Financial Posting

    March 19, 2020

    How to Update Manual Journal Entry Numbering for Accurate Financial Posting

    If a company uses a different numbering series each year, it is required to manually change the document series for JE numbering, because the system does not make automatic changes specifically for Journal Entry. Example: 2019 uses the 19-JE series,…

    Read more ›

  • SAP BusinessOne Tips Make Popup Reapear

    SAP B1: Restore Confirmation Pop-Up Messages Re-Appear

    March 17, 2020

    SAP B1: Restore Confirmation Pop-Up Messages Re-Appear

    SAP Indonesia Tips – Have you ever accidentally tick the checkbox on a pop-up message that appear during system operation in SAP Business One? Usually the pop-ups are to notify users that some changes has been made in some field.…

    Read more ›

  • SAP Business One TipsQuery Delivery Order

    SAP B1 Delivery Order Report Query (Header & Detail)

    March 11, 2020

    SAP B1 Delivery Order Report Query (Header & Detail)

    TIPS SAP Indonesia – Sometimes we need to know how many Delivery Order (DO) documents we have created in certain period and the details of those documents in SAP Business One. Maybe the standard Delivery Order (DO) report does not…

    Read more ›

  • SAP Business One Tips ChangeGroup Transaction

    Change Item Group for Items with Transactions

    March 9, 2020

    Change Item Group for Items with Transactions

    Sometimes when inputting a new item master we might make mistakes such as incorrect setting of Group items. If there are no transactions, we can immediately replace them with the correct item group, but what if there are already many…

    Read more ›

  • SAP Business One Tips Setting for Cancelling Document

    Set Max Days to Cancel Marketing Documents in SAP B1

    March 5, 2020

    Set Max Days to Cancel Marketing Documents in SAP B1

    We need to maintain the process of canceling a marketing document. One way to prevent a document from being embedded is to cancel the time limit of the document creation date so that the journal that is formed from the…

    Read more ›

  • SAP BusinessOne Tips Query List of Goods Received

    Custom GRPO Report Query for SAP B1 – Header & Detail

    February 26, 2020

    Custom GRPO Report Query for SAP B1 – Header & Detail

    Tips SAP Indonesia – Sometimes we need to know how many GRPO documents we have created in certain period and the details of those documents in SAP Business One. Maybe standard GRPO information provided from SAP Busines One is not…

    Read more ›

  • SAP Business One Tips Puchase Order from Purchase Request

    Efficient Multi PO / RFQ Creation from Purchase Request Report

    February 24, 2020

    Efficient Multi PO / RFQ Creation from Purchase Request Report

    Tips SAP Indonesia – Purchase Request is a purchase request from the company which, if approved, will be further processed to become Purchase Quotation / Purchase Order. In SAP Business One there is a feature called ‘Purchase Request Report’, used to…

    Read more ›

  • SAP Business One Top 5 Sales Items SQL Query

    SAP Business One Top 5 Sales Items SQL Query

    February 20, 2020

    SAP Business One Top 5 Sales Items SQL Query

    Tips SAP Indonesia – As we know, SAP Business One provide a feature / facilities to make us easier retrieving data from the system using queries to database. In this example, we want to make a report to show the…

    Read more ›

  • Query Sales Order List in SAP Business One (SO Query)

    Query Sales Order List in SAP Business One (SO Query)

    February 19, 2020

    Query Sales Order List in SAP Business One (SO Query)

    Tips SAP Indonesia – As we know, SAP Business One provides a feature / facilities to make it easier for us in retrieving data from the system using queries to the database. In this example, the standard Sales Order report…

    Read more ›

  • Query for List of Purchase Orders (PO) in SAP B1

    Query for List of Purchase Orders (PO) in SAP B1

    February 18, 2020

    Query for List of Purchase Orders (PO) in SAP B1

    Tips SAP Indonesia – As we know, SAP Business One provides a feature / facilities to make it easier for us in retrieving data from the system using queries to the database. In this example, the standard Purchase Order report…

    Read more ›