Investment Database

  • Thread starter Jarem Financials
  • Start date
J

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.
 
S

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
 
J

Jarem Financials

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...
 
Top