Smart List Help

I am trying to create a Smartlist for receivables aging and I having some 
difficulty. 
I want to be able to see all customers with an outstanding balance and the 
associate the outstanding unpaid documents to the customer. I can get the 
aging information but I am unable to get the documents that responsible for 
the balance.
I can get the information from I need that is displayed but I can’t get the 
information from “receivables transaction inquiry” window I am looking for. I 
want to be able to show any document with a dollar amount in the remaining 
amount field and only show the documents that will equal the current balance 
amount.
Any help will be greatly appreciated.

Fliehigh  

0
Fliehigh (443)
11/6/2007 1:49:02 PM
greatplains 29623 articles. 6 followers. Follow

5 Replies
671 Views

Similar Articles

[PageSpeed] 11

Fliehigh:

You need SmartList Builder so you can create the table relationships
and queries you need to generate the aging.

Frank Hamelly
MCP-GP, MCT
East Coast Dynamics


0
fhamelly (399)
11/6/2007 6:34:30 PM

"Frank Hamelly, MCP-GP" wrote:

> Fliehigh:
> 
> You need SmartList Builder so you can create the table relationships
> and queries you need to generate the aging.
> 
> Frank Hamelly
> MCP-GP, MCT
> East Coast Dynamics
> 
> 
> 

I have smartlist builder.

The probelm I am having is that when I create the link to RM_OPEN table I 
get all opened documents for the customer not just the ones for the customers 
balance.

Fliehigh
0
Fliehigh (443)
11/6/2007 6:43:02 PM
We typically find it a lot easier to create a SQL view with the data first, 
then create the SmartList from that.  Just my 2 cents.

I believe what you're looking for is to only return the transactions in the 
RM_OPEN (RM20101) table that have a Current Transaction Amount (CURTRXAM) > 
0.

Hope that helps.

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.


"Fliehigh" <Fliehigh@discussions.microsoft.com> wrote in message 
news:E8C8DD99-4EF1-46DC-9CFF-6C5564F9F226@microsoft.com...
>
>
> "Frank Hamelly, MCP-GP" wrote:
>
>> Fliehigh:
>>
>> You need SmartList Builder so you can create the table relationships
>> and queries you need to generate the aging.
>>
>> Frank Hamelly
>> MCP-GP, MCT
>> East Coast Dynamics
>>
>>
>>
>
> I have smartlist builder.
>
> The probelm I am having is that when I create the link to RM_OPEN table I
> get all opened documents for the customer not just the ones for the 
> customers
> balance.
>
> Fliehigh 

0
victoria (3340)
11/12/2007 9:41:43 PM
I'll second your 2 cents Victoria - great advice. It is MUCH easier to
create a view and use it than create directly in SmartList.  You can
also see the results of the view prior to using it in the SmartList so
you can tweak it.

Frank


0
fhamelly (399)
11/13/2007 2:09:57 AM
Another benefit of using a view is that you can bypass Smartlist
completely and link Excel directly to the view using MSQuery. These
links are read-only so there is no risk of damaging data.

-- 
Lyle U


Victoria [MVP] wrote:

> We typically find it a lot easier to create a SQL view with the data
> first, then create the SmartList from that.  Just my 2 cents.
> 
> I believe what you're looking for is to only return the transactions
> in the RM_OPEN (RM20101) table that have a Current Transaction Amount
> (CURTRXAM) > 0.
> 
> Hope that helps.
0
lyleu (305)
11/13/2007 3:08:01 AM
Reply:

Similar Artilces:

SKU119.CAB for Publisher 2002 Help
I have msiplaced my installation CD...I have my product ID and Version number close by....but, can't access my publisher files for some reason. Says I don't have access because the program is not intalled for current user. I am the only user on this computer. And somehow....I just can't get in now. Can someone help me find it...email the file to me...or something? Ric S EventDyn@aol.com Thank you Have you tried to do a repair? -- JoAnn Paules MVP Microsoft [Publisher] "EventDyn" <EventDyn@discussions.microsoft.com> wrote in message news:6545BA3A-185D...

HELP
help need to use statement expense in excel ...

CISCO and MSExchange help needed
We need help with troubleshooting and resolving complex problems to ensure quality transmission service on the network; manage and maintaining and user accounts, maintaining and updating our system security plans on all platforms if anyone feels they can help us. We have sufficient budgets to pay for the right person. Thanks John. -- John D Allen. CEO & President. Leveridge Systems INC. ...

IF STATEMENT HELP NEEDED!!!
I'm trying to create a spread sheet and don't know this program AT ALL! I'm a designer and math and art just don't mix... So, here are the equations... In cell X6 I enter: If C6>D6 then (C6-D6)*5 or If C6<D6 then (D6-C6)*10 But, if cell D6 is yellow --- Put 20 in cell X6 So, I need some sort of identifier in the equation saying whether the cell is yellow or not. I'm sure excel doesn't recognize "yellow" but there must be another way. I can put a letter with a number in that cell if necessary. I'm not sure this is making sence, but if anyon...

