Simple reports not available?

I am trying to get what I thought would be an easy report, with no luck... I 
need a report that:

I can see who my top vendors are by fiscal year by dollar amount in 
descending order. Without it being a million pages (figuratively speaking).

Also want the same report for my top customers, showing who has spent the 
most with us over the fiscal I choose to run it.

Is this possible? any ideas, or anyone know a place I can find good FREE 
templates?

Thanks Paul
0
J (145)
4/3/2007 7:18:01 PM
greatplains 29623 articles. 5 followers. Follow

6 Replies
519 Views

Similar Articles

[PageSpeed] 27

Use Smartlists.
-- 
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
4/3/2007 3:27:02 PM


Paul J wrote:

> I am trying to get what I thought would be an easy report, with no
> luck... I need a report that:
> 
> I can see who my top vendors are by fiscal year by dollar amount in 
> descending order. Without it being a million pages (figuratively
> speaking).
> 
> Also want the same report for my top customers, showing who has spent
> the most with us over the fiscal I choose to run it.
> 
> Is this possible? any ideas, or anyone know a place I can find good
> FREE templates?
> 
> Thanks Paul
0
4/3/2007 7:27:13 PM
I am new to GP... is there somewhere that goes over how to use Smartlists? We 
have a small company, and no one here knows how... your help is greatly 
appreciated.

"Japheth Nolt" wrote:

> Use Smartlists.
> -- 
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 4/3/2007 3:27:02 PM
> 
> 
> Paul J wrote:
> 
> > I am trying to get what I thought would be an easy report, with no
> > luck... I need a report that:
> > 
> > I can see who my top vendors are by fiscal year by dollar amount in 
> > descending order. Without it being a million pages (figuratively
> > speaking).
> > 
> > Also want the same report for my top customers, showing who has spent
> > the most with us over the fiscal I choose to run it.
> > 
> > Is this possible? any ideas, or anyone know a place I can find good
> > FREE templates?
> > 
> > Thanks Paul
> 
0
PaulJ (12)
4/3/2007 7:32:04 PM
Paul,
	Just a real quick answer.  Smartlist is a flexible, adhoc reporting
tool built into Dynamics GP.  Go to View > Smartlist.  Press F1 on your
keyboard and that will get you the Help file for Smartlist.

	Just as a starting point, after looking over the Help file, start in
the Customers node.

	If this still doesn't make sense, get your partner to do some training
for you or go onto CustomerSource and go through the free training
there.
-- 
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
4/3/2007 4:05:00 PM


Paul J wrote:

> I am new to GP... is there somewhere that goes over how to use
> Smartlists? We have a small company, and no one here knows how...
> your help is greatly appreciated.
> 
> "Japheth Nolt" wrote:
> 
> > Use Smartlists.
> > -- 
> > Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 4/3/2007 3:27:02 PM
> > 
> > 
> > Paul J wrote:
> > 
> > > I am trying to get what I thought would be an easy report, with no
> > > luck... I need a report that:
> > > 
> > > I can see who my top vendors are by fiscal year by dollar amount
> > > in descending order. Without it being a million pages
> > > (figuratively speaking).
> > > 
> > > Also want the same report for my top customers, showing who has
> > > spent the most with us over the fiscal I choose to run it.
> > > 
> > > Is this possible? any ideas, or anyone know a place I can find
> > > good FREE templates?
> > > 
> > > Thanks Paul
> > 
0
4/3/2007 8:08:12 PM
Hi Paul:

I have a PDF document you can use.
Just let me know where I can send.


"Japheth Nolt" wrote:

