Project: Updating current general ledger process
I am in the process of updating the current ledger process for a database. Currently when a user submits a transaction the process captures the current balance and then updates the new balance on the new form. It actually captures the current balance when the user composes the transaction form. The first issue is that if you have 2 people composing a form at the same time, the current balance is the same on both. I’m going to remove this and calculate the new ending balance when the transaction is submitted. I worry about a situation where multiple users submit a transaction at the same time.
Is it best to have it calculate the new ending balance when the transaction is submitted ?
Should the balance be calculated via a server agent calculating it ?
If this was in SQL I could create a query that calculated this ending balance.