SAP Business One Connectors

SAP Business One is an ERP System that tracks financial, inventory, product and customer data.

SAP Business One is supported by two separate Connectors for SQL (using the B1WebAPI) and Hana (using Service Layer).

Additionally, the SAP Business One InterCompany Connector supports InterCompany integrations for either SQL or Hana installations of SAP Business One.

Details for actions, functions, and workflow triggers for each are outlined in the pages below:

  • SAP Business One Hana (Service Layer) Connector
    • Actions Reference provides details for actions used to build a workflow. These actions apply to the Hana (Service Layer) version only.
    • Function Reference provides a list of functions and different ways they can be used to build a mapping. These functions apply to the Hana (Service Layer) version only.
    • Workflow Trigger Reference provides details on how to configure advanced settings to fetch the data needed by a workflow. These triggers apply to the Hana (Service Layer) version only.
      • Format Settings Reference provides details about how to handle and pre-process trigger data. These details apply to the Hana (Service Layer) version only.
    • Warnings Reference explain the details behind warnings found in Saltbox. These details apply to all versions of SAP Business One.
  • SAP Business One SQL (B1WebAPI) Connector
    • Actions Reference provides details for actions used to build a workflow. These actions apply to the SQL (B1WebAPI) version only.
    • Function Reference provides a list of functions and different ways they can be used to build a mapping. These functions apply to the SQL (B1WebAPI) version only.
    • Workflow Trigger Reference provides details on how to configure advanced settings to fetch the data needed by a workflow. These triggers apply to the SQL (B1WebAPI) version only.
      • Format Settings Reference provides details about how to handle and pre-process trigger data. These details apply to the SQL (B1WebAPI) version only.
    • Warnings Reference explain the details behind warnings found in Saltbox. These details apply to all versions of SAP Business One.
    • B1WebAPI Guides provide supporting walkthroughs for setting up and configuring B1WebAPI, which is required for the SQL (B1WebAPI) version only.
  • SAP Business One InterCompany Connector
    • Actions Reference provides details for actions used to support InterCompany workflows. These details apply to all versions of SAP Business One.

Release Notes for SAP Business One Hana Connectors

SAP Business One Hana (Service Layer) Connector updated - v1.31.1

v1.31.1 - April 17, 2023

Version 1.31.1 fixes a bug when executing actions that include Item Codes containing special characters (65151).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.5

v7.13.5 - February 27, 2023

Version 7.13.5 fixes a bug resulting in a connection error when the specified base URL ends with a forward slash (/) (64044).

SAP Business One Hana (Service Layer) Connector updated - v1.31.0

v1.31.0 - February 6, 2023

Version 1.31.0 adds an action to insert records to UDT by batch.

SAP Business One Hana (Service Layer) Connector updated - v1.30.1

v1.30.1 - February 6, 2023

Version 1.30.1 fixes a bug in Get Query Results from a B1 Query action (63499).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.4

v7.13.4 - November 16, 2022

Version 7.13.4 fixes a bug where SSL certificate validation was not working (61879).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.3

v7.13.3 - November 14, 2022

Version 7.13.3 adds support for CSV output type to Bulk Data Query action.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.2

v7.13.2 - September 19, 2022

Version 7.13.2 fixes a bug when using the trigger GetWorklfowMessagesv2 - "All" filter option did not select expected data (57263).

SAP Business One Hana (Service Layer) Connector updated - v1.30.0

v1.30.0 - August 22, 2022

Version 1.30.0 adds support for beta functionality - dynamic schema generation.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.1

v7.13.1 - August 22, 2022

Version 7.13.1 updates config options for B1 Object Type on triggers and actions to improve usability.

SAP Business One Hana (Service Layer) Connector updated - v1.29.0

v1.29.0 - August 8, 2022

Version 1.29.0 adds a header option to the action Create a B1 Object.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.0

v7.13.0 - July 4, 2022

Version 7.13.0 adds support for beta functionality - dynamic schema generation.

SAP Business One Hana (Service Layer) Connector updated - v1.28.2

v1.28.2 - June 8, 2022

Version 1.28.2 fixes a bug for special characters in CSV generation (58282).

SAP Business One Hana (Service Layer) Connector updated - v1.28.1

v1.28.1 - June 6, 2022

Version 1.28.1 fixes a bug when DateCreatedEarlierCurrentTime is not set (58214).

SAP Business One Hana (Service Layer) Connector updated - v1.28.0

v1.28.0 - May 16, 2022

Version 1.28.0 adds an option to download a document's attachments.

SAP Business One Hana (Service Layer) Connector updated - v1.27.1

v1.27.1 - May 16, 2022

Version 1.27.1 improves usability of the Create Batches action by supporting decimal partial quantities (e.g. 0.5).

SAP Business One Hana (Service Layer) Connector updated - v1.27.0

v1.27.0 - May 11, 2022

Version 1.27.0 adds a new action to Create Batches.

SAP Business One Hana (Service Layer) Connector updated - v1.26.2

v1.26.2 - May 9, 2022

Version 1.26.2 fixes a bug in Get List Of Workflows trigger (57230).

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.4

v7.12.4 - May 9, 2022

Version 7.12.4 fixes a bug in the "Get List Of Workflows" trigger where it wouldn't exclude deleted messages (57147).

SAP Business One Hana (Service Layer) Connector updated - v1.26.1

v1.26.1 - May 2, 2022

Version 1.26.1 fixes a bug where item codes that include "/" can't be found in B1 (57014).

SAP Business One Hana (Service Layer) Connector updated - v1.26.0

v1.26.0 - April 25, 2022

Version 1.26.0 adds a new Bulk Query workflow trigger data type (message source) to support CSV file imports.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.3

v7.12.3 - April 18, 2022

Version 7.12.3 includes updates to configuration settings, defaults and tooltips to improve usability and ease of setup.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.2

v7.12.2 - April 4, 2022

Version 7.12.2 adds CardCode as a parameter to the Visual Data Mapper function GetItemPrice.

SAP Business One Hana (Service Layer) Connector updated - v1.25.4

v1.25.4 - March 28, 2022

Version 1.25.4 fixes a configuration bug in query actions, and updates tooltips and labels.

SAP Business One Hana (Service Layer) Connector updated - v1.25.3

v1.25.3 - March 21, 2022

Version 1.25.3 fixes a bug when creating attachments (53646).

SAP Business One Hana (Service Layer) Connector updated - v1.25.2

v1.25.2 - March 14, 2022

Version 1.25.2 adds support for date variables such as {Today} and {Today-7}.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.1

v7.12.1 - March 14, 2022

Version 7.12.1 fixes a bug in date variables where they were case sensitive (and now are not) (55350).

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.0

v7.12.0 - March 9, 2022

Version 7.12.0 adds support for date variables such as {Today} and {Today-7}.

SAP Business One Hana (Service Layer) Connector updated - v1.25.1

v1.25.1 - March 7, 2022

Version 1.25.1 adds default settings to workflow triggers.

SAP Business One SQL (B1WebAPI) Connector updated - v7.11.1

v7.11.1 - March 7, 2022

Version 7.11.1 adds default settings to workflow triggers.

SAP Business One SQL (B1WebAPI) Connector updated - v7.11.0

v7.11.0 - February 28, 2022

Version 7.11.0 adds a new action to upload and install a metadata.zip package - Requires B1WebAPI v100.24.0.5 or higher.

SAP Business One SQL (B1WebAPI) Connector updated - v7.10.0

v7.10.0 - February 21, 2022

Version 7.10.0 adds support for Project Codes as B1ObjectType and new actions to support Financial Projects.

SAP Business One Hana (Service Layer) Connector updated - v1.25.0

v1.25.0 - February 14, 2022

Version 1.25.0 adds support for selecting B1ObjectType dynamically in a workflow.

SAP Business One SQL (B1WebAPI) Connector updated - v7.9.0

v7.9.0 - February 14, 2022

Version 7.9.0 improves error messages encountered by the connector and adds additional support to early-access functionality.

SAP Business One SQL (B1WebAPI) Connector updated - v7.8.0

v7.8.0 - January 31, 2022

Version 7.8.0 adds support to set B1ObjectType dynamically in a workflow (53545).

SAP Business One Hana (Service Layer) Connector updated - v1.24.1

v1.24.1 - January 24, 2022

Version 1.24.1 resolves an issue in visual mapper targets for VendorPayments, PaymentInvoices, and PaymentCreditCards (49642).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.3

v7.7.3 - January 17, 2022

Version 7.7.3 resolves an error in BulkDataQueryMessageSource when output is JSON (53212).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.2

v7.7.2 - January 11, 2022

Version 7.7.2 resolves an issue in beta functionality that retrieves queries by category (52976).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.1

v7.7.1 - January 10, 2022

Version 7.7.1 fixes a bug where a trigger shows as successful even though it had an error (52849).

