SAP Business One

Provides integration into SAP Business One via the DI Server.

Revision History

1.0.0.0 Initial Release
9.3.0.1 Added support for SAP Business One 9.3
9.3.0.5 Fixed issue where incorrect interop assembly would be loaded if the version changed on the Connection
10.0.0.3 Added support to authenticate on the SLDServer instead of LicenseServer
10.0.1.0 Updated to .NET Framework 4.8, refactored samples

Properties

Connection

Type: Connection Input
The Connection Property

DatabaseServer
Type: String
Name or IP Address of the application server

LicenseServer
Type: String
Name or IP Address of the licensing server

DatabaseType
Type: List Input
The type of database in use.

dst_MSSQL
dst_DB_2
dst_SYBASE
dst_MSSQL2005
dst_MAXDB
dst_MSSQL2008
dst_MSSQL2012
dst_MSSQL2014
dst_HANADB
dst_MSSQL2016
dst_MSSQL2017
dst_MSSQL2019

DatabaseNameType: String
The name of the company database to connect to

DatabaseUsername
Type: String
The company database username (ie. MS SQL account username)

DatabasePassword
Type: String
The company database password

CompanyUsername
Type: String
The SAP B1 user ID

CompanyPassword
Type: String
The SAP B1 user password

BusinessOneVersion
Type: String
The version of the SAP B1 company

Action

Type: List Input
The action to take against the specified data

Add
Update
Get
List
Raw

BusinessObject

Type: List Input
The name of the Business Object

ActivityLocations
ActivityStatus
ActivityTypes
AdditionalExpenses
AlternateCatNum
BankPages
BillOfExchangeTransactions
Budget
BudgetDistribution
BudgetScenarios
BusinessPartners
BusinessPlaces
ChartOfAccounts
ChecksforPayment
Contacts
ContractTemplates
CorrectionInvoice
CorrectionInvoiceReversal
CorrectionPurchaseInvoice
CorrectionPurchaseInvoiceReversal
CreditNotes
CurrencyCodes
CustomerEquipmentCards
DeliveryNotes
Drafts
DunningLetters
EmployeesInfo
IncomingPayments
Industries
InventoryGenEntry
InventoryGenExit
Invoices
ItemGroups
Items
JournalEntries
JournalVouchers
KnowledgeBaseSolutions
LocalEra
MaterialRevaluation
Messages
Orders
PackagesTypes
PaymentRunExport
PaymentsDrafts
PaymentTermsTypes
PriceLists
ProductTrees
PurchaseCreditNotes
PurchaseDeliveryNotes
PurchaseInvoices
PurchaseOrders
PurchaseReturns
PurchaseTaxInvoice
QueryCategories
Queue
Quotations
Relationships
Returns
SalesForecast
SalesOpportunities
SalesTaxAuthorities
SalesTaxAuthoritiesTypes
SalesTaxCodes
SalesTaxInvoice
ServiceCalls
ServiceContracts
SpecialPrices
StockTakings
StockTransfer
Teams
Territories
UserFields
UserKeys
UserObjectsMD
UserPermissionTree
Users
UserTables
VendorPayments
Warehouses
WorkOrders

RequestXml

Type: Xml Input
An XML document containing the request XML for the transaction. Refer to Node Samples for examples.

ResponseXml

Type: Xml Output
An XML document containing the response from the DI Server for the transaction

Remarks

The Flowgear SAP Business One connector provides a light abstraction over the DI Server. It is recommended that you refer to the DI Server and API documentation when using this Connector.

Reference documents

SAP Business One SDK General
https://archive.sap.com/documents/docs/DOC-28739

SAP Business One SQL Table Names
https://blogs.sap.com/2016/01/14/sap-business-one-tables

Troubleshooting

Resource Error (Error Code -8006: Error opening language resource)

This error may occur when attempting to establish a session after licensing or reinstalling the SAP DI Server. To resolve, locate and delete the folder named SM_OBS_DLL located in the user temp folder. Note that this folder varies depending on the service account under which the DropPoint is running.

If the DropPoint is running under the SYSTEM user, the folder will be located in %windir%\temp. If you are using a named user account, log into the server with this account and access the folder at %temp%.