Smartlist Shows Zeroes For Vendors' Last Year Amounts

After upgrading to 9.0, a Smartlist vendor list shows zeroes for all vendors 
for Amount Billed LYR and Amount Paid LYR.  The Inquiry screens show the 
correct dollar amounts.  The LTD and YTD amounts are correct in Smartlist; 
only the LYR amounts are zeroes in Smartlist.
I can't find any TechKnowledges on this and file maintenance had no effect.  
Any help would be greatly appreciated.
0
DonMcCPA (12)
2/4/2007 4:00:01 AM
greatplains 29623 articles. 3 followers. Follow

2 Replies
1293 Views

Similar Articles

[PageSpeed] 10

I think the LYR numbers in the SmartList show the 'amount since last close'.  
When you look up the numbers in the inquiry screen are you selecting 
something and then clicking on the 'calculate' button.  The calculate routine 
is actually reading the records and computing the number on the spot rather 
than reading from a summary table.

"DonMcCPA" wrote:

> After upgrading to 9.0, a Smartlist vendor list shows zeroes for all vendors 
> for Amount Billed LYR and Amount Paid LYR.  The Inquiry screens show the 
> correct dollar amounts.  The LTD and YTD amounts are correct in Smartlist; 
> only the LYR amounts are zeroes in Smartlist.
> I can't find any TechKnowledges on this and file maintenance had no effect.  
> Any help would be greatly appreciated.
0
LeslieVail (702)
2/4/2007 4:57:31 PM
Thanks, Leslie.  I believe that the amount since the last close would be the 
YTD amount.  The amount between the second-last close and the last close is 
the LYR amount that I'm missing in SmartList.  If we had processed the YE 
close in AP twice, that would account for a zero LYR amount, but that was not 
the case.  Each year was closed once at the correct YE date.

"Leslie Vail" wrote:

> I think the LYR numbers in the SmartList show the 'amount since last close'.  
> When you look up the numbers in the inquiry screen are you selecting 
> something and then clicking on the 'calculate' button.  The calculate routine 
> is actually reading the records and computing the number on the spot rather 
> than reading from a summary table.
> 
> "DonMcCPA" wrote:
> 
> > After upgrading to 9.0, a Smartlist vendor list shows zeroes for all vendors 
> > for Amount Billed LYR and Amount Paid LYR.  The Inquiry screens show the 
> > correct dollar amounts.  The LTD and YTD amounts are correct in Smartlist; 
> > only the LYR amounts are zeroes in Smartlist.
> > I can't find any TechKnowledges on this and file maintenance had no effect.  
> > Any help would be greatly appreciated.
0
DonMcCPA (12)
2/5/2007 1:42:01 PM
Reply:

Similar Artilces:

sent emails are not showing up in SENT folder; + signs, duplicate recved emails
first time user of this bb... of bb in general for that matter / where and how do I check for a reply? here goes... some of my sent emails are not showing up in SENT folder while others do... and sometimes when I send a SINGLE email, progress bar shows up and says "1 of 4" or "1 of 5" being sent also getting these weird "little grey +" symbols in boxes to the left of the envelopes in the MAIN window... appear to be random... can be next to a "read/opened" envelope or not... when you click on the '+' symobol, indent appears... .... th...

repeating formulas by the same row or colum increment as the last. #2
I need to repeat formulas in a sheet by the same #of rows. I mean I might increase the copied value by 22 rows. How can I enter that without typing each row increment. So if I was to copy row 22 and then row 42 and then row 62. I might have one that looked like +sheetnameb22. The next one would be +sheetname b42, the next +sheetnameB62 ...

M04 Paycheck not showing in budget
Hello, I entered my paycheck in M04 Bill section. The actual amount shows in the budget, but not the budget. The budget shows 0 Thanks Frank I just realized that the paycheck date was set for february and I was looking at my january budget. That's why it was not showing up as a budgeted item. Regards, Frank ...

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

how do I setup a pie chart that does not plot zero values ?
I have a set of rows and columns were column 1 is the description and column 2 is the value (in percentage). I have setup a pie chart linked to these data to display these categories and their respective percentage. Howver, when a cell from column 2 has a zero value, I would like this whole row (description + zero percentage), not to be displayed on the pie chart as it is meaningless. Can you please suggest to me how to do it ? Thanks, Dimmy. Hi, Have a look here. http://www.andypope.info/charts/piezeros.htm Cheers Andy Dimmy wrote: > I have a set of rows and columns were column...

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

Imported Activities do not show up in Calendar
Hello, I've been working on importing Data from ACT! to Microsoft CRM and have 90% of the information pulled over and working correct. The last thing on my need to fix list is the calendar. We imported all Activities and Notes using Scribe, our 45 day license is expired and I cannot pay for another. So I'm stuck getting this working by hand. The ActivityPartyBase Table is populated with a ton of stuff. The AppointmentBase table has a bunch of entries, however only 1 column (ActivityID) is populated with something. (all others are <NULL>). I can't seem to figure out what n...

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

a field automatically change every year
I'm working on an elementary database. There is a specific field for grader. For example, there is a student who is first grader so I put G1. He will become the second grader in Sept. I would like the field automatically change to G2 in Sept. We have a thousand students. It's hard to change it manually. I'm talking about something like age. The age field will change every year. Thanks You raise an important point about database design, Anna. It is imporant to store the data so it does not go out of date, so don't store a student's age. Instead, store the date of bi...