> Paul,
> 	Just a real quick answer.  Smartlist is a flexible, adhoc reporting
> tool built into Dynamics GP.  Go to View > Smartlist.  Press F1 on your
> keyboard and that will get you the Help file for Smartlist.
> 
> 	Just as a starting point, after looking over the Help file, start in
> the Customers node.
> 
> 	If this still doesn't make sense, get your partner to do some training
> for you or go onto CustomerSource and go through the free training
> there.
> -- 
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 4/3/2007 4:05:00 PM
> 
> 
> Paul J wrote:
> 
> > I am new to GP... is there somewhere that goes over how to use
> > Smartlists? We have a small company, and no one here knows how...
> > your help is greatly appreciated.
> > 
> > "Japheth Nolt" wrote:
> > 
> > > Use Smartlists.
> > > -- 
> > > Japheth Nolt
> > > Microsoft SBF Specialist
> > > Landis Computer
> > > www.landiscomputer.com
> > > 4/3/2007 3:27:02 PM
> > > 
> > > 
> > > Paul J wrote:
> > > 
> > > > I am trying to get what I thought would be an easy report, with no
> > > > luck... I need a report that:
> > > > 
> > > > I can see who my top vendors are by fiscal year by dollar amount
> > > > in descending order. Without it being a million pages
> > > > (figuratively speaking).
> > > > 
> > > > Also want the same report for my top customers, showing who has
> > > > spent the most with us over the fiscal I choose to run it.
> > > > 
> > > > Is this possible? any ideas, or anyone know a place I can find
> > > > good FREE templates?
> > > > 
> > > > Thanks Paul
> > > 
> 
0
ValentinPR (38)
4/3/2007 8:18:05 PM
paulj@wigginslift.com

Thank you so much.



"Valentin PR" wrote:

> Hi Paul:
> 
> I have a PDF document you can use.
> Just let me know where I can send.
> 
> 
> "Japheth Nolt" wrote:
> 
> > Paul,
> > 	Just a real quick answer.  Smartlist is a flexible, adhoc reporting
> > tool built into Dynamics GP.  Go to View > Smartlist.  Press F1 on your
> > keyboard and that will get you the Help file for Smartlist.
> > 
> > 	Just as a starting point, after looking over the Help file, start in
> > the Customers node.
> > 
> > 	If this still doesn't make sense, get your partner to do some training
> > for you or go onto CustomerSource and go through the free training
> > there.
> > -- 
> > Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 4/3/2007 4:05:00 PM
> > 
> > 
> > Paul J wrote:
> > 
> > > I am new to GP... is there somewhere that goes over how to use
> > > Smartlists? We have a small company, and no one here knows how...
> > > your help is greatly appreciated.
> > > 
> > > "Japheth Nolt" wrote:
> > > 
> > > > Use Smartlists.
> > > > -- 
> > > > Japheth Nolt
> > > > Microsoft SBF Specialist
> > > > Landis Computer
> > > > www.landiscomputer.com
> > > > 4/3/2007 3:27:02 PM
> > > > 
> > > > 
> > > > Paul J wrote:
> > > > 
> > > > > I am trying to get what I thought would be an easy report, with no
> > > > > luck... I need a report that:
> > > > > 
> > > > > I can see who my top vendors are by fiscal year by dollar amount
> > > > > in descending order. Without it being a million pages
> > > > > (figuratively speaking).
> > > > > 
> > > > > Also want the same report for my top customers, showing who has
> > > > > spent the most with us over the fiscal I choose to run it.
> > > > > 
> > > > > Is this possible? any ideas, or anyone know a place I can find
> > > > > good FREE templates?
> > > > > 
> > > > > Thanks Paul
> > > > 
> > 
0
PaulJ (12)
4/3/2007 8:52:00 PM
If you go to the help menu, there are some training videos. One of the videos 
is on using SmartList. 
-- 
Charles Allen, MVP



"Paul J" wrote:

