JEs in Series Post

(1) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Mariano, can you suggest how to create that SmartList.

Thank You.

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Do you have the SmartList Builder product?

Navigate to Administration | Setup | SmartList Builder | SmartList Builder

If you do have this product, it will be easier to walk you through how to build this.

Leslie

Was this reply helpful? Yes No