Lists in excel
Is there a way to have a list that will eliminate a value once it is already used in a group of cells? Have a look here: http://www.contextures.on.ca/xlDataVal03.html -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kameca" <Kameca@discussions.microsoft.com> wrote in message news:2B43DEBA-1BFD-457E-884C-6643C95081F1@microsoft.com... > Is there a way to have a list that will eliminate a value once it is > already > used in a group of cells? see: http://www.cpearson.com/excel/Duplicates.aspx -- Gary''s Stud...

Need Help with log on
I have frontpage and have always edited my site using it, my computer crashed, we got a new one and installed frontpage again. In the past when I would go to edit my site a box would come up asking for my user name and password so I could connect to the host server (I think thas what it is called) Anyway now no box comes up at all and I do not seem to beable to edit anything. I have asked my web host and they can not help me. The site is up and working but I can not make changes. Sorry I do not understand much of the tech stuff. I had a lady who did this for me but she is no lon...

Help with 'Auto_Open' please...
SubThe first time I open my excel workbook, a macro automatically runs. Part of this macro eventually calls for the deleting of 'Sheet1' in the workbook. When the macro is finished running, I save the file. The second time I open the workbook, I want it to check to see if it contains a 'Sheet1'. If it does, 'Exit Sub', else do something else... I've pasted my VBA code below. Do you see anything wrong with it? Many thanks, Craig ---------------------------------- Private Sub Auto_Open() calcmod = Application.Calculation With Application ...

