Update Current Tax Lot Balance Records Process

At the end of each batch processing sequence and in preparation for the next day’s business, this process instructs the system to compile information in the Holding Tax Lot table along with calculations of market value and estimated income into a new table called Current Tax Lot Balances. Data is this table is used for balance inquiries and is used as the source of data—including estimated income—for Holding Archive records.

The process is run daily. It must be run only after all transactions are generated and/or posted (manually and via other batch processes), and after market (unit) values are updated if these updates come from an outside source.

More:

Market Value Calculations

Next Twelve Months Estimated Calculations

Remainder of Fiscal Year Estimated Calculations

Next Fiscal Year Estimated Calculations