srini (User)
Fresh Boarder
Posts: 4
|
Restricting Payables Account to only AP Source 14 Years, 4 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
raja (User)
Junior Boarder
Posts: 39
|
Re:Restricting Payables Account to only AP Source 14 Years, 4 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 14 Years, 4 Months ago
|
|
Thanks Shanmuga!
|
|
|
|
|
The administrator has disabled public write access.
|
srini (User)
Fresh Boarder
Posts: 4
|
Re:Restricting Payables Account to only AP Source 14 Years, 4 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 14 Years, 4 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 13 Years, 10 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 13 Years, 10 Months ago
|
|
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.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 13 Years, 10 Months ago
|
|
Hello Hasan
Please, help me by answering my question when you a a moment.
Thank you.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 13 Years, 7 Months ago
|
|
Hello Hasan
Please, help me by answering my question when you a a moment.
Thank you.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Restricting Payables Account to only AP Source 13 Years, 7 Months ago
|
|
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.
|
|
|
|
|
The administrator has disabled public write access.
|
|