P
pietlinden
this is more an exploratory question than anything else...
I have a client that wants a solution very similar to what QuickBooks
Pro Accounting/Manufacturing does. He's a manufacturer's rep, so he
currently has a somewhat spreadsheet that calculates the price of an
item based on several factors, including:
* Purchase Price
* Shipping Costs
* Packaging Costs
* Merchandising Costs
*Discounts
* Commission Costs (Sale Price * Comm Rate (which is variable))
Since QuickBooks Enterprise will do the vast majority of what he
wants, I was considering building the weird pricing part in Access and
then exporting the data to QuickBooks and just using their accounting
"solution". Has anybody done anything like this before in Access? I
know there are developers that do this kind of thing with Quickbooks
SDK or something like that (I talked to Intuit today for about a half
hour...)
Since I'm trying to get the most bang for my buck, I was thinking of
getting QBPro to do the accounting part and just build the part it
won't do myself... Has anybody done this kind of thing before, using
something like QODBC?
I think that reinventing the Quickbooks wheel is a waste of time...
sorry if this is more a Quickbooks question, but I didn't find a whole
lot of joy in their NG either...
Thanks for any input!
Pieter
I have a client that wants a solution very similar to what QuickBooks
Pro Accounting/Manufacturing does. He's a manufacturer's rep, so he
currently has a somewhat spreadsheet that calculates the price of an
item based on several factors, including:
* Purchase Price
* Shipping Costs
* Packaging Costs
* Merchandising Costs
*Discounts
* Commission Costs (Sale Price * Comm Rate (which is variable))
Since QuickBooks Enterprise will do the vast majority of what he
wants, I was considering building the weird pricing part in Access and
then exporting the data to QuickBooks and just using their accounting
"solution". Has anybody done anything like this before in Access? I
know there are developers that do this kind of thing with Quickbooks
SDK or something like that (I talked to Intuit today for about a half
hour...)
Since I'm trying to get the most bang for my buck, I was thinking of
getting QBPro to do the accounting part and just build the part it
won't do myself... Has anybody done this kind of thing before, using
something like QODBC?
I think that reinventing the Quickbooks wheel is a waste of time...
sorry if this is more a Quickbooks question, but I didn't find a whole
lot of joy in their NG either...
Thanks for any input!
Pieter