inventory and orders

  • Thread starter Thread starter programming
  • Start date Start date
P

programming

I am in a shipping department that labels product and then
sends out completed packages. I want to control
inventory, how many products recieved, how many labeled,
packaged and then when an order is placed, the number of
items sent in the order is subtracted from the inventory.
There are 2 templates for order and invintory for new
access databases, but the orders do not automatically
subtract from the inventory. I know how to set up tables
and make relations, but subtracting orders from inventory
is beyond my present programming abilities. Should I just
use an accounting program? if so, would peachtree or
Quikbooks work and which would be better? I am not an
accountant, so setting up an entire company for just the
inventory is hard for me. Anyone have a program that
subtracts orders from inventory?
 
Record receipts as +, orders sent as - (minus) qtys then do a Sum() by
product # to obtain the current balance remaining in inventory.
 
Thanks, this is just what I was looking for. I know it
seems easy, but can I get a little more detail? are
receipts and orders on the same table, and would they be
products? Can I do this in one of the databases I set up
from the templates?
 
You need a table that contains items received and shipped with these
quantities. This table is separate from Products, Orders, Customers,
Vendors, etc. It may use ID numbers from the other tables as foreign keys.
Any initial balances or adjustments to inventory physical counts go into
this table.

I don't use template DB so I dunno.
 
Back
Top