RW Query - tax registration number prompt

Hi,

I have a customer who has several companies set up.

Some of the companies have different report dictionaries as they have a 
variety of modifications per company.

For the RM Blank document, there is a conditional field - Tax registration 
number based on whether Tax Registration number prompt <> ' '.
2 compamies have the Tax nunber set against the company control but only one 
company prints the  number. Is this a set up issue - what does it mean by Tax 
Registration number prompt <> ' '
Thanks
Jean
-- 
JB
0
JB (195)
2/12/2009 4:00:03 PM
greatplains 29623 articles. 5 followers. Follow

0 Replies
437 Views

Similar Articles

[PageSpeed] 10

Reply:

Similar Artilces:

Query Criteria 04-15-10
Hi, Some of the fields I have in a table which is imported from a csv file are: Salesperson (has up to 20 names in it) Status (has Won,Lost,Submitted,Prospect,Did Not Proceed,Estimation) Status Date (has date) Value ($ value) What I am getting stuck on is a query to get the total value per Salesman for each status and also the count of each status, I would like it to show in datasheet form something like below. Salesman $won No. Won $lost No.Lost A $100000 5 $150000 3 B ...

Excel query #5
Hi, I'm using Microsoft Query to get data from my Access tables. After the 64th query, I get the message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed", which means I can't add another query. I need several more queries. Each query has 53 fields. Can I increase the number of queries the driver can open some way? If not can, pivot tables or OLAP cubes open more queries. I have played with them some. Can they open that many fields? Are pivot tables or OLAP cubes the best way to handle the data? I'm not looking for a 'how to' ans...

Another issue with RPC over HTTP and credential prompts...
Alright, I have this set up at about 25 total locations, 20 of which are working flawlessly. The other 5... well please let me know if you can help! I have each location logging into a domain accross a VPN. I have implemented RPC over HTTP to minimize the load on the VPN equipment. The issue is that at 5 of these sites, they keep asking for the logon credentials when you go into Exchange. I have installed the certificate from the server, I have made sure that the terminals are using credentials that have not expired. If I allow the terminals to connect using the normal RPC method that...

Queries to Views?
I posted this question in a SQL Svr newsgroup and was basically slapped down for doing so. I was told this is an "Access" issue and I should try an "Access" group (man, those guys can be sensitive!). So, here we go... I've tried a few different approaches but, each time I try to convert an access query to a view in SQL Svr 2000, the result is a table not a view. Does anyone know how to take the dozens of queries I've created and move them into SQL server as views without copying and pasting the SQL statements into query analyzer one at a time? I've ...

Templates and Queries
I have an Excel Template that contains a query pulling from and Access Database. I have tried to modify this query, however, it doesn't seem to accept my changes. I can create a new query within a new template and then it works fine. Rather than doing this for everyone, I would like to just modify the query and save that within the template. I've tried saving the query and then resaving the template also. What am I doing wrong. This is Excel XP. Thanks, ...

On line price updates corrupting number of shares
Recently there has been a signficant change in the way Money handles updating investments with the latest prices. Before Sepetember (and going back to at least 1997 when on-line updating became available and I started using on-line updating) when you hit "Internet Updates" only the LATEST price for a stock was downloaded. Now suddenly a complete history of weekly prices is downloaded. This in itself is not necessarily bad, but for a signficiant number of stocks in my portfolio PHANTOM SHARE SPLITS have been introduced. ie share split when in fact there were none. eg Austra...

Excel Won't Recognize Numbers
Hi, I can't get Excel to recognize numbers when copying text from a specific site for some reason. When I copy and paste numbers and search terms after doing a query from this site... http://inventory.overture.com/d/searchinventory/suggestion/ it seems that in excel, they display with a space before each number and each term. I'm not an advanced user and I just can't seem to get rid of the space so that I can sort by number or by term alphbetically (without manually deleting each unnecessary space). I have tried using the 'trim' function, paste special->value...

Network connection for query
G'day there One and All, I'm currently trying to adapt a few of the Dept's workbooks to suit our district. There is a single master book, to produce reports, that is available to all on a read only basis and read write to the relevent manager. There are also a number of data entry books that are identical to each other and that provide the data from each division. The master book uses a query to obtain data from the division's books and thereby build the reports. The data books are read write for everyone with only a single sheet from each providing data for the que...

Query to find when a total is hit
We are trying to get some statistics on our Inventory people to see if they are issuing material to work orders on time. My work order table has a field that shows the last transaction date of the order, but if Inventory issue all the material then has to issue more because of scrap later they get dinged as being late. We have a Transaction History table that shows every issue however I don't know a good way to find out when the total number of needed parts was reached. For Example I am creating a shop order that needs 3 parts, 50 of each: ShopOrder PartNeeded D...

import from MS Access
When importing Access file to Outlook 2003 contacts using wizard, phone number fields without area code in source have default area code inserted in the outlook contact, i.e. 555-5555 in Access becomes 222-555-5555. This is happens for all numbers in all phone fields. ...

LDAP Query needed
I need an ldap query to find all users with an exchange mailbox where the users alias does not equal the nickname of the smtp email address(s). Thanks! "MrRAlan" <MrRAlan@discussions.microsoft.com> wrote: >I need an ldap query to find all users with an exchange mailbox where the >users alias does not equal the nickname of the smtp email address(s). Thanks! I don't believe LDAP supports what you want to do. You'll have to write a small program (vbs or perl) that creates a mail address and then queries the AD for a match. -- Rich Matheisen MCSE+I, Exchange ...

Queries?
Is it possible to make an "update query" to roll back year to date overtime hours? I have an tblhours that totals all overtime hours worked and refused in which I have ran queries to sum all of those. Once a year we have to rollback the year to date overtime hours which means we take the lowest employee, he goes to "0" and we subtract the lowest employees hours from the highest employees hours. I was trying to do this in an update query, but everything I try subtracts, for example, 10 hours from every line of overtime in the tblhours table. I know you are no...

