Solved

Ensure Open/Save Company in QuickBooks

Posted on 2015-01-07
7
91 Views
Last Modified: 2015-01-28
Our client is using Windows 7 Professional and QuickBooks 2013.  They have company files stored on their servers "D" drive commonly used for data containers.  On their computers this drive is mapped as their "F" drive.  

 Given this is an accounting office, there are hundreds of company files on the "F" drive, and this list is always changing.  When they go to open a company file, the company they want is NOT in the "previously opened" companies.  Further, we don't want it to be as their too many companies. In all cases the accountants click on "open or restore an existing company".  This is where the problem arises.

 Sometimes the open company no longer points to the QuickBooks directory on the "F" drive. Also, when a new company is created and they want to save it, sometimes directory is NOT the QuickBooks company files folder on the "F: drive.  

 Question : how do I ensure that when they OPEN an existing company OR SAVE a new company that they directory is ALWAYS points to "F:\QuickBooks Company Files"?

 Requirement:  that they start with QuickBooks whereas clicking on file in a folder is not an acceptable option.
0
Comment
Question by:Roy Kaplan
  • 3
  • 2
7 Comments
 
LVL 92

Expert Comment

by:John Hurst
ID: 40537793
There is not a lot you can do.  QuickBooks will keep a list of recently opened files.

You can do two things:

1. In the QuickBooks Recent File list, under OPEN, there is an edit list link. Edit the list and remove entries you do not need currently. I do this but I do not have as many companies.

2. Instead of Recent, get into the habit of using Open or Restore and navigate to the ledger you need.

There is NO pin function like Office 2013 backstage.
0
 

Author Comment

by:Roy Kaplan
ID: 40537895
John,

Thank you for your valued input.  Given more then 500 company's, each having many years of data, the RECENT company list will not do the trick.  Also, it does not allow sorting the list by last modified date nor a search functionality.

I am looking for a vbscript, bat file, or .net code that will be executed upon the open of QuickBooks, that will insure the open/save function is pointing to the proper directory of the server.
0
 
LVL 92

Accepted Solution

by:
John Hurst earned 500 total points
ID: 40537913
You cannot change the behaviour of QuickBooks with VB or a batch file.

What you can do is open a file via command line.

path\qbw32.exe foldershare\company.qbw

So then you need to build the program and structure outside of QuickBooks to open the correct file. QB cannot do this or be modified to do this.
0
 

Author Comment

by:Roy Kaplan
ID: 40555030
I've requested that this question be deleted for the following reason:

just delete the question
0
 
LVL 92

Expert Comment

by:John Hurst
ID: 40549606
The correct answer is:  You cannot do what you are trying to do in QuickBooks.

Deleting the question is bad behaviour on your part.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now