SmartList for Canadian Payroll returns no data

We are running GP V10 and Canadian Payroll.  When our Payroll clerk tries to 
run a SmartList for payroll data she gets nothing returned in her query 
result.  She is able to see all of her data and do her Payroll work with no 
issues, and her security access to Payroll data is correct.  Can anyone 
advise as to what we may have missed in her security and / or setup that 
would prevent her from seeing the data in her SmartList query?

As POWERUSER I get no results from the SmartList query either.

Appreciate any help or advice!

Thanks!


0
lmg (26)
7/16/2008 5:44:01 PM
greatplains 29623 articles. 5 followers. Follow

3 Replies
1460 Views

Similar Articles

[PageSpeed] 40

Hi LMG

Which CPR Smartlists are you trying to run?

The CPR EMployees, Employees T4 and Pycode YTD are the only ones that return 
any info for me.

the user isn't trying to run the US payroll smartlists are they?

Fliehigh

"LMG" wrote:

> We are running GP V10 and Canadian Payroll.  When our Payroll clerk tries to 
> run a SmartList for payroll data she gets nothing returned in her query 
> result.  She is able to see all of her data and do her Payroll work with no 
> issues, and her security access to Payroll data is correct.  Can anyone 
> advise as to what we may have missed in her security and / or setup that 
> would prevent her from seeing the data in her SmartList query?
> 
> As POWERUSER I get no results from the SmartList query either.
> 
> Appreciate any help or advice!
> 
> Thanks!
> 
> 
0
Fliehigh (443)
7/16/2008 7:10:01 PM
Hi!
Thanks very much for the response.  Maybe that's the problem - the User is 
trying to run US SmartList.  Or she's trying to run something other than what 
you've listed. I'll check it out with her - thanks for the tip!




"Fliehigh" wrote:

> Hi LMG
> 
> Which CPR Smartlists are you trying to run?
> 
> The CPR EMployees, Employees T4 and Pycode YTD are the only ones that return 
> any info for me.
> 
> the user isn't trying to run the US payroll smartlists are they?
> 
> Fliehigh
> 
> "LMG" wrote:
> 
> > We are running GP V10 and Canadian Payroll.  When our Payroll clerk tries to 
> > run a SmartList for payroll data she gets nothing returned in her query 
> > result.  She is able to see all of her data and do her Payroll work with no 
> > issues, and her security access to Payroll data is correct.  Can anyone 
> > advise as to what we may have missed in her security and / or setup that 
> > would prevent her from seeing the data in her SmartList query?
> > 
> > As POWERUSER I get no results from the SmartList query either.
> > 
> > Appreciate any help or advice!
> > 
> > Thanks!
> > 
> > 
0
lmg (26)
7/16/2008 8:06:04 PM
NP let me know how you make out.

Fliehigh

"LMG" wrote:

> Hi!
> Thanks very much for the response.  Maybe that's the problem - the User is 
> trying to run US SmartList.  Or she's trying to run something other than what 
> you've listed. I'll check it out with her - thanks for the tip!
> 
> 
> 
> 
> "Fliehigh" wrote:
> 
> > Hi LMG
> > 
> > Which CPR Smartlists are you trying to run?
> > 
> > The CPR EMployees, Employees T4 and Pycode YTD are the only ones that return 
> > any info for me.
> > 
> > the user isn't trying to run the US payroll smartlists are they?
> > 
> > Fliehigh
> > 
> > "LMG" wrote:
> > 
> > > We are running GP V10 and Canadian Payroll.  When our Payroll clerk tries to 
> > > run a SmartList for payroll data she gets nothing returned in her query 
> > > result.  She is able to see all of her data and do her Payroll work with no 
> > > issues, and her security access to Payroll data is correct.  Can anyone 
> > > advise as to what we may have missed in her security and / or setup that 
> > > would prevent her from seeing the data in her SmartList query?
> > > 
> > > As POWERUSER I get no results from the SmartList query either.
> > > 
> > > Appreciate any help or advice!
> > > 
> > > Thanks!
> > > 
> > > 
0
Fliehigh (443)
7/17/2008 11:50:02 AM
Reply:

Similar Artilces:

Access External Tables Using SmartList Builder
Can I access external SQL tables in SmartList Builder? We want to query tables in the Tensoft Fabless Semiconductor Manufacturing (FSM) software module that is bolted to GP. Thank you. You certainly can! If your tables reside in another database, you will need to create views from within your GP company database as follow: create view vwTensoftTable as select field1, field2,...,fieldN from YourTensoftDatabase.dbo.tensofttable You will need to then grant permissions to DYNGRP on those views. From there on, you can pull into SLB. Best regards, -- Best regards, -- MG.- Mariano Gomez, ...

formulas and external data
i have an issue trying to calculate data based on a query i import the data with all my columns and records, at the end i insert a column with a formula that calculates 4 different cells in the row then i run a query to remove null (zero) value data from a certain field, then the formual column that i added manually doesn't look right. for example, if i have 800 rows of data, i copied that formula to all 800 rows in the last column following the external data when i run the query, all the zero values are removed (doing what it should) and the formulas stay, except the last row that is...

reading data from a port
hi all can i read the data that an application recives and sends using a specific port ?? thanks Hi, This artile explains Implementing Serial Communication in Win9X/2000 http://www.codeguru.com/network/CSerialPort.html and list of console ports, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vclib/html/_crt_console_and_port_i.2f.o.asp ----- Ayman wrote: ----- hi all can i read the data that an application recives and sends using a specific port ?? thanks With Regards, R.Selvam ...

SmartList Security for New SmartLists
I'm having a problem with version 9 SmartList Security. I create a SmartList and then open SmartList and let it add the new object. I go to Advanced Security and the SmartList is marked automatically but nobody that is marked for it can see it. I have to unmark and remark the checkbox. Is there a setup issue or a software issue? -- Charles Allen, MVP Hi Charles, I have you gone into Smart list Security. I have found that even though the New Smartlist object is checked in Advanced Security, it will not be checked in the Smart List Security. I believe that this has been writt...

Copy data to another spreadsheet
I currently have to copy and paste data from one spreadsheet to another. Is there a formula that I can write that would automatically copy the data that I enter in a cell on spreadsheet one to a corresponding cell on spreadsheet two. Thanks, Hold Shift key and select Sheet2 When you type in sheet1 it also enter in sheet2 or =Sheet1!A1 "JIm" wrote: > I currently have to copy and paste data from one spreadsheet to another. Is > there a formula that I can write that would automatically copy the data that > I enter in a cell on spreadsheet one to a corresponding ce...

