You’re offline. This is a read only version of the page.
1,800
We would like to setup a new GP entity/company such as called as Malaysia Company. But we would like to load a chart of account (full COA list) from our consolidation company. How can we do that?
*This post is locked for comments
Hi Josey,
The "Account" destination used in IM does show fields for Posting Type and Typical Balance. I assume they show in all versions of IM but I could be wrong.
Also the account master is the GL00100. Hope this helps.
Thanks,
Donald Wisch
Thanks, Leslie.
I have couple questions for you.
I reviewed the Integration Manager Tool, we have a template for uploading Chart of Account. However, I found the upload fields contain 3 fields only such as Account Number, Category and Description. But in the front-end Account Maintenance window, it has Typical Balance and Posting Type. However, these 2 fields do not exist in the IMTool. My question is how I can add these 2 fields into the IM templates?
The other question I have is to use Table Import Utility. I believe the target table needs to point to Account Master Table (GL00100). Am I correct? Do you have a screen shot to show me how I can map all the fields in Table Import template?
Thanks,
Josey
Oh,
That's much easier. Using the VLookup function, as has been suggested, come up with your missing accounts. You could also use a SQL statement to find the missing accounts. SQL would be easier IMHO. If you have integration manager, it's a piece of cake, just import them using that tool. You can change that first character with your SQL statement. But, let's say you have the missing accounts in Excel and do not own Integration Manager. You could go the macro route, or you could get bold and use the Table Import Utility and slam the records into the GL master table. You'd need to save your Excel spreadsheet as a comma or tab delimited text file. Be sure to run checklinks if you use the utility, because you need to populate the GL00105 table.
The macro (or Integration Manager) is much safer, I must be in a rebellious mood tonight to suggest such a radical move. :)
Kind regards,
Leslie
Josey -
I personally would change manually compare to using the VLOOKUP feature in Excel, which can substantially automate the comparison of data.
Once, you have your missing data set for Malaysia and Romania, which may be two different lists, then I would use a Macro to upload the missing accounts to the Malaysia and Romania entities. I put a link to my blog post on macros in my earlier response, please refer to the post to get you started with macros. If you have any specific questions, don't hesitate to reach out to me.
I think we need to rephrase my question.
We have existing Consolidation company, US, Malaysia and Romania. However, we want to find out how many GL accounts are missing in Malaysia and Romania. So we downloaded the GL Account list from Consolidation company. Manually compare with the other company's COA. Once we find out the gap, we want o push the new GL accounts to Malaysia and Romania.
How can we do that?
Thanks,
Josey
Hi Josey,
I might be missing what you want to do, so let me state what question I think I'm answering.
You have company A that has a COA with the first segment designating 'company'.
You want that same COA in company B, but you want to change the first segment to align with that company.
Here's what I propose:
Create your company (company B) in Dynamics Utilities
Log in to company A, launch the PSTL tool and then select Copy Company in the Misc. Tools section and hit ‘Next’.
Check all of the boxes for what you want to copy, identify the target company and complete the transfer
Log in to company B.
Go to the Financial Mass Modify screen (Cards | Financial | Mass Modify) and change the first segment to whatever you need. Use the ‘Move’ option.
After running the process, your new company should have an identical chart of accounts to company A, except the first segment will reflect the appropriate company number.
I would then run checklinks on the Account Master and then check my Account Format Setup to make sure the correct segment is marked as my Main Account.
I don’t have GP installed on this machine, but I think that will work.
Kind regards,
Leslie
Josey,
I have a blog post on creating a macro.
redbeardblogging.blogspot.com/.../how-to-create-and-run-simple-macro-in.html
The only steps to add would be:
Add the segment columns to your account list in SmartList prior to exporting your COA to import it using the macro.
Once you have the COA in Excel, change 'Segment 1' from 10 to 11 using Excel prior to performing the mail merge function in Word.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
