2 Reconciliation Account to one vendor

[Former Member]

Hi All,

one vendor is there some X

he is providing matieral and Services

if u assign only one reconciliation a/c to him

in the balance sheet it shows total amount of that vendor X

but where as my client is asking that at blance sheet he wants to show vendor X for matiral and vendor X for services seperately

If u maintin only one reconciliatin a/c to vendor it is not possible to show them separetly in the balance sheet

So any other option is there????????????????

[Former Member]

Hi Renuka,

There are two configurations you need to make. Firstly if you do not have a reco. account for services provided, please create one. The only additional setting that you would have to make is that in the GL account master for both your reconciliation accounts you would have to add a tick for the field - "Recon. acct ready for input" in the create/bank/interest tab.

Then you need to make a configuration setting in SPRO. Define alternative reconciliation account. The path is below.

SPRO->Financial Accounting->Accounts Receivable and Accounts Payable->Business Transactions->Postings with Alternative Reconciliation Account->Define Alternative Reconciliation Accounts

The alternative GL account you should have the Recon account for services. So when you are making a posting (non enjoy transaction) you will see that the reconciliation account appears in the screen and you would be able to choose the recon account you need.

Reward Points if Found Useful

Regards,

Jigar

[Former Member]

Hi,

In case of vendor i have done the configuration suggested, functionality work perfect in FB60 but in MIRO the G/L account field is still display only. So effectively i am not able to change the account.

Any solution for this?

[Former Member]

Hi,

Here you can define the alternative reconciliation in front of that reconciliation account which you define in the Customer Master Data :-

For setting in FI :-

IMG -> Financial Accounting ->Accounts Recievable and Accounts Payable -> Business Transaction -> Postings with alternative reconciliation account ->Define Alternative Reconciliation Account for Customers or Vendors -> Double Click on the Line Item

For setting in SD :-

1. IMG -> Sales and Distribution -> Basic Function -> Account Assignment/Costing -> Reconciliation Account determination

-> Define Access Sequence

(This is used to define based on what criteria the system will propose an alternative customer GL reconciliation account)

2. IMG -> Sales and Distribution -> Basic Function -> Account Assignment/Costing -> Reconciliation Account determination

-> Assign GL Accounts

(This is the Alternative GL account assignment, which will override the reconciliation GL account in customer master)

P O I N T S P L E A S E... ... ...

Cheers

Raghu