You’re offline. This is a read only version of the page.
Hello everyone, we use GP as our General Ledger System and our prosess to post journar entries is User 1 uploads the entry, User 2 approves and User 1 has to go into the Series Post section and post it one last time for entry to be posted.
This is the process and we like it as it is.
The issue that i am having is we have over 50 different companies in GP (and a number of them are no longer even used) and on monthly basis we post around 100 journal entries into all those companies. With all that valume sometimes User 1 forgets to do the Final step in the series post section. If a company has 2-3 entries a month if User 1 forgets to do the final step he most likely will not log into that company again for the month so the entry will just seat there.
Is there a way we can find out if there's an entry in the Series Post section in any of the companies that we have. Obviously one way is to go into every company, but with the valume we have there's just no time to do this 2-3 times a day.
Maybe a report or something like that.
Also, i am a user of the system, i am not an administrator and if possible i would like to avoid that requres involving IT and various approvals, because we are a publicaly traded company any software change needs to be approved by multiple people and documented so i am looking for something as simple as possible.
Thank You.
*This post is locked for comments
What Mariano suggest is the most easier way of achieving this task.
Another solution is to hire someone for writing a small add-on for you which will notify you by standing in any login company on Series Posting window about other companies having JE sitting there.
Mariano, is there an easier way.
I probably should have pointed this out, but I am an Accountant. I simply use GP. I have exactly zero programing or any similar experience. I am basically User 1 as I described in the example above.
I understand the accounting side of GP very well but not the tech aspect of it.
Thank You.
There are two ways to do this:
- You can use a SQL query to create a SQL view that you can add to SmartList Designer
- You can create a cross-company query using SmartList Builder from eOne Solutions (eonesolutions.com)
If you do decide to go down the view route, you can do something like this:
select '<INTERID1>', * from <INTERID1>..GL10000 union all select '<INTERID2>', * from <INTERID2>..GL10000 union all ..
That's the basic query for your view, where <INTERIDn> is the actual company database name in SQL.
Mariano, can you suggest how to create that SmartList.
Thank You.
The real way to solve something like this is to use an automated posting tool like Smart Post from eOne or Post Master from Envisage Software. However, given that you cannot or do not want to go through a software buying process, you should be able to create a cross-company SmartList to show you what batches are out there that remain unapproved/unposted. This should be fairly straight forward and need not any intervention from your IT department.
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 (