Hi All -
New to C++ and I am having problems with the syntax. I have been able to make a ADODB connection string to work and I can do a "Select Field from Table" to return the results. Please note that at the moment I only have one record in the table so it only returns this one record, however...
Hello -
I need assistance with a subreport. I can have multiple clients per companies and mulitple companies per county. I am able to get my distinct count of both the companies and clients by county but I am unable to sum the contacts that were made within the a set timeframe.
Example of data...
Hello All,
I was wondering if any of you knew if I could make changes to the custname and adrsCode using sql instead of doing all changes to the Customer Maintenance Card in GP. I can see the items that I want to change in these tables RM00101 and RM00102.
The whole purpose of wanting to make...
Hi All!
My problem is that a customer card was created twice for the same customer. The first card was created 6 months ago and then 6 weeks ago someone created a new card for this same customer and gave them a new number. Sales orders and invoices have been applied now under both customer...
Hi all,
My boss wants to have an admin account and password that will allow him to sign into any users computer and view/work as if it was them logged in. He does not want to sign in as the Network Administrator and have to explore through their MyDocuments Folder, and favorites folder. He wants...
Can someone tell me where the beginning and ending balances come from that are display in the GL Trail Balance report. I am trying to create a short version of this report that can be pulled using Crystal as a daily Cash Report. I have located my journal entries, but I am totally lost trying to...
Does anyone know if this can be done in GP9? I am trying to modify the blank invoice form to include a second page that would be the Terms and Conditions of Sale. Currently users are loading pre-copied sheets with the Terms and printing the invoices onto the sheets that way. I would like to...
I was wondering if anyone could tell me what tables are used to populate the GL10110. The GL10110 table is used to populate the Summary Inquiry Report. I have a crystal report that I created to show our sales by customer class and my sales figures are not matching the General Ledger Summary...
I am running Veritas 9 Exec and have been having some issues with jobs failing. I have been working through all the Failures and I tried a Test Run and it was successful, so I decided to Run Now. It has been stuck as Queued for the past 2 hours. I am afraid that this is going to have a Time Out...
I am using GP9 and I received an emailed from one user saying that when she would export her smartlist results to excel that only half the items were being exported. I tried several and so far I can only see this problem in Purchase Line Items. At the bottom of the smartlist results grid the...
Hi,
I have an order that was transferred to an invoice, but only 2 out of the 3 items on the order was invoiced. The user assumed that it was hung up and they have now VOIDED the order. Is there a way to unvoid the order. I can see both the order and the invoice in the SOP30300 table. And what...
Hi,
I am having a problem with sharing an email account. I have followed all the necessary steps for sharing and giving permissions and it works great, except it the owner is out of the office and their pc is off. Any suggestions? The intent of sharing this email account was because of...
I am rather new to using Great Plains, but I have used sql 7 and sql 2000. I was wondering if I could perform a update query on RM00101 table to update the userdef1 column and the comment1 column? I have a spreadsheet that contains some key information on our customers and I would like to update...
Hi,
I'm trying to create a report that will be display as a crosstab. I would want the customers as my rowheaders and my column headers to be LY/MTD, TY/MTD, and var% (this being (TY/MTD - LY/MTD)/ LY/MTD) group by month. I have tried writing a command to give me the qty for 2005 and 2006, but...
Hi,
I am trying to add a sql command in Crystal X1. After I create it and finish linking to tables I receive an error "More than one datasource or store procedure has been used in this report. Make sure that no SQL expression is added and no server side group by is performed. " When I refresh...
I am trying to do a validation check on dates entered by my users. This date can not be greater than today’s date. The problem is comparing the whole date (MM/DD/YYYY)
Example Values Current date = ‘07/13/2005’
Input Date1 = ‘07/13/2050’
Input Date2 = ‘07/11/2050’...
This is my first experience with triggers so any help would be great. I am trying to figure out how to write a trigger that will update a column in Table(B) based on changes to a column in Table(A). I thought I should place the trigger on Table(A) and that the trigger should be something like...
I have a LostFocus sub routine that will generate a random ID number for adding a new record. When the user clicks the command button Save New it gives the user an error if this number already exist in the table. I did not use the auto random numner in ACCESS because users wanted a unique number...
I am having a serious problem trying to compare dates. I am trying to compare a specific month like someone's birthmonth to another specific month like one that has been stored as an Issue date. An example of the problem is that I have a person with a birth month of February (2) and an Issue...
I am trying to retrieve a list for a random audit of new entries in our database. The list (report) needs to be 10% of the total new entries. I have written a store proc to retrieve my number for the 10%, but I'm having a hard time trying to input this into another store proc or in VB6 code. My...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.