Special GL - alternate reconciliation accounts

[jeff_mayfield2]

I'm have difficulty bringing together the concept of Special GL accounts and Alternate Reconciliation accounts as they relate to customer invoices. Can anyone help point me in the right direction?

We have a requirement to create a separate A/R subledger to collect a specific goup of A/R invoices. These need to be aged separately and the A/R needs to be separately identifyable in the Balance Sheet. A Special GL account seems to be the best way to solve these requirements but I am not able to sucessfully match the Special GL configuration with the SD invoice billing.

I would appreciate any thought or help on this issue.

Thanks,

Jeff

[Former Member · Accepted solution]

Hi Jeff,

You can create the Reconciliation GL's for AP and AR, then for the list of vendors/Customers give the reconciliation accounts created.

Create Reconciliation account (Advance) in FS00 for Vendor and Customers, then assign the GL's in OBXR (Down payment for Customers). Assign the GL's in OBYR (Down payment for Vendors).

[Former Member]

Hi,

Your requirement looks to be having an additional customer account group wherein you will be treating the customer receipts / invoices in a specific manner. I don't see a need to maintain it as a special G/L. All you will need to do is create a new customer account group, customers at the customer level and create a new GL account and associate it with the customers as a recon account at the G/L level. This should solve your problem.

Regards,

Zubair

[aman_goel]

Hi,

- First you determine the customers for which the alternative reconciliation account is required.

- Then check the reconciliation account for that customer.

- Check the existing special GL indicators which are present using following path,

Financial Accounting - Accounts receivable and payable - Business transactions - Postings with Altenative Reconciliation account - other Special Gl transactions - Define alternative reconciliation account for customer/vendor. (For down payments, the path is Financial Accounting - Accounts receivable and payable - Business transactions - down payment made - Define alternative reconciliation account for down payment)

- Depending upon the type of transaction (viz. RDD or interest etc.) check whether there is a special GL indicator existing. If yes, then maintain the reconciliation account and the alternative reconciliation account for the respective reconciliation account. You can create your own special GL indicators and assign the reconciliation account within that.

Hope this helps.

Thanks,

Aman Goel