I recently purchased Order Export 3 for my Quick Books 2007 but I'm a little afraid to use it.

We have QB configured with Profit Centers (Classes) for our Clinic sales. For our clinic sales, Product x sales all go into Class x. Product y ... Class y etc.

Quick Books apparently does not support tying products to classes. I cant really put my variable costs in as inventory costs either because the variable costs (ice rental, labor) jump in larger increments based mostly on the number of participants we are going to have. We cannot put a cost on an individual inventory item.

I also don't have any products set up in QB but I think the connector will set them up. I've just been recording the sales by class.

I also have about 3 years of sales sitting in BV5 that have not been flagged by the connector as transfered yet. The first transfer should take care of that.

Questions:
1. If I send my BV5 transactions to a dummy QB company, will they stay flagged as having been moved when I make subsequent new transaction transfers to the real company?
2. If so, will QB reset up the products on the transactions that have not been flagged as transfered to the dummy company when I move to the real company?
3. If I restore QB from backup after transferring transactions from BV5 can I resend them? In other words can I reverse a transfer in BV5.
4. Is there an easy way to set up classes (tied to product) in BV5?
5. Baring that, can I export transactions using the connector from BV5 directly into an Excel spreadsheet where I can use look up to add the class to the transaction, then import that into QB?
6. Anybody got an easier way to do this?

Bob Noble

Thanks Marcus.

I'm planning on using the paid invoice option on our transfers. I'm assuming your connector will pick up any new transactions that have not been marked on the last pass, including addition payments to invoices, returns, discounts posted at a later time, that sort of thing. I know SQL can handle that.

Not that it will be necessary but instead of rerunning the data transfer by all orders afer xxx, can we run as transactions posted to BV5 after dd/mm/yyyy?

I think this is going to save us a lot of time. It's always fun to automate the routine boring tasks.

Bob Noble

Marcus:

I came up with a long and complicated suggestion, but then I decided the best solution was to keep it simple. Any Returns Allowances and Discounts after the order is transfered to QB could be accounted for manually because they probably should be going to different accounts anyway. Creating a total completely integrated accounting system as a new piece of software may be a good idea but making one work with QB may not generate enough revenue to justify the time it would take. Unless you could get a license agreement with QB lol.


Thanks again.

Bob Noble