4 ms·
Positive quantities on sales orders decrease inventory. Positive quantities on purchase orders increase inventory. Closed sales orders increase cost of goods
by TehShrike 3y ago
Positive quantities on sales orders decrease inventory. Positive quantities on purchase orders increase inventory.
Closed sales orders increase cost of goods sold and accounts receivable. Closed purchase orders increase assets and accounts payable.
You could create one uber-record that could represent all of these different assets, but it wouldn't necessarily be a good idea, because my clients and their accountants conceive of them as separate entities, and I need to make them legible to my clients as separate entities.
I create schemas that store/make legible data beyond a double-entry general ledger.