SAP Business One + Le New Black integration overview
SAP Business One is a cloud-based ERP provided by SAP for small and medium businesses. Le New Black offers a collaborative B2B portal for your team and retailers, and an order-taking iPad app for your sales team.
The connector uses the SAP Business One API to exchange data |
|
Le New Black drives all data flows: it triggers every push and pull operation |
|
The connector requires basic configuration in Le New Black and SAP Business One |
Data flows
| Type | Flow |
| Inventory stock levels | SAP Business One ⇢ Le New Black |
| Orders | SAP Business One ⇠ Le New Black |
Data flow: Inventory stock levels
Available quantities of the SAP Business One warehouse set up are imported for each EAN13 of the seasons set up.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Items with a barcode whose season field (U_GSP_Season) holds one of the season codes set up
Quantity imported: The quantity in stock minus the committed quantity of each item, in the SAP Business One warehouse set up
Matching keys: Size: EAN13, matched against the SAP Business One barcode.
Import mode: Add by default → only the sizes in the SAP Business One data are updated, the others keep their quantity. Replace, when set up → the stock of every size is set to 0 before the quantities are applied. Negative quantities are imported as 0.
Rejected rows: A SAP Business One EAN13 unknown in Le New Black is ignored and reported in the task log: import products first.
Configuration
| Setting | Values | Type | Comment |
import_mode |
add (default) / replace | string | With replace, the stock of every size is set to 0 before the quantities are applied |
lnb_sku_identifier_column |
ean13 (default) / sku | string | Le New Black key the stock rows are matched against |
lnb_stock_column |
quantity (default) / incoming_quantity | string | Le New Black quantity updated |
warehouse_code |
SAP Business One warehouse code | string | SAP Business One warehouse the stock is read from |
season_codes |
SAP Business One season codes | list | Seasons whose items are read |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are created in SAP Business One as sales orders, with their lines in the warehouse set up for their order mode.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Orders exported: Status Invoicing
Integration status: Only orders whose integration status is Pending are exported, and it becomes Successfully sent after export. The selection can be adapted during set-up.
Status after export: Closed
Blocked orders: An order that fails a check keeps its status and gets the integration status Blocked, with the reason in the task log. It is not sent again until you set its integration status back to Pending from the orders list (action Set integration status to Pending).
Limit: No limit
Sales order: A SAP Business One sales order for the customer, with the order date as document date, the delivery start date as due date, the delivery address code, a comment naming the Le New Black order ("PO-" followed by its number) followed by the order's comment, the user fields set up, and one line per ordered size with its quantity, the order currency and the warehouse
Matching keys: Customer: LNB retailer reference, sent as the SAP Business One business partner code. Delivery address: LNB address reference, sent as the SAP Business One address code. Products: EAN13, matched against the SAP Business One barcode.
Not synchronised: Prices and discounts are left for SAP Business One to apply. Shipping costs are not part of the order sent.
Configuration
| Setting | Values | Type | Comment |
default_warehouse_code |
SAP Business One warehouse code | string | Warehouse of the order lines |
default_user_data |
SAP Business One order field → value | list | User fields set on every order created |
data_by_order_modes |
order mode → warehouse code and user fields | list | Warehouse and user fields used instead for the stock-based or the pre-order orders (optional) |
validate_stock_ats |
true / false | bool | With true, the orders are exported in stock allocation order: by status (Invoicing first), then by date |
Callouts
- An order containing a product without an EAN13 code is blocked as a whole: none of its lines is exported.
- An order whose customer has no SAP Business One customer reference in Le New Black is blocked. Other orders are still exported.
- An order is also blocked when it has no delivery start date or no order mode (stock-based or pre-order), or when a customer or an EAN13 is unknown in SAP Business One.
- After the order has been exported from Le New Black, any further change must be made directly in SAP Business One.
Global configuration
Configuration
| Setting | Values | Type | Comment |
url |
SAP Business One Service Layer address | string | Address of your SAP Business One account |
database_name |
SAP Business One company database | string | Company database the data flows read and write |
login |
SAP Business One user name | string | Credential of your SAP Business One account, set up with your account manager |
password |
SAP Business One user credential | string | Credential of your SAP Business One account, set up with your account manager |
Integration project
Who's assigned from your team?
Your SAP Business One administrator, or an IT profile within your company who is familiar with your specific setup. A Sales Manager who understands your business and your merchandising strategy.
Who's in charge at Le New Black
Your account manager at Le New Black takes care of the whole process from day 1:
- Asking questions about your specific SAP Business One setup and sales process.
- Setting up the connection with your SAP Business One account.
- Generating and exporting test orders to SAP Business One.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and SAP Business One to troubleshoot any unexpected issue after launch.
Timeline
A standard integration of the inventory stock levels and orders data flows will take 4-6 weeks to get up and running.
Integration monitoring
Once the connector is set up, the Integration center of your back-office gives you a set of tools to manage and monitor the integration:
- Task logs, for continuous monitoring and troubleshooting (for example a missing EAN13 or retailer reference that prevents an order from being exported)
- Running a task on demand, to push or pull data at once
- A preview of the data before the actual import (only available on some connectors)
- E-mail notifications per task, set up on request: exported and blocked orders, import errors
- The integration status of each order in the orders list (Pending, Successfully sent, Blocked), which you can set back to Pending to send an order again
Comments
0 comments
Please sign in to leave a comment.