Hi I have been a SQL developer for many years but have somehow managed to avoid doing any finance related applications. However my current project is a custom lease management system. I boned up on modeling double entry accounting and I feel pretty good about that.
But I am not sure the best way to handle 10 years of fixed and scheduled lease payments. Should I keep a separate table to record all future payments and run a daily job to post due payments to the posting table? or should I just making posting entries that are future dated?
Or something else? Any ideas or links to related material appreciated
Dave
Trainmark.com IT Training B2B Marketplace
(Jobs for IT Instructors)