Available To Promise for SXP Employee Edition

First published on 08/10/2023 at 6:54 pm

'Available To Promise' (ATP) allows stock levels to be displayed in SXP Employee when orders are placed by a Sales User. Configure ATP Settings as described below.

Enabling ATP

You can enable ATP in SXP Manager Add-On for SAP Business One:

• In B1, go to SXP Manager AddOn > Administration > Employee Platform Order Pad.
• In the 'General' tab, apply these settings:
  • Enable 'Available To Promise' by placing a checkmark in the lower right section.
  • Set the desired validation level: 'Warning Only' will allow Sales Users to continue through checkout. 'Block Backorders' will prevent Sales Users from placing an order when there's insufficient stock.
  • Set the category to B1WebAPI_SU.

  • Set the query to AvailableToPromise.

• Save config settings.

The website will now display ATP for Sales Users in SXP Employee.

Updating ATP Logic

You can update ATP with an implementation customization (i.e., modifications to standard B1 queries, which doesn’t require development effort). A B1 expert can update the ATP query using SAP Business One.

Out of the box, the ATP query calculates the default warehouse’s “On Hand + Ordered - Committed” quantities for the item. You can customize this behavior by creating a copy of the stored procedure zed_ItemsATP and updating B1 to use the new version, as described below.

The web passes three parameters to the stored procedure, which can be used in customizations:

• ItemCode of the item being queried.
• CardCode of the current order’s business partner.
• ExpectedDeliveryDate for the current order.

To change the default ATP behavior:

• In SAP Business One, create a 'Query Category' for custom queries: B1WebAPI_Custom. (If it doesn’t already exist.)
  • Go to Tools > Queries > Query Manager…
  • Press the “Manage Categories” button.
  • See if B1WebAPI_Custom already exists. If not, enter the “Category Name” B1WebAPI_Custom, then press the 'Add' button.
• Open the existing ATP query found under B1WebAPI_SU/AvailableToPromise.
• Save your custom query in the B1WebAPI_Custom category (e.g., B1WebAPI_Custom/AvailableToPromise.
• Copy the stored procedure in the database and update the above custom ATP query. This will ensure your customized version is never overwritten during an upgrade.
• Update the configuration for SXP Employee. In SAP Business One, go to SXP Manager AddOn > Administration > Employee Platform Order Pad. In the 'General' tab, apply the following settings:
  • Enable 'Available To Promise' by placing a checkmark in the lower right section.
  • Set the desired validation level: 'Warning Only' will allow Sales Users to continue through checkout. 'Block Backorders' will prevent Sales Users from placing an order when there's insufficient stock.
  • Set the category to B1WebAPI_Custom.
  • Set the query to the customized version AvailableToPromise.
  • Save config settings.

The website is now updated to display the customized ATP for Sales Users in SXP Employee.

Sales User ATP

When configured, Available To Promise quantities are displayed on the order during checkout, as shown in the screenshot below.

Previous