Search results for query: *

In MS SQL I used a program that would report on what tables, stored queries, etc. were being accessed when a window was opened. Is there something similar in DB2? I want to make a Crystal Report of a work order. I can open the work order on the screen, but have no associated report. I would...

My SBS 2003 Server has an out of control priv1.edb. The file is 95 GB in size on disk, but when I view the mailboxes in administrator and add everything up there is only 5 GB of data. I attempted to perform an offline defrag, but ran out of time (9 hours) during the night. Mail becomes slow...

I've got an issue with licenses and logons. I've got a limited budget and want to find a way to allow my users to partially back out of the system, so that they don't need to perform a complete load up of GP everytime they need access. I've got some users that are constant. (5) I've got some...

We've got two test companies on our GP 7.5 system. The first is World Online and the second is OurCompany Test. My CFO would like the OurCompany Test to reflect the current data in our live company. What is involved in updating the test company to the current data state for the live company...

Staff in our company are disappointed by the inconsistencies in document numbering, ie - Quotes, Packing slips, orders, invoices, etc. may not have the same number. The master number appears to be consistent across these documents though. Is there a way to search for all documents in the...

I am looking to create a report that will list all customer account numbers, names, address, total sales amount per invoice, and invoice date for all customers since Jan 1, 2004. Looking at table info it suggests using SOP10100, SOP10106, and SOP10200. I didn't find a complete history here...

Here's a new one. Similar to my last thread, but different. I've made a trigger to tell me when the system is full. Most of the time it works, but when the system is full and a user attempts to login they get an error message on saving to one of the stored procedures related to activity...

I'm doing some VB work connecting to my SQL 2000 backend, which also is my Great Plains SQL server. When coding I've noticed I have to use UID and PWD in my code. I hate hard coding, or even having to store these variables in the registry or an ini file. My SQL server is set up for SQL...

I have a user who is unable to print her sales order batch postings. The window I am supposedly looking for is called "Print". Try as I may, in advanced security, I cannot find the "Print" window. Does anybody know where this window lurks? The problem is that since she doesn't have rights to...

I can't imagine I'm the only person who ever needed this. I've tried to create a business alert that would notify a user when an order is saved. Unfortunately the best I could come up with was one that every minute sent all the open orders. Does anyone have the definition for this business...

I have a user who gets crashing at times while completing Sales Orders in Great Plains 7.5 SP5. Although resolving the crashing is the best fix for this, the secondary problem these crashes are creating requires more immediate attention. When this user assigns inventory to an order, and the...