> paulj@wigginslift.com
> 
> Thank you so much.
> 
> 
> 
> "Valentin PR" wrote:
> 
> > Hi Paul:
> > 
> > I have a PDF document you can use.
> > Just let me know where I can send.
> > 
> > 
> > "Japheth Nolt" wrote:
> > 
> > > Paul,
> > > 	Just a real quick answer.  Smartlist is a flexible, adhoc reporting
> > > tool built into Dynamics GP.  Go to View > Smartlist.  Press F1 on your
> > > keyboard and that will get you the Help file for Smartlist.
> > > 
> > > 	Just as a starting point, after looking over the Help file, start in
> > > the Customers node.
> > > 
> > > 	If this still doesn't make sense, get your partner to do some training
> > > for you or go onto CustomerSource and go through the free training
> > > there.
> > > -- 
> > > Japheth Nolt
> > > Microsoft SBF Specialist
> > > Landis Computer
> > > www.landiscomputer.com
> > > 4/3/2007 4:05:00 PM
> > > 
> > > 
> > > Paul J wrote:
> > > 
> > > > I am new to GP... is there somewhere that goes over how to use
> > > > Smartlists? We have a small company, and no one here knows how...
> > > > your help is greatly appreciated.
> > > > 
> > > > "Japheth Nolt" wrote:
> > > > 
> > > > > Use Smartlists.
> > > > > -- 
> > > > > Japheth Nolt
> > > > > Microsoft SBF Specialist
> > > > > Landis Computer
> > > > > www.landiscomputer.com
> > > > > 4/3/2007 3:27:02 PM
> > > > > 
> > > > > 
> > > > > Paul J wrote:
> > > > > 
> > > > > > I am trying to get what I thought would be an easy report, with no
> > > > > > luck... I need a report that:
> > > > > > 
> > > > > > I can see who my top vendors are by fiscal year by dollar amount
> > > > > > in descending order. Without it being a million pages
> > > > > > (figuratively speaking).
> > > > > > 
> > > > > > Also want the same report for my top customers, showing who has
> > > > > > spent the most with us over the fiscal I choose to run it.
> > > > > > 
> > > > > > Is this possible? any ideas, or anyone know a place I can find
> > > > > > good FREE templates?
> > > > > > 
> > > > > > Thanks Paul
> > > > > 
> > > 
0
callen (2505)
4/4/2007 3:46:01 AM
Reply:

Similar Artilces:

Excel Reports & GP 10
Hi All, I have a question regarding the Office Data Connections in GP 10. If an excel report is created from a smartlist query and sent to a person who does not have GP access can they update the report by using the "refresh" function? Does the company need to have Sharepoint installed for this or is the only prerequisite Office 2007? Thanks -- TC I don't see that it shouldn't work ok. Somewhere in the connections in office 2007 you'll end up seeing a connection string that controls the database connection. Then of course there is the query that excel is us...

Crystal Report Images on the same horizontal line
Hi! I'm trying to get images from a DB and I need to place them on a small card in the same row (attached is a MS Word doc example). I don't know how to manipulate the BLOB fields to place it in the same row. It is a small A5 card. I need to get the persons text info placed in rows. This is easy. But I need to place their pictures on the same horizontal line. This is where I don't fall of the bus. Eg. 1. Name 2. Name 3. Name 1. Photo 2.Photo 3.Photo Thanx! Frik Thanx! Frik Olivier This is the wrong user group for this question. Try the SQL Server user gr...

Simple graph
I have a chart with zip codes and a population rate. ZIP RATE 80001 2.34 80002 1.23 80003 1.23 I want to make a chart that has the rate on the x axis and the number of times that rate occurs on the y axis. | | | * | | * |_________________________________ | | 1.23 2.34 Thank you. I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1) Label in G1 to read RATE (but leave it empty for now), label in H2 to read COUNT Make a list of rates in G2:G20 (say) In H2 =COUNTIF($B$2:$B$200,G2) Copy down the row Select H1:G20 and make a...

Report Print Preview in Access 2007
Problem is I can set up a report under properties to open in Print Preview as the default, but when I add it to the switchboard, it opens in Report view instead. How can I get it to use Print Preview mode when users open the report? Thank you for your time and assistance. Check the switchboard code. Look at the HandleButtonClick() routine. My switchboard was originally created in an older Access version. That routine contains a Select Case statement to process the various commans. The relevant one in my code reads: ' Open a report. Case conCmdOpenReport ...

Simple help with implementing Outlook-like GUI
Hi All. I am an experienced unix programmer who sometimes has to do something in the windows world, and always has newbie-questions. Basically I want to write an application program that looks like outlook in that it has nice icons down the left hand side that choose the content of the main area in the right hand side. So I started the MFC App wizard, and got me a SDI program with a CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd). Then I prepared the following snippet of code to draw the buttons: // Create a pushbutton CBitmapButton* pmyButton; pmyButton = new CB...

Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo calculating square inches. Column A: Height Column B: Legnth Column C: Total Tags per 16 x 24 Column D: Cost per tag Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches What I want to do is enter the Height, enter the Length and have th total (sum) be entered into columns C and D. I can't believe I forgot how to enter formulas. Any help will b appreciated. Thank you, Crai -- Message posted from http://www.ExcelForum.com Hi Craig, One Way, might be better ways but this'll work: List the colou...

