on 10-06-2008 7:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, but this is a service invoice NO ITEMS and there are no target documents attached to it, but when you look at the Document itself (credit memo) in the remarks section it notes "based on Sales order and based on A/R Invoices" why would these be noted, as if it had target documents attached. There is a service credit memo right below it on the Sales Analysis and this comes out with a GP of 0% with no target documents and no remarks.
Thank you
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
Hi,
Please check Note No. 963879 if the same is relevant and helpful regarding your scenario/case.
Regards,
Jitin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.