changing customer master

[former_member600294]

Hi

In the customer master we have assigned a reconciliation a/c. Now i want to change That reconciliation a/c.How to do that.Pl. explain with TC

Thanks

shivaji

[Former Member · Accepted solution]

Hii u can carry out any changes in customer master data through T.Code XD02.

here u can give the new recon. account and save the same. changes will be saved.

reward point if helpful

sejal

[former_member600294 · Accepted solution]

Now if i change the recon a/c in TC-XD02 what will be the impact of the balance laying with the same customer with the old recon a/c.& will it automatically transfer the balance to the new recon a/c.What will be the overall impact on this changes

Pl. advice

Thanks

shivaji

[Former Member · Accepted solution]

Conceptually!! The system won't transfer Balances to new Recon account automatically. You can not change the Recon account if the balances are exits.

Satish

[Former Member · Accepted solution]

If a recon account is changed then

1. If no transaction data is posted to Customer / Vendor account - it is simple and the reconciliation can be changed in the Master record.

2. If the transaction data is already posted and if you want to change the reconciliation account in the master record, you can still change it. Here, the transaction data already posted will remain the old reconciliation. As and when the old open items are cleared (incoming / outgoing payment) it gets nullified and all the new postings will be reflected in the new reconciliation account.

3. If the Balance is not zero, we can change the reconciliation Account, but we have to maintain a clearing Account / adjustment in Configuration (Transaction code OBBW) and then execute the transaction F101. While executing this transaction select the check box "Change Rec Account". After executing this transaction, this will move the balance to the new reconciliation account.

regards

thavishi

[Former Member · Accepted solution]

Dear Satish,

i can not agree, changing a recon account to a customer or vendor is part of daily business and it is not acceptable to clear all open items before changing the account.

SAP offers transaction f101 for changed recon accounts - see tab parameters. If requested, the system carries out correction postings on adjustment accounts.

So - changed recon accounts are definetely no problem in AR/AP.

Best regards

Horst

[Former Member · Accepted solution]

Hi HorstRn

Thanks for correcting me. May be you are true, but here i have few douts,

1. Its easy to change if there are few customer but, what if the customer are huge. It becomes very tedious to change for every one.

2. For suppose, u have posted a invoce to the customer for 1000$. and changed the Reconcilation Account, and now if the payment is received for this invoice, then how this is cleared against that particular invoice and how amount is deducted from first Reconcilation Account? Where is the link to old reconcilation account?

3. If this adjustment is done with F101 at the end of the month/year, what if client ask a report in meddle of the month.

4. You said its part of daily business.. can u give me few examples. why it is so often need to change the Reconcilation Account?

Can you please tell me how to change Reconcilation Account and Balancing the Reconcilation account with total of Cutomer/s.

[Former Member · Accepted solution]

Regarding your question no. 2, the link to old reconciliation account is available in the customer line item in table BSAD. The new recon. a/c. mentioned in the customer master is used for transactions after the change in the customer master record. When clearing happens, system doesn't use the recon. a/c. on the customer master, but the one on the open item (it fetches it from the table).

[diogo_peretti · Accepted solution]

In general you can only change recon account when balance is zero. In

your case, I believe that you received the warning message "F2067" when

the reconciliation account was changed via FD02.

(F2067 ; Account has been posted to; hold balance sheet adjustment)

If you look at the long text of the warning message, it tells you

exactly what should be done.

"By changing the reconciliation account in the open item master record

the proportionate values from the items open at the time of change are

not posted to the new reconciliation account.

On the balance sheet key date the open items from the old reconciliation

account are allocated to the new reconciliation account using adjustment

accounts. This allocation is carried out automatically when you create a

sorted list of receivables and payables using report SAPF101.

The postings necessary are only carried out for G/L accounts and are

cancelled on the first day of the subsequent month (balance sheet

adjustment posting)."

From the above, it explains that you will need to run SAPF101. Please

read the documentation on this report to guide to to be able to proceed

further. Documentation on this report/program exists when you go via

SA38>goto>documentation. From here, you should be able to proceed in

transfer posting.

regards.

[Former Member]

Hi,

You can change the recon account by the tcode XD02

Regards,