Does Smartlist have max # of records it looks at?

I created a report through SmartList builder and when I run it, the 
information stops at 12/7/09.  It does not show the rest of the year 
regardless of what date criteria I use.  I then created a similar SQL query 
and made a new SmartList from that query.  Again the information stops at 
12/7/09.  Is there a maximum number of records that SmartList will look at?  
Or any ideas on why this is happening?

This is my SQL query:
select a.ordocnum, a. crdtamnt, a.debitamt, a.trxdate, a.actindx, 
a.ormstrid, a.ormstrnm, a.dscriptn, b.mnacsgmt, c.userdef1, c.userdef2

from gl20000 a  left join sop10106 c on a.ordocnum = c.sopnumbe
	inner join gl00100 b on a.actindx=b.actindx

where b.mnacsgmt='1150'

THANKS!
0
Utf
1/8/2010 5:27:02 PM
greatplains 29623 articles. 3 followers. Follow

2 Replies
1310 Views

Similar Articles

[PageSpeed] 14

In the SmartList toolbar, click the Search button and change the maximum 
number of records being displayed from 1,000 (default value) to a number that 
best suit your needs.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com


"inin" wrote:

> I created a report through SmartList builder and when I run it, the 
> information stops at 12/7/09.  It does not show the rest of the year 
> regardless of what date criteria I use.  I then created a similar SQL query 
> and made a new SmartList from that query.  Again the information stops at 
> 12/7/09.  Is there a maximum number of records that SmartList will look at?  
> Or any ideas on why this is happening?
> 
> This is my SQL query:
> select a.ordocnum, a. crdtamnt, a.debitamt, a.trxdate, a.actindx, 
> a.ormstrid, a.ormstrnm, a.dscriptn, b.mnacsgmt, c.userdef1, c.userdef2
> 
> from gl20000 a  left join sop10106 c on a.ordocnum = c.sopnumbe
> 	inner join gl00100 b on a.actindx=b.actindx
> 
> where b.mnacsgmt='1150'
> 
> THANKS!
0
Utf
1/8/2010 7:17:01 PM
Have you checked to be sure you have transactions after 12/7 through GP?

-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"inin" wrote:

> I created a report through SmartList builder and when I run it, the 
> information stops at 12/7/09.  It does not show the rest of the year 
> regardless of what date criteria I use.  I then created a similar SQL query 
> and made a new SmartList from that query.  Again the information stops at 
> 12/7/09.  Is there a maximum number of records that SmartList will look at?  
> Or any ideas on why this is happening?
> 
> This is my SQL query:
> select a.ordocnum, a. crdtamnt, a.debitamt, a.trxdate, a.actindx, 
> a.ormstrid, a.ormstrnm, a.dscriptn, b.mnacsgmt, c.userdef1, c.userdef2
> 
> from gl20000 a  left join sop10106 c on a.ordocnum = c.sopnumbe
> 	inner join gl00100 b on a.actindx=b.actindx
> 
> where b.mnacsgmt='1150'
> 
> THANKS!
0
Utf
1/11/2010 5:06:01 PM
Reply:

Similar Artilces:

Outlook 2003, 2GB max file size?
Can Outlook 2003 surpass its previous versions' 2GB max file size? If so, what is the "new" limit? Yes Humongous - theoretically practically unlimited? - probably exceeds the capacity of the dektop. Though why any desktop user should have need of a single pst of even 1gb I find hard to invisage. Info overload? - You backup to what media? David "Michael in Portland" <anonymous@discussions.microsoft.com> wrote in message news:05c201c3c600$6f577c90$a601280a@phx.gbl... > Can Outlook 2003 surpass its previous versions' 2GB max > file size? If so, what is...

Add new record in a sub form
Hi I have a Booking Form with 2 subforms - Customer Details & Booking Details. I can find a Customer & get his details displayed in the Customer Details section, and click a button on the Booking Details subform which executes the following: DoCmd.GoToRecord , , acNewRec This works fine - I can enter details for a new Booking. I also have an Enter/View Customers form in the system, and I am trying to put a New Booking button on there which opens the Booking Form with the selected Customer Details at the top and the Booking Details sub form open to Add a new booking. I tried execut...

Show the records from table based on time range
Hello, I created a form will display the records from a table. The records in the table contain years (mm/dd/yyyy) information. I would like to write the code to retrieve the records based on the year range. For example, retrieve all data from year 2000 or data from 2001. Could some one help me? Thanks! There are several ways to implement this, but the basic filtering is: Year([YearInfoDate]) = SomeYear. You could use the Where argument of the OpenForm method. You could use the Form's Filter and FilterOn properties. You could include it in a query to use as the form's r...

looking for outlook forum or answers
looking for outlook forum or answer -- hokiegu ----------------------------------------------------------------------- hokieguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2191 View this thread: http://www.excelforum.com/showthread.php?threadid=37600 hokieguy, http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#8 and then look for the outlok section. HTH, Bernie MS Excel MVP "hokieguy" <hokieguy.1q0b2a_1117728301.1612@excelforum-nospam.com> wrote in message news:hokieguy.1q0b2a_1117728301.1612@excelforum-nospam.com... &...

Plugin running on deletion of a record
I'm having some problems with a plugin which runs whenever a custom entity is deleted. The plug-in code itself seems to work fine, but after it steps out of the plugin, I get a "The requested record was not found or you do not have sufficient permissions to view it", and the record itself doesn't get deleted. Within the plugin, I do access the record itself to get some information that is not passed in the message. It might be that the entity is not properly released. Do you guys know what's the proper way to release the dynamicentity? (I tried to set it to null,...

