Tax / Financial Software

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi guys

My program includes a simple query on Sage 50 via ODBC, something I've programmed hundreds of times before. The Sage data tables are on a network drive. On this particular client's PC (Windows 7, 64 bit), the query ran perfectly every time when run manually, but threw the following errors when scheduled:

ERROR [08001] Cannot find all files in data path
ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 23.1
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

I checked all the DSNs, drivers and registry and everything seemed OK. I did a search and the only relevant post was one here by RogerMoquin:

Problem with ODBC connection when run from a scheduled task
      
His solution was to insert a two minute delay, though I think his issue was with login.  In my case the program runs long after login. Using his idea, however, I found one solution was to set the program to try to connect, then each time an error exception is raised, it waits two minutes. After 3 tries it consistently connects. (Please note that I changed to a DSN-less connection string, but it still uses the 3 tries).

' Original 
'Dim 

Open in new window

0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Submit all the tax forms that affect your small business.
0
Know a carpenter and need an Ap or can I email him an excel he can save and edit on his phone ?

Thanks
0
Hello EE,

I am reviewing my first SOW with a vendor who is looking to help integrate their application with a new system we are putting in.
It seems like a lot of generalizations:
1. "organize workshop"
2. "define strategy"
and a lot more, but I am curious for those experienced in these, what must you have in it?
0
Recently when I tried to reconcile, I get the message that there are no transactions to reconcile but there are many that are marked with a c which indicates that they have not been reconciled. I crossed a month boundary so there wouldn't seem to be a statement date issue. How can this be corrected?
0
I have Peachtree 2012 and need help. I am looking for either answers or a link that will show me how to do the following:

Why some of my files will not let me enter invoices for them?

Thanks for any help!
0
I have Peachtree 2012 and need help. I am looking for either an answers or a link that will show me answers on the following:

How to keep inserted text boxes on forms from moving when I want to print them?

Thanks for any help.
0
I have Peachtree 2012 and need help. I am looking for either an answers or a link that will show me how to set up forms.

Thanks for any help!
0
I am running Sage 50 v.21 on windows 10. Every time I print an invoice the application stops and closes with the message "sbd desktop has stopped working". Any help in resolving this would be welcome.
0
We are running an old version of MAS200, just added a new user to system, when going into ANY MENU, get a dialog box saying "You are not authorized for this menu option"
0
Enroll in August's Course of the Month
LVL 9
Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

I am unable to make corrections in Sage Instant v.15 via File/Maintenance/Corrections.

The list of transactions are shown and I can search a trans number via the Find key but then the software freezes and I have to either Control Alt Delete or Esc to exit the screen.

There seems to be no data corruption and everything else is running fine.  When the software is loaded onto my desktop the correction wizard works.  

Your help would be appreciated.
0
I wish to delete the entries under "Sage" from the C:windows\assembly but keep getting the "access denied" message.

How do I get round it?
0
Hello,

I am using Sage Line 50 on a 64 bit machine runnings Winfows 7. I want to export data from SAGE to Excel. I need data from what I be three reports / tables in SAGE:-

1) A list of all sales items by product - showing:-
                          i) the date of the sale
                          2) the items sold
                          3) the number sold
                          4) the price of the items
                          5) the total revenue

2) A list of all the operational costs by date

3) the trial balance

I have already set up the ODBC connection between SAGE and Excel. However I can't seem to create the data extract within excel. At this point, I only need to use the practice data in SAGE but will later on need to switch to the true data.

Also I would like to implement a button as a Macro to pull in all the data. Thanks

Regards
Kaps
0
I am involved in writing a point of sales system in C# .Net 4.0.  To capture credit card information we are using a VeriFone mx 870.  I am having trouble connecting the device properly.  I can open the device, put a message on the screen, and retrieve card information.  However, it takes a very long time.  Also, on the LineDisplay.ClearText and LineDisplay.DislayText  an exception is thrown that says device off-line.  The text does clear or display.  I am using Microsoft POS for .Net 1.12 and VeriFone's OPOS.
Does anyone know what I am doing wrong. or what I am missing?  I don't think it should take several seconds to open or claim the device.
0

Tax / Financial Software

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.

Top Experts In
Tax / Financial Software
<
Monthly
>