ERPstuff - Oracle EBS Community

Dear all,

we are using oracle 11i. We have 7 Dept. Now we want seperate T.B for 3 depts out of 7. Everything is Fine when we r changing the fsg account assignment but the problem is with Trade Receivables and Payables can we seggregate trade rec and trade paybles account. Waiting For your Kind advice.

Sayeed,

Please explain issue & your requirements in details

Dear.

actually we want to seperate one company from the existing set up. That company occupies 3 dept.Now we Want the Seperate Tb for 3 particular Dept.The problem is with accounts receivable and accounts payables control accounts .(The 3 dept has customers and Suppliers and they share same control Accounts like other depts).

awaiting your kind response.

Regards
sayeed khan.

i can only understand your requirement that:
In existing setup, Dept. 3 is not balancing segment value its Cost center ? If you want separate TB for Dept. 3 you have to setup new SOB.
U want to change AP & AR COA codes assigned to Suppliers & customers ? Yes you can change coded for future transactions only.

i will tell u the scenario in detail.
We r having 7 departments in our balancing segment . tyre,oil,refrigeration,hotel,
Handling , carpentary and packing .Currently we r getting single t.b for all the depts..

Now company wants to separate the last three depts.. they want separate t.b for hand? carp? and pack? The problem is with the control accounts A.P and A.R
Bcoz that 3 depts are sharing the same control accounts code .each dept is having there own customers and suppliers. ..We r planning to change the codes of A.p And Ar control accounts and assigning this accounts to three depts. Customers and suppliers ..For the existing balance we r thinking to pass a manual j.v . pls advice for further actions.
Awaiting your valuable comments.
Regards.

Dear Sayeed,

if you have 7 values in balancing segment then you can get 7 TBs instead of one consolidated TB. Run standard TB reports & view individual TB for each balancing value.
This is no issue is changing AP & AR control account codes for future transactions and Pass manual JVs for previous transactions.

DEAR AMAN.
IN TRADING WE HAVE ONLY ONE BALANCING SEGMENT. I WAS TELLING U ABOUT THE COST CENTRES. WE WANT TO CONVERT THREE COST CENTRES IN ONE COMPANY.WE DONT WANT TO SETUP A SOB INSTEAD IN REPORTING WE WILL PICKUP THOSE THREE DEPTS.


AWAITING YOUR VALUABLE SUGGESTIONS.

REGARDS.
SAYEED KHAN.

In customized reporting, you can achieve your goal but not in standard reports.
Ultimately, you have to setup one new SOB. You can use existing COA & calender & currency, define OU, & add new company value in COA & use security rules to restrict Dept.

Thanks for Your Cooperation. we will go according to your advice.

You can use your existing setup or SOB with just adding New OU & balancing segment value and you can generate TB for separate co. from current SOB. Perform setup changes in TEST and verify results. You can go for either of above approach.