You’re offline. This is a read only version of the page.
425
hi all,
i'm new user of GP, im doing my job as internal support, my company has 10 company registered on GP, 9 as subsidiaries and 1 as holding. i dont know the history of, but each company has different master data, coa and so on.
i wondering to querying all CoA master (Chart of Account) of all company (10), i dont have sql enterprise manager user id, i just have superuser authority on my GP.
i used to use sql manager to querying @ my former job, but now, i found it hard. i just do it one by one, extract all COA from all company, by login 1 company -> smartlist -> extracrt Coa -> export it to excel, and so on for 10 times.
my question is, can i querying all coa data of 10 company on one hit through this system (GP)? i try it on smartlist, but still iv found it very hard.. i cannot write proper filter and choose any company..
appreciates all comment
thank you
*This post is locked for comments
I feel your pain. It must be very difficult to write reports if you are not given access to the data. The simplest solution would be for them to deploy the SSRS reports that come with GP and then give you access to modify those reports. Since they are reports they are read only so you cannot damge the GP data only the SSRS database. There are no querying tools directly within GP to allow you to access the data. Maybe you can suggest log shipping to your IT staff. This would giev you a read-only copy of the database that is a fresh as they will allow. Again you will be in read-only mode so you are not a threat.
Richard,
Unfortunately , you found the right term , I'm not allowed to .. for every option you said above...
i'm not mean for comparing
i was sap business one (sbo) consultant before take this position,
sbo has tools to do such think, use sql language, and i can querying the data as simple as write the script on it.
on another term it just like "ssms" embedded as package on the application.
the main idea of the question is, does GP has tools,that use sql language, which i can write my free own script on it, just on GP. no need SSMS, allowed or not allowed etc :)
cause i think one of my task is easy, simple.. take all the master data category on 10 company, once for improvement purpose, and periodically to keep the history...
i think and i feel ( for time being) - especially for periodic purpose, its really takes time to extract those data, while i had another task (daily task) also project task.
after all, i really want to contribute to my company by giving such fast and exact solution even i don't have enough tools to do it, everything had to be done just through and directly on the application only.
thank you for your concern :)
really appreciates all your recommendation and knowledge share
Are you allowed to apply scripts to your databases? If so, you could install SSMS on your local computer and just point to the server. You could do the same thing with MS Acess or Crystal Reports or any number of other reporting tools. If you cannot do that, then can you get a copy of the database and then copy it to your local computer and then run queries against that copy. Can you get then to export just the data you need to Excel or Access? Somehow we either get the data to your computer or you are given a tool with access to the server.
If you have Smartlist Builder you can ask your IT staff to create a SQL view based on the SQL script I mentioned. Once the view is in place you can use SLB to accecss it.
hlo sir,
yes i have smart list builder,
i'v try your suggest, linking gl 100 and 105,
but i don't know what exactly you mean by :
"you would need to log into each company and pull a chart of accounts"
do i have to open 10 different application for all comp. and log on to?
or there is log on menu on smart list menu..
-newbie :)
It is not easy to reach other companies from Smart List. Unless you have Smart List Builder, you would need to log into each company and pull a chart of accounts. Then drop the list to Excel (include a company number in the spread sheet) and merge the 10 lists. You can now sort that any way you want.
I am would suggest linking the GL00100 as suggested above with GL00105. Otherwise, the 100 table provides the segments of the account in separate fields that you will need to concatenate. 105 will give you an account number string field with the entire account (all segments plus dashes minus spaces).
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (