How to create Two seperate reconciliation account for one Vendor???

[Former Member]

Hi all,

We have a situation out here. The client has many vendor which are supplying raw materials as well as providing services.

So in such a case the Vendor will be created twice under two different reconciliation accounts. But I want to know whether there is any exit i.e. can we create one vendor under two seperate reconciliation accounts?

If this can happen let me know the process as well as what all accounts will be hit during postings or report generation.

Cheers!!!!!!!!!!

Dhruva

[Former Member]

It is not possible to have two recon accounts for the same vendor. What I may suggest is to create special GL indicator to tag it to the other recon account

[iklovski]

Hi,

It's not possible; create two vendors instead.

Regards,

Eli

[Former Member]

Hi

from my point of view you could only have other GL accounts when you use a special GL key.

If the services invoices are inputted by FICO only this could be realized but i think it is not advisable.

Cheers

Tim

[Former Member]

Hi

First you need to have to two Recon Accounts(GL Accounts) one for Materials(e.g GL-XXXXXX) and another one for Services(e.g. GL-YYYYYY).

In the GL Master(XXXXXX) you can check the box "Recon A/c Ready for Input". You can maintain this GL Account(XXXXXX) as Recon Acct in Vendor Master.

Once you do this, when you post invoice(FB60), the field - GL Account in Details tab will be defaulted to XXXXXX and will be available for editing. USER then can change the GL Account to the RECON ACCT(YYYYYY) created for services.

I have tried this to correct the GL Account when clearing the line items which were having wrong recon acct due to error in loading of initial entries. And this works fine.

There will be no change or impact on accoutning entries except that the balance will be updated to another acct(YYYYYY) instead of vendor recon acct(XXXXXX). It is as good as posting with a Spl GL indicator.

I have never tried the same for MIRO / Invoice verification for a Purchase Order. It may be the case that GL acct is not available for editing even after the above change. In that case it may be necessary to modify the screen variant in MM to make the GL Acct field available for editing. Hope it is allowed. Try it and check if it works!!!!!

Also be aware that the GL Field is available for editiing and make sure that it does not cause any other issues.

Hope it helps.

Thanks

Prasad

[former_member787999]

If the above works I learned something new today! One thing I would caution you about is that our auditors run year end reports by reconciliation account and while some reports pull in transaction data recon accounts others seem to pull in master data recon accounts. The ones that pull in master data recon account assignments would likely not tie to the GL balance.

Not a big deal as it's explainable but wanted to point it out.