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

Reconciliation Account Splitting in Billing

Good Day,

I would like to request for your assistance on my scenario below:

Scenario is that a customer buys a product worth 80,000 and pays the 50,000 in cash and uses a credit card to pay the remaining 30,000. These payments below are recorded as tenders as such below in billing:

ZPR1 = Cash Payment

ZPR2 = Credit Card Payment

YPR0 = Total Payment

Requirement is that for each tender used, there should be a corresponding line in the accounting document as such that each tender should be mapped to a certain reconciliation account. Currently, the setup in accounting is like this:

Instead of the single line in the red box, there should be three lines in the red box, one for each tender type and one for the output tax (in effect, for each condition type in the billing, there should be a corresponding line in the accounting for the recon account).

I have tried classify G/L Accounts for document splitting on this but it does not work.

Please advise what needs to be done for this.

Your assistance is highly appreciated.

Thank you very much.

Carlo Enrico Datoc

Recon1.png (75.6 kB)
Recon2.png (102.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 22, 2016 at 08:55 AM

    Hope you are aware how a value from SD side would be posted to FI. From your screen shot, you were posting that 80000.00 with one line item and you want split to happen from FI side which is not possible with the SD configuration. You need to discuss with your FI team. From SD side, you need to differentiate the Account Key in pricing procedure

    G. Lakshmipathi

    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.