Microsoft Word
I'm trying to get a list of all the files a Microsoft Word document is hyperlinked to. Is there a way to have Word generate or show a list of all the files a Word document is hyperlinked to? Thanks On Tue, 4 May 2010 14:50:01 -0700, ikovy <ikovy@discussions.microsoft.com> wrote: >I'm trying to get a list of all the files a Microsoft Word document is >hyperlinked to. Is there a way to have Word generate or show a list of all >the files a Word document is hyperlinked to? > >Thanks Use this macro (see http://www.gmayor.com/installing_macro.htm if...

Excel 2003 question about help menu
I use Excel 2003 OFF-LINE. I find myself extremely limited and frustrated with the "menu approach" that it uses as well as the set number of items it will display as the result of a keyword search. The main problem for me ATM is that I know that the functions are categorized into say eight categories, e.g., text, but I don't always remember all of them. In the past, a search in Help would return a list of those categories from which I could quickly and easily navigate around to doublecheck my understanding. Search results in Excel 2003 are erratic, and trying to find the list...

teredo tunneling psuedo-interface code 10??? affecting my usb now i cant download music onto my ipod help!!
so i just got an ipod and when i pluged it in it said that and ipod was detected but could not be......( i forgot the rest) please unplug and try agian and it dosent work . so then i downloaded tune up utilities and it said i had 3 errors ,2 of wich really dont matter, but then i looked at the 3rd one and it said i had a code 10 on my teredo tunneling psuedo interface and it could not start. please help me!!!!! -- etfboy450 ------------------------------------------------------------------------ etfboy450's Profile: http://forums.techarena.in/members/169455.htm View this t...

trust help.
Hi all, We are going to create a two-way forest with CompanyB. The companyB has same internal and external public naming b.com. I just create the conditional forwarder for b.com to use their internal DNS server IPs. Now, when I ping b.com, it still routes to the external IP. Is this supposed to be? If I do nslookup b.com and it returns all their internal DNS IPs. Can I build a two-way forest trust or any additiona steps I need to configure? Thank you. If you are getting a different address when pinging and using NSLOOKUP on the same computer it is probably just the ...

Network Adapter Name help.
Is there a way to get the Network name "Local Area Connection" beside reading it from registry? ...

Vlookup Table Help
Revisiting an eariler issue. I have an excel document that looks like what I've shown below, in Sheet 1 Column A Column B Column C Column D 1 Origin Airport Destination Airport City Name Airline 2 ABE 3 ABQ 4 ACE 5 ABI I am trying to create a Vlookup table that will decode the origin airport code in Col A and display the decoded code with the city name in Column D. In Sheet 2, my table array I have created looks like this. Column A Column B 1 Airport Codes City Code 2 ABE Abilene, TX, USA Municipal 3 ABQ Albuquerque, NM, USA Albuquerque International ...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...

Outlook 2000 Can't find contacts for Distribution list
In Outlook 2000 on Windows 98SE I have added contacts and want to create a distribution list I go File->New->Distribution list Then click Select Members. In the drop down list box next to the text "Show names from the:" there is nothing!! I expect to be able to set it to the Contacts folder but when I open the list box nothing is there. Any ideas? Thanks jw Is the Contacts Folder enabled as an email address book in its properties? -- Russ Valentine [MVP-Outlook] "MS" <yea@right.off> wrote in message news:%23$vfCi4DFHA.624@TK2MSFTNGP15.phx.gbl... > ...

government can help you
http://government-assistances.blogspot.com/ ...

Help to modify a formula
This is my formula I need help with, in cell I10 this is entered =IF((I7-I6)*24>4,(I7-I6)*24-0.5,(I7-I6)*24) Problem is when cell I6 & I7 are blank cell I10 shows #value I need it to be blank or 0 any ideas? thanks all. Bob Bob, You should be getting zero when I6 and I7 are empty. It sounds as if there's a space or something like that in the cell. Some folks do that to clear a cell. -- Regards from Virginia Beach, Earl Kiosterud www.smokeyl.com ----------------------------------------------------------------------- "Bob Bob" <NOeMAILl@mail.com> wrote in me...

Help on Label Designer
I need help to design the label on label designer I know how to design label like Reg Price 4.99 Sale Price 3.99 But I need to ad on bottom of label You save $1. How I do it. -- Thank You Harjit SherGill You could sacrafice an unused field like MSRP and run a SQL statement to set the field like: update item set msrp=price-saleprice the that amout would be available to the label to display however you format it. "Gill" wrote: > > I need help to design the label on label designer > I know how to design label like Reg Price 4.99 Sale Price 3.99 But I need > to a...

Looking for Manpower Templete Help
I am interested in creating a stacked line chart that will display my >manpower overtime. I would like it to look just like a stock price >chart. X will be the dates per day and Y will be the number of >personnel available. Information that will be available will be Name >for the legend and the inclusive dates of their duty. This will need to >run the fiscal year from 01 Oct 04 to 30 Sep 05. Below an example of the data that need to be in the spread sheet. Thanks. Name Start Date End Date Person 1 12/1/2004 5/31/2005 2 10/1/2004 12/31/2004 3 12/1/2004 9/30/200...

Help! Someone is sending Spam through our email server
We are only a small company so not sure how to handle this. Someone is sending spam from our Exchange 2000 server. Hundreds of people are getting Spam from our email address! How do we stop this from happening? Please help! Thanks Hello, If someone complains that they are getting a lot of messags where sender's domain name matches your domain then you cannot do a lot to stop this. Anyone can send messages forging your email address. One solution for this is to use an SPF record. Refer to http://spf.pobox.com However, if they say that your SMTP server is sending spam (meaning messag...

Please help!!! Information Store and System Attendant does not start
Hello Everyone, I have a couple of questions. Friday my exchange 2k box crashed on the windows side. I have put the exchange hard drives in a new pc. I repaired the drive by running the windows repair and bascially had to almost install windows again. However, it comes back up at win2k sp3. I reran the exchange sp3 patch on the server. All my drives look good. However, the information store and exchange system attendant will not start. I was wondering if anyone can give me advice on why this is happening? Also on a side note I can not remote desktop into this pc which is weird? I can ping...

Weird problem with Publisher's listing of available printers #2
None of the installed printers will show up in Publisher on this lady's computer. They are installed in Windows and show up fine in other Office Programs (Word, Excel, Powerpoint, etc.). However, when you go to print a document in Publisher, the only printers listed are the "Microsoft Office Document Image Writer" and the "Lanfax Printer". None of the physical printers are listed! I tried uninstalling and reinstalling all the printers. I also tried upgrading from Publisher XP to Publisher 2003, but the problem has persisted. I have googled this and searched Micr...

Using a List Box
Using Access 2002 VBA I'm trying to post events in my program as they occur, using a list box(named ev_log). With: (In Module1) Public Function StatusOut(LogItem$, ByVal bLogFile As Boolean) As Boolean Forms!frmTest.ev_log.AddItem LogItem$, 0 Forms!frmTest.ev_log.Selected(0) = True If bLogFile Then If bLogging Then PrintString$ = LogItem$ & Chr(13) & Chr(10) If bLogFileChgBusy = False Then Err.Clear Put #hLogFile, , PrintString$ If Err Then LogItem$ = Format(Now, "...

Help with formula
Can't seem to get this to work can someone please help Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100) Mike wrote: >Can't seem to get this to work can someone please help >Expr1:Int(CDec( [DETAIL_LINE_AMT]*0.0675+ 0.005) * 100 / 100) Will this do what you want? Expr1:Int([DETAIL_LINE_AMT]*0.0675+0.005 * 100) / 100 -- Marsh MVP [MS Access] Mike "...can't ... get this to work ..." could mean a lot of things. Does it run but return incorrect values? Does it fail to run and gives an error message (it would be helpful to know what that message sa...

Using Excell, how do you alphabetize the completed list?
See above. Use the Sort function. "Kimo" <Kimo@discussions.microsoft.com> wrote in message news:3522CAD5-31B0-4251-9F48-542FE4F44E93@microsoft.com... > See above. ...