Convert AR/AP One Company to Another

jgersic

jgersic

Reputable Poster
This is a multi-part message in MIME format.

------=_NextPart_000_00A0_01C068D8.6CC88880
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have been asked if there is a way to do this, and other than table =
hacks, I don't know of a way through the application:

The business wants to convert AR/AP of three companies into one company. =
Is there a way through the application which could move it to another =
company?=20

I guess this could be applicable if the company dissolved old =
subsidiaries and wanted to just absorb their books into their accounting =
system. Any ideas would be really appreciated. Otherwise I am going to =
look at possibly doing table edits and just change the appropriate =
account numbers/companies/business units, etc. to the new value.

John

John Gersic
OneWorld Administrator
eGlobe, Inc.=20
703/787-5727 x.2033
[email protected]

------=_NextPart_000_00A0_01C068D8.6CC88880
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have been asked if there is a =
way to do=20
this, and other than table hacks, I don't know of a way through the=20
application:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The business wants to convert AR/AP of =
three=20
companies into one company. Is there a way through the application which =
could=20
move it to another company? </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I guess this could be applicable if the =
company=20
dissolved old subsidiaries and wanted to just absorb their books into =
their=20
accounting system. Any ideas would be really appreciated. Otherwise I am =
going=20
to look at possibly doing table edits and just change the appropriate =
account=20
numbers/companies/business units, etc. to the new value.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>John</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>John Gersic
OneWorld =
Administrator
eGlobe,=20
Inc.
703/787-5727 x.2033
<A=20
href=3D"mailto:[email protected]">[email protected]</A></FONT></DIV></B=
ODY></HTML>

------=_NextPart_000_00A0_01C068D8.6CC88880--
 
John,

There is more at issue that simply changing the AP/AR documents. The GL is also impacted by this change.

Here are some things to consider;
When folding the companies together, are P&L business units being consolidated?
Are Balance Sheet accounts being consolidated?
Could this be solved by creating a consolidated report instead of changing the table records (Very messy by the way)?
Could the change be made for all documents entered after a specific date and allow the existing 'trade' balances be clears when payment occurs?

Any changes should be done in prototype (CRP) before production and approved my the financial managers before changing production. JDE does provide some chart of account mapping alternatives under the advanced section. These could be used to move (consolidate) the GL balances. You can call me and I'd discuss with you more of the details if you like.

Mike Dupaix
JDE Certified Professional
(630) 904-5373 - Office/fax
(630) 750-2500 - Cell

To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=2856
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<
 
Re: re: Convert AR/AP One Company to Another

Mike,
you are simply the MASTER when it comes to financial questions !
dave


NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4
 
I was looking at document# WFN-99-0102 from the knowledge garden..would
this accomplish the task? What about the AR and AP ledger, is that something
that I would have to worry about? (the document only mentions F0911, F0901
and F0902...

John

John Gersic
OneWorld Administrator
eGlobe, Inc.
703/787-5727 x.2033
[email protected]
 
John,

I would consider:

Set up a new company in GL, AP, AR.
Do journal entries as needed.
Start transactions in the new companies.
Leave history where it is.
When the old items are paid, you are over to the new company.

Avoids doing risk-prone stuff with tables.
People will say "But you have to work with 3 companies for awhile". Yes, but
that beats the major headaches of converting a whole bunch of data. Such
stuff never goes as planned. Especially in buggy software.

Dave Mallory Denver Water
 
re[2]: Convert AR/AP One Company to Another

John,

The aforementioned document only changes the GL accounts and transfers the GL balances. It does not address the AP or AR ledger files balances (F0411 & F03B11).

If you change the only the GL, your integrity reports will be out of balance in the same fashion if you changed only the ledger files.

If you must change the balance information, you must redirect the AAI's, transfer the GL balances and ledger balances when no one is on the system. You must change the AID fields in the ledgers to point to the correct AAI account (GL account) short ID. You should also change all company fields to reflect the changes.



> I was looking at document# WFN-99-0102 from the knowledge garden..would
this accomplish the task? What about the AR and AP ledger, is that something
that I would have to worry about? (the document only mentions F0911, F0901
and F0902...

John

John Gersic
OneWorld Administrator
eGlobe, Inc.
703/787-5727 x.2033
[email protected]




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=2871
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

<



Mike Dupaix
JDE Certified Professional
(630) 904-5373 – Office/Fax
(630) 750-2500 - Cell
 

Similar threads

F55EM06 Update Issue
Replies
8
Views
2K
Larry_Jones
Larry_Jones
jgersic
SP 13.3 Post Reverse Entry
Replies
0
Views
2K
jgersic
jgersic
jgersic
TC with PO to Choose File
Replies
0
Views
2K
jgersic
jgersic
Printing on a DOT matrix printer
Replies
2
Views
3K
DBohner-(db)
Term server OW user setup
Replies
1
Views
2K
SSAJAROFF
Back
Top