Reconciliation Account Splitting in Billing

[Former Member]

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

[Lakshmipathi]

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