Skip to Content
avatar image
Former Member

Gross profit showing -5200%

Customer issued AR credit memo - but order and invoice number # noted on the

credit memo, when you look at the sales analysis it shows a GP of

-5205.126%,

the gross profit is set up ok... this is a service invoice with no Traget

documents attached to it.

Gross profit is set up: base price origin "item cost"

profit/sales price.

I did a restore to the BP and this did not fix the issue, they do several

credit memo's and have never had an issue, they would just like an

answer as to why this one is off

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 07, 2008 at 10:26 AM

    Hi Jill,

    may I point out SAP note number [752031|https://service.sap.com/sap/support/notes/752031] where it is explicitly stated that the restore functionality should only be used according to direct instruction from SAP support.

    Service-type invoices do not have a base price & hence are excluded from GP calculation. Hence, if a service was invoiced as an item & this item did not have a base price, the GP should show 100%. If this item however has an item cost & was sold for less, then the GP will be negative.

    My recommendation would be to check the details of the GP report & determine which row causes this GP. Then work backwards & determine where the base price comes from.

    You might find helpful info about troubleshooting Gross Profit issues in these EES:

    [Gross Profit - Part I|http://service.sap.com/~sapidb/011000358700000324142008E.zip] - how does it work?

    [Gross Profit - Part II |http://service.sap.com/~sapidb/011000358700000326172008E.zip]- troubleshooting GP

    All the best,

    Kerstin

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2008 at 06:21 PM

    Hi,

    Please check Note No. 963879 if the same is relevant and helpful regarding your scenario/case.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2008 at 06:47 PM

    If there is no Target for your AR Credit Memo, actually should be no Base in B1 term, B1 will calaculate your Credit total as minus and GP as positive. That is why you get high negative nubmer.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If that note is added by B1, then this AR Credit Memo is either copied from A/R Invoice or by using A/R Invoice copy to it. The invoice type can be both Item or Service to do like this.

      You can run a query to see if there any baseref associate with this credit memo:

      Select T0.Docnum, T1.BaseRef from RIN1 T1 INNER JOIN

      ORIN T0 ON T0.DocEntry = T1.DocEntry where T0.DocNum = [%0\]

      Thanks,

      Gordon

  • avatar image
    Former Member
    Oct 06, 2008 at 08:26 PM

    Hi Jill

    I am not sure whether this will help you or not but you can give a shot .

    Go to form setting and open up all the field specially discount field and quantity and unit price .

    Try to recreate the document and see how the gross profit is acting on this new document .If it is coming correct then you know it us caused by user operation for some action .

    For example ,One time I was getting 98% discount for no reason , and I realise that user when changed the price ,to adjust the price ,sap takes the rest of the change as discount percentage . So I put unit price and qty visible and discount field visible which help user to identify when they correct the data what action is triggered .

    The reason what I am saying this simple thing will help you to analyse if this issue is duplicated for one document or multiple document .So that it will help you to narrow down to focus the issue .

    Hope this helps

    Bishal

    Add comment
    10|10000 characters needed characters exceeded