4 ms·
One question, why separate into different tables for each journal (expense, sales,...) . You could also have one journal table instead ?
by revskill 3y ago
One question, why separate into different tables for each journal (expense, sales,...) . You could also have one journal table instead ?
- ComputerGuru 3y agoIt depends on how they classify them but in many systems sales is separate from the rest because you generate quotes and invoices and mark them as sold but reconcile that against the actual line items in your bank account separately. I.E. sales isn’t ( ecessairly) a subset of all transactions but entirely apart. In addition to sharing few fields and having more columns all to itself, it can just be semantically completely orthogonal to the journals. But I say all this not having looked at this product and I don’t know if sales here works that way or not.
- revskill 3y agoBy looking at the db models, i guess they're using Sales Transactions in place of a Sales Journal.
- jsmith99 3y agoAs an accountant I think of the single source of truth being a single table of double entry transactions (the ledger) but most ERPs actually have a maze of tables to support a sophisticated UI that's easier to use, and when you actually want a ledger then it's generated as a report.