Need to be able to run Historical outstanding check report
Have clients that need to be able to run a Historical outstanding report. ---------------- 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 the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=bf1482a4-b574-4368-ad30-af8ed9fbd297&dg=microso...

Simple hack to get $500 to your home. 06-05-10
Simple hack to get $500 to your home at http://uknews.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...

how to make "Quotes Product Associated " view available on Quotes
I am trying to print a quote and the items under "Quotes Product Associated" view do not appear on my print preview. Is there a way to relocate the same on the main quote sheet? ...

Sub Report Repeating
With On My Main Report I have a Sup Report, The Main Reports Shows The Project Number. Project Title and Enquiry: Enquiry Could Be Anything From "Supply Only Ductwork" The Sub-Report Shows All The Drawings That Are Needed For That Enquiry, The Sub-Report Is Set to a Contineuos Type, The Problem Arise's If Ive Seletced The Say 2 or more Companys For that Enquiry, What Is Happening The Sub Report Is Duplicating The Drawing List For How Many Companys Ive Set The Enquiry To. Is The Away I Can Just Print the One Set of Drawings for that Enquiry Records, and Not Repeat the Whole S...

Report Printing
I have a FORM. On this form is a BUTTON. This button should be opening an REPORT and PRINTING it. The REPORT is based on information pulled together in a QUERY. The query asks for a Sales Number in a dialog box. The FORM in question also has a Sales Number field. I need for the BUTTON to open and print the REPORT based on the contents of the Sales Number field rather than asking for it in a dialog box. All attempts I have made to achieve this have failed. Any ideas? Farkyss - In your query, instead of just having [Sales Number], you should have something like Forms![Yo...

Free/busy info not available
We have Exchange 2003, client uses outlook 2003. From outlook 2003, when we try to schedule meeting invite and add attendants, the "no free/busy information could be retrieved" shows up under the attendants scheduling. This only happens to meeting dates 1 or 2 months in advance. Is this by design or a problem. Any help will be appreciated. the default is to publish Free / Busy info 2 months in advance. What settings do your users have? "Andrew King" <andre_king@coa.com> wrote in message news:e%236l3uMiFHA.3568@TK2MSFTNGP10.phx.gbl... > We have Exchange 20...

GP8 Security and Modified report
Hi there this is my problem We have this bunch of modified report for different departement here With of course different security for each of them So far, the initial security has been apllied with the standard security from an external consultant. He found it easier to work with that He told me a while ago the only problem is you cannot do it by groups,,, user only So I openned "Advance security" a choose "view by alternate modified and custom". Now what I see is not the same as standard security User for a particular report that doesn't have access ...

Simple Query Wizard hangs
I am using Access 2003 When I initiate the "Simple Query Wizard", I am presented with the first screen - "What fields do you want in your query" When I click on the pulldown list to select a table, I get the following message: "The expression On Get Focus you entered as the event property setting produced the following error: the text you entered isn't an item in the list * the expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the function, event, or macro&q...

Access Report
On my Report I have a Page Header that has my column names, a Category Header that has my Categories and then my Detail. How do I sum up my Categories after each heading? Do I have to create another Header? ANO $400,000 10% $5000 15% $600,000 15% $8000 14% I WANT TO SUM UP ANO DATA HERE BEN $400,000 10% $5000 15% $600,000 15% $8000 14% You want a Category Footer. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) &...

GP Crash when printing reports
Whenn printing reports (Invoice or Trial Balance) GP crash and returning and error GP encountered an issue and needs to be closed. Look at the Event Log and the error is "The description for EVent ID (1000) in Source (Dexterity) cannot be found. The local computer may not have the necessary registry information or message DLL fies to display messages from a remote computer. You may be able to use the /AUXSOURCE = Flag to retrieve this description . What is the cause of this Issue? Ems Most likely a corrupted reports dictionary file (REPORTS.DIC). If these are modified reports, I...

Label / Notes / Legend on the RIGHT of a Report
I have an Excel report with a legend box on the right. I am trying to recreate this report in Access but am not sure how to do it. Either it is repeating with every record or it shows at the TOP of the report or page. I want it on the RIGHT of the report. I thought about using a subreport, but I would rather not if possible. Rebecca_SUNY wrote: >I have an Excel report with a legend box on the right. I am trying to >recreate this report in Access but am not sure how to do it. Either it is >repeating with every record or it shows at the TOP of the report or page. I >wan...

