2,935
*This post is locked for comments
Hey Roger,
The variable allocation accounts were created and saved first without any distribution or breakdown accounts. I'm just trying to import the distribution accounts and breakdown accounts which relate to an existing variable allocation account.
There is an eConnect import available for Variable Allocation Accounts:
msdn.microsoft.com/.../ff623661.aspx
I'm guessing that it isn't showing up because you have to add the GL account to multiple tables (GL00100, GL00105) in addition to the allocation table.
Sue, I have imported the account indexes into the Variable Allocation Table, but the related accounts do not appear in the Variable Allocation Account Setup Window. Is there a process to run after import to get the accounts to show up? What format does the data need to be in to be successfully imported, such as the "separator" fields?
Unfortunately there is no Integration Manager setup for doing this. But what I have done in the past is to do a direct table integration into the Variable Allocation Master. And I know some people are saying just do a sql export and import from one company to another.
1. Reason for not just taking the contents of this table (GL00104) copying it into the new company same table is that you would need to make sure that the ACTINDX is exactly the same on all of the accounts. Which means taking an export out of the GL00104 in the test company and then making sure that all the accounts are exactly the same. If that is the case then you could do a SQL export and then import them into the new company.
2. If you get the contents of the GL00104 (test) and export to excel then do a vlookup against the GL00105 (test) Account Index and then bring in the Account Number String. Then you can do a look up from your new company GL00105 (new) and do a vlookup against the new company for the ACTNUMSTG (new) and come up with the new Account Index. Then with the new information for the new company. Do a Direct Table import into the Variable Allocation Master Table.
Takes a little bit of time to do the queries and get all your data ready, but far easier than sitting and re-entering them all in.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (