Balance by BU

[wkwong]

Hi List,

Has anyone implemented a set up that has Business Unit by Balance sheet?

I have many BUs and that each BUs needs to be reported in Balance sheet separately.

eg . i may have a customer that buys from me different items that belong to different BUs. How can I enter any Sales order or invoices but yet get it to post to respective l BUs accordingly. In this case, I need to have separate AR a/c maintained by BU.

Is this possible? This is very challenging...

 

[ame]

On your second question.. are you creating one sales orders against multiple
branch plants and want the revenue to show up against one BU or do you want
the business unit from where it ships to get the revenue? thanks, bobby



Has anyone implemented a set up that has Business Unit by Balance sheet?

I have many BUs and that each BUs needs to be reported in Balance sheet
separately.

eg . i may have a customer that buys from me different items that belong to
different BUs. How can I enter any Sales order or invoices but yet get it to
post to respective l BUs accordingly. In this case, I need to have separate
AR a/c maintained by BU.

Is this possible? This is very challenging...

 

[mjf]

This is possible. I have done partial balance sheets according to business
units. In OneWorld a balance sheet is defined by a range of object accounts
eg 1000 - 5999 may relate to balance sheet and 6000 - 9999 to P&L.

We currently have balance sheet accounts on many of our business units for
inventory and fixed assets. These are controlled by aai's and it can get
reasonably complex to maintain them. I have not gone down as far as AR and
AP, but with some thought to the aai structure I suggest that it probably
can be done. Possibly look at setting the G/L class field on the customer
master and supplier master to the business unit (ie 1000 in G/L class =
business unit 1000) then construct your aai's around that.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K






OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K

 

[pjoh]

We have approx 20 Operating Business Units but only one Business Unit Balance Sheet. At month-end we must report the Balance Sheet by Business Unit for Capital Employed and Return on Investment calculations.

Our method to date is not very elegant but it is working:
- all entries to the Balance Sheet carry the Business Unit number in the subledger. At times this is manually recorded, at other times we invoke Flex Accounting to complement the AAI's and record the business unit into the subledger.
- at month-end we use Simple Balance Sheet R10111B to report the Balance Sheet for each of the 20 Business Units. In the Data Selection Criteria for the report, the required Business Unit is specified in the Subledger-G/L (F0902) selection criteria. The Business Unit Manager receives an Income Statement and Balance Sheet for his Business Unit and this meets company requirements.
- we have been doing this for 4 months prior to which we used a very complex set of Business Units and AAi's to accomplish the same goal. We find the new setup to be quite efficient although vigilance must be maintained over the subledger to ensure it always bears corrct values.

 

[KSmithCPA]

Why not just set up each plant as a separate company number, each with a complete balance sheet? Then it would be a realatively simple process to roll the companies up for consolidated reporting. This would keep the AAI's realatively straight forward, and it is much easier to roll information up than to try and break details out.

You are limited to how many company numbers you can set up, but unless you have 100,000 plants I don't think it will be a problem.

Just an idea.