cancel
Showing results for 
Search instead for 
Did you mean: 

GL account mapping

former_member182805
Active Participant
0 Kudos

Dear Gurus,

My scenario is as follows:

There is a customer for which the total cost of the invoice must be split into total onsite costs and total offshore costs (total invoice value = total onsite cost + total offshore cost). These prices should post to separate GL accounts. The onsite invoice should have a consumption tax added to it.

Sales orders are created with reference to a value contract. The value contracts are created in SAP based on an event in a 3rd party system (.NET front end). We have currently thought of 2 solutions:

1. During the sales order creation, calculate the onsite and offshore amounts and create 2 sales orders in SAP, 1 for onsite and 1 for offshore. In order for Account determination to happen, 2 new materials will be created with AAG posting to a separate GL. Onsite material will be populated in onsite SO and offshore material will be populated in offshore SO. A tax condition type will be added for the onsite SO and will be determined based on condition technique. 2 invoices will be created where the revenues post to different GL accounts and the tax posts to a separate GL.

2. 1 sales order is created and lines are added for onsite and offshore amounts. A material is used for onsite and 1 for offshore. The offshore line has a tax type determined. During invoice creation, 2 invoices are created using invoice split criteria in copy controls (Sales -> Billing). 2 invoices are created. The revenues post to different GL's as per Revenue Account Determination. The tax posts to a separate GL.

We are considering solution 1 due to lesser custom code (VOFM routine for invoice split) and complications that can arise during invoice split if Sales order has multiple line items.

Which is a better solution and is there any other solution? Please help. Thanks

Accepted Solutions (1)

Accepted Solutions (1)

sez41
Active Contributor
0 Kudos

Srinivas,

Do you have two create two separate invoices (Is it legally binding in your scenario)?

If not, how about creating a different pricing procedure and finding it when your customer places a contract (a different customer pricing procedure is assigned to the customer)?

In the new pricing procedure;

total onsite costs = Condition Type 1, Account Key Z01

total offshore costs = Condition Type 2, Account Key Z02

Tax is calculated by total onsite costs only.

In this case, no development is needed, only customizing effort is required. Only one material is used in sales documents.

former_member182805
Active Participant
0 Kudos

Hi Kivanc,

Thanks for the reply.

It is needed to create 2 separate invoices. But thanks for giving an idea about separate condition types for onsite and offshore, using different account keys and posting to different GL's

jpfriends079
Active Contributor
0 Kudos

Hi Srinivas,

I have counter solution based on standard configuration and account/pricing determination.

When you are using 2 different materials getting determined for onsite and offshore. Then with one condition type and account key,  you can achieve the result.  Provided you determine your account determination based on different material account assignment group and accordingly maintain different GL accounts for them.

Say, you can have following combination and maintain relevant pricing(V/08) and account determination (VKOA)

Material ONSITE - Condition Type  ZPR1 - Account Key ERL - Material Account Assignment Group 1: Onsite - GL Account 410001

Material OFFSHORE - Condition Type  ZPR1 - Account Key ERL - Material Account Assignment Group 2: Offshore - GL Account 410002

Similarly,  you can differentiate you tax account determination either based on different material account assignment group or different taxcode determination.

Thanks JP

Answers (0)