Changing Control Account in A/R Down Payment Request Scenario

[rishiagrhmc]

I have created a A/R Down Payment request and Incoming Payment for it, but am I unable to change Control Account for the Customer in either of the transaction.

A/R Invoice has to be posted to a different Control Account than the default in Customer Master, but when the paid Down Payment request is being linked to that Invoice, Control Account mismatch is occurring.

Please suggest a solution!

[jitin_chawla · Accepted solution]

Down Payment document does not create a Journal Entry but in ODPI table, CtlAccount is booked whatever is defined in the BPMD.

When you create the Payment, it takes this CtlAccount as base and creates a Payment for DPR. Now, if you change the Control Account in BPMD to another account, and then create Invoice and apply down payment it will give you error. In such a case try Manual Reconciliation of Invoice and Paid DPR as it will create a JR type entry for such reconciliation.

Please test scenario in DEMO by having a different account when creating DPR and when trying to create Payment. You will see Payment still picks in Journal Entry of Payment, CtlAccount of DPR.

Kr,

Jitin

[rishiagrhmc · Accepted solution]

Hi Jitin,

Thanks it really helped, was able to adjust the DPR Payment with the Invoice through Manual Reconciliation!

[rishiagrhmc · Accepted solution]

Hi Jatin,

Is there any option by which we can change the Control Account in the ODPI table while booking the Down Payment Request??

Manual Reconciliation on a day to day basis is being really tedious and error prone!

[rishiagrhmc]

Jatin,

There is another issue that we are facing with Control Account Mismatch, please see if you can help in that

https://answers.sap.com/questions/13463007/control-account-issue-in-return-request-scenario.html#

[rishiagrhmc]

Jitin,

I think when making "A/R Invoice", you haven't changed the Control Account in "Accounting" tab and its coming as per what is mapped in "Accounts Receivable" of the BP master.

In our case each A/R Invoice's Control Account is changed by us based upon the Items that we are billing to that Customer.

[jitin_chawla]

I checked in DEMO. No error appears for me in DEMO.

Which patch and Version are you working with? Was the database upgraded? Are you able to reproduce the issue everytime.

What is the JE created when incoming Payment for DPR is created? Are involved Down payment Accounts similar to one defined in the Accounting tab of the BP master Data?

Kr,

Jitin

[jitin_chawla]

The Down Payment Clearing Account and Down payment interim account are impacted when Payment is created for DPR.

The same are defined under the BP Master Data for which DPR is raised.

As such there is no place in Payment where control account can be changed.

What error are you getting when applying the DPR to Invoice?

KR,

Jitin

[rishiagrhmc]

The error that is coming is:-

“You cannot add document; control accounts in the invoice and linked down payment do not match.”

The problem is as explained earlier that while posting the linked down payment I do not have any option to select the control account manually!

[jitin_chawla]

Hi,

Under Administration > Setup > Financials > G/L Determination ; Sales and Purchasing Tab, there is a checkbox as 'Permit Change of Control Account'.

What is the status of that checkbox. Is it marked? If no, what is your testing result if it is marked.

KR,

Jitin

[rishiagrhmc]

Jatin,

The Checkbox is marked.

The Problem is “A/R Down Payment Request” doesn’t create any Journal Entry so there is no option of Control Account here.

The Journal Entry is created only when Incoming Payment against the “DPR” is posted, but here no option is coming to change the Control Account!

[jitin_chawla]

Hi,

I think the best possible way to go it cancel the DPR and Incoming Payment and create afresh with correct control account.

Control Accounts cannot be changed once document has been posted in the system. Infact, any entry which has been posted in the system can be amended with only a few editable fields. Data recorded is legally binding and as such cannot be changed later on.

Please test your scenario in DEMO database.

KR,

Jitin

[rishiagrhmc]

Hi Jitin,

Thanks for your revert.

The issue is actually that while creating a New “Down Payment Request” or “Incoming Payment” against it, not getting any option to change Control Account!

Not trying to change Control account for already posted document!