We help IT Professionals succeed at work.

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.

We have 55,000 vendors and 46,500 of these have never had any activity. These vendors are not in a certain range so I would probably need to delete them in SQL.  Is there more than one table involved.
We are trying to print checks for the auditors from the Payables TRX Inquiry screen. Some of the checks are not appearing. It's only 2 checks but these are the checks the auditors want a copy of.  What would be a reason that the check doesn't appear when I highlight the transaction and click on the Voucher/Payment option.. Thanks..
Are payment terms tied to the vendor card for just that vendor or do all payment terms show up for each vendor. Do "classes" play a role in setting up the payments terms.. Thanks!
I am looking for financial businesses (in particular tax, litigation, audit, accounting services and estate and trust) that have moved (or even partially moved) services/data to the cloud.

I would like to ask some specific questions, including security, about how you moved to the cloud. We are getting some push from management to explore the cloud more but currently we have several TB of data and many servers. Most are already in our VM environment.

We use the regular tax software like CCH, Caseware, quickbooks, time matters, casemap and others.

Are you using AWS EC2, Azure or something else?
How is everything separated in terms of access and file shares?
What happens when the internet goes down?

I will have more questions im sure but lets start with those.

Thank you.
A user posted an invoice with the wrong Distribution Reference description on the Payables Distribution Zoom screen. What is the best way to correct this?  Void the transaction and re-do?  The description is in the GL20000 table and I know how to change it but not sure if that would affect other tables.  Thanks!
I have loaded a lot of transactions into a batch and realized I was using the wrong vendor.  What is the correct way to handle this?  Go ahead and post the batch and the void or change the vendor in the open transactions table using SQL?  I do not want to re-enter all of these transactions if at all possible.  Thanks!
Our AP staff would like for the "Distributions" window to open in "expanded mode."  Right now, they are manually expanding the screen. There is VBA code out there somewhere for this.  I have attached what the screen looks like in "expanded mode."

I have a client that uses Sage Manufacturing, Line 50 Accounts and Payroll.

Several users access SMan and L50 from data shared on the Windows 2008 Server. Payroll is accessed by one user, data also on server in pretty much the same location.

SMan and L50 work fine for all users but Payroll is so slow it's almost unuseable.

We recently introduced a Meraki managed switch to increase security but can't see how this would affect just Payroll.

So far we've tried:
1/ Running Payroll on server - data local - result some improvement but not great
2/ Moving data from server to local on slow client no improvement
3/ Installing Payroll on another client and accessing data on server just as slow
4/ Repairing payroll data using Sage utilities - no change

I'm in the process of installing Payroll on a device outside of the business environment (i.e. my own laptop) and will test there.

Any suggestions welcome please.

We have an unposted transaction that GL would like to have deleted. The user entered the transaction and the system got hung up and they re-entered the transaction and posted that one.  Can I delete the unposted transaction from the GL10000 and GL100001 or are there other tables that are affected?  Thanks!
The summary inquiry as well as the detail inquiry in the financial module are not matching what is showing in SmartList. We narrowed it down to the month of December of 2014.  SmartList (Account Transactions) has 48K more in Credits than the summary and detail inquiry.  There are two 48K entries in SmartList (one of the entries was not posted) but only one 48K entry in the GL inquiries.  Why would the smartlist be different from the GL detail and summary inquiry?

I am currently trying to import an IIF file into Reckon(Quickbooks), specifically an Invoice Transaction.

I am having a problem finding a way to import the "Customer Tax Code".

I have worked out how to set the Tax code for each item in the invoice but i also need to be able to apply the tax code to the Transaction as well. I have attached a screen shot of the field i'm trying to fill.

I need to apply the Australian Tax "GST"

Thanks in advance for any help.
I am trying to pull a list of all the "Bank Country/Regions" on the Vendor EFT Mainteance Screen.  I cannot find the GP table that has this field. I have checked Smartlist but I don't think it's an out of the box smartlist report.

Bank Country/Region
I have removed all of the default accounts at the vendor level for "discounts available"  The default is set at the system level and the changes were rolled down. I have 5 vendors out of 1000 that is not pulling the default account information from the system level. It should be pulling '0000-2099' and it is pulling '0000-9010' when AP is inputting an invoice for one of the vendors. Where is GP pulling this account from.  '0000-9010' does exist but is not set as the default for the vendor class in Setup!
We have recurring problems with our Sage 50 2015 data.  We suffered some corruption recently and it had to go to sage for repair.  The data came back 3 weeks ago and since then we have had corruption a further 2 times which resulted in having to restore a good backup and re-entry of missing transactions.

Our network setup is as follows
HP DL380 g8 6 Core Xeon, 32GB RAM, 4x 600GB 10K SAS drives in RAID 6, VMWare 5.5 Essentials.

Virtual Server 1
Windows server 2012 R2 - DC - Fileshares -Widows 2012,  4 vCPU, 120GB Drive C, 300GB Drive D, 8GB RAM

Virtual server 2
Windows server 2012 R2 - Remote desktop server -  8vCPU, 120GB Drive C, 300GB Drive D, 8GB RAM

