Good Evening,
I have a couple questions hopefully someone can help me clarify.
- What is the benefit of a one to many vs one to on in regards to system database(s) and application databases?
- Can intercompany transactions occur between application databases?
As always I appreciate any help!
Regards,
N
*This post is locked for comments
Nathan,
The explanation is listed on page 30 of the MultiCompany manual found under Applications> User Guides folder
Processing Inter-Company Transactions Between Different Databases
When transferring data between companies that reside in different application databases, it is necessary to export the data from one database and import it into the next.
Exporting Company Data from a Database
Use the following procedure to export data from an application database when transferring it to a company in a different application database.
1. Log in to the application database of the company from which the data is being exported.
2. Choose Module | Multi-Company | Screens | Inter-Company Export/Import. Inter-Company Export/Import (13.510.00) displays.
3. Select Export Inter-Company Transactions.
4. Enter the company ID from which transactions will be exported.
5. Enter the ledger ID from which transactions will be exported.
6. Enter the period for which transactions will be exported.
7. Enter the file path to which the data should be exported, or click the Folder icon to open Path Selection (13.510.01) and browse to the appropriate directory.
8. Click Begin Processing.
Importing Company Data to a Database
Use the following procedure to import data from an application database when transferring it from a company in a different application database.
1. Log in to the application database of the company to which the data is being imported.
2. Choose Module | Multi-Company | Screens | Inter-Company Export/Import. Inter-Company Export/Import (13.510.00) displays.
3. Select Import Inter-Company Transactions.
4. Enter the company ID to which transactions will be imported.
5. Enter the ledger ID to which transactions will be imported.
6. Enter the period for which transactions will be imported.
7. Enter the file path from which the data should be imported, or click the Folder icon to open Path Selection (13.510.00) and browse to the appropriate directory.
8. Select the files to be imported from the list under Available Files. Use >> to transfer individual files, or use Select All >> to transfer all of the files. Those files transferred to Selected Files will be imported.
Note: The exported files listed under Available Files are named by concatenating the Due From/Due To company ID, the batch number, and the module (for example, 0060-To-0010-000141-GL.exp).
9. Click Begin Processing
Hey Elaine,
That is exactly the information I was looking for. Thank you! We have a single company that has a different fiscal year than the rest. We do have intercompany transactions that are needed between the two app databases. Would you have a link that gives a bit more detail of the export/import process to accomplish this? Hoping there is a Partner Source link for this.
Thanks!
Nathan,
SQL licensing allows for 1 system dbase and any number of application databases except for another test copy.
I think you are asking about having a single application database with many companies versus having each company in a separate application dbase.
To be in the same application database, a company needs to share fiscal years, base currency IDs and acct/subaccts. Using a single app dbase also allows you to use the same vendors, customer, accts.
You can have intercompany transactions between different application databases but you have to run a process to export the data and then another process to import it. When the companies are in the same application database, the intercompany transactions are created when the batch is released.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
