Revenue account issue.

[Former Member]

Hello all,

I am currently stuck on an issue. I would be extremely grateful for any thoughts or feedback.

My client sells a certain product as well as accessories for that product. Currently, the US company code has a Revenue acct for the Product and another revenue account for the Accesories. The client has approximately 8 Resellers (who are in effect also customers) in 8 different countries. Each Reseller sells the product in their respective country. Currently all the revenue from individual customers as well as these Resellers goes into the Product Revenue A/c and the Accesory Revenue A/c. Each Reseller sells the Product in their respective country.

<b>The client wants to maintain <u>individual</u> Revenue(separate) A/c for each specific Reseller.</b>They want each Reseller to have a Revenue A/c for Product and for Accessories. They also want all the individual Revenue accts for Resellers to roll up into ONE main revenue acct for the US company code.

Eg. US company code

400000 (main revenue acct for product) $12000 (CanMalaysiaFrance)

400001 (Reseller Revenue acct for product sold in Canada) $4000

400002 (Reseller Revenue acct for product sold in Malaysia) $4000

400003 (Reseller Revenue acct for product sold in France) $4000

Etc.

410000 (main revenue acct for Accessory) $6000 (CanMalaysiaFrance)

410001 (Reseller Revenue acct for accessory sold in Canada)) $2000

410002 (Reseller Revenue acct for accessory sold in Malaysia) $2000

410003 (Reseller Revenue acct for accessory sold in France) $2000

etc.

Keep in mind that regular sales to US customers (web, phone orders) need to go into the main Revenue accounts (400000 and 410000).

<b>Is there a way to configure this in SAP?</b>

Sorry for the long question, but I was trying to be as detailed as possible. Thanks in advance!

[Former Member · Accepted solution]

Hi,

You can do this by creating customer groups and assign revenue accounts using VKOA with Customer group and Account key combination.

Hope this will help you.

Pl. Assign points if useful.

Thanks

[Former Member]

Hi,

You can Account Assignment Group in Customer Master - Sales Area Data - Billing document.

In Transaction code, you need to define Revenue Accounts for each of the different Account Assignment Group Combinations.

As your SAP system is already live, this needs to be taken up as a mini project and plan it meticulously / test it and then move to Production system.

Thanks

Murali.

[Former Member]

Hi,

You may resolve the issue by creating different Customer groups which is an easy way of monitoring the revenue instead of opening up several revenue accounts.

If the accounting dept is very specific then assign the account groups to the particular revenue account in Customer master recon account.

Hope this helps.

Thanks, Chitras

[Former Member]

To answer your question you can use a concept called group chart of account, where u can call these accounts into a group and this way client can look at it in consolidation as a single revenue account. But you can still post to individual accounts.

Assign points if helpful

Message was edited by:

sunil bahunapati