Thank you Mr. Max
Dear Max, I want to thank you once again for your respond and provided solutions for my problem. I m very thankful and grateful to Microsoft Office who provided such fantastic platform for learners who can improve their skill through it. Your solution is working in new opened workbook but it is not working in my this file which is I m already working. Please find out what is the reason. I m sending my file to you Thanks and regards. Rao Ratan Singh "Rao Ratan Singh" wrote: > ...it is not working in my file .. Please find out what is the reason Believe you didn't foll...

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...

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, ...

Check for record
I am using the following code to determine if a record is present, then doing stuff accordingly. Trouble is...I do get the message if there is a record and do not get the message if there is not. Am I doing something wrong? Is there a better way? If HasData1(ClientID) Then MsgBox "record" Else ( I even tried NOT HasData1(ClientID)) MsgBox "no record" End If -- Thanks for your help, Chris HasData1 appears to be a function in your application. You need to have a look at it and see what it is returning. Your code expects it to return a boo...

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...

PivotCharts (max cell/row limits)?
I've recently created an Excel spreadsheet to track Utility (water, sewer, electricity) consumption and costs at 5 different locations...tracking the past 3 years. It's 11 columns wide and is now on it's 389th row. To view the data graphically (i.e. by individual site or type of utility) I am using PivotCharts...which by the way are AWESOME! Unfortunately, when I'm trying to view the last site I'm unable to view all of it's data...oddly enough it stops at about 260 of the 388 records/rows. I've hit REFRESH but still nothing. Are these two related? (I figured, it...

Go to a new record on another form?
Hello! I have a form (Form2) which is being opened (or sometimes set focus to) from another form (Form1). On the open and gotfocus events, I want it to go to a new record; however, I also want it to be able to see/edit previous records (so the DataEntry mode option is right out). -I have no OnGotFocus, OnLoad, etc events in Form2 -the code on Form1 calling Form2 is on a command button. I've included the whole mess of code on that button, just in case I'm missing something dreadfully obvious: Private Sub Command28_Click() 'the "record the valiant effort of this volunteer&qu...

Prefer how Outlook 2000 looked-now using 2003-Can I switch views?
I don't like the way Outlook 2003 displays and would prefer to go back to the 2000 display. Is this possible. Kinda, http://www.slipstick.com/emo/2003/up031029.htm#classicview might be helpful. "Manhart" <Manhart@discussions.microsoft.com> wrote in message news:A4549A3C-4B06-4AEC-8ADA-DD154CC7795B@microsoft.com... >I don't like the way Outlook 2003 displays and would prefer to go back to >the > 2000 display. Is this possible. Outlook 2003 is highly customizeable - tell us what you want to change, and we'll tell you how to achieve it. There is ...

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...

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...

Tracking shared records in 4.0
Anyone know if 4.0 version has the ability to track shared records easier than 3.0? thanks none so far. but you can try the SDK "Bernardina" <dl@discussions.microsoft.com> wrote in message news:03B6F61B-C105-47E7-8E25-FD2B946D6FEF@microsoft.com... > Anyone know if 4.0 version has the ability to track shared records easier > than 3.0? > thanks ...

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...

Easy report? How to report on a record, skip, report, etc.
I have a totals query that looks like this: SegmentID LandCost ImpvCost Damages Relo Incidental Demolition 001 $ amt $amt $amt $amt $amt 002 $ amt $amt $amt $amt $amt 003 $ amt $amt $amt $amt $amt 004 $ amt $amt $amt $amt $amt 005 $ amt $amt $amt $amt $amt 006 $ amt $amt $amt $amt $amt 007 $ amt $amt $amt $amt $amt 008 $ amt $amt $amt $amt $amt 009...

Next Record in ListBox
Is there an easy way to move to the next record in a list box after the list box has been clicked on? Martin Hi, you can use following code: If Me.MyListbox.ListCount > 0 Then Me.MyListbox.Selected(1) = True end if -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "Martin" <Martin@discussions.microsoft.com> wrote in message news:40D2CCF5-0F84-4A49-94F4-6D2E37C8F82F@microsoft.com... > Is there an easy way to move to the next record in a list box after the > list >...

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...

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...

Max Account length and number of segments
Just discovered today (after about 10 straight hours of tinkering) that your max account length and number of segments will affect your ability to test 3rd party dictionaries in TWO (Fabrikam). I had the account length maxed out to 66 and the number of segments set at 5 (sufficient for TWO's accounts) however I got an error everytime I tried to debug in the script "Setup_Account_Format". I found that switching to max account length 12 and max number of segments 3 alleviated this problem. Not sure if this has been posted anywhere else, but I sure couldn't find it so ...

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 ...

Smartlist Grouping
Is there any way to group the ever increasing list of SmartList reports into logical 'folders'. Would be great to have one for Finance, one for Operations etc. and have department or function specific reports under there instead of a huge list through which one has to scroll. thanks. Nope, but it would be nice. I have seen folks add their name to the end so other people know no to change it. You could add a department to the front so at least everything would be grouped together. Then again, you've already got a big list like the rest of us don't you? Mark (DynamicAccounti...

loop thru cells to find matching record
I'm having difficulty with the following code. I think thre are several issues, perhaps the easier one first. When I set the following range, I noticed it didn't start at row 14 but at row 12, not sure why? Set rng = wsSheet.Range("A14:A" & Cells(65536, "A").End(xlUp).Row). I noticed that the message box shows cells I'm not interested in. The more difficult problem is per the following The active workbook, "sheet 1" has a lising of serial numbers, the serial numbers start at row 14, the exact number varies, hence the set rng as per abo...