SAP Business One Hana (Service Layer) Connector updated - v1.24.0

v1.24.0 - January 5, 2022

Version 1.24.0 adds new actions to support SQL Query functionality in Service Layer for B1 v10, as well as support for beta functionality.

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.0

v7.7.0 - January 4, 2022

Version 7.7.0 adds support for a new bulk data message source.

SAP Business One SQL (B1WebAPI) Connector updated - v7.6.0

v7.6.0 - December 21, 2021

Version 7.6.0 adds support for beta functionality related to remote data functions that retrieve query categories and queries by category.

SAP Business One Hana (Service Layer) Connector updated - v1.23.0

v1.23.0 - December 20, 2021

Version 1.23.0 adds a new bulk data message source to fetch data from a query.

SAP Business One Hana (Service Layer) Connector updated - v1.22.7

v1.22.7 - December 13, 2021

Version 1.22.7 version 1.22.7 resolves a bug related to displaying Chinese characters (52331).

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.4

v7.5.4 - November 29, 2021

Version 7.5.4 resolves a backward compatibility issue with the action Insert B1 Object Record (51372) and resolves a bug in error message reportin...

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.3

v7.5.3 - November 8, 2021

Version 7.5.3 adds the soft failure option to object "unit of work" actions.

SAP Business One Hana (Service Layer) Connector updated - v1.22.6

v1.22.6 - October 25, 2021

Version 1.22.6 includes a patch to closed-beta functionality. This version is compatible with production projects, and includes all previous bug ...

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.2

v7.5.2 - October 25, 2021

Version 7.5.2 includes a patch to closed beta functionality. This version is compatible with production projects, and includes all previous bug fixes.

SAP Business One Hana (Service Layer) Connector updated - v1.22.5

v1.22.5 - October 12, 2021

Version 1.22.5 fixes an error in the raw message source "hexadecimal value 0x1E, is an invalid character."

SAP Business One Hana (Service Layer) Connector updated - v1.22.4

v1.22.4 - September 27, 2021

Version 1.22.4 improves connection testing with better error messages and simpler config.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.1

v7.5.1 - September 27, 2021

Version 7.5.1 fixes a bug in adding Attachments using the "Attachment2" object.

SAP Business One Hana (Service Layer) Connector updated - v1.22.3

v1.22.3 - September 20, 2021

Version 1.22.3 fixes a bug related to Chart of Accounts.

SAP Business One Hana (Service Layer) Connector updated - v1.22.2

v1.22.2 - September 13, 2021

Version 1.22.2 fixes bugs related to Chart of Accounts. This version also updates action names, forms and descriptions to make them easier to use.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.0

v7.5.0 - September 13, 2021

Version 7.5.0 adds support for remote data functions "GetParameters" and "ExecuteDataFunctionAsStream". Remote data functions are a beta feature.

SAP Business One Hana (Service Layer) Connector updated - v1.22.1

v1.22.1 - August 31, 2021

Version 1.22.1 fixes a bug in remote data function support. Remote data functions are a beta feature, however this version of the connector is sta...

SAP Business One Hana (Service Layer) Connector updated - v1.22.0

v1.22.0 - August 30, 2021

Version 1.22.0 adds support for remote data functions. Remote data functions are a beta feature, however this version of the connector is stable a...

SAP Business One Hana (Service Layer) Connector updated - v1.21.7

v1.21.7 - August 23, 2021

Version 1.21.7 adds support for target schema files in message sources.

SAP Business One SQL (B1WebAPI) Connector updated - v7.4.1

v7.4.1 - August 23, 2021

Version 7.4.1 fixes a bug in Item Price actions when using specific dates and quantities. This version also improves support in other connectors tha...

SAP Business One Hana (Service Layer) Connector updated - v1.21.6

v1.21.6 - August 19, 2021

Version 1.21.6 fixes an issue in "Bulk Data Provider" trigger when reading data whose object is itself a large object.

SAP Business One SQL (B1WebAPI) Connector updated - v7.4.0

v7.4.0 - August 16, 2021

Version 7.4.0 adds a new action to support object hydration within a workflow, and trigger options have been updated. This addresses a bug where wor...

SAP Business One SQL (B1WebAPI) Connector updated - v7.3.1

v7.3.1 - August 11, 2021

Version 7.3.1 improves test options and updates schemas.

SAP Business One Hana (Service Layer) Connector updated - v1.21.5

v1.21.5 - August 2, 2021

Version 1.21.5 adds configuration options to workflow triggers, and improves error messages when bulk data processing is disabled but attempted to...

