inventory tracking

[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

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

Ok, Thanks, I appreciate your help. Let me try that..