2975838 - Discount or Price List is Not Correctly Determined for Sales Orders Created via the Excel Add-In, Web Service or Intercompany Purchase Order

Discount or Price List is not correctly determined for Sales Orders created via the Excel Add-In, the web service ManageSalesOrderIn or an Intercompany Purchase Order. However, when creating a manual Sales Order in the system with the same data the determination of the Discount or Price List works correctly

SAP Business ByDesign

You are using the scenario Pricing with Extension Fields to determine the Discount/Price List by creating a Pricing Table on Header or Item Level which includes an Extension Field for the determination of the respective Discount/Price List.

This is a known limitation from extensibility framework as the extension framework buffers gets filled after the modification for standard fields complete. In the case of Excel upload as well as through web services (internal B2B and external A2X), the modification call to add the account to the sales order as well as to add items happen in the same call and hence the extensibility buffers are not filled as the pricing logic accesses the extension fields while in same modification call.

Hence, in the case of Excel uploads and web service calls (Internal B2B and external A2X), where the extension field values flow from Account or Product to the Sales Order and if the same extension field is used in the pricing calculation, the extension field values won't be available for calculation as the value in the buffer will get updated only after the modification call completes.

Therefore the Discount/Price List cannot be determined.

In order to ensure that the Discount or Price List is determined correctly you can perform either of the following steps in the created Sales Order:

• Perform a dummy change for the value of the extension field
• Perform a dummy change on the Pricing Date in the in the Pricing and Invoicing tab
• Update Pricing in the Pricing and Invoicing tab

Blog: SAP ByDesign Price Determination using Extension Fields

wrong; discount; Price List; Discount List; ManageSalesOrderIn; B2B; A2A; A2X; Excel upload; Sales Order; web service; List Price; extension fields; custom price list , KBA , sales order , AP-PRC-PC , Calculation , Problem