SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP Business ByDesign

Cause

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.

Resolution

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

See Also

Blog: SAP ByDesign Price Determination using Extension Fields

Keywords

wrong; discount; Price List; Discount List; ManageSalesOrderIn; B2B; A2A; A2X; Excel upload; , KBA , AP-PRC-PC , Calculation , Problem

Product

SAP Business ByDesign 2008