How can I control Posting key allocation to G/L accounts?

[Kaitlin]

Hello.

I have the following requirement: to create a new pricing condition to trace commissions entitled for the distributor partners. This condition must have some attributes:

1. new condition must not modify the price, in some sense it must behave as if it's a statistical condition

2. new condition must modify(=decrease) the profit margin displayed in the Conditions tab/pricing procedure calculation.

3. new condition must be added manually, at header and must be of percentage type

4. FI document for invoice must include 2 lines for this condition, commission value with debit / 40 posting key(PK) must contain a 6aaaaa account and positive value of commission and a second line with credit/50 posting key with a 2aaaaa account and negative value of commission.

So far I created the condition using instructions from THIS BLOG - I kept empty the Plus/Minus field - added it in the pricing procedure and created entries in VKOA for account determination (6aaaaa in G/L column and 2aaaaa in Provision acc. column) and I can see the expected 2 lines in FI document but I'm facing some problems:

a. PK determined are swapped from what are expected to be, account 6aaaaa receives PK 50 and 2aaaaa receives PK 40

Question nr. 1: How can I control what posting keys are allocated to the accounts in FI document? I noticed I can influence it by tweaking the Plus/minus checkbox but if I select X(- minus) the profit margin increases(!!!) with the value of the commission so this doesn't seem to be a solution

b. profit margin in Header shows diminished value - commission is subtracted - but at line level profit margin is not changed despite the fact the share of the header condition is also shown at line level - in other words sum of profit margins collected from lines differ from the header value

Question 2: Is it normal to have the Profit margin displayed at Header different from the sum of the ones from lines? If not how can I control/modify this?

Thank you.

[jignesh_mehta3]

Hello,

For posting positive and negative entry for Commission have a look at below Blog Post:

https://blogs.sap.com/2012/03/26/commission-on-sales-accounting-entry-from-sales-invoice/

For deduction of Commission from Profit Margin, create a Routine for Profit Margin line in Pricing. This Routine should include the Commission Amount in the Profit Margin calculation and then display the result.

Thanks,

[Kaitlin]

Hello.

Thank you for the time taken to reply.

Your solution does no comply with some of the requirements indicated by the client so I can't use it.

I also don't have the luxury of creating a new routine and must rely 100% on configuration - no budget for ABAP - and at least at header level I don't need one as my new commission condition behaves like a cost, is subtracted from net value, my problem is different, please read my second question.

Best regards.

[Lakshmipathi]

When you create a discussion and start adding additional information as asked by the members, please add the same under Comments and not under Answer as you were not answering but sharing additional information. Also, when you add under comments, a mail will be triggered to who you respond. By the way, I have converted your above Answer to Comment

[Kaitlin]

Thank you for taking the time to reply, to be honest I would have treasured from you a reply to my question rather than this administrative detail.

I noticed all SAP reps or moderators insist for this segregation between replies and comments but I see no added value to it, in fact if anything IMO it unnecessarily complicates this communication. For clarifying my view consider this: instead of being able to see a chronological evolution of all contributions it creates a branching that over-complicates this interaction and often misleads the less experienced user that assumes the last answer must be the latest;all forums work this way. Maybe it is the time for this SAP portal admins to stop going against the flow and acknowledge it's not a good idea, it's just a waste of everybody's time.

That being said I want to use this opportunity to thank you for all the wisdom and experience nuggets you shared with us in all these years, you've been a great help and an inspiration for me and, I'm sure, for many others browsing this portal searching for answers.