Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Ensure Open/Save Company in QuickBooks

Posted on 2015-01-07
7
Medium Priority
?
116 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 98

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 98

Accepted Solution

by:
John Hurst earned 2000 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 98

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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

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…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

604 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