SAP Business One Consultants | IT Support | 0843 886 1449

All posts in SAP Business One News

The latest SAP Business One News. Find out what is going on with SAP B1, Crystal Reports, HANA for Business One and more with 1 Dash 1.

Get The Most Out Of SAP Business One

You have been using SAP Business One for some time; it could be months or years – but are you getting the most out of your system?

Here are a list of questions to ask yourself:

  • Are you using spreadsheets for a system process?
  • Are your reports giving you data that you have to then transfer to Excel or Word before they are submitted to someone else?
  • Are you calculating VAT outside of SAP Business One?
  • Are you calculating anything outside of SAP Business One?
  • Do you enter payments manually into your bank?
  • Are you sending documents one by one via post or email?
  • Are you missing data within SAP Business One that you need?
  • Do you run multiple Companies but do not have inter company reports at a button click?
  • Are you missing links between Sales and Customer service?
  • Are you missing vital reports that could save time and money?
  • Are your transactions taking more than 20-30 seconds to enter into SAP Business One?
  • Are your processes confusing or cumbersome?
  • Are you missing information that you can’t get to in 10 seconds?
  • Are you missing documented business processes?
  • Are your users not getting the most out of the system?

If you answered yes to any or all of the questions above then you can benefit from a visit for a system tune up, report writing and a process/ system improvement session. SAP Business One is a great system which can give you everything you need within seconds – it may just need a few tweaks to get you there. If you think your system can be improved, you’re probably right. Let’s find out together!

Contact us now to organise a session and review of what can be improved.

Call 0843 886 1449 now to find out how a site visit can give you more from your system.


Exciting times! Our SAP Business One support lines are now open!

SAP Business One Support

What’s included in our support services?

  • Telephone Support
  • Email Support
  • Remote Access Support

SAP Business One Support Line

Ad Hoc Support Prices

Only £37.50 + VAT per support call*
Monthly Support

Just £500 + VAT per Month for unlimited users **

<< Check out the Support page in detail here >>


* & ** – See our main support page for more details.

Bookings are now being taken for September and October 2015 so don’t miss out!

Courses available:

  • SAP Business One – All Modules
  • Crystal Reports
  • SQL Queries for SAP Business One
  • Implementation best practices

1 dash 1 can assist you with selecting the best ERP or Accounting software for your business.

SAP Business One V9.1 New Features

The release of SAP Business One V9.1 is THE best version of SAP Business One so far. The new features push the abilities past most – if not all – other Business & Accounting systems! It is an exciting time for existing SAP Business One users and Companies that are looking for a full Business System.


  • Copy & Paste from/ to Excel
  • ‘Zoom’ into the tables in documents e.g. rows to make it easier to view and add Data to the rows
  • Extended Production Functionality
  • Resource Management for Production
  • The ability to ‘switch off’ functionality in the system if not used
  • Extended User authorisations including the ability to ‘group’ users together in an authorisation group to improve efficiency
  • A whole host of other new/extended functionality!!

Read the full document here


Warning: fsockopen(): unable to connect to (Connection timed out) in /homepages/35/d344059352/htdocs/1dash1/wp-content/plugins/sweetcaptcha-revolutionary-free-captcha-service/library/sweetcaptcha.php on line 81

SAP Business One Year End Closing Instructions

SAP kindly provide a 50 page document which provides in depth instructions on the Year End process but most people only need to know how to run the actual Year End process in SAP B1.  Because it is a once yearly procedure, it is forgotten year to year. Here are the instructions for running the Year End process in Business One.

Year End Process in SAP B1

To carry forward the balances of the P&L accounts to the corresponding account in the balance sheet
(or several different balance sheets), you can use the period-end closing function. You can store the
results initially as a report and then post them at a later stage.
If you make postings after entering the balances carried forward, you need to restart the period-end
closing routine to include these subsequent postings.

Administration / Utilities / Period-End Closing

When you execute the report, the Period-End Closing window opens:

In the Period-End Closing – Selection Criteria window, you can specify the same account
in the Retained Earnings Account and the Period-End Closing Account fields.

