Investment Database

[Jarem Financials]

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.

 

[Seth Schwarm]

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

 

[Jarem Financials]

THanks.

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