Excel VBA SQL Query Filename
I recorded a macro to pull in an external dbf file using a SQL query in VBA (Excel 2003 on an XP machine). Everything works great until I point it at the original file (was pointing at a renamed copy) that I want to pull in. The files I need to pull in will have the format <output filename>~<model 1>~<model 2>~<sub model>.dbf. The SQL query doesn't like the strange characters (~'s) in the filename and if I try a wildcard within the filename (i.e. <output filename>*<sub model> or <output filename>%<sub model>) it doesn't l...

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

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

eConnect registration failure
Hi. I had been successfully using eConnect for Great Plains 8.0. However, upon reinstalling business objects (we were writing support doco) the registration step failed and consequently eConnect has ceased working. The error during install simply states "Warning! Registration failed." We are using the same registration key as before. Do they expire? Do eConnect keys become invalid if other GP features (national accounts) are activiated? The user is in the DYNGRP sql role. So what else would cause it to fail? What diagnostics is possible? Thanks. ...

Search Function with queries
Hi guys, new user to access 2000 and i am trying to create a search query that will allow me to enter in a value and return that value. The part i am having trouble with is i need to do this for many fields and if i use the method i came up with, when i leave a entry empty using the "AND" function i get nothing and when i use the "OR" function i get all the values for both. maybe you guys can help me get in the right direction. this is the command i am using in SQL: SELECT [Chain Machine prod Machine list].Description, [Chain Machine prod Machine list]...

Querying master worksheet
Hi: I have a master worksheet that runs from an Access query. After it is populated I want the other sheets to be populated dynamically. So like this: WorksheetA ColumnA ColumnB ColumnC Agent Supervisor Calls b. smith 1199 3 s. jones 1199 6 a. sharma 2244 4 a. chong 2244 5 WorksheetB Header: Supervisor Number: 2244 ColumnA ColumnB Agent Calls a.sharma 4 a.chong 5 So basically each worksheet brings back...

INSERT INTO Query Converted to VBA
Hello all, I have a append query that works great if I just run the query via Access. I need to convert that query into VBA code. Here is the SQL View of the query I'm trying to convert: INSERT INTO TblInitiator IN 'I:\Archive\TestFinal\080107\TS3000v101_be.mdb' SELECT tblAddInitiator.* FROM tblAddInitiator; What the query does is append the table called tblInitiator located in a network location from values in a table called tblAddInitiator. There is only one field in each of the tables both called fldInitiator I tried this VBA statement (all on 1 line) AppendDB = "IN...

How do I run a SQL query against a MS SQL Server database from exc
How do I run a SQL query against a MS SQL Server database from within Excel 2002? I know it can be done somehow using the SQL.Request addin function. However my attempts using this function have continually failed. Can some one please provide a working example to the pubs or Northwind dbs that I can work with and use to help debug my attempt? Thank you! ...

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

Multiple database query
Hi gang - How can I make a query work with two databases on the same server- I tried this but its not working - [both databases are exactly the same] SELECT KEP.dbo.PM30200.VCHRNMBR AS PaymentNumber, PM30200.VENDORID, PM30200.DOCDATE AS CheckDate, PM30200.DOCNUMBR AS CheckNumber, CONVERT(varchar, CONVERT(MONEY, PM30200.DOCAMNT), 1) AS CHECKAMOUNT, PM00200.VENDNAME, PM30200.CHEKBKID FROM PM30200 INNER JOIN PM00200 ON PM30200.VENDORID = PM00200.VENDORID WHERE (PM30200.DOCTYPE = 6) AND (PM30200.DOCAMNT > 25000) AND (PM30200.DOCD...

The column prefix 'c' does not match with a tablename or alias used in the query
I got his error message on this scritp which I do not understand: select Top 1500 p.master_customer_id as parent, c.master_customer_id, c.label_name, sum(c.usr_pbuntsmngmnt+c.usr_rhuntsmngmnt+c.usr_bsuntsmngmnt+c. usr_othuntsmngmnt+c.usr_lchountsmngmnt + c.usr_genbedmngmnt + c. usr_rescaremngmnt + c.usr_shelteredmngmnt + c.usr_supportedmngmnt) as TotalUnitsManagedByGroup, sum(c.usr_pbuntsowned + c.usr_rhuntsowned + c.usr_othuntsowned + c. usr_lchountsowned + c.usr_genbedowned + c.usr_supportedowned + c. usr_rescareowned + c.usr_bsuntsowned + c.usr_shelteredowned) as TotalUnitsOwned...

counting the number of times shown
I am trying to figure out a way to put a numerical value next to the id that is shown, suggestions? ex: ID This is what I am hoping to get to show up in the next column 55 1 55 2 37 1 46 1 62 1 55 3 89 1 82 1 Hi With ID in column A, insert this formula in B2 and copy it down as required: =COUNTIF($A$2:A2,A2) Regards, Per "klh84" <klh84@discussions.microsoft.com> skrev i meddelelsen news:14D13B5C-FEE8-4489-B91E-AC65F2ABB090@microsoft.com... > I am trying to figure out a way to put a numerical value next to the id > th...

backing up to a CD-RW #2
When i attempt to backup to a CD-RW, I am instructed that I do not have administartor's privlidges to do so. I have Windows XP, and I am the administrator and only active account. I have double-checked and I am listed as the computer's administrator. Is this a "Money" administrator, or computer administrator? m> When i attempt to backup to a CD-RW, I am instructed that I do m> not have administartor's privlidges to do so. I have Windows m> XP, and I am the administrator and only active account. I m> have double-checked and I am listed as the compute...