RW Error in GP 10 Modified Account Statement

I  have modified the Account Statement to bring in the RM Tax Work table to 
display GST for each invoice.
When I run report from GP, I get:
'Inconsistent restriction/sort expression.  Please add the following 
restriction 'calc20009 = calc20009.'
I did add a restriction with 2 strings to do this, but error doesn't go away.
Help.
Tx
Les
0
LesWright (25)
1/23/2008 7:46:00 PM
greatplains 29623 articles. 5 followers. Follow

1 Replies
821 Views

Similar Articles

[PageSpeed] 59

Figured it out by restricting number of records coming in from 1 to many 
table.. then saw this in KB:

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVTQUUXNNZOUKYPPPNUXLNZQRYMOKTVQUMUULVKYNOXRKNNKXOYQQROXLKLMYZPOWQKLKQOMMRQTZQQLV 

Les 

"LesWright" wrote:

> I  have modified the Account Statement to bring in the RM Tax Work table to 
> display GST for each invoice.
> When I run report from GP, I get:
> 'Inconsistent restriction/sort expression.  Please add the following 
> restriction 'calc20009 = calc20009.'
> I did add a restriction with 2 strings to do this, but error doesn't go away.
> Help.
> Tx
> Les
0
LesWright (25)
1/23/2008 8:36:02 PM
Reply:

Similar Artilces:

Help with query... 10-19-07
I need to create a querry that needs to have values of two different columns to be looked up in another table. Ex. Table: ChangeDetails Column: Note Column: PaperStatusID Column: DigitalStatusID Table: Status Column: StatusID Column: Description I need a querry that will display the Note, Description from the Status table (where PaperStatusID = StatusID), and Description from the Status table (where DigialStatusID = StatusID). I need this in a single query, but I'm not good at queries yet and can't figure out how to do this. Here is sample data to clarif...

Can't remove other users mailbox from my account
Using outlook 2k and exchange 2k. I added a users mail box to my outlook, via the "tools menu/services/exchange server properties/advanced" route, but while i was in the process of this outlook crashed and i had to restart. The extra mailbox then appeared in my outlook, but when i check the list of extra mailboxes for my account the other mailbox is not listed, but it has been added to my outlook anyway. Obviously the crash caused a loss of communication between the server and it thinks i should have that extra mailbox open in outlook, but i want to remove it now but becasue its no...

Outlook Error #57
I am getting an error from Outlook 2003. It seems to happen at random times but always seem to be during attempts to send/receive email. The error does not happen every time. The error seems to occur every hour or 2, even though I do a send/receive every 5 minutes. I tried doing a repair and it did not help. I then did an uninstall and a new install and that did not help. I then created a new profile and that did not help. The error does not always occur on the same email account (I have 10 accounts, but have experimented with less accounts). When the windows error message pops ...

How do I get CD-RW to be revisable?
I don't understand your question. Does this have anything to do with Excel? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Angie" <Angie@discussions.microsoft.com> wrote in message news:8B85D26B-00F0-4FF8-8716-9B37ED3CBBFA@microsoft.com... > ...

On error displayes default error code instead of the specifyed one
Hi, I have added error handling code to my combo box. Private Sub searchName_AfterUpdate() ' Find the record that matches the control. Dim rs As Object On Error GoTo ERR_Handler Set rs = Me.Recordset.Clone rs.FindFirst "[sdutentId] = " & Str(Nz(Me![searchName], 0)) On Error GoTo 0 Exit Sub ERR_Handler: MsgBox "Please empty search box before continuing!" End Sub But it doesn't display the message in msgbox, it displayed default ms access error code. which is "The text you have entered isn't an item in the ...

6 bottles of wine gets you 10% off?
Has anyone figured out how to do this without an add-on? RMS Out of the box, or is it impossible? -- Thank You Vince :) One way is using the discount section. But you have to figure out amount for the 6th bottle and above. "Vince" <Nagarra@yahoo.com.(donotspam)> wrote in message news:14DF8630-C031-4C90-8FCB-BE8085FFCA25@microsoft.com... > Has anyone figured out how to do this without an add-on? RMS Out of the > box, > or is it impossible? > -- > Thank You > Vince :) Can you elaborate any further? If in using the discount section won't tha...

Frx Susbcript 9 error
I am running a consolidated Income Statement in FRx and I get an Error 9 when it hits this one company. It consolidates 5 different companies, one that is translated. I just can;t figure it out. I have a very similar Balance Sheet that runs just fine. I have tried everything, change the output names, etc. I can run the report if I just select that one company but when I run the total company it won't run, it stops with the error. I am using row linking and currency translation. I can run the report for all companies individually. I just don't get it. I have gone through the various kb...

