MK13/financer
1
0
Fork 0
Code Issues 10 Actions Activity

Add transaction types #20

New Issue
Closed
opened 2021-07-03 19:04:49 +02:00 by MK13 · 3 comments
MK13 commented 2021-07-03 19:04:49 +02:00 (Migrated from 77zzcx7.de)
Copy Link

Asset swap:
CASH or BANK -> BANK or CASH

Expense:
CASH or BANK or LIABILITY -> EXPENSE

Liability:
CASH or BANK -> LIABILITY

Income:
START or INCOME or LIABILITY -> CASH or BANK

Add to FQL:
transactionType = '...'

Maybe add as column in transaction table?
'+ easily queriable in SQL
'+ Simplifies some SQLs
'- Can be calculated on the fly

Maybe add in transaction view tables in web-client?

**Asset swap:** CASH or BANK -> BANK or CASH **Expense:** CASH or BANK or LIABILITY -> EXPENSE **Liability:** CASH or BANK -> LIABILITY **Income:** START or INCOME or LIABILITY -> CASH or BANK ----- Add to FQL: transactionType = '...' Maybe add as column in transaction table? '+ easily queriable in SQL '+ Simplifies some SQLs '- Can be calculated on the fly Maybe add in transaction view tables in web-client?
MK13 commented 2021-08-08 00:00:05 +02:00 (Migrated from 77zzcx7.de)
Copy Link

'+ Migration script for existing transactions

'+ Migration script for existing transactions
MK13 commented 2021-08-08 00:53:08 +02:00 (Migrated from 77zzcx7.de)
Copy Link

FQL there, still missing description

FQL there, still missing description
MK13 commented 2021-08-08 23:33:31 +02:00 (Migrated from 77zzcx7.de)
Copy Link

Implemented. One thing that is not clear however, is, that some expenses might be counted twice:

  1. Liability account -> Expense account | buying something with credit card
  2. Asset type account -> Liability account | paying back the credit card

Both get counted as expense, e.g. by de.financer.dba.TransactionRepository#getExpensesForAllPeriods

Mind that both might happen in different periods.

Implemented. One thing that is not clear however, is, that some expenses might be counted twice: 1. Liability account -> Expense account | buying something with credit card 2. Asset type account -> Liability account | paying back the credit card Both get counted as expense, e.g. by `de.financer.dba.TransactionRepository#getExpensesForAllPeriods` Mind that both might happen in different periods.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something is not working
enhancement
New feature
No Label
enhancement
Milestone
No items
No Milestone
Assignees
Clear assignees
MK13
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: MK13/financer#20
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?