SmartList/SmartList builder
Hello, I was training a group of customers today on SmartList builder and they were creating trying to create a SmartList report. Everything goes well until at least 4 or 5 of them were having errors saving the SmartList in the SmartList Builder window. The error was something about a duplicate key being created on the SLB11000 and the SLB 11100 tables (I cannot recall which users have errors on which tables) but after attempting to save the SmartList ID and building the SmartList ID on the actual SmartList view, I cannot see the favorite there. (They say they may have, at one point in...

default return addresses
How can I create a default return address with a graphic in it? Hi Bill, In an email message the return address field is always plain text. There is something you can do, however. Use Entourage's Tools>Signatures menu to create a signature. You can drag a picture into the signature window. You'll probably have to use HTML message formatting for the picture to be seen by recipients. -Jim -- Jim Gordon Mac MVP MVP FAQ <http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs> Bill Puterbaugh wrote: > How can I create a default return address with a grap...

Received Not Invoiced
GP 9.0 contains a prewritten Smartlist under Receivings line Items entitled "Shipments Received but Not Invoiced*". I, erroneously, expected the results to match the Received Not Invoiced report (Reports - Purchasing - Analysis - Received Not Invoiced). However, it does not. In my instance, the Smartlist contains numerous items that are not on the report. It appears that the Smartlist is simply querying POP10500 file and comparing the QTY Shipped field to the QTY Matched fields and displaying those items where these amounts are not equal. When I attempted to examine the Rece...

Copy data across workbooks
I want to create a master workbook with data entered for multiple divisions and create a summary page that will auto update when the master is updated. I have tried a simple =, but it will only bring 1 cell at a time. When I drag from the right corner it just repeats that first cell or if I pull a few cells and high all and drag it repeats those cells. How can I copy multiple rows and columns? Not sure I completely understand your problem, but it sounds to me like your formulas are absolute. In other words, when you are typing in the formula it looks something like =[Book1]Sheet1!$...

Creating a bigger list in Data Validation
Hi all, Is Data Validation limited in terms of the items you can create for the drop down list. I am creating a shopping list and would like to enter in all my grocerie items, but there are too many. Any work around solutions? Hi Shezageek, By default the length is limited to 8 items. See Debra Dalgleish's workaround suggestion at http://www.contextures.com/xlDataVal08.html#Font --- Regards, Norman "shezageek" <notavailable@domain.com> wrote in message news:%23XtmRRS%23EHA.2700@TK2MSFTNGP14.phx.gbl... > Hi all, > > Is Data Validation limited in terms...

Smartlist Security
OK... SmartlIst Builder.... V10 Where did they now hide the Smartlist Security window to give User/User Class access to the new objects???? Bueno1 Access to smartlists is controled through the Alternate/Modified forms and Reports (Tools->Setup->System->Alternate......) Select the profile (forms and reports group) to be modified and then select Smartlists. View the list of Smartlists and mark which ones this profile should have access to. -- Richard L. Whaley Author / Consultant / MVP 2006-2008 Documentation for Software Users Get our Free Tips and Tricks Newsletter and ch...

external data doesn't show all data...
I am trying to access a SQL database (MS CRM 4.0) using the Connections feature in Excel 2007. I am able to connect to various tables and views, however, some key columns of data do not appear. I am wondering if they are hidden or I have a security issue. If I try to access the data using SQL Server BI 2005, all data is available. However using Excel 2007, the columns I need to connect the data to other tables is missing. Any thoughts? I've encountered a similar problem in the past when SQL columns were 'raw' data. Once cast to appropriate data type things worked fine....

Blocking data entry
Is it possible to configure a cell or cells to be unavailable for data entry unless data is entered in another cell or cells first? You can do this with Data Validation. Select the cell whose entry you want to restrict. Open Data Validation dialog from the Data menu, choose "Custom" on the Allow list, and enter =LEN($D$1)>0 where $D$1 is the cell which must have data in it in order to enter data in to the validated cell. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com ...

Is there a way to rotate a column of data into a row of data?
Hi all, Is there a way to rotate a column of data into a row of data, in Excell 2003? Let's say B8 - B1000, there are so many of them... I want to rotate it into a row form... Thanks a lot! You'll need to explain the rules a little better.... You want to convert 992 vertical cells into one row .....but Excel 2003 only has 256 columns. *********** Regards, Ron XL2002, WinXP "cfman" wrote: > Hi all, > > Is there a way to rotate a column of data into a row of data, in Excell > 2003? > > Let's say B8 - B1000, there are so many of them... I...

Loss of Data going from Money 2001 to 2004
When I installed Money 2004, my previous 2001 was uninstalled, but its data converted into the new program. However, all but one entry in one credit-card account disappeared and no new entry appears when I try making a payment from another account. The one entry remaining is actually from a closed predecessor card account. This happened yesterday, and I may find more missing data. ...

Added data in columns
I am new to Excel. I have a project I am working on in which I have a column with a value from 1 to 5. Each number (and in some columns letters) represents a different answer. Is there a way to add the total number of each value? For instance I have over 2000 rows with data. In column "N", an answer can be either 1,2,3,4 or 5. How would I figure out how many answers are "1", how many are "2" an so on. Likewise there is a column with a yes/no answer. How can I see the total number of Yes's and how many No's there are? I appreciate any help. Hi ...

Default column layout in Smartlist Builder
When generating new Smart list using the Smartlist Builder tool it would be great to allow for a means of identifying what the default column layout to be rather that having to create a favorite to do that. For Example. If SLB wanted to place columns 1, 2, 3, 4, 5 as such you could tell it to make it 5, 4, 3, 2, 1 instead in the root folder of the new SL created ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see th...

User-defined property as textbox data source
Is it possible to use a user-defined property DIRECTLY as the row source for a text field on a form? Obviously it is possible to write a custom function which retrieves such a property, but then it becomes a read-only field. I want to change it as well. An unbound textbox with code behind works, but that seems unnecessarily clumsy. None of the variations of syntax I have tried have worked and I find no mention of such a usage in the archives. Pete -- This e-mail address is fake, to keep spammers and their auto-harvesters out of my hair. If you want to get in touch personally, I am '...

Smartlist Creation
New User - Went into Smartlist under Customer Balance and added the aging to it but when it refreshed everything was 0-30 days. I know if I run an AR aging report it will not reflect everything in 0-30 days. Where does the Smartlist pull its data from. Go to Tools->Routines->Sales->Ageing and run this process. It ages the accounts just like the report but it writes the data back to the tables. This provides the data for the SmartList as well as updating the agening displays and information printed on statements. Richard L. Whaley Author/Consultant btw.....more informat...

Getting data from Access to Excel?
How would you go about pulling data from Access database into Excel? (Like weekly reports) Troy, Data|Get External Data|New Database Query Select MS Access Database The Wizard should take you through the remaining steps of selecting the data you want to import and the criteria (if any) that you wish to use. PC "Troy" <corptkm@yahoo.com> wrote in message news:nLDXa.3726$Jk5.3138269@feed2.centurytel.net... > How would you go about pulling data from Access database into Excel? (Like > weekly reports) > > You can also push-it-out of Access to Excel by (While...

SMARTLIST REPORTS
i can't modify smartlist reports is there a way to modify reports from smartlist. can i modify smartlist reports in version 9 or in the succeeding versions(ex. 10-11) -- Jeremy Ayaay Technical Specialist STRC Jher, If you are talking about creating you own smartlist reports, you can use Smartlist Builder. This will allow you to create your own smartlist, as well as use SQL Views to pull into Smartlists. If this is not what you are looking for, can you please explain a little more about which reports you want to modify in Smartlist. "Jher" wrote: > i can't mod...

Linking data to drawing
Dear all, Can anybody guide me, how to link the data in excel to make drawin from its drawin g options like lines, circles etc -- sumit487 ----------------------------------------------------------------------- sumit4879's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1628 View this thread: http://www.excelforum.com/showthread.php?threadid=27687 Maybe you're referring to linking a cell's contents to display inside an autoshape ... If so, play around with this .. Draw an autoshape, say: a circle (oval) on the sheet Right-click on it > Select "...

Formula to return non-zero values in a list
I have a list of numbers in a column like so - 2 3 4 1 8 0 0 0 0 What formula would I create to always give me the a SUM of the las couple values before the zero value. The list always ends with a valu other than zero, so in this case, the '8' is the end of the list, and would like to SUM the 3 "last" values, those being 8, 1 and 4. As use this file, the zero values will automatically be updated with ne information, so I need a formula which would constantly reflect thi change -- Message posted from http://www.ExcelForum.com If you don't mind having an extra col...

V10 Smartlist Builder smartlists
I upgraded from V9 to V10, none of my users (except power users) see the manufacturing smartlists or the Smartlist Builder smartlists we created in V9. Where is the security for this? thanks! -- Doug ...

How to calcuate mean and median of time (d hh:mm) data?
I have time data in an excel column (formatted as d hh:mm and also as hh:mm (2 seperate sets) . I need to find out the mean (average) and the median for these sets. How should I go about it? =AVERAGE() =MEDIAN() -- David Biddulph "kp" <kp@discussions.microsoft.com> wrote in message news:D1F61BBD-A171-41DA-B37B-C6C46D0CC000@microsoft.com... >I have time data in an excel column (formatted as d hh:mm and also as hh:mm > (2 seperate sets) . I need to find out the mean (average) and the median > for > these sets. How should I go about it? Times...