Customer Invoice Web Service: Item sums when a price component is used

[omakinen]

Hello experts,

We have an issue with Customer Invoice web service QueryCustomerInvoiceIn response. We use this web Service to read invoices, convert them to another format and submit to external invoicing partner.

The web service we use is https://myxxxxxx.sapbydesign.com/sap/bc/srt/scs/sap/querycustomerinvoicein

If the invoice has a header level Price Component (Freight or some other surcharge), the Web Service response doesn't contain values for:

• Item's Tax amount WITHOUT the price component's additions
• Item's Gross value WITHOUT the price component's additions

Our invoice recipients require these values.

These values now need to be calculated in the interface, which is bad because:

• it will lead to differences between the manually calculated sum of line items taxes versus the Total tax amount provided by the Web Service. The problem gets worse when there are many rows and rounding differences accumulate.
• calculating line item taxes and gross amounts again in the interface adds complexity. Would be easier to get them directly from ByD web service.

So, my questions are:

1. Is it possible to get the line items' "clean" Tax and Gross sums added to the Web Service response without the price component's part in them?
2. Is there anyway to configure ByD so that the price component is NOT mixed to the invoice line items in ByD and in the web service response?

Thank you very much!

br, Ossi

[Adie]

Hello Ossi,

Take freight as example, when there is an header freight added into an order, the freight will be calculate based on the scale base and added into item. The tax amount is based on item net value which includes freight. It is not possible to get item net value without freight currently from the system. Same applies to data source, there is no key figure provided by SAP for 'net value without freight'.

Thanks,

Adie

[omakinen]

Thanks for confirming this Adie,

I hope the web service is enhanced some day to return also the values without price components' influence. Meanwhile, I keep calculating in the interface.

br,

Ossi