Nothing shows up in windows ME forum so im puting it here
I have an old windows ME that i am trying to clone on to a flash drive and half way through the proccess the program gives me an error saying hd error cannot read try running chkdisk to fix any errors but then i run it and there is no errors. is there any program that can clone the whole hd including OS and errors it contains just a complete clone. the computer only holds 4gb and i am using a 8gb flash drive. Sure Norton Ghost 15 can perform a cold image of your system. This means, you just bootup your system using the recovery CD and it can save the image file on your flash...

HOW DO I SHOW VAT CONTENT
trying to set up a spreadsheet and final column must show vat content but can't work it out Assuming you have the total price in D2 then you can use =D2-D2/(1+17.5%) to get the VAT Since we are dealing with money you might want to add ROUND to it =ROUND(D2-D2/(1+17.5%),2) -- Regards, Peo Sjoblom "josudare" <josudare@discussions.microsoft.com> wrote in message news:9E5CBBB2-6208-44EA-9ACB-53BE8370603A@microsoft.com... > trying to set up a spreadsheet and final column must show vat content but > can't work it out ...

How do I get a cell to show the fifth character of another cell?
I have a number in cell N7 which is 8 characters long. I am using =LEFT(N7,3) to refer to the first 3 digits of that cell and =RIGHT(N7,3) to refer to the last three digits. How do I get it to refer to the 2 center digits without showing any of the rest of the number? =MID(N7,4,2) cheers Pete -- (][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][) "dedsky" <dedsky@discussions.microsoft.com> wrote in message news:BA3B7CF5-9AF1-4BCB-8646-D5D59A0ADA84@microsoft.com... >I have a number in cell N7 which is 8 characters long. I am using >=LEFT(N7,3) > to refer to...

Budgeted Item Shows Zero Amount When Tied to a Bill that reoccurs.
This applies to Microsoft Money 2004 Standard OEM Version 12.0 Update 1 I noticed in my budget report it shows that I have a monthly budget for Automobile: Automobile Insurance of $0.00. However, if you click edit budget on the common task page and then click next. Then you arrive at the "Enter Your Expenses" page. I have a budget group called Automobile. If you drill down and expand Automobile it looks like this: Automobile: Automobile Insurance ( red arrow) Safeco Insurance Monthly126.50 Other Expens...

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

Storage Limits not being accepted or showing up in ESM
I am running Exchange 2003 with Service Pack 2 applied. I have taken off storage limits for a particular user and it still does not show up in ESM. Hi Eric, How long have you waited? It can take a couple of hours to take. "Sabo, Eric" <sabo_e@cup.edu> wrote in message news:65742EA8-D7A6-4D0F-853D-2BA091CB9E4C@microsoft.com... >I am running Exchange 2003 with Service Pack 2 applied. I have taken off > storage limits for a particular user and it still does not show up in ESM. > > ...

non-zero solution
Hi, I do not know whether i can use excel in this or not. but I am trying to find the non-zero solution to the following equation: 0.6*exp(t*1.0986)-0.6=0.99994572*t but i always get a zero solution. How could i obtain the non-zero solution?I know that there is a non zero value of t satisfying the previous equation. Plz help, A.A.A A.A.A - Here's one way. Let A1 contain values of t, and initially enter 1 (or your choice of starting value) in A1. Let A2 contain the left side: =0.6*EXP(A1*1.0986)-0.6 Let A3 contain the right side: =0.99994572*A1 Let A4 contain the difference, which...

RPC over HTTP shows not enabled?
I think I have follwed the instructions properly for setting up a single exchange server for rpc over https. but when I view the server from Exchange System Manager it shows RPC over HTTP "not enabled" what could I have missed? gary Gary M wrote: > I think I have follwed the instructions properly for setting up a > single exchange server for rpc over https. > > but when I view the server from Exchange System Manager it shows RPC > over HTTP "not enabled" > > what could I have missed? > > gary Hmmm - see http://www.msexchange.org/tutoria...

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

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

why does named range only show up on some worksheets?
XL 2003, SP2 The title about sums it up. On sheet A I create a range Resource_List. I can access the range, it shows up when I hit F3, etc. If I move over to another worksheet and hit F3 it is not listed. It seems some ranges are "universal" and others I create only live with the sheet whence they were created. This seems bizzaro to me. Especially when the range used to show up everywhere. Any ideas on how to get these things to work ubiquitously? I did add a DB query to drop data into the area of the range. Seems like it hasn't worked since then. Could the query ...

2002/2003 Last Edit Problem
Hi, I've embeded "Last Edit" Date field in a 2002 document's Doc Box which generally works fine, except..... If the document is opened using 2003 (instead of 2002 where it was created), the Last Edit Date gets updated even though nothing on the diagram has changed! It's clear from the XML versions that 2003 is doing lots of changes to the underlying file structure which is probably what's triggering the "Edit/Update", but is there any way to turn this off? I've tried opening the file Read-Only, but even that doesn't appear to help. Thanks in a...

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

Windows Installer Runs / Show Office as a "Hybrid"
I am having serveral issues. All started when I noticed my Start menu button was lagging for at least 30 sec before expanding, and/or whenever I click on an office program the Windows Installer would run, and then try to re install/config Office, but as a Hyrid program. I have uninstalled and reinstalled and nothing has been fixed, just made worse. I have associated my Excel file with the office program. I click on the file IE excel file, and as it opens the Config screen pops up. I cancel it. I get an error message that I should repair/restore the program. The file cont...

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