Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Advantage of Purchase Orders and Invoices Tables vs. one table for all Transactions


This topic is 4873 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I was wondering if there were any advantages to building an invoicing system using separate tables for Purchases Orders and Invoices vs just one table for all Transactions...

My thought process was to create only one table called Transactions with a TransactionType field to differentiate between an Income Transaction and an Expense Transaction. This way, the SUM of all or a found set of Transactions is essentially the Balance, showing Profit or Loss for the found set (or all). Of course doing this creates the need to show Expense Transactions as negative totals and Income Transactions as positive totals (much like a bank account ledger).

This also allows me to add to and subtract from my InventoryItems::QuantityOnHand, thus efficiently maintaining and tracking Inventory Items.

Does this make sense to anyone else and/or is my logic flawed?

This topic is 4873 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.