Once you have executed the period-end closing for the selected expenses and revenue accounts, 2
transactions are created for each account and 2 journal entries are automatically created to reflect
those transactions.
The balances of those P&L accounts are posted to the period-end closing account on the same day
(the last day of the period) and the balances are reduced to zero. The first journal entry reflects this.
On the first day of the subsequent period, the period-end closing account is posted to the
corresponding balance carried forward to the retained earnings account in the balance sheet. The
second journal transaction reflects this.

The balance of the period-end closing account is zero.

This is how to run the SAP Business One Year End Process.


Contact Stuart Folley @ 1Dash1 if you have any questions or suggestions.

    Your Name (required)

    Your Email (required)

    Your Telephone

    Your Company


    Your Message



    We like to make things really simple to avoid confusion. Have a look at this quick vid and see it helps a bit. Although we install SAP Business One I guess our real talent is helping businesses improve their processes along the way.

    Any questions please contact us by from our contact page, at, phone (at the top of the page) or carrier pigeon 🙂


    Sage Line 50 Upgrade

    Warning: fsockopen(): unable to connect to (Connection timed out) in /homepages/35/d344059352/htdocs/1dash1/wp-content/plugins/sweetcaptcha-revolutionary-free-captcha-service/library/sweetcaptcha.php on line 81

    Most young or Start Up businesses buy Sage Line 50 but soon find that they outgrow the functionality available. Not to fear!

    Upgrade from Sage Line 50 to SAP Business One and save 15%

    If your small or medium sized business is running on Sage Line 50 then you can upgrade to the functionality rich SAP Business One software suite which will grow with your business as it grows… and grows. With integrated accounting (incl multi-currency, advanced nominal structure), stock control including Serial and Batch numbering and multiple warehouses, customer relationship management, production, sales and purchasing (plus much more!).

    Sage Line 50 Upgrade

    A Slice of life

    If we could, we’d give you the software because we know it will help your business. That’s quite a statement but you can benefit and we can show you how.

    With an amazing offer like this, is it worth missing out on something so good?

    This offer has a limited time period so get in touch now!

    …maybe you’d like SAP Business One HANA? Instant processing with In-memory computing. Want to know more?

      Your Name (required)

      Your Email (required)

      Your Telephone

      Your Company


      Your Message


      Warning: fsockopen(): unable to connect to (Connection timed out) in /homepages/35/d344059352/htdocs/1dash1/wp-content/plugins/sweetcaptcha-revolutionary-free-captcha-service/library/sweetcaptcha.php on line 81

      Are you getting the best support for your SAP Business One system?

      SAP B1 customers generally ask this question whether it is due to certain issues taking some time to be solved, a business requirement that hasn’t quite been provided within the software or occasionally due to a breakdown in the relationship between the customer and the SAP Partner that provides them with support.

      Can you have a field that does this?
      Would it be possible to do that?
      My VAT report doesn’t include a Tax Code that I want it to.
      Is it possible to see which Customer pays the fastest?

      We hear all of the questions and we provide the answers.

      1 Dash 1 offers support to solve the problems you need solving. Fast, effective and efficient. It’s what you want and it’s what we provide, naturally.  We listen to your questions and we will provide an answer by phone, email, text or carrier pigeon if required!

        Your Name (required)

        Your Email (required)

        Your Telephone

        Your Company


        Your Message


        Warning: fsockopen(): unable to connect to (Connection timed out) in /homepages/35/d344059352/htdocs/1dash1/wp-content/plugins/sweetcaptcha-revolutionary-free-captcha-service/library/sweetcaptcha.php on line 81

        If you are interested in writing your own SQL queries for SAP Business One the following will assist you.

        Basics of SQL Writing for SAP Business One

        SQL query and related terms

        Before going into the details of SQL query, I would like to briefly introduce some basic database concepts because SQL is a database language for managing data in Relational Database Management Systems(RDBMS).


        RDBMS is a Database Management System that is based on the relation model. Relational here is a key word for RDBMS. You will find that data is stored in the form of Tables and the relationship among the data is also stored in the form of tables for RDBMS.


        Table is a key component within a database. One table or a group of tables represent one kind of data. For example, table OSLP within SAP Business One holds all Sales Employee Data. Tables are two-dimensional data storage place holders. You need to be familiar with their usage and their relationships with each other. If you are familiar with Microsoft Excel, the worksheet in Excel is a kind of two-dimensional table.

        Table is also one of the most often used concepts. Relationships between each table may be more important than tables themselves because without relation, nothing could be of any value. One important function within SAP Business One is allowing User Defined Table (UDT). All UDTs start with “@”.

        SAP Business One training


        A field is the lowest unit holding data within a table. A table can have many fields. It is also called acolumn. Field and column are interchangeable. A table is comprised of records, and all records have the same structure with specific fields. One important concept in SAP Business One is User Defined Field(UDF). All UDFs start with U_.


        SQL is often referred to as Structured Query Language. It is pronounced as S-Q-L or as the word “Sequel”. There are many different revisions and extensions of SQL. The current revision is SQL: 2008, and the first major revision is SQL-92. Most of SQL extensions are built on top of SQL-92.


        Since SAP Business One is built on Microsoft SQL Server database, SQL here means Transact-SQL or T-SQL in brief. It is a Microsoft’s/Sybase’s extension of general meaning for SQL.

        Subsets of SQL

        There are three main subsets of the SQL language:

        • Data Control Language (DCL)
        • Data Definition Language (DDL)
        • Data Manipulation Language (DML)

        Each set of the SQL language has a special purpose:

        • DCL is used to control access to data in a database such as to grant or revoke specified users’ rights to perform specified tasks.
        • DDL is used to define data structures such as to create, alter, or drop tables.
        • DML is used to retrieve and manipulate data in the table such as to insert, delete, and update data.Select, however, becomes a special statement belonging to this subset even though it is a read-only command that will not manipulate data at all.


        Query is the most common operation in SQL. It could refer to all three SQL subsets.

        You have to understand the risks of running any Add, Delete, or Update queries that could potentially alter system tables even if they are User Defined Fields. Only SELECT query is legitimate for SAP Business One system table.

        The above extract provides the basics of SQL, to read the full article, read it here.


        SAP Business One table for SQL Report writing


        DunningLetters Dunning levels definition ODUN
        Recipients Message recipient list AOB1
        Messages Messages OALR
        Currencies Currency codes OCRN
        UserPermissionTree User authorizations for add-on forms OUPT
        UserPermissionForms User permission forms UPT1
        Users Users of SAP Business One application OUSR
        UserPermission User authorizations USR3
        AddonChecking(SBO-COMMON Database Only runned this table) Overall Addon Path Defining SARI
        User Queries User Queries OUQR


        Budget Budget management OBGT
        Budget_Lines Budget item details of an account BGT1
        BudgetDistribution Budget distribution methods OBGD
        BudgetScenarios Budget scenarios OBGS
        ChartOfAccounts G/L accounts OACT
        JournalVouchers Journal vouchers OBTD
        JournalEntries_Lines Journal transaction – rows JDT1
        JournalEntries Journal transaction OJDT
        SalesTaxAuthorities Sales tax jurisdictions OSTA
        SalesTaxAuthoritiesTypes Sales tax authority types OSTT
        SalesTaxCodes Inclusive sales tax codes OSTC

        Marketing Documents and Receipts
        (Sales Opportunities, Sales A/R, and Purchasing A/P)

        Document_Lines Delivery note rows DLN1
        Document_LinesAdditionalExpenses Delivery note rows – expenses DLN2
        DocumentsAdditionalExpenses Delivery note – expenses DLN3
        AdditionalExpenses Defines additional expenses OEXD
        Document_Lines Draft – rows DRF1
        Document_LinesAdditionalExpenses Draft rows – expenses DRF2
        DocumentsAdditionalExpenses Draft – expenses DRF3
        Document_Lines Invoice – rows INV1
        Document_LinesAdditionalExpenses Invoice rows – expenses INV2
        DocumentsAdditionalExpenses Invoice – expenses INV3
        Document (oDeliveryNote) Delivery – header ODLN
        Documents Drafts – header ODRF
        Documents (oInvoice) Invoice – header OINV
        Document (oPurchaseInvoices) AP invoice – header OPCH
        Document (oPurchaseDeliveryNotes) Goods receipt purchase order – header OPDN
        Document (oPurchaseOrders) Purchase order – header OPOR
        Document (oQuotation) Quotation – header OQUT
        Document (oReturn) Returns – header ORDN
        Document (oOrder) Order – header ORDR
        Document (oCreditNote) AR credit memo – header ORIN
        Document (oPurchaseCreditNotes) AP credit memo – header ORPC
        Document (oPurchaseReturns) Goods return – header ORPD
        Document_Lines AP invoice – rows PCH1
        Document_LinesAdditionalExpenses AP invoice rows – expenses PCH2
        DocumentsAdditionalExpenses AP invoice – expenses PCH3
        Document_Lines Goods receipt purchase order – row PDN1
        Document_LinesAdditionalExpenses Goods receipt purchase order rows – expenses PDN2
        DocumentsAdditionalExpenses Goods receipt purchase order – expenses PDN3
        Document_Lines Purchase order – rows POR1
        Document_LinesAdditionalExpenses Purchase order rows – expenses POR2
        DocumentsAdditionalExpenses Purchase order – expenses POR3
        Document_Lines Quotation – rows QUT1
        Document_LinesAdditionalExpenses Quotation rows – expenses QUT2
        DocumentsAdditionalExpenses Quotation – expenses QUT3
        Document_Lines Returns – rows RDN1
        Document_LinesAdditionalExpenses Return rows – expenses RDN2
        DocumentsAdditionalExpenses Returns – expenses RDN3
        Document_Lines Order – rows RDR1
        Document_LinesAdditionalExpenses Order rows – expenses RDR2
        DocumentsAdditionalExpenses Order – expenses RDR3
        Document_Lines Credit memo – rows RIN1
        Document_LinesAdditionalExpenses Credit memo rows -Expenses RIN2
        DocumentsAdditionalExpenses Credit memo – expenses RIN3
        Document_Lines AP credit memo – rows RPC1
        Document_LinesAdditionalExpenses AP credit memo rows – expenses RPC2
        DocumentsAdditionalExpenses AP credit memo – expenses RPC3
        Document_Lines Goods return – rows RPD1
        Document_LinesAdditionalExpenses Goods return rows – expenses RPD2
        DocumentsAdditionalExpenses Goods return – expenses RPD3
        BatchNumbers Batch number for item OIBT
        Industries Industries list for sales opportunities OOND
        Relationships Relationships for sales opportunities OORL
        SerialNumbers Serial numbers for items OSRI
        WithholdingTaxData Withholding tax data INV5
        TaxInvoices (botit_Invoice) Master header data of a tax invoice of sales document OTSI
        TaxInvoice_Lines (botit_Invoice) Tax invoice of sales document – rows TSI1
        TaxInvoices (botit_Payment) Master header data of a tax invoice of purchase document OTPI
        TaxInvoice_Lines (botit_Payment) Tax invoice of purchase document – rows TPI1
        TaxInvoices (botit_JournalEntry) Master header data of a tax invoice of journal entry document OTXD
        TaxInvoice_Lines (botit_JournalEntry) Tax invoice of journal entry document – rows TXD1

        Business Partners

        ActivityLocations Business partner activity locations OCLO
        ActivityStatus Statuses for Task type activities OCLA
        ActivityTypes Business partner activity types OCLT
        AlternateCatNum Customer or vendor catalog number OSCN
        BusinessPartners Business partners OCRD
        BPAddresses Business partner addresses CRD1
        BPPaymentMethods Business partner payment methods CRD2
        BPAccountReceivablePayble Business partner account receivable payable CRD3
        BPWithholdingTax Business partner withholding tax CRD4
        BPPaymentDates Business partners payment dates CRD5
        BPBankAccounts Business partners bank accounts OCRB
        Contacts Contact customers and vendors OCLG
        ContactEmployees Contact persons OCPR
        SalesOpportunities Sales opportunities OOPR
        SalesOpportunitiesLines Sales opportunity – rows OPR1
        SalesOpportunitiesPartners Sales opportunity partners OPR2
        SalesOpportunitiesCompetition Sales opportunity competition OPR3
        SalesOpportunitiesInterests Sales opportunity interests range OPR4
        SalesOpportunitiesReasons Sales opportunity failure reasons OPR5
        Territories Territory segmentations OTER

        Inventory and Production

        Document_Lines Goods issue – rows IGE1
        Document_LinesAdditionalExpenses Goods issue rows – expenses IGE2
        DocumentsAdditionalExpenses Goods issue – expenses IGE3
        Document_Lines Goods receipt – rows IGN1
        Document_LinesAdditionalExpenses Goods receipt rows – expenses IGN2
        DocumentsAdditionalExpenses Goods receipt – expenses IGN3
        Document (oInvetoryGenExit) Goods issue OIGE
        Document (oInvetoryGenEntry) Goods receipt OIGN
        StockTransfer Stock transfers OWTR
        StockTransfer_Lines Stock transfers – rows WTR1
        ProductTrees_Lines Product tree – child ITT1
        ProductTrees Product tree OITT
        WorkOrders Work instructions OWKO
        WorkOrder_Lines Work instructions – rows WKO1
        Items_Prices Items – prices ITM1
        Items Items OITM
        ItemWarehouseInfo Items – warehouse OITW
        ItemGroups Item groups definition OITB
        MaterialRevaluation Stock revaluation OMRV
        MaterialRevaluation_Lines Stock revaluation – rows MRV1
        PackagesTypes Package types for deliveries OPKG
        PriceLists Price lists management OPLN
        StockTaking Items – warehouse OITW
        SpecialPrices Special prices OSPP
        SpecialPricesDataAreas Special prices for specified periods SPP1
        SpecialPricesQuantityAreas Special prices for specified quantities SPP2
        Warehouses Warehouses definition OWHS


        SalesForecast Sales forecast OFCT
        SalesForecast_Lines Sales forecast – rows FCT1


        Payments Receipt ORCT
        Payments Vendor payment OVPM
        Payments_Checks Receipt – checks RCT1
        Payments_Invoices Receipt – invoices RCT2
        Payments_CreditCards Receipt – credit vouchers RCT3
        Payments_Accounts Receipt – account list RCT4
        Payments_Checks Payments – check rows VPM1
        Payments_Invoices Payments – invoices VPM2
        Payments_CreditCards Payments – credit memos VPM3
        Payments_Accounts Payments – list of accounts VPM4
        ChecksforPaymentLines Checks for payment – rows CHO1
        BankPages External bank statement OBNK
        ChecksforPayment Check for payment OCHO
        PaymentTermsTypes Payment term types OCTG
        PaymentRunExport Payment results table OPEX
        PaymentRunExport_Lines Payment results table – rows PEX1
        BillOfExchange Bill of exchange table OBOE
        BillOfExchangeTransaction Bill of exchange transactions table OBOT
        BillOfExchangeTransaction_Lines Bill of exchange transactions table – rows BOT1


        ContractTemplates Contract template (CRM) OCTT
        CustomerEquipmentCards Customer equipment card OINS
        KnowledgeBaseSolutions Knowledge base solution OSLT
        Queue Queues list for assigning to a service calls OQUE
        QueueMembers Queue member users QUE1
        ServiceContracts Service contract OCTR
        ServiceContracts_Lines Service contract – rows CTR1
        ServiceCalls Service call OSCL
        ServiceCallActivities Service call activities OCLG
        ServiceCallInventoryExpenses Service call inventory expenses INV1

        Human Resources

        EmployeesInfo Employees information OHEM
        EmployeeAbsenceInfo Employee absence information HEM1
        EmployeeEducationInfo Employee education HEM2
        EmployeeReviewsInfo Employee reviews HEM3
        EmployeePrevEmpoymentInfo Employee previous employment information HEM4
        EmployeeRolesInfo Employee rolls information HEM6
        Teams List of teams OHTM
        TeamMembers Employee membership role in a team HTM1
        If you would like to receive SQL report writing training for SAP Business One, contact 1 Dash 1 by entering your details below or calling us on 0844 858 1080.

          Your Name (required)

          Your Email (required)

          Your Phone


          Training Course Topic

          Your Message