I Need a Simple Sales Software
Hello, I am looking for software to keep track of my prospects, customers, and the notes of the sales process. I spend about one hour a day on sales and marketing, so I prefer a simple and inexpensive software. Maximizer, Outlook, Act, and Goldmine seem made for the full-time professional salesperson. Please let me know if what I am looking for exists. Best Regards, T.I. ...

Reports
Greetings, If i have a combo box on a form that runs a report, can i reference hidden columns form it ( Im assuming as I only pass in the bound column, probably not) ?? e.g. =[Forms]![frmstudentletter]![cbostudentid]![Column](1) Doesnt like the above .. And how can I concatenate fields? It doesnt like =[FirstName] & " " & [SurName] Cheers Rob On Mon, 25 Feb 2008 23:01:12 -0000, Rob W wrote: > Greetings, > > If i have a combo box on a form that runs a report, can i reference hidden > columns form it ( Im assuming as I only pass in the bound column, p...

Make it more simple or intuitive to do simple things
I appreciate the fact that applications are becoming more versatile and able to do things that we hardly thought possible in the past but I feel that in this added complexity you are losing sight of the need to do simple things easily without resorting to trial and error or consulting "help" which often anyhow doesn't lead one straight to the solution! An example is how to produce a chart with a series of months i.e Jan Feb Mar etc appearing on the X axis. This is no doubt something that resulted naturally in the first versions of Excel charts or in a competitor's ea...

Simple public folder permission problem
I have a public task list folder. However even though I have given everyone "Author" priviledges and full control of the directory, users cannot update the tasks (although they can create new ones). The changes to tasks get reset to their original values. Where should I look to fix this problem? Brian How did you grant Author Access, via Outlook or ESM? What do you meanyou gave them full control of the directory? "Brian Taylor" <taylorb@newsgroups.nospam> wrote in message news:e2hwumGrEHA.1160@tk2msftngp13.phx.gbl... > I have a public task list folder. Ho...

Incident/Case Resolutions Report
What would be the easiest way to get hold of a report with all CASE-related information (Name, subject, etc.) with 2 additional fields: - Resolution Title: - Resolution Description (This info is being captured in the Resolution Activity in an incident currently and is not exposed in views, queries, etc.) TIA... Please keep your posts in ONE newsgroup!! "Janneman" <Janneman@discussions.microsoft.com> wrote in message news:E207C08B-F42F-4E39-8984-14D587B68AA3@microsoft.com... > What would be the easiest way to get hold of a report with all > CASE-related > in...

What is simple text?
When creating a custom list that includes a column of accounting formated data, I get an error message that 'fields without simple text will be ignored'. The result is all other data except the accounting formatted data. Help!!!! I suppose it means without the currency symbol and thousands delimiters. On Fri, 8 Apr 2005 11:01:04 -0700, TexMas <TexMas@discussions.microsoft.com> wrote: >When creating a custom list that includes a column of accounting formated >data, I get an error message that 'fields without simple text will be >ignored'. The result is ...

simple question
Okay, I have a very simple question. Where do the old posts go after they run off the last page of this newsgroup? Sometimes I would like to refer to a post that I remember seeing in October, but is no longer on the current section. The search function seems to only search current posts as well. If anyone has some input please email me at joep@siboneylg.com Thanks kindly. have you tried google groups, they keep archived old posts: http://groups.google.co.uk/groups?q=microsoft.public.greatplains&hl=en "Joe Proehl" <joep@siboneylg.com> wrote in message news:099701c5...

change label on subFORM in REPORT
I have a REPORT with in it a subFORM Now I have this label (lblMonth) that I want to change. How should I do this? What would be the proper event to do this? The lblMonth should contain the name of the month as jan 07 Any ideas? TIA, Henro What do you mean exactly, do you want the label to change dynamically or should it just say jan 07. Either way run in code you could try something like: me.(subreportname).controlname.caption="jan 07" where controlname is the name of the label and subreportname is the name of your subreport. Sometimes it is neccesary to use the full suntaxi...