This menu item allows users to view and edit Inventory Advice (IA) templates. This is also where the user can transmit the IA to their Trading Partners.

Inventory Advice Template

Creating an Inventory Advice Template

Navigate to SPS Integration > Inventory Advice and click the “+” to add a new Inventory Advice template.

Creating an Inventory Advice Template.
Creating an Inventory Advice Template.

This will open the Inventory Advice window:

Creating an Inventory Advice Template.
Creating an Inventory Advice Template.
  1. Populate the header fields on the Inventory Advice Template.
  2. Click Add Items which will bring up a list of items in SAP Business One.
  3. Populate % (Override) to assign a subset % of the Quantity.
  4. Repeat 2 & 3 with all items required by Trading Partner.
  5. Once done, click the Add button. An Inventory Advice Template is now created.


Inventory Advice Template
Field Name Type Definition

Business Partner

Field

Business Partner for Inventory Advice to be transmitted to.

Allow Autosend 846

Check box

Set to checked to enable auto-sending of this template.

846 Profile

Drop-down UDF

Select auto-send profile. Add/modify profiles by navigating to: SPS Integration > SPS Integration Setup > 846 Profile Setup.

Allocation %

Field

This is the percentage allocation of the inventory quantity which will be sent to the Trading Partner on this template.

Field

This is the percentage allocation of the inventory quantity which will be sent to the Trading Partner on this template.

Include Pricing

Drop-down

This determines the price sent:

None - Prices are not sent.

Business Partner's Price List- Transmit BP specific prices

Specific Price List - Additional dropdown allowing user to select one of the following: (1) Base Price, (2) Discount Purchase Price, (3) Regular Purchase Price, (4) Distributor Sales Price, (5) Regular Sales Price, (6) Small Amount Sales Price.

Available Qty Calculation

Drop-down

Available quantity to be sent:

On Hand - Quantity in Stock.

Available - Quantity in Stock minus Quantity Committed.

Custom Query - Determine Quantities based on HANA/SQL Query.

Warehouse

Check-boxes

Select your warehouse in which you want to send the quantities to be calculated from. In the screenshot above, the quantities from the all the warehouses are sent with the main warehouse set to the General Warehouse.


Sending Inventory Advice

To send an Inventory Advice, navigate to SPS Integration > Inventory Advice. Select the check-boxes for the templates to be sent, then click the Send button.

Setting up Auto-sending of Inventory Advice

In order to automatically send Inventory Advices to Trading Partners, the SPS Connector will need to be setup as follows:

Auto-send Inventory Advice Configuration.
Auto-send Inventory Advice Configuration. In this screenshot, the IA is sent at 09:00 on weekdays and 21:00 on weekends.
  1. Create an Inventory Advice Template (please see “Creating an Inventory Advice Template”). Do not select “Allow Autosend 846” yet.
  2. Navigate to SPS Integration > 846 Profile Setup.
  3. In the 846 Profile screen, populate the Code & Name fields.
  4. Click Add Row then Select the days to the IA and the Time in 24hour format and then click Update.
  5. Repeat (4) for additional schedules.
  6. Navigate back to SPS Integration > Inventory Advice then select the Template to be setup for auto-sending.
  7. On the Template, check the box “Allow Autosend 846” then select the 846 profile that was created for this template.