A while ago when I was assigned to work on such a system, I found this link in the Martin Fowler website: Martin Fowler – Accounting Patterns It contais some patterns for accounting software, such as accounting entries, transactions and adjustments. The architecture he describes is based on events. Never read it entirely, as the … Read more
A. Preliminary Your Approach First and foremost, I must commend your attitude. It is rare to find someone who not only thinks and works from a solid grounding, and who wishes to understand and implement a Double-Entry Accounting system, instead of: either not implementing DEA, thus suffering multiple re-writes, and pain at each increment, each … Read more
Create the following tables account transaction line_item contact (can be a customer a supplier, or an employee). To keep things simple, we will leave out the account_type table, contact_type table, etc. Identify the relationships between the tables and set them up a contact can have many transactions, but each transaction can only have one contact … Read more
Should Float or Decimal data type be used for dollar amounts? The answer is easy. Never floats. NEVER! Floats were according to IEEE 754 always binary, only the new standard IEEE 754R defined decimal formats. Many of the fractional binary parts can never equal the exact decimal representation. Any binary number can be written as … Read more