The Daily Pulse
technology trends /

What are the uses of posting transactions of accounts?

Definition: Posting is the act of moving debit and credit account balances from individual journals to their corresponding ledgers. These ledgers are later used to create a trial balance used to generate the income statement, balance sheet, and other financial statements.

What is the posting process?

Posting refers to the process of transferring entries in the journal into the accounts in the ledger. Posting to the ledger is the classifying phase of accounting.

What are special transactions?

Special Transaction means any Transaction on preferential terms for a Promotional Period that we may make available from time to time.

When is an appropriate time to use a transaction?

Currently none of my SPs use a transaction, but there are numerous Try-Catch blocks throughout. The reason is because every time I tried to wrap them in a transaction the SP would cease to function and I would end up with missing data and worse off than had I used Trans. So again… When is an appropriate time to use a Transaction?

When do you use transactions in a database?

You use transactions when the set of database operations you are making needs to be atomic. That is – they all need to succeed or fail. Nothing in between. Transactions are to be used to ensure that the database is always in a consistent state.

Is it possible to run a program with no transactions?

If it is not, you must change it (with or without transactions). If it has no transactions, it must be possible to run it safely n consecutive times and each run must continue the work of the previous one or do nothing if job is done.

How are try / catch blocks related to transactions?

Try/Catch blocks have nothing to do with transactions – they are used for exception handling. The two concepts are not related and are not replacements for each other. The common answer is that transactions allow database operations to be atomic. The confusion is in what this means.