SAP Business One Consultants | IT Support | 0843 886 1449

All posts tagged SAP Business One Consultants

SAP Business One 9.0 Business Accounting System

SAP Business One 9.0 Advanced GL Account Determination

SAP Business One 9.0 provides a flexible and centralised system to manage inventory G/L account determination. With the advanced G/L determination rules, you can assign inventory G/L accounts by item groups, items, warehouses, business partner groups, ship-to countries, and various combinations of all the above criteria.


SAP Business One 9.0 Financials

Deferred Tax Enablement in Manual JE

SAP Business One 9.0 enables you to manage deferred tax in manual journal entries, journal vouchers, posting templates, and recurring postings


SAP Business One 9.0 Fixed Assets

SAP Business One 9.0 allows you to manage fixed assets using a fully integrated solution. In addition to the functions provided by the Fixed Asset Solution in SAP Business One 8.82, the fixed assets functionality implemented in SAP Business One 9.0 enables you to do many things that were out of reach with previous versions of SAP Business One.

In order for you to better manage your fixed assets in SAP Business One, SAP Business One 9.0 has also enhanced some functionality from the add-on, such as the use of the ‚ ‘Declining Balance‛‚ ‘Special Depreciation‛, and ‘Multilevel‛ depreciation methods, depreciation forecast, depreciation run, asset history sheet, and so on.


Internal Reconciliation in SAP Business One 9.0

The internal reconciliation functionality has been enhanced to support the following system currency aspects:

  • When performing internal reconciliation, conversion difference postings are automatically created
  • You can display system currency balances due, in various windows, and reports
  • The Conversion Differences report has been enhanced with an optimised calculation of the unrealised conversion difference


SAP Business One 9.0 Sales and Purchasing

Cancellation of Sales and Purchasing Documents

You can now cancel most sales and purchasing documents that normally trigger postings. Upon cancelling such a document, a corresponding cancelation document is created to reverse the associated accounting, tax, and inventory changes. The base documents belonging to the cancelled documents are reopened with balances due restored. You can now copy these base documents to new documents.


Adjusting Total Freight in Goods Receipt POs Based on A/P Reserve Invoices

SAP Business One 9.0 supports adjustment of the total freight when creating a goods receipt PO based on A/P reserve invoices under the following conditions:

  • The freight of the goods receipt PO does not exceed the unallocated freight of the base A/P reserve invoices
  • If you have allocated all open quantities of the base A/P reserve invoices to this goods receipt PO, you must allocate all the remaining freight of the reserve invoices to the goods receipt PO

Adjusting Item Cost in Non-Based A/R Return and A/R Credit Memo

The item cost in non-based A/R return and an A/R credit memo is determined by item cost at the time of the document creation. Starting from SAP Business One 9.0, the user can adjust the item cost in these documents. This enhancement applies only to items managed by Moving Average Price or FIFO methods.


SAP Business One 9.0 Banking

Payment, Cheque, and Deposit Cancellation Improvements

With SAP Business One 9.0, you are able to do the following:

  • Cancel incoming payments with deposited cheques
  • Cancel deposits partially
  • Cancel deposited cheques
  • Cancel non-deposited cheques with automatic journal entries


Down Payment Request Reconciliation

SAP Business One 9.0 enables you to manually reconcile, fully or partially, a payment of down payment request with an invoice (regular invoice or reserve invoice, correction invoice is not supported).


SAP Business One 9.0 Inventory

Bin locations in SAP Business One 9.0 allows you to manage bin locations for your warehouses. You can enable the bin location function for individual warehouses.


Bin Location Related Documents

After you enable the bin location function for intended warehouses, you need to record bin locations in those warehouses for all receipts and issues of inventory, including the processing of the following documents or transactions:

  • Goods receipt PO, goods return, A/P invoice, A/P credit memo, delivery, return, A/R invoice, A/R invoice + payment, A/R credit memo
  • Goods receipt, goods issue, inventory transfer, inventory taking
  • Receipt from production, issue for production
  • Pick and Pack

During the receipt, issue, and transfer of goods, SAP Business One 9.0 lets you automate the process of allocating goods from and to bin locations. You also can perform the allocation manually.


Inventory in Bin Locations

