Investment Database

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

Guest

Hi,
I am trying to build a database that will serve as an inventory dbase for
Investments. The main events taking place will be buys and sells of the
securities. The part i am having trouble with are the Tax Lots. Since the
FIFO (first in First out) Method of inventory will be used, how would I link
the buys to add a new Tax lot, and for the sales to pull from the first
available Lot and then proceed to the next?

Thanks in advance for your help.
 
You might consider storing the Tax Lot as a field of the new inventory and
store a date the product was entered into the inventory. Your process will
then look at the product selected and choose the oldest available date first
until the quantity is exhausted.

Just a thought - an excellent book which thoroughly discusses your issue is
Building Microsoft Access Applications by John Viescas by Microsoft Press.

Seth Schwarm
 
THanks.

Seth Schwarm said:
You might consider storing the Tax Lot as a field of the new inventory and
store a date the product was entered into the inventory. Your process will
then look at the product selected and choose the oldest available date first
until the quantity is exhausted.

Just a thought - an excellent book which thoroughly discusses your issue is
Building Microsoft Access Applications by John Viescas by Microsoft Press.

Seth Schwarm
Click to expand...
 
Back
Top