Home Page link  

QuickBooks List as Read-Only

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
QuickBooks List as Read-Only Alex 04-09-2007
Posted by Alex on April 9, 2007, 2:03 pm
Please log in for more thread options
I currently am using MS Access to maintain an item list and have a
method of synchronizing the data with QuickBooks Enterprise 3.0 (mult-
user mode). How can I prevent users in QuickBooks from adding or
changing items since the Access database will be used to manage the
list of items?


Posted by Allan Martin on April 9, 2007, 2:10 pm
Please log in for more thread options

>I currently am using MS Access to maintain an item list and have a
> method of synchronizing the data with QuickBooks Enterprise 3.0 (mult-
> user mode). How can I prevent users in QuickBooks from adding or
> changing items since the Access database will be used to manage the
> list of items?


Tell them if they change it they are history.





Posted by Alex on April 10, 2007, 9:52 am
Please log in for more thread options
>
>
> >I currently am using MS Access to maintain an item list and have a
> > method of synchronizing the data withQuickBooksEnterprise 3.0 (mult-
> > user mode). How can I prevent users inQuickBooksfrom adding or
> > changing items since the Access database will be used to manage the
> > list of items?
>
> Tell them if they change it they are history.

Thanks for the advise, but that is not in my job description.


Posted by L on April 10, 2007, 11:53 am
Please log in for more thread options
>I currently am using MS Access to maintain an item list and have a
> method of synchronizing the data with QuickBooks Enterprise 3.0 (mult-
> user mode). How can I prevent users in QuickBooks from adding or
> changing items since the Access database will be used to manage the
> list of items?
>
You can't.

Well, at least not and let them still work in the file.

QB permissions system is not all that flexible. User's have access to
different 'areas' of the program. Giving a specific user access to the
inventory area, for example,


"gives a user the ability to:

§ Write purchase orders. Receive against purchase orders.

§ Make adjustments to inventory.

§ Maintain your list of inventory items.

§ Enter bills.

§ Edit an item's history.

§ Print purchase orders. To allow printing, you must select either
Full Access or "Create and print transactions" under Selective Access.

§ Create inventory, purchase, and vendor reports. To allow access
to these reports, you must select either Full Access or "Create transactions
and Create Reports" under Selective Access."




So, if you don't want folks to have access to the list of inventory items,
the administrator can deny them access to inventory. Of course, then they
can't do ANY of the other functions listed above.




Posted by TonyK on April 11, 2007, 8:42 pm
Please log in for more thread options
>
using MS Access to maintain an item list and have a
> > method of synchronizing the data with QuickBooks Enterprise 3.0 (mult-
> > user mode). How can I prevent users in QuickBooks from adding or
> > changing items since the Access database will be used to manage the
> > list of items?
>
> You can't.
>
> Well, at least not and let them still work in the file.
>
> QB permissions system is not all that flexible. User's have access to
> different 'areas' of the program. Giving a specific user access to the
> inventory area, for example,
<SNIP>

Realistically, you have a personnel problem, not a software problem. I
would turn on the dreaded "Audit Tracking" feature, so that you can
confirm which username is misbehaving, and can then be disciplined
appropriately.

If they are making unauthorized/incorrect changes to the database,
this will at least CYA & explain to your boss(es) why you are wasting
so much time fixing things.

Perhaps then, a training class will take place to alleviate your
issues.

Otherwise, as above, you don't have much help for the system.

Good luck,

Tony


Similar ThreadsPosted
Re: Import vendor list from Co. 1 to customer list in Co. 2??? January 7, 2007, 10:22 am
Import vendor list from Co. 1 to customer list in Co. 2??? January 3, 2007, 2:59 pm
How to start QuickBooks from a list of companies August 25, 2006, 4:54 pm
List/Print Invoices November 7, 2006, 9:00 am
Simplify Item List March 24, 2007, 3:33 pm
Copying Shortcut list from on pc to another March 28, 2007, 11:32 am
Customer list problems November 30, 2007, 11:03 am
Help! How to delete the WHOLE item list? January 2, 2008, 11:43 pm
Customer Phone List April 22, 2008, 2:36 pm
Vendor list by "account" May 27, 2008, 3:33 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap