cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor's reconciliation account change

Former Member
0 Kudos

Hello

There's change in the reconciliation account of vendor....

for this strategy is like this....

first making the all open items of vendor equal to zero....using vendor clearing account...

For e.g

Vendor reconciliation a/c(old)-Dr.

To vendor clearing a/c-Cr.

Now after changing the reconciliation account:

vendor clearing a/c-Dr.

To Vendor reconciliation a/c(new)-Cr.

so there will be open items for Vendor reconciliation a/c(old) and vendor clearing a/c.

How its going to take care of open items..........

regards

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Something doesn't seem right to me. At the end you will have open items on the new reconciliation account, only.

Regards,

Milen.

Former Member
0 Kudos

Hi

There is already open items of existing invoice(credit entry) after that open items of step no. 1 Vendor reconciliation a/c(old)-Dr.

is also exist.

How its need to take care.........how i am going to clear it...........

regards

former_member188028
Active Contributor
0 Kudos

The best way is shifting the line items from old recon to new recon. account.

Vendor Dr(Old recon)

Vendor clearing a/c

After changing the recon. account

Vendor clearing a/c Dr

to Vendor a/c(New recon)

F101 also not the proper solution, as this will post an adjustment entry at period end to show the balances in the existing recon account and next month first date it'll reverse the same entry, because the items clearing happen only with the account which was at the time of original posting,so this is not proper solution.

Rgds

Murali. N

Former Member
0 Kudos

Hi Murali,

I am also following this solution only.....but my client's query is that there is open items exist for invoice(RE) old and entry of old recon a/c also..................

so how to handle this.......

regards

former_member188028
Active Contributor
0 Kudos

1. Post accounting entry to transfer the items from old recon to clearing account

2. Clear Vendor in F-44(with old reconciliation account, here system clears the items of old recon)

3. Now change recon to new and transfer the balance from clearing account to new recon.

Rgds

Murali. N

Former Member
0 Kudos

ok, start with F-44, select the vendor open item (1st tab- standard) and then F7 (or button <Charge off difference>). Next is posting key 50- the chosen adjustment account. This way you will have Dr Vendor (PK27) / Cr Adjustment account. Vendor account will be cleared. Similar with the adjustment account itself, after second part of the task.

Regards,

Milen.

Former Member
0 Kudos

Hey thanks for the solution.............

But the problem is that document splitting is activated currently.............before these document splitting was not activated......so when i am doing F-44 this is showing following error:

Document splitting: Items for clearing 1000/5100001337/2011/001 not found

Message no. GLT0002

Diagnosis

Document splitting cannot perform clearing because it was not possible to find complete splitting information on the items to be cleared (company code, document number, fiscal year, item).

System Response

Clearing cannot be performed and the document cannot be posted.

Procedure

Exclude the affected item from clearing.

It may be that this item was not posted with active document splitting. In this case, this item or document would have to be migrated.

for this what is the best solution for it.............there are so many old items without document splitting.....

regards

former_member188028
Active Contributor
0 Kudos

Please check program RGURECGLFLEX, also read the program documentation properly.

Rgds

Murali. N

Answers (2)

Answers (2)

nico_dewaele
Active Contributor
0 Kudos

change the reconciliation account in the vendor master (FK02)

maintain OBBW

run F101

Former Member
0 Kudos

Dear KS,

You have to transfer the line items one by one, then you would get all line items to new reconciliation accounts. so that you can track all the invoices ( in text or in assignment field enter the invoice number).

In one entry you can add 999 line items. if you dont transfer it line by line the system wil post only one entry to the new reconciliation account. if this is the case for receipt of the payments how you track.

so transfer the open invoices line by line.

thanks & regards,

siva reddy.s