Im building database with an finance part.
it will include accounting income and outcome, as well as expense planing (expected income
and expected expenditure)
It is also needed to correlate planing transaction with the real one. Im suspecting situation,
when expected income will be splited into several payments.
System should help my customer to shift expected outcomes to keep shaky finance balance.
I hope, that some of you had faced similar questions .
Im realizing that my questions is quite global, but any thoughts and advices are wellcome!
My questions is:
- should I use one table to expected and real transactions and just use flag of it adoption, or better to separate planing payments with real ones ?
- how to correlate one expected income with several payments ?
- I heard about good practice to duplicate records (for example all records in one table and separate table for debit and credit for double audit) What is your thoughts ?
- may be you have good links to web sites or forum or may be books, that describes possible architecture solutions, based on FileMaker similar to my needs ?
(plz excuse for my English)