Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inventory Movement/Transfer
Message
De
31/03/2008 14:35:24
 
 
À
24/03/2008 15:25:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01305074
Message ID:
01307086
Vues:
9
Fred

You can use the SDK from Quickbooks, but I have found that QOCBC ODBC drive (a commercial product) is very easy to setup and use. It is great for getting and sending data to Quickbooks. You can google OODBC for the company that sells the driver.

I assume you are moving the data out of inventory based on some field reports indicating the number of bulbs planted. Then based on either a lifo,fifo or average cost basis move the inventory costs to the next Work in Process stage. The QODBC drive would be very good at downloading the inventory cost data from QB and then manipulating it and sending a Journal Entry back up to QB to move the costs out of Inventory to the next stage.

As I understand it the QODBC driver is a wrapper around the QB SDK that makes it quite easy to use.


Gaylen



>I am just starting to design a simple inventory database for a small nursery "no bar codes all user input" I need a simple way to move the inventory from Bulbs to veg growth to flowering and finally to floor and or sales etc..... in other words minus out of 1 database and add to another.............
>
>I have done other stuff like this but mostly at the form level and for single user databases.
>
>Any ideas would be helpful.
>
>Still learning Fox
>
>
>
>
>Thanks,
>
>Fred
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform