Hello,
I have a situation where I cant use cross validation rules in this scenario. I have users from other departments doing manual JE to Payables (liability) account. Now when AP runs trial balance report its not reconciling with GL because those entries were not posted from AP. Is there a way I can lock down Payables account to be used only from JE source of AP? So no manual entries or no other source can use the payables account. I cant use Cross validation rule for this scenario. Any help is highly appreciated.
Thanks,
Srini

Hi Srini,

You may try this..

Add the qualifier 'Third Party Control Account' for GL Natural Account segment.

Enter ‘Payables’ for the Third Party Control Account to designate the account as a Control Account. Access to this account will be restricted to Oracle Payables.

This will allow you to enter journals for this account only from AP subledger and no manual entries from GL are allowed.

Regards,
Shanmuga

Thanks Shanmuga!

Thanks Shanmuga for your reply. I would appreciate if you can explain how exactly can I add this qualifier. This is not one of the qualifiers I see in the list of qualifiers I can enable. Is this qualifier new in R12? I'm sorry I should have said in the beginning. I am on 11i.
Thanks,
Srini

In 11i you can enable security in the Define Flexfield Segments window to protect your control accounts from modifications in General Ledger.

Third Party Control Account qualifier is available in R12.

Hasan

Could one later remove the qualifier 'Third Party Control Account' for GL Natural Account segment value (Payables), and then start again entering manual Payables Journals into GL (directly) without causing any dis-functionality to the Applications, apart from Accounts Payable's Trial Balance not reconciling with General Ledger's Payables?
Thank you

In the "Third Party Control Account" list of values (LOV) to control Payables, what value to choose: Supplier or YES?
Do we have to enforce the above by also choosing YES from the "Reconcile" LOV?
Thank you.

Hello Hasan
Please, help me by answering my question when you a a moment.
Thank you.

Hello Hasan
Please, help me by answering my question when you a a moment.
Thank you.

Sorry you have asked this question twice or perhaps thrice.
Sometimes I do ignore the posts if they are not related to the topics that are already covered. The purpose of the forum is to let members clarify confusions/questions they have about what they have learned in the lessons. Please keep that in mind. Thank you for your understanding.
To answer to question briefly the value "Supplier" would restrict the account to be used in supplier related transactions. The value "Yes" would let this account be used for both "Suppliers" and "Customers". I will talk more on this once I am back to AP, AR, and CE videos after finishing first round of EB-Tax.