SAP Business One Hana (Service Layer) Connector updated - v1.21.4

v1.21.4 - July 19, 2021

Version 1.21.4 fixes a bug where item master data with certain special characters fail to sync when enqueued.

SAP Business One Hana (Service Layer) Connector updated - v1.21.3

v1.21.3 - July 12, 2021

Version 1.21.3 fixes a bug in the action "GenericAction UserDefinedAction v2" to handle query parameters. This version also enforces "B1Query Conver...

SAP Business One Hana (Service Layer) Connector updated - v1.21.2

v1.21.2 - June 28, 2021

Version 1.21.2 improves support for batch actions, and fixes two issues related to item codes with hash (#) and time zones.

SAP Business One SQL (B1WebAPI) Connector updated - v7.3.0

v7.3.0 - June 28, 2021

Version 7.3.0 adds support for Inventory Count, Timesheet and Inventory Posting endpoints.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.3

v7.2.3 - June 21, 2021

Version 7.2.3 fixes a bug where JPEG attachments become corrupt.

SAP Business One InterCompany Connector updated - v1.0.1

v1.0.1 - June 14, 2021

SAP Business One InterCompany Connector version 1.0.1 updates default values to make "Parse InterCompany Details" action easier to configure.

SAP Business One Hana (Service Layer) Connector updated - v1.21.1

v1.21.1 - June 7, 2021

Version 1.21.1 updates the layout of workflow trigger settings.

SAP Business One Hana (Service Layer) Connector updated - v1.21.0

v1.21.0 - May 31, 2021

Version 1.21.0 adds a new action to support robust workflow messages, improvements to caching, and updates to message sources and options.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.2

v7.2.2 - May 31, 2021

Version 7.2.2 fixes a bug where workflow messages whose data contains the keyword "error" won't load in Saltbox.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.1

v7.2.1 - May 25, 2021

Version 7.2.1 resolves an issue when loading certain visual data mappings.

SAP Business One Hana (Service Layer) Connector updated - v1.20.4

v1.20.4 - May 10, 2021

Version 1.20.4 adds a soft failure option to the close object action.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.0

v7.2.0 - May 10, 2021

Version 7.2.0 adds support for oGoodsReturnRequest, oPurchaseRequest and oReturnRequest objects.

SAP Business One Hana (Service Layer) Connector updated - v1.20.3

v1.20.3 - April 28, 2021

Version 1.20.3 fixes a customer-reported issue related to Workflow Messages v2 workflow trigger.

SAP Business One Hana (Service Layer) Connector updated - v1.20.2

v1.20.2 - April 21, 2021

Version 1.20.2 adds advanced filter options to the query workflow trigger, and adds details to bulk data provider actions.

SAP Business One SQL (B1WebAPI) Connector updated - v7.1.0

v7.1.0 - April 21, 2021

Version 7.1.0 adds a new Workflow Trigger "WorkflowMessage v2", which updates the message status in B1 upon failure.

SAP Business One Hana (Service Layer) Connector updated - v1.20.0

v1.20.0 - April 14, 2021

Version 1.20.0 adds attachment actions, soft failures to select actions, and several bug fixes.

SAP Business One Hana (Service Layer) Connector updated - v1.19.4

v1.19.4 - April 7, 2021

Version 1.19.4 patches an issue with Incoming Payments map targets.

SAP Business One Hana (Service Layer) Connector updated - v1.19.3

v1.19.3 - March 17, 2021

Version 1.19.3 adds support for action Headers, and soft failures for some actions. This version also patches bugs in trigger splitter options and ...

SAP Business One Hana (Service Layer) Connector updated - v1.19.2

v1.19.2 - March 10, 2021

Version 1.19.2 adds Page Size setting to the Generic action "User Defined Action v2".

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.4

v7.0.4 - March 10, 2021

Version 7.0.4 patches Purchase Quotation actions and schemas.

SAP Business One Hana (Service Layer) Connector updated - v1.19.1

v1.19.1 - March 3, 2021

Version 1.19.1 patches issues with map targets and provides user-friendly error messages for known test connection failures.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.3

v7.0.3 - March 3, 2021

Version 7.0.3 adds support for Purchase Quotes in existing actions and message sources.

SAP Business One Hana (Service Layer) Connector updated - v1.19.0

v1.19.0 - February 24, 2021

Version 1.19.0 patches an issue where SSL validation incorrectly fails. Saltbox query extension for Hana has also been updated.

SAP Business One Hana (Service Layer) Connector updated - v1.18.1

v1.18.1 - February 10, 2021

Version 1.18.1 patches a customer-reported issue related to triggers.

SAP Business One Hana (Service Layer) Connector updated - v1.18.0

v1.18.0 - January 20, 2021

Version 1.18.0 updates the Bulk Data Provider workflow action, allowing it to be used with any workflow trigger.

SAP Business One Hana (Service Layer) Connector updated - v1.17.0

v1.17.0 - January 6, 2021

Version 1.17.0 adds an action to save large data sets as a csv file.

SAP Business One Hana (Service Layer) Connector updated - v1.16.0

v1.16.0 - December 30, 2020

Version 1.16.0 patches an issue with the action "ItemPrice Get Price" and the workflow trigger "Bulk Data Provider".

SAP Business One Hana (Service Layer) Connector updated - v1.15.0

v1.15.0 - December 16, 2020

Version 1.15.0 adds a new trigger to support bulk data operations.

SAP Business One Hana (Service Layer) Connector updated - v1.14.2

v1.14.2 - December 10, 2020

Version 1.14.3 provides configuration updates to the "Get B1 Object Message Source".

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.2

v7.0.2 - December 10, 2020

Version 7.0.2 patches an issue with the action "AttachmentUploadAndProcess".

SAP Business One Hana (Service Layer) Connector updated - v1.14.2

v1.14.2 - December 2, 2020

Version 1.14.2 patches an issue when fetching UDO data using the "Workflow Messages v2" workflow trigger.

SAP Business One Hana (Service Layer) Connector updated - v1.14.1

v1.14.1 - November 23, 2020

Version 1.14.1 patches the Chart of Account action and workflow message v2 trigger.

SAP Business One Hana (Service Layer) Connector updated - v1.14.0

v1.14.0 - November 12, 2020

Version 1.14.0 improves support for large volume transactions.

SAP Business One Hana (Service Layer) Connector updated - v1.13.0

v1.13.0 - October 28, 2020

Version 1.13.0 patches an issue when fetching results from a stored procedure, and adds options to test connections and when fetching data.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.1

v7.0.1 - October 28, 2020

Version 7.0.1 features clearer error messages in the cases of connection failure or transaction failure.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.0

v7.0.0 - October 21, 2020

Version 7.0.0 features changes to attachment actions which are not backward-compatible. Other features remain unaffected.

SAP Business One Hana (Service Layer) Connector updated - v1.12.1

v1.12.1 - October 15, 2020

Version 1.12.1 patches an issue when fetching deleted objects.

SAP Business One SQL (B1WebAPI) Connector updated - v6.5.0

v6.5.0 - October 15, 2020

Version 6.4.1 features schema files to support data mappings.

SAP Business One Hana (Service Layer) Connector updated - v1.12.0

v1.12.0 - October 7, 2020

Version 1.12.0 features schema files to support data mappings, and better scalability support.

SAP Business One Hana (Service Layer) Connector updated - v1.11.0

v1.11.0 - September 30, 2020

Version 1.11.0 features new actions to Cancel and Close objects.

SAP Business One Hana (Service Layer) Connector updated - v1.10.1

v1.10.1 - September 23, 2020

Version 1.10.1 features usability updates to form settings and descriptions.

SAP Business One Hana (Service Layer) Connector updated - v1.10.0

v1.10.0 - September 16, 2020

Version 1.10.0 features the ability to perform sub-operations, such as cancel and close documents, as well as minor usability updates.

B1WebAPI Connector updated - v6.4.1

v6.4.1 - September 16, 2020

B1WebAPI Connector version 6.4.1 features improved support for special characters.

SAP Business One Hana (Service Layer) Connector updated - v1.9.3

v1.9.3 - September 10, 2020

SAP Business One Hana (Service Layer) Connector version 1.9.3 features minor updates workflow trigger config settings.

SAP Business One Hana (Service Layer) Connector updated - v1.9.2

v1.9.2 - September 2, 2020

SAP Business One Hana Connector version 1.9.2 includes updates to the Saltbox Hana Extension and exceptions.

Service Layer Connector updated - v1.9.1

v1.9.1 - August 26, 2020

Service Layer Connector version 1.9.1 provides improved user hints when setting up queries in actions and workflow triggers.

SAP Business One InterCompany Connector launched - v1.0.0

v1.0.0 - April 17, 2020

SAP Business One InterCompany Connector version 1.0.0 supports integrations between different SAP Business One companies.