Page 1 of 2 1 2 >
Topic Options
#50993 - 09/14/16 09:21 AM Department Lookup
Doreen Offline
New Guy

Registered: 06/05/16
Posts: 6
Loc: BC Canada
When posting I cannot search or get the list of departments, in the department fields the accounts come up. I am wondering how I can pick/see the departments without having them memorized?

Top
#51003 - 09/14/16 01:08 PM Re: Department Lookup [Re: Doreen]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4446
Loc: Wynnewood, PA
Hi Doreen

That question is too vague. What module are you using and what screen? It can't be while "posting" in the way Adagio uses that word. Maybe you meant "entering a transaction"?

Please expand.

Steve

Top
#51006 - 09/14/16 01:46 PM Re: Department Lookup [Re: Steve Schwartz]
Doreen Offline
New Guy

Registered: 06/05/16
Posts: 6
Loc: BC Canada
Yes sorry you are right, when entering transactions in GL or AP I cannot lookup the department and get the description. When I use the lookup button I get the accounts. Maybe there is a way to change this in the setup? Right now I have to look them up on a printed list.

Top
#51045 - 09/19/16 02:04 PM Re: Department Lookup [Re: Doreen]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1144
Loc: Thunder Bay, ON, Canada
Hi Doreen,

There is no way that I know of to look up the department by description from the journal entry screen in the Ledger. However, if you have lanpaks, you can open a second instance of Ledger on another screen and have the Edit>Departments window open and use the F6 key to look up by description using the smart finder.

It's not much better than having a printed listing in front of you unless you have a lot of departments. The same thing would apply if you were keying in AP. Have the GL open on another screen with the Edit>departments window open to search using the F6 key.

If you don't have Lanpaks free, you could go to Edit>departments and use the excel direct button to put the departments in a spreadsheet and use the filters or Find function in Excel to search the list on another screen while doing entries.

Of course, these options only work well if you have a second screen.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#51046 - 09/19/16 03:03 PM Re: Department Lookup [Re: Doreen]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Hi Doreen,

If you are not using the second description or optional fields associated with the account, then you can build an Excel sheet with the department names and import them into the account master. Then use the Grid editor to place the second description or optional field on the Finder Grid so that you can see the department name when you press F5.

Your Adagio Consultant would be able to set this up for you pretty quickly.
_________________________
Andrew Bates

Top
#51068 - 09/21/16 09:18 AM Re: Department Lookup [Re: Dan_Desautels]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
A couple of questions for the audience:

What sequence of keystrokes do you use to enter:
  • A GL account and department where you know both values
  • A GL account where you know the account and not the department


Currently, when you type in an account without using the Finder (F5), the department is populated with the first department in the list. If you tab into the department field and press down-arrow, would you prefer to see:
  • All the accounts-departments so that you can choose a different account if necessary (this is the way it is now). -or-
  • Just the departments that are available for that specific account (which may be empty), necessitating an escape and backtab to change the account if the wrong account was chosen initially.


All comments welcome.
_________________________
Andrew Bates

Top
#51073 - 09/21/16 11:31 AM Re: Department Lookup [Re: Retired_Guy]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Andew

When both values are known then the current process works fine.

When the account is known but not the dept them the f5 needs to display the dept description.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#51074 - 09/21/16 11:39 AM Re: Department Lookup [Re: Douglas Dickie]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10493
Loc: Canada
Hi Doug,

Since you didn't describe any keypresses, I'll assume you are answering question 2. But you didn't really answer question 2.

Is it acceptable to show just the departments that are valid for the chosen account, forcing an ESCAPE-BACKTAB sequence to select another account if the department isn't there that you expect, or is it useful to have the full chart of accounts available for selection - the way it currently works.
_________________________
Andrew Bates

Top
#51077 - 09/21/16 01:52 PM Re: Department Lookup [Re: Retired_Guy]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4322
Loc: Vancouver, BC
Andrew:

What sequence of keystrokes do you use to enter:

A GL account and department where you know both values - Yes

A GL account where you know the account and not the department - Enter the account number, tab to Dept field and press F5. The way this works now if fine except I have had requests to show the Dept name.


Currently, when you type in an account without using the Finder (F5), the department is populated with the first department in the list. If you tab into the department field and press down-arrow, would you prefer to see:

All the accounts-departments so that you can choose a different account if necessary (this is the way it is now). -or-

Just the departments that are available for that specific account (which may be empty), necessitating an escape and backtab to change the account if the wrong account was chosen initially.

Option 1. Again with a column that shows the Dept names.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#51080 - 09/21/16 03:18 PM Re: Department Lookup [Re: Douglas Dickie]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3504
Loc: Toronto ON, Canada
Andrew:

I vote for Option 2. It's always been a puzzle to me why the Finders for the Account and the Department basically show the same information. I would say that the user enters the base Account code correctly at least 95% of the time. If the user then selects the Finder on the Department field, they are looking to see which Department(s) match the base Account.

If the Department name can also be displayed as Doug suggests, that's a bonus.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
Page 1 of 2 1 2 >


Moderator:  Softrak Support 
Who's Online
0 registered (), 25 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31