Skip to Content
author's profile photo Former Member
Former Member

SD Invoice split to 2 reconciliation account

Dear All

The requirement is to split the following Invoice amount in to different accounts in Accounting Document.

Customer A Dr. 10,000.00 (GL – 900000)

Revenue Cr. 900.00

Tax (10%) Cr. 100.00

As per the above invoice, collection from the customer A would be 10,000.

As per the business requirement, account entry of invoice should split as follows,

Customer A Dr. 1,000.00 (GL – 900000)

Customer B Dr. 9,000.00 (GL – 900001)

Revenue Cr. 900.00

Tax Cr. 100.00

Kindly provide a solution in SD/FI to overcome the above.

Thanks in Advance

Madhawa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 03, 2012 at 06:15 AM

    Hi Madhawa,

    Please go to the below screen short

    Those g/l is recon g/l>go to the path spro -GLa/c new- business transaction -document splitting-classify g/l a/c for document splitting

    Just test It.

    Regards

    Mastan Reddy N


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mastan Reddy

      Thanks for the reply. My requirement is to split at the time of invoicing to 2 different reconciliation accounts which are maintaining in 2 customers.

      Invoice amount will be Customer A+ Customer B but show only total for customer A.

      Only accounting entry to be separated.

      Thanks

      Madhawa

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2012 at 09:52 AM

    Hi,

    1. At first you create one instrallment payment terms which is help to splite the customer balance in two line items

    2. Two normal payment terms which is assign with instrallment payment terms.

    3. Allow to your customer reco. account in alternative reco.from Gl master

    4. Write a substitution rules if payment terms is 00A goes to 10000 reco. A/c and payment Terms 00B goes to 2000 reco A/c. 00A and OOB is normal payment terms which is already assign with customer line items thorugh instrallment payment terms.

    I hope it is help to you.

    Regards,

    Spradip







































    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.