Data and sage data service sits on server 1,  Using sage on this machine gives excellent performance as expected.  Using Sage on the RDS is fine except when posting invoices and doing bank rec's.  Today it took more than 15 minutes to update 20 invoices (approx 20 items per invoice) and while the ledgers were updating, all other users were locked out saying, "waiting to lock file".  It now turns out that we have corruption again and will have to restore and re-enter.

I have checked AV exclusions, and performed network testing and I'm confident that it is not infrastructure causing the problem but I cannot seem to get this issue resolved.  My data is fairly huge with approx 56000 invoices and 373000 transactions. We will archive and reduce these in an effort to ease the situation.

Is anyone aware of any…
I have set the discounts default account at the system level but the default accounts set on the vendor card overrides the system defaults. What is the name of the GP table in SQL so that I can remove the defaults from the vendor card (Vendor Account Maintenance?
I use SageOne.com as my Accounting package. Works for us. Has done since 2012.

I'm just catching up on some expenses and there is a CSV upload feature. So I downloaded the CSV template, added 31 lines (copying the lines down.

The resulting CSV ends up being 14MB:
If I save the same file as XLSX it goes to 11KB:
Save it back to CSV and its now 15MB!!!:
CSV File: Trainline.csv
XLSX File: Trainline2.xlsx

When I try to upload the CSV to Sage One it complains because the max file size is 0.5MB.

Any ideas folks?
I am using QuickBooks Online and doing the sync with my AMEX importing the charges.  So far I have had no problem entering the charge category and the vendor.
The problem is I don't know what to enter in category and vendor in the AMEX payments I have made to the card, which is the other way around, this is important so that I can keep the real balance on the card. What should I enter in both boxes ?

In the category drop down it only displays: Accounts under Expenses, Equity, Assets, Revenue.  none make sense for a payment made to the card.
We have moved our accounting software to a new VM.

Physical  Server - Dell R730, dual proc, 128Gb Ram - Windows Server 2012 Datacentre
Virtual Server - 4 vProc, 8GB RAM - Windows Server 2012 Standard

The Sage application uses Pervasive Database 10.

When opening companies, it can take 5 minutes before the user can do anything. It takes 2 minutes to commit a transaction.

We have reinstalled Pervasive. Disabled IPv6. Added a host entry to resolve and potential DNS/NETBIOS issues.

When running the application locally via Terminal Services, It is very quick. And both the physical and virtual are idling. This points to a networking issue. Or possibly an ODBC/driver issue.

I don't believe its network related as the network is configured on Stacked Dell 5548 switches with 10 Gig uplinks. I also ran Process Explorer from SysInternals. The process only transfers 250KB of data while opening a company.

Any ideas on how I troublshoot this?
We have Windows Vista and trying to print preview a Turbo Tax form. The attempted viewing tries to open in Microsoft Picture Manager and won't open. How do we change the default program from MPM to what we think needs to be Adobe Acrobat since there is an option to save the form as a PDF.

I am trying to set up an ODBC connection between Excel and SAGE Line 50. SAGE is stored on the network. However just confused as to what information is required in stage 2 of the pop up below (User Name and Password). Can anybody help ? Thanks

Kind Regards

Hi Experts,

I need to make my .net/sql CRM/CPQ software development work in the USA, I know the way axes are done in the US are different from the UK, is there an easy way to handle this please?
hi there,

A little puzzle here, looking for suggestions or at least something that will jog my brain towards further solutions.

I share a property 50:50 with a family member. In double entry accounting this could be:

Debit: Property asset account 100,000
Credit: Equity shareholders 50,000 + 50,000

Suppose we agree to pay a nominal rate to use the property privately. An alternative to actually transferring money could be to agree to let the equity split vary according to our respective use of the property, for example:

Private use of property for nominal rent of 2,000
Debit: equity shareholder account (the tenant) 2,000
Credit: retained earnings 2,000

Re-distribute earnings:
Debit: retained earnings 2,000
Credit: equity shareholder accounts 1,000 each

Balance on equity shareholder accounts is then 51,000 and 49,000 respectively.

Two questions:
1. is the working on the above example correct?
2. are there alternative ways to account for this? without any actual money transferring hands.  Apart from a private loan agreement.

Many thanks!

For my info: related question: http://www.experts-exchange.com/Other/Consulting/Q_28600158.html
2 charges hit one vendor and it was the wrong vendor.  I need to move those charges to 2 different vendors. How can I do this.

For example:  V12345 was hit with $100,000. $35000 and $65000 make up the $100,000. These two amounts need to be transferred to V000001 and V000002.
How do I make customer payment terms correctly show in a statement using QuickBooks Premier 2014. Here are the steps I took:

In Customer Center  --  double click customer name -- click payment settings -- click the down arrow on "payment terms".  -- click the preferred term from the list (2 weeks) --  click OK and dismiss the "Customer Center". Go to Statements. I leave the default date as todays date and select one customer (The same customer with the 2 weeks term.) Click preview.

It shows current $113.00 with a statement date of 3/17/2015;  but there is among the invoices one invoice for example dated 3/13/2015 for $560.75.  There are no current invoices less than $45.50. Thank you for any help.  --  Joe
Hi guys,

I would like to get financial data yahoo finance and bring them in C ++

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.