Outlook 2000 Account Settings keep changing.
We use Comcast Email and Outlook 2000 on one Win98 and many Win2k and WinXP PCs. The Win98 machine does this all the time, and now a Win2k machine has done this. Email works fine, then fails to connect. I check the Account settings and on the Servers tab the Incoming Mail settings will say Localhost. When I change it to mail.????.com Outlook works fine. Days, maybe weeks go by and email fails to connect again. Sometimes the Incoming Mail setting will have reverted back to Localhost again and the change mentioned will fix it again. Other times it will still be mail.????.com and changing to Lo...

Bad Experience with GP Purchase
When our company decided to go with Dynamics GP, Microsoft directed us to a local "partner" who would sell us the software. This partner would also be responsible for importing our existing data and customizing GP to fit our business. This was in January. We were given a completion date of no later than March 1st. It's now March 12th, and we don't even have our customers imported correctly into GP (the bill-to addresses are mixed up). At this rate, our ETA will be April 30th at the earliest (assuming all goes well from this point on). Sorry for venting, but my ...

error in code
m_TQuote.Open(); // addedd for database m_bInserting = FALSE; // addedd for datbase DoModal(); //GetDlgItemText(IDC_EDIT1 ,m_MainEdit); //GetDlgItemText(IDC_EDIT1,m_TQuote.m_ID,m_TQuote.m_DateTimeStamp,m_TQuote.m_MarketNo,m_TQuote.m_Bid,m_TQuote.m_MarketName,m_TQuote.m_Ask,m_TQuote.m_MarketState); GetDlgItemText(IDC_EDIT1,m_TQuote.m_DateTimeStamp,); GetDlgItemText(IDC_EDIT1,m_TQuote.m_MarketNo); GetDlgItemText(IDC_EDIT1,m_TQuote.m_Bid); GetDlgItemText(IDC_EDIT1,m_TQuote.m_MarketName); GetDlgItemText(IDC_EDIT1,m_TQuote.m_Ask); GetDlgItemText(IDC_EDIT1,m_TQuote.m_MarketState); HRESULT hr = 0; ...

Report Layout 01-19-10
I have a database table that has the following columns: PicDescription - Text type Picture - Attachment type I now want to create a report that looks like the following: pic1 pic 2 pic 3 pic 4 Description1 Description2 Description3 Description4 I can either get the pictures the way I want them, put then the description is wrong, or I can get the description correct, but then the pics are wrong. How do I get the report to look the way I want. Thanks Apparently you want the pictures to display across and the descriptions to display vertically under the pictures...

SBS2003 to SBS2008, preparation. SP1 install errors
I'm doing a dummy run of the migration. I'm using duplicate in all respects apart from a different NIC, slightly smaller partitions. The BPA insisited SP1 was not installed (though it was) so I went about re-applying all the components of SBS2003 SP1 and on the main SBS SP1 patch, the last of them, I'm getting a "The Administrator must be a member of the Domain Admins, Enterprise Admins and Shcema groups to install the update". I've checked the usual causes, not having the master role etc. The only thing I can think is that there is another Server 2003...

Outlook 2002 error.
Hi, At least once or twice a day, Outlook has some sort of serious error that requires it to close. It immediatly reopens, but it looses all your unsaved work. I have XP Pro. Does anyone have any ideas on what I could do to make the thing more stable? Thanks. ...

Error adding a new field to form
I did the following things: - Add a new attribute to a Lead with the deployment manager - publish this customization - add this new field to the Lead form with the form-designer - After saving the form again publish the customization with the deployment manager - restart iis When i try to open the leads gui i get an error saying me that for the lead object i do not have the select permission. any ideas? I repeated my action with different objects but always the same error! The error doesn't occur if i add a field that is already defined in the deployment manager as an ...

An error occurred while trying to promote the email
Customer is getting an error: "An error occurred while trying to promote the email. Try again" Anyone seen it before? Thanks, Stephen No takers? "Stephen Redmond" <noreply__stephen@crm.ie> wrote in message news:%239Ebcn5gEHA.1184@TK2MSFTNGP12.phx.gbl... > Customer is getting an error: "An error occurred while trying to promote > the > email. Try again" > > Anyone seen it before? > > > Thanks, > > > Stephen > > OK, here's a shot: If the user is trying to promote the mail from any folder other than I...

Error 0x800ccc0e?
I've googled for the Outlook Error 0x800ccc0e and have followed all of the examples that I can find but it still doesn't seem to have solved my problem. 1) I am not able to check my email and get the error above. 2) I've tried to TELNET to my mail server Port 110, DOESN'T WORK 3) I've tried to run the command "netsh int ip reset c:\resetlog.txt" ISN'T RECOGNIZED NOW WHAT? If you can't Telnet to port 110 on the server, sounds like there's a server side issue. Can you at least PING the server? "HotRod" <NOSPAM@youremail.com> wr...

