![]()
In WangTool.com, we learn and share on how to improve our personal finance management skill.
| ||
Type R TransactionsTable Of ContentRecon type (type 'R') of transaction is a special type of transaction that different from normal transaction (type 'N') where user enter the balance of the account, instead of the amount of transaction. The amount of transaction will be determined by the system from the previous balance where system always ensured the balance of account will be equals to balance the user entered. ExampleLet say we have transactions like following: Date TxnTyp UserAmt TxnAmt(Effective) Balance 1Jan N 10.00 10.00 10.00 5Jan N 20.00 20.00 30.00 8Jan N 30.00 30.00 60.00 Then let us create a Txn on 7Jan, type='R', with amount=45. Date TxnTyp UserAmt TxnAmt(Effective) Balance 1Jan N 10.00 10.00 10.00 5Jan N 20.00 20.00 30.00 7Jan R 45.00 15.00 45.00 <-- user add this 8Jan N 30.00 30.00 75.00 <-- new calculated balance The system will calculate the amount of that txn, should be 15.00, so that the balance=45 (as entered by user). And also see that the new balance of Txn on 8Jan. Let's said now, we have another txn that we forget to enter, on 6Jan, type='N', with amount=8 Date TxnTyp UserAmt TxnAmt(Effective) Balance 1Jan N 10.00 10.00 10.00 5Jan N 20.00 20.00 30.00 6Jan N 8.00 8.00 38.00 <-- user add this txn 7Jan R 45.00 7.00 45.00 <-- TxnAmt adjusted (15->7) 8Jan N 30.00 30.00 75.00 You will see that the 'R' type transaction's amount will be changed automatically, where system always ensured that the balance of the 'R' type transaction always equals to the amount that user entered (45.00 in this case). Why Type R? |
Sponsor Ads/LinksTiongHua.Info 中华资讯,经典书塾,一起看古典文学、小说,一窥五千年中华文化。 NegaraKita.com One stop reading of all bloggers view about Malaysia Politics. | |