AR Invoice With PriceAftVAT and Discount

[edy_simon]

Hi All,

I created an AR Invoice using the below code :

                SAPbobsCOM.Documents oDoc = oC.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oInvoices) as SAPbobsCOM.Documents;
                oDoc.CardCode = "C20000";
                oDoc.Lines.ItemCode = "A00001";
                oDoc.Lines.Quantity = 1;
                oDoc.Lines.PriceAfterVAT = 94.5;
                oDoc.Lines.DiscountPercent = 10;


                if (oDoc.Add() == 0)
                    Console.WriteLine(oC.GetNewObjectKey());

There is no Item PriceList set for this Item,

The Document created is as below :

Note that this document has incorrect values :

Unit Price  = 90

Disc = 10 % -> Price Aft Discount = 81

+ Tax SO (5%) -> 81 + 5% = 85.05 which  is different with the Gross Price shown 94.5 (Which is the value i need).

I would Expect my values to be :

PriceAfterVAT = 94.5

Price Before VAT = 94.5 - tax(5%) = 90

Price After Discount = Price Before VAT = 90

Unit Price = 90 * (100/(100-10)) = 100$

Is this a bug ?

I have tested this in the latest 92.PL4.

Hi http://scn.sap.com/people/ankitchauhan%40sap can you confirm this ?

Regards

Edy

[ANKIT_CHAUHAN]

Hi Edy,

Just a quick question what was the status of this program in previous versions like 9.0 or 9.1 ?

It will really help to further investigate this. Meanwhile, I am also going to check this and let you know how it goes.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[edy_simon]

Hi Ankit,

I did a test on 9.0 PL15 with the same result.

Regards

Edy

[ANKIT_CHAUHAN]

Hi Edy,

It is not a bug while it is the current system design.

In current version, we have limitation to support gross price.

In your example,  you set price after vat, then B1 calculates unit price and price after discount internally. But you also set discount, so B1 again calculate price after discount based on discount.

To some extent it makes no sense. But it has similar behaviour in UI. Once user changes the discount, it will always calculate based on unit price.

As there has not been much requests on it, it appears that most of the partners/customers are not having any problem with this. Therefore, by current design we cannot solve it. But in the future versions (it is not an official statement) a purely gross mode could be introduced.

Hope it helps.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[edy_simon]

Hi Ankit,

Thanks and appreciate your help checking on this.

If you compare to the result from UI, this is not even close to the ui result.

UI result is consistent between all the unit price,  price after discount, gross price.  I can understand if you call this a system design.

DI result is a senseless AR invoice with the prices not tally.  It should at least follow the same as UI,  but it does not.

From my point of view,  it should not be dismissed as system design.

Try and calculate the line created by DI,  you would definitely agree with me that the line is erratic.

Especially try to compare the price aft discount and the gross price.

Anyway,  i found my work around to this.

Aside from setting the gross price and discount,  i manually calculated my price aft discount and set it into DI. 

Regards

Edy

[ANKIT_CHAUHAN]

Hi Edy,

Yes, I agree with you that it’s a problem. But As I said, there has not been much requests on it, it can only be solved by redesign in future versions (If there are any) .

Kind regards,

ANKIT CHAUHAN

SAP SME Support