Exchange 2003 Mailbox Move Error
Hi - I'm trying to clean out some old mailboxes from our primary storage group to a newly created one that will be used to archive these mailboxes. However, I'm getting the following errors: Event Type: Error Event Source: MSExchangeAdmin Event Category:MAPI Session Event ID: 9175 Description: The MAPI call 'OpenMsgStore' failed with the following error: The information store could not be opened. The logon to the Microsoft Exchange Server computer failed. MAPI 1.0 ID no: 80040111-0286-00000000 Event Type: Error Event Source: MSExchangeAdmin Event Category: Move ...

RW
Have just recently upgraded customer from v7.5 to V9. They have specialised inventory item numbers that include dimensions but when they print their SOP sales invoices - they only require the first 6 digits printed. We achieved this a while ago by putting a format on the field (XXXXXX). Since the upgrade one user has experienced a printing problem as the full item number appears - we have now establised that it is only if the user uses a smartlist to select the invoice and drills back to the invoice to print. If they use the inquiry screen to select the invoice - all is ok. Anyone any i...

difreance between GL and Account receivable
Dear All When I print the trail balance for customers then print the GL account for account receivable the amounts are NOT MATCAING, I already checked the system setup, configuration and posting account please advice thank you very much Amr, If you are on v10, you can go to Microsoft Dynamics GP > Tools > Routines > Finacial > Reconcile to GL. This routine will generate an Excel spreadsheet showing the differences between the two modules. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com The Dynamics GP...

Outlook 2003 Errors
Perhaps someone can help... I've got a small, but annoying issue with Outlook 2003. I use Word as my e-mail editor. Following a restart, if I go to reply to an e-mail I am greeted with an hourglass and the following message: "Preparing To Install" Never says what... Process completes in about 10-15 seconds... If I open Word as a standalone application the following message comes up: ""An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?" I click OK. Then is says, "Preparing To Install." Wh...

Office 11.4.0 error
I attempted to run Autoupdate to get this update and I get this error message. The installer could not locate the correct version of the software to install the update. I even tried downloading it directly and it didn't work. I have 11.3.9 on my computer and don't know why it isn't working. On 2/18/08 2:05 PM, in article ee8deb4.-1@webcrossing.caR9absDaxw, "mac09@officeformac.com" <mac09@officeformac.com> wrote: > I attempted to run Autoupdate to get this update and I get this error message. > The installer could not locate the correct version of the softwar...

I can't get Outlook to synchronize with my yahoo email account.
I keep getting error messages. IS there someone or a website with good directions that might be able to assist me. Thanks! "Dan" <Dan@discussions.microsoft.com> wrote in message news:933B689D-59DF-4237-958C-45A246982C33@microsoft.com > I keep getting error messages. IS there someone or a website with > good directions that might be able to assist me. > > Thanks! Do you have a paid-for premium account with Yaoo? (Unless you're in the UK.......) Dan <Dan@discussions.microsoft.com> wrote: > I keep getting error messages. And those messages are? ...

Socket errors
Hi, i don't understand the following error completly WSAEUSERS 10068 User quota exceeded. Ran out of user quota. WSAEDQUOT 10069 Disk quota exceeded. Ran out of disk quota. When do these errors occur ? WSAEUSERS - it is due to Too many users. The quota system ran out of table entries. WSAEDQUOT - A write to an ordinary file, the creation of a directory or symbolic link, or the creation of a directory entry failed because the user's quota of disk blocks was exhausted, or the allocation of an inode for a newly created file failed because the user's quota of inodes was exh...

would i be able to get my gmail account folder in my outlook 2007?
Hi This is Ravi here. My concern is that i do have gmail account running in my outlook 2007 and the problem is that would i be able to get my all folders which is in my gmail account in my outlook 2007. I have checked all options but unfortunately, i can not find any option where i can get any option to activate my those folders as my gmail account is so important for me. I can say that it's my business. I want to use outlook anyhow. So can you being able to solve this problem? if you can, that would be highly appreciated for me. Thanks Ravi "Ravi Patel" ...

Sales for Outlook Errors when creating new records
We have just installed MS CRM 1.2, and all seems well in the web client, and on the activities side of the Outlook client, but when any user attempts to create a new record of type Account or Competitor or Contact or Invoice etc, they get the following error in the popup window; Microsoft CRM Error An error has occurred, for more information, contact your system administrator Try Again | Close Can anyone shed any light? Seems pretty fundamental, but I'm drawing a blank. TIA Paul. is the users computer running antivirus software as we have seen issues like this with mcaffees an...