Search results for query: *

Sorry, syntax again. Trying to convert a DateTime to display as a Date in a VIEW I am creating. Data is: 2006-07-15 00:00:00.000 Would like it to be: 2006-07-15 Also would anyone know of a good link/s where I can go and find some of the syntax listing I need. I am green at this and...

Can't find in my records; know I had it. What data file contains the paths to all the shortcuts for users for GP v6. Thanks

I am presently using a formula to calculate -45 days from a date and using this formula to create the Group and formatting the group to show mmm-yy. My problem is that it is sorting the group by acsending order instead of by month order. The numbers are coming out correctly. I do not have the...

When selecting a customer in Cards>Sales>Customers after the window opens and I select a customer the following error pops up on my screen. (Don't think it's a rights thing because I have full rights in GP across the board. I have tried logging into GP from different system in the office and I...

GP v6 One of my users can not access a cash batch. According to Dynamics SY00800 his user name is listed twice in there. He is logged out of GP and I do not see him under User Activty. Also no mention of him on Citrix boxes. Is it safe for me to just delete these two records thinking that...

C v8.5 I had to change a VIEW that I am presently using in my report. Existing VIEW field01 field02 New VIEW field01 <-- same as existing field02 <-- same as existing field03 <-- added field I did this once before a while back and for the life of me can't remember. All my fields that I am...

T-Sql My code is pulling all records where field2 = 0. In tableA are sales orders. Each sales order may have multiple records. Those multiple records will contain either a 0 or 1 in field2. What I need is to only pull from the many records for a sales order (field1) only ONE record where field2...

Sorry about the name of the title but hard to describe my problem. I am trying to capture NULLs on both ends. Meaning if sopnumbe is null then use order_num and if order_num is null then use sopnumbe AS master_SOP_Num. This works ok if order_num is null it populates master_SOP_Num, but if...

MS-Sql 2000 I was working on a project about 1 month ago that involed a crystal report using several VIEWs. My problem is that I was working with 3 different databases on 3 different servers. One, our live system and two other test systems. Stupid me can't remember on what database I made my...

MS-Sql 2000 I was working on a project about 1 month ago that involed a crystal report using several VIEWs. My problem is that I was working with 3 different databases. One, our live system and two other test systems. Stupid me can't remember on what database I made my last edit of the VIEWs...

It seems we failed to run "End of Year" for our inventory. Our Last Year is still reflecting 2004 and Year to Date is carrying over from last year. So far I see tables IV30101 and IV30102 hold the totals. Would anyone be able to tell me what other tables would have been effected. Also, if we...

Trying to connect 2 computers to a home workgroup. 1 WinXP Home Edition 1 Win98SE I have the two systems set for the exact same workgroup name. The win98 system sees the workgroup and sees itself. The winxp home system sees the workgroup but does not see itself. Even turning the firewall off...

V8.5 My mind is just not functioning correctly today. Trying to create a selection formula that will pull only records based on a NULL value from two different fields in the same record working only with one table. Example: Pull records that this field GP_Ord is Null or this field RB_ord is...

The code below works fine if sopnumbe is null it then uses order_num and populates master_sop_num with order_num. But I am also trying to achieve the reverse. If order_num is null then use sopnumbe and populate master_sop_num. I am not too go with syntax. Thanks, much appreciated. select...

When an item is set up in the master inventory file "itm_mstr" a corresponding record is automatically created in the file "loc_mstr". This automatically created record is the master location record. In order for the system to hold inventory amounts and ship an additional location record must be...

Sorry about the title of the thread. Could not think of a better one to describe the problem. My main objective is to be able to join the two different databases together and drive off of the master_item field for my report. Accounting: Blue color WMS: Green color Here is my present code...

I think I am having one of those moments where your brain just does not function correctly. I would like to combine the below two if then's into one statement and just for the life of me can't get it right. A little assitance would be greatly appreciated. Thanks #1 if...

MS-SQL2000 I am attempting to access a different database from a database on the same server. No matter what combination I use I am getting invalid columns etc. I am new at this and it is probably just some simple syntax I am missing. Also this is test code. Once this code goes live it will be...

v8.5 MS-SQL2000 I have a basic report. Not using the report header section. No grouping. Have 3 files linked together using a common key to all three files. 2 files are from one database on one server and 1 file is a view from another database on another server. This does not seem to be the...

We are running v6 GP Is there any way to limit that an item can only be placed on a sales order once and not multiple times. Non of our customers order the same item more than once with different ship dates on the same order. We would create separate orders. The only time the same item would...