inventory tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First of all I'm a beginner at this... I'm creating a database to track
imports and exports. The exports could be a partial quantity of the import. I
have the imported qty.. How do I get the database to allow me to subtract a
partial off that total
 
You should not subtract from that total but sum your transactions.
Imports are positive transations and exports are negative transactions.
Each transaction should have a date and invouce/voucher/requisition number.

A totals query will sum the transactions to give you the current balance.
 
I can't sum these because each entry is unique because there is a manifest #
tied to it that must be reported at the time of export. I might bring in
let's say 10 pieces all linked to the same manifest. I might import more of
the same product but under a different manifest therefore cannot be added
together, they must be kept as a separate item...

What do you suggest in this case?

Thanks.
 
You total on the product and pluses and minuses omitting the manifest
information to obtain the balance.
Periodically you would reconcile the inventory to the balance by making a
entry record. This is necessary for many reasons - spoilage, breakage,
shelf-life, theif, etc. The record would be dated and indicate Reconcilation.
All balance queries would check for latest reconcilation date and only
include it and any records afterwards.
 
Back
Top