Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 35mph
  • Content: Threads
  • Order by date
  1. 35mph

    Able to make Purchasing Receivings default to Shipment/Invoice?

    Is there a way to make the receivings entry screen in Purchasing default to "Shipment/Invoice" instead of "Shipment?
  2. 35mph

    TCP/IP Printer and DNS?

    Sorry about the perhaps elementary nature of this question, but I'm no DNS expert. Our new HP printer takes a long time to be "found" on our network... even though we have assigned it a static IP. Here are the particulars: Our LinkSys router is set up as follows: IP: 64.xxx.xxx.236 Mask...
  3. 35mph

    Another VBA Toolbar User Date question

    I'm clear on using 7.5 to get the toolbar objects for 8.0 (thanks, David), but when I use the toolbar to get the Great Plains User Date, it's called ZoomButton and doesn't seem to work. A. Is that the field I should be using, and my syntax is simply wrong? B. I tried using the 8.0...
  4. 35mph

    Change default using VBA

    We have used VBA to lock the PO date in Transactions > Purchasing> Purchase Order Entry, so that the user can't change the PO date. It always defaults to the Toolbar date... Now, if a user opens an OLD PO it (correctly) shows the OLD PO date... and that's what we want... and if they make a...
  5. 35mph

    Please help with INSERT

    We have two databases, almost identical, and we are trying to copy data from Table1 in Database1 to Table1 in Database2. DB1..TBL1 has these columns: Col1: primary key integer Col2: text Col3: Identity column DB2..TBL1 has the same structure, and ALSO already has data in it, that we want to...
  6. 35mph

    Copying GL Accounts from One Company to Another

    We need to copy gl accounts from one company to another... this would be pretty simple if accounts did not already exist in the destination company... which we want to keep... but consider this sql statement: insert into THREE..GL00100 select ACTINDX, ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3...
  7. 35mph

    How simple to disable Terminal Services TEMPORARILY?

    We wish to install Symantec's Control Center on a machine running Terminal Services in Application mode. Symantec says that if we disable TS in app mode then we can install Control Center (I think)... Our question is: we have TS set up in app mode, and it works just fine now... we REALLY don't...
  8. 35mph

    SQL Server Security Basics?

    At the risk of exposing my COMPLETE ignorance, I find that I MUST break down and ask for a simplified explanation of a few SQL Server security topics. Basically, I find that "security" is addressed in several locations... and I'm just plain confused on what each means. For example: Under Edit...
  9. 35mph

    Integration Manager: import to multiple companies?

    We have a series of text files we want to import into a series of companies in Great Plains 8.0 using Integration Manager. Each text file corresponds to a company. We have set up a batch file that automatically runs IM, and it works fine as long as we're logged into the company that we're...
  10. 35mph

    How to change program name on taskbar?

    I know this may seem trivial, but we have a client that operates several companies in Great Plains... and they may have more than one company open at each time... on the same workstation. Is there a way to change the verbiage on the program button on the taskbar according to our own user...
  11. 35mph

    Need scheduling add-on (HVAC) for SBF

    Does anyone know of an add-on to handle scheduling of maintenance personnel in conjunction with Small Business Financials? For example, a customer may call in and ask to schedule maintenance on their air conditioner... User could look up customer and choose History, Notes and/or Schedule a New...
  12. 35mph

    Enterprise Reporting vs Analytical Accounting

    We are just coming up to speed on some of the advanced reporting features of Great Plains 8.0. Can someone help us save a little bit of time by answering a couple of quick, basic questions? What is the relationship/difference between Enterprise Reporting and Analytical Accounting? Did...
  13. 35mph

    Transfer and clear?

    We are looking at purchasing a TalkSwitch telephone system. We will install it at our main public phone number, then program it to say "For Joe, press 1, for Susan, press 2, etc." Then the calls will be forwarded to our respective, geographically disbursed locations. We have been told that if...
  14. 35mph

    Need high-speed wireless internet access

    Like many of us, I use a laptop to provide remote support to my clients. I just left the beach early because the local cable people couldn't/wouldn't get cable internet access up and running. I had taken my cable modem and router and lots of cables... for nothing. Dial-up was WAY too slow...
  15. 35mph

    Quick question about sa password

    probably obvious, but... Our client long ago set up a Great Plains sa password that is too easy to figure out. We would like to change it. We need to change it in SQL Server in Enterprise Manager > Security > Logins, yes? If we do that, won't that disable each user's local ODBC settings...
  16. 35mph

    Is there a way to include Computer Name in AMS Mail Subject?

    We're using Symantec AntiVirus Corporate Edition 9.0. Is there a way to configure the AMS alerts to include the Computer Name in the Subject of an Internet Mail alert... as opposed to only listing it inside the email body? I tried putting <Computer Name> in the email subject, but it just sent...
  17. 35mph

    How to encrypt the password in CDOSYS stored procedure?

    Our SMTP server requires authentication, and therefore, our CDOSYS stored procedure has the password hardcoded into it. Is there a way to encrypt the password field? How about encrypting the entire stored procedure? Or lastly, what about restricting permissions on simply viewing the stored...
  18. 35mph

    Business Alert Question

    We need to set up a business alert that will notify us whenever the status of a PO changes to canceled. It is apparent to me how we can have the alert run periodically to scan for that particular status code... but what we REALLY need is to be notified ONE TIME _when_ it changes... Not be...
  19. 35mph

    Electronic Signature Software for Great Plains?

    We're looking for software that will allow (require?) users to apply their own electronic signature to Purchase Order documents. We've looked at PO Enhancements - Approvals, and that MIGHT do it, but we REALLY want a digital image of a signature attached to the PO... and if possible, to have...
  20. 35mph

    Why export all reports before installing SmartList Builder?

    In reviewing a TK about installing SmartList Builder, it says to export all modified forms and reports before installing it. Pardon my ignorance, but why is it necessary to export all modified forms and reports? (And pessimist that I am, the TK doesn't make any mention of re-importing those...

Part and Inventory Search

Back
Top