Vendor Open items transfer from one Recon to Another recon

[Former Member]

We have wrongly maintained one recon account in Vendor.

Is there any way to trnasfer Vendor Open items transfer from one Recon to Another reconciliation account..

[former_member188028]

Hi,

The best way is to transfer the items from old to new reconciliation account.

Please use the following entries to transfer.

1. Dr Vendor a/c(Old recon a/c)

Cr Vendor clearing a/c

After nullifying the balance in old recon account, here chage recon in the master.

2. Dr Vendor clearing a/c

Cr Vendor a/c(New recon a/c)

F101 only post the adjustment entry at period end and reverse the same entry in next period. So, transferring the items is the best method. If you have volume of data, then create a LSMW for this.

Rgds

Murali. N

[Former Member]

Hi,

yes, Murali said it true. For the sake of history, you have to re-class the transaction one by one.

Don't forget to clear the open item manually or using automatic clearing to made open item become closed.

Hope helps

[atif_farooq]

Hi:

I would recommend to do that on the last day of your reporting period other wise you will need to create new vendor account with correct recon account and transfer the balance using F-30. However if you go for 1st option then transaction F101 will reclassify your vendor positions with new reconciliation account. For doing so maintain adjustment account in OBBW . Doing so will create adjustment postings and reverse them on the next day which will be next reporting period.

Hope it will help you.

Regards

[Former Member]

Hi,

See the following thread it'l surely help for transfering open items from one account to other, then change Recon account in vendor master.

[Former Member]

hi,

Check the vendor balances. If the any balance is there in that vendor account, then transfer the same to some other general vendor account and change the recon account in the master. and now again transfer the balances from general vendor account to your vendor account.

Use F-02 or FB01 with the posting Key 21 & 31

rgds

gopal