To better manage the inventory in your bin locations, SAP Business One 9.0 enables you to do the following:


  • View the information of stored items, such as the item quantity, and number of items
  • Restrict the storage of your bin locations, for example, to a particular batch, item, or item group
  • Restrict the use of your bin locations, for example, to receiving or issuing goods only
  • Replenish the inventory in your bin locations if the inventory level falls below the minimum

Bin Location Management

To facilitate the management of bin locations, SAP Business One 9.0 supports the generation, update, and deletion of bin locations in batches.


Serials and Batches

SAP Business One 9.0 lets you maintain serials and batches in your bin locations. When you issue serials and batches from bin locations, you can decide whether you want to pick the items according to their bin locations, or their serial and batch information.SAP Business One 9.0 lets you maintain serials and batches in your bin locations. When you issue serials and batches from bin locations, you can decide whether you want to pick the items according to their bin locations, or their serial and batch information.


Receiving Bin Locations
SAP Business One 9.0 allows you to designate certain bin locations as receiving bin locations. When you receive goods, these goods can first be automatically placed in receiving bin locations.



You can get an overview of all bin locations, and check the inventory statuses and movements in bin locations using the following reports:


  • Bin Location List
  • Bin Location Content List
  • Inventory Posting List

Multiple Unit of Measurement (UoM) in SAP Business One 9.0

SAP Business One 9.0 provides a high degree of flexibility to your management of products in multiple units of measurement (UoM). The Multiple UoM feature enables you to sell, purchase, receive and ship products in any UoM that your business needs, and to define default UoMs for various types of transactions. All sales and purchasing documents support items with multi-UoM definitions.The highlights of this new feature are as follows:

  • Unlimited global and product-specific UoMs
  • Setup of UoM groups with conversion rules between base UoMs and alternative UoMs within the groups
  • These UoM groups are used in item master data, marketing documents, and inventory documents
  • Default sales UoMs, purchasing UoMs, inventory UoMs, and automatic conversion to other applicable UoMs in transaction processing
  • Related enhancement of packaging, bar code and pricing functions:
  • Package settings for multiple UoMs are incorporated into item master data and are used in sales documents to recommend the number of packages
  • For an item using multiple UoMs, you can define multiple bar codes and different prices for each of its UoMs

Note that production transactions are processed in a single inventory UoM.

Price List and Discount Enhancements

In SAP Business One 9.0, the price list and the discount-groups functionality has been enhanced to improve efficiency and to support specific business processes. Using the enhanced price list function you can now do the following:

  • Assign a price list to a business partner group
  • Define multiple currency prices in a specific price list or in a special prices list
  • Define prices and special prices for different units of measurement, of a specific item
  • Define price lists as active or inactive

In addition, you can now decide whether to remove un-priced items from the database in order to reduce the database size and impact on performance when running applications on the database.Using the enhanced discount groups function you can now do the following:

  • Define discount groups for all business partners, for customer groups or for vendor groups
  • Define discounts for specific items
  • Define variable discounts based on quantity bought
  • Define discount groups as active or inactive
  • Define discountable control for a business partner and for an item
  • Allocate multiple discounts

You can get an overview of all prices and discounts using the following reports:

  • Price report
  • Discount report

These reports are also available from within marketing documents, enabling the user to track the source price and discount of each item during document creation.

Serial and Batch Items in Drop Ship Warehouses

SAP Business One 9.0 now lets you manage serial and batch items in drop ship warehouses. After you enable the serial and batch management for your drop ship warehouses, you can do the following:

  • Allocate serial and batch items in drop ship warehouses to newly created documents. The documents include the following:
  • Sales order, delivery, return, A/R invoice, A/R invoice + payment, A/R credit memo, A/R Debit Memo, A/R reserve invoice
  • Goods receipt PO, goods return, A/P invoice , A/P credit memo, A/P Debit Memo
  • Maintain the serial and batch information for items in drop ship warehouses using Serial Number Management and Batch Management
  • View the transactions of the serial and batch items in drop ship warehouses using Serial Number Transactions Report and Batch Number Transactions Report

In addition, if your serial items in drop ship warehouses are delivered, SAP Business One can create customer equipment cardsautomatic
ally for these items in the same way as for the items in non-drop ship warehouses.

Inventory Tracking

