Search results for query: *

Sage 300 2019 PU2 + UP73A PU18 + UT73G PU1 We found a rounding error in the payroll pre-check register. A time card was entered for 15 hours @ 62.2743 = 934.1145 Normal rounding would give 934.11 but the pre-check register shows to 934.12 Yeah I know it's 1 penny off.... but try explain that...

In AR terms setup number of days is limited to 999 days. We have a client who has multiple payment schedules with 48 monthly payments for example, so 999 is not enough days. Are there any workarounds to this limit? I've tried altering the field in SQL, yeah it does not like that ;) Sage 300...

I need to sync data from a legacy ERP database to an Oracle database. I'm running a test VBScript with the following: Set oCn = CreateObject("ADODB.Connection") oCn.Open "Data Source=strdb; UID=user; PWD=password; DBA=W;" sSQL = "update CUSTFILES set CMEMO='ABC' where CLIC='107647'" oCn.Execute...

MS SQL Server 2012 Standard Edition 64 bit I have a simple trigger on one table that sets the value of one field based on the values in another field int the same table. The trigger works perfectly - then it just disappears from the table. Things are fine again after the trigger is recreated...

I have to verify customer's address and ZIP codes on a database of about 10,000 records. Some customers have invalid or blank ZIP codes and others have incorrect street address details. We're hoping to resolve most of the ZIP code errors and then deal with the incorrect street addresses...

I have to extract OE sales history from macola and I was given a dump of the oelinhst_sql table without any field explanations. Where can I find a list of field definitions?

From the Sage Accpac 5.6A Readme.htm file: Using Non-Datapiped Versions of the Item Valuation Report To use non-datapiped versions of the Item Valuation report, you must replace sections ICVAL01 to ICVAL13 in the ICRPT.INI file. See Knowledgebase article KB27876 for instructions and the...

I have to convert Navision data to Accpac, specifically GL, AP & AR. I don't know Navision at all and have no version information and the client is clueless, so sorry for the dumb question. So can the data be export to Excel, and if so then how?

When I add an MSFlexGrid to a VBA form I get an error message: The subject is not trusted for the specified action. This has worked perfectly before and now a lot of customers are reporting the same error, so I suspect a Microsoft updated has something to do with it.

Our company has an Exchange 2003 server running in city A, I'm in city B 400 miles away. I can use OWA to get my mail from http://mail.domainname.com:8888/exchange. I would like to use MS Outlook 2007 to sync my calender and contacts with the server, but cannot get this going. What needs to be...

I need to convert Peachtree data to another accounting program and the user does not know how to export data from Peachtree. How would you export the following data to Excel or CSV? GL chart of accounts GL transactions AP vendors AP open invoices AR customers AR open invoices Thanks

Win2K Server SP4, 4GB RAM and 150GB drive with 100GB free. There is only one drive C: with one partition of 150GB, 100GB free. Users periodically get an error message that the disk is full when they try to save files. No errors reported in the server event viewer and no error reported on the...

I am using the following code to open an Excel spreadsheet using DAO and reading records and posting transactions into an accounting application. The spreadsheet layout is simple: Vendor Invoice Date Amount ABC100 IN100 04/01/2008 100.00 DEF100 IN101 04/01/2008 200.00 Dim...

I have an ATT 8525 with WM6 and Exchange server 2003 SP2. I am told that direct push should work, but so far no joy. I cannot figure out what the problem is, and the documentation is rather thin on setting this lot up, any help would be appreciated.

I have a dilemma. Back in 1998 I worked for a software company and wrote an application for a client. The software company has gone out of business and the source code cannot be located by the client. Actually all the source code was purchased by another software company, but they cannot find my...

I have a project that I did way back in 1998 in VB3 that a client has been running ever since. The client contacted me today and needs the program updated to work with a newer database, no changes to the actual logic are required. I'm not really in the mood to rewrite this app in VB6 and go...

I am trying to setup my Outlook 2002 to synch with a remote Exchange 2003. I have OWA access to the Exchange server and can see all folders, the calendar and so on. What is required to get my local calendar to synch with the calendar on the server?

I'm running FTP on a Win2000 SP4 server, I need the ftp server for clients to access and upload/download files. My problem is that there are endless attempts to login to the ftp server from various IP addresses, reverse lookup places these addresses either in the Far East (most China) or South...

I use CDO to send shipment notification emails to customers for orders that have shipped, the typical email you would receive if you order anything online. There is no problem with sending emails. The issue I have is that sometimes the email addresses are wrong or invalid, and CDO does not...

Please forgive me if this has been asked, the search function is currently under maintenance. Here is what I want to do: copy new records inserted in table A to table B. This is what I have tried: CREATE TRIGGER [Append Sales] ON dbo.A FOR INSERT AS INSERT INTO dbo.B ( CUSTOMER, ITEM, YR...