Single customer with 2 diffrent GL account

[former_member200298]

Hi SD Gurus

My client has a one Customer in India and USA. but need to assign separate GL accounts for India and USA in VKOA settings. Customer should be same. Please advise.

Regards

Babu

[siva_vasireddy2 · Accepted solution]

Hi,

you can define different distribution channel for exports and domestic,also create separate customer account assignment group for exports and domestic

These customer account assignment group you assign them under VKOA settings

[Lakshmipathi]

Are your clients' end customer would function under one name from India and USA?

Since one sales would be treated as a domestic and another as exports, obviously, you need to have a different pricing procedure in which case, you can differentiate the sales in FI postings.  But from FI point of view, what exactly you want to differentiate?

G. Lakshmipathi

[former_member182378]

babu, after thinking about this thread, i have one "the most important" question -

In KNVV, when you put customer no. KUNNR, how many entries do you get?

BABU,

Do you have two different sales organizations for this customer (India and USA)?

If yes, then you just have to maintain records in VKOA. Instructing for each sales organization, the G/L account to be determined.

Note: Interesting here is that you can have the same account assignment group too.

but having different AAGs is advisable - domestic and foreign revenues (01, 02)

TW

Message was edited by: TW Typewriter

Message was edited by: TW Typewriter - added in blue

[former_member183879]

Hi,

First of all there cannot be 2 accounts representing one customer.

Let me get into the fundamentals

What does Babu mean when he says, same customer is in both India and USA. Which address is updated in his customer master?

Second, This customer is dealing with only one company code. This means that the reconciliation account is going to be only one for this customer. During invoicing, the account receivables is going to be posed on the customer sub-ledger account within the RECON account in the company code irrespective of which country or which customer the company code is dealing with.

So the company code deals with only one customer, may be in different sales locations (Only Ship to address is different?) and hence his FBL5N will represent only one account.

To put simply FBL5N cannot have 2 accounts for one customer. The GL accounts are in company's perspective and not in Customer's perspective. This again means that any customer should only have a single reconciliation account per company code which represents the account receivables (Current asset)

There can be some other current assets which can have different GL accounts, but receivables from customer will always point to one particular GL only.

Please comment if I am conceptually wrong somewhere.

[former_member182378]

Navaneetha,

Thanks for your post!

Some of your comments are from FI side, and I donot completely understand those.

From Account Determination perspective and OP is touching upon VKOA -

Example:

Business is selling Electronic goods and services to the same customer. These two sale amounts can be posted in to different G/L accounts, even though the customer is one.

From configuration / design point of view - In account determination functionality, there is nowhere the mention of "customer no.", it deals with a group. (Customer account assignment group).

Based on these points, it is technically possible.

Looking forward for your comments.

Typewriter

What does Babu mean when he says, same customer is in both India and USA. Which address is updated in his customer master?

this is a good point

Message was edited by: TW Typewriter

[moazzam_ali]

Hi

As you can see that there is no field of customer in any condition table in VKOA. You can use any field you want to assign seprate GLs. See which one is feasible for you. As Siva Prasad suggested you can use customer group, distribution channel, plant or country etc. What you need to do is to make new condition table and assign that in your account determination procedure.

Thank$

[former_member182378]

MoazzaM,

I don't agree (so much) with below comment. First option is to see how we can use the already available standard SAP objects (in this case condition tables, access sequence).

This requirement can be achieved with standard.

What you need to do is to make new condition table and assign that in your account determination procedure.

TW

[moazzam_ali]

Hi TW

Yes this could be done using standard tables if they have separate sales organization or customer group etc. If they want to use some other fields e.g country or distribution only in that case new condition table is required. Suggested solution is to check in standard tables and if not possible then go for some customized table.

Thank$