SAP Business One 9.0 provides new capabilities for running a complete inventory taking process. It starts with cycle counting alerts and continues with well-structured tasks and innovated reporting.Major enhancements include the following:

  • Providing documents to record and manage inventory counting and inventory posting
  • Freezing items during inventory counting
  • Recording counting results and variance by two different inventory takers
  • Improving the cycle count function to enable continuation of counting process from cycle count alerts and recommendations
  • Counting the exact serial numbers and batches
  • Supporting inventory taking for bin locations
  • Providing inventory-taking reports to consolidate and analyse existing inventory counting and inventory posting documents
  • Providing an Inventory Counting Recommendation dashboard report
  • Providing documents to record and manage inventory opening balances
  • Counting by unit of measurement

SAP Business One Missing Months / Periods in Reports

Have you run a Balance Sheet, Profit and Loss or Trial Balance in B1 V8.1, 8.2 or a recently upgraded V9 and discovered that you are missing periods or months from the report? Weird, eh? It is as much use as an Octopus tentacle snooker cue, but don’t worry, it can be fixed!

The issue appeared in V8.x and is fixed in V9. The problem is, you upgrade V9 and the problem still exists. The problem has been fixed and will not occur again but you need to fix the cause of the issue to see the months again. All this requires is a quick fix to a users settings.

  1. Find the formid, itemid of the problematic grid
    a) Open SBO, find the problematic grid in a form
    b) Enable the System/Debug information(Go to Menu->View, check System/Debug information)
    c) Put the mouse on any field of the problematic grid, find the formid (The number after ‘Form=’) and the itemid(The number after ‘Item=’) on the status bar at the left bottom of SBO
    d) Record this formid and itemid
  2. Close SBO. Make sure no SBO clients are connected to the server. (This step is very important! If SBO is not closed, this solution will not work!)
  3. Open SQL Analyzer, run the update query below

Open SQL Analyzer, run the update query below.
Before running the query, do please replace:
/!Formid found in Step 1!/ to the formid found in step 1.
/!Itemid found in Step 1!/ to the itemid found in step 1.
/!Problematic User Code!/ to the user code of problematic user.
–delete all the user settings
delete cprf where formid=’/!Formid found in Step 1!/’ — for this form
and itemid=’/!Itemid found in Step 1!/’ — and this document
and usersign =
select internal_k from ousr where
user_code = ‘/!Problematic User Code!/’
–endMissing months financial report fix


ERP SAGE SAP B1 Implementation Consultant

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

Senior Implementation Consultant – SAP Business One (SAP B1 )

Home Based in Bedfordshire, Buckinghamshire, Cambridgeshire, Hertfordshire, Surrey, Oxfordshire, Northamptonshire
£35k – £50k + Bens

  • SAP Business One (SAP B1)
  • Implementation Consultant
  • SAP Business One Certified
  • ERP
  • Project Definition & Costing
  • Project Life Cycle
  • Pre-Sales
  • Data Migration
  • Installation 
  • Configuration
  • Product Training
  • Accounting background (ideally AAT)
  • SQL
  • CRM
  • SQL Server
  • Crystal Reports
  • DTW

ERP SAGE SAP B1 Implementation Consultant

Senior Implementation Consultant – SAP Business One, SAP B1

A Senior SAP Business One (SAP B1) implementation consultant is required by 1 dash 1.
We want an experienced and enthusiastic SAP B1 Senior Consultant with an ERP/ SAP Business One implementation background to join our team. An Accounting background would be an advantage.

ERP Consultant?

Do you have skills?


Do you know the difference between Net and Gross Profit?

As a SAP B1 certified Consultant you will have a proven and demonstrable track record in all aspects of the project life-cycle of SAP Business One implementations.

Your duties will include Pre-Sales, project definition and costing, installation and configuration, and training. Coupled with this, strong knowledge of Microsoft Windows operating systems and Microsoft Office products is essential for the successful Implementation Consultant. You’ll understand the accounting needs of an organisation from general accounting, A/R, A/P, ordering process and configuration, production, stock, delivery and distribution, and CRM.

Naturally you’ll have superb communication Skills and pride yourself in your consultative approach.

If you can convince us that you deserve the job, you’ll get it.

Rewards, bonuses and other incentives are on offer for the right SAP Business One consultant. If you have a background in ERP consultancy in Sage, Access, Dynamics or the larger ERP suites from SAP or Oracle – we still want to hear from you.

Enter your details below or send an email to

    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

    Using variables in SQL queries for SAP Business One is straight forward for simple select statements but what about the more complex variables or if you want to declare a variable for your SQL?

    Answer: You have to get a bit more creative! See the example below.

    To select a from and to date as a variable in a declare statement you have to add a nifty bit of extra code.


    /SELECT FROM [dbo].[VPM1] T0/

    declare  @fromdate as datetime

    /* WHERE */

    set @fromdate = /* T0.DueDate */ ‘[%0]’


    /SELECT FROM [dbo].[VPM1] T1/

    declare  @tilldate as datetime

    /* WHERE */

    set @tilldate = /* T0.DueDate */ ‘[%1]’



    select  OVPM.docnum, VPM1.dueDate,VPM1.CheckNum, VPM1.Branch,

    VPM1.BankCode, VPM1.CheckSum, OVPM.CardName,


    when OPCH.docnum is null then VPM2.docEntry

    else OPCH.docnum

    end as ‘docnum’

    from OVPM INNER join VPM1 on OVPM.docnum = VPM1.docnum

    left join  VPM2 LEFT JOIN OPCH ON VPM2.DocEntry = OPCH.DocEntry

    on OVPM.docnum = VPM2.docnum

    where OVPM.Canceled = ‘N’ AND VPM1.DueDate >=@fromdate AND

    VPM1.DueDate <=@tilldate



    1 Dash 1 can provide you and your SAP Business One users with excellent training of the usage of SQL and Crystal Reports. If you would like to find out more simply enter your details in the boxes below or call us.

      Your Name (required)

      Your Email (required)

      Your Phone


      Training Course Topic

      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

        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

        We are currently taking bookings for training courses throughout August 2013. Our training courses can either be on your site for a maximum of 8 people or at an external location suitable for attendees from various companies.

        On site training is excellent for your employees as it will be specific to your system as it will be based on your Test system.

        External multi-company training is more suited for non specific training requirements and usually proves extremely useful for those candidates wishing to network with peers from other industries.

        SAP Business One Training Courses

        Our SAP Business One training courses can be specifically tailored to your system and, dependent on time, our time can be used for consultancy questions. We will listen and work with you to ensure that your users receive the training that will positively impact your business.

        1 Dash 1 also provide Super User 1 week long training courses to enable one of your users to become the main point of contact for any SAP Business One related questions that arise within the business. The week long course will empower your user to answer questions and create SQL Queries for entry and intermediate reporting. The week long course is structured and priced differently to our offer training course offerings so please specify if the course is of interest and we will contact you with the relevant information.

        Simply enter your details below with your training requirements and we will contact you to arrange dates and discover what training style is most suitable for you and your users.

          Your Name (required)

          Your Email (required)

          Your Phone


          Training Course Topic

          Your Message

          SAP Business One – Date Deviates From Permissible Range

          The ever popular Date Deviates From Permissible Range error message appears for two reasons and IS easily solved!

          The usual occurrence is in the New Year when new posting periods need to be created. To resolve this simply create a new posting year/period in (and watch out for your sub-periods!):

          Within SAP Business One in the Main Menu or top menu Modules option go to –

          Administration –> System Initialisation –> Posting Periods

          The second occurrence is when you are trying to post documents with a due date that is not covered by the created Posting Periods Due Date range. This usually occurs towards the end of the year. You can solve this problem with the following solution.

          Administration –> System Initialisation –> Posting Periods

          Change the Due Date range to allow you to enter the document.


          We understand SAP Business One, so you don’t have to.

          SAP Business One, the SAP offering for Micro businesses and SME’s is a powerful product with immense potential. With more and more businesses using SAP Business One we have listened and pleased to offer consultancy services to provide training, audits and general advice on how to get the most out of the system.

          Do you know which Partner or Gold Partner is best for you?

          With our market knowledge and contacts in many of the SAP Business One partners throughout the UK, we can assist you in finding the best match for you, your staff and your business. Every business is different and requires a different approach. The SAP Business One implementation consultant assigned to you has to work with you – we will find the best match.

          Contact us to discuss your requirements. We’d love to hear from you.