How do I update invoiced items in inventory control?

[Guest]

How do I set up invoices that will interface with an inventory control
database?
Is Excel a better choice to solve this problem?
I am using office 2003.

 

[Arvin Meyer [MVP]]

There are several ways, but I personally prefer 2 tables. One for purchases,
and 1 for sales. Sales subtracted from Purchases with allowances for
spoilage always yields current inventory.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[UpRider]

Your inquiry is probably too general to get much response here. What do you
specifically mean by "interface"? What program is generating the invoices
now? Can that program export data files? Do you need a real-time system or
will batch updates once or a few times a day suffice?

Personally, I would either add the invoicing functionality to the Inventory
control database, or add the inventory control functionality to the
invoicing database, given that either or both are currently in Access.
Another possibility is linking tables from one application to the other, and
adding code as appropriate.

UpRider