nutank
commented
4 years ago - Normally, inventory COGS is only affected when you sell inventory items on invoices or sales receipts. There will be a Sales/Accounts Receivable transaction and you'll see the Inventory/COGS transactions which credits the Inventory Asset account and debits the COGS accounts.
- if you sell inventory that you do not have, you can force the next bills, checks, or credit card charges to adjust the Inventory Asset account and the COGS account. The amount on each side of the Inventory/COGS transaction is: Number of Items Sold x Average Cost of Item.
Approach doc - https://docs.google.com/document/d/1eF9CkEpcKPGpCShiDaT5bJaubdrM_8OCOQU_Rw-WxxQ/edit
PENDING TASKS:
Cogs - (for later) Op balance = Sum of transactions of all types excluding bill payments and payments whose category is of type cogs List = <find out if API gives value, else display as per current logic>
Inventory Assets - - (for later) store separately in DB from QB (bills with inventory asset for its product + cogs based invoices for those products)
Server Side Pagination
Originally posted by @nutank in https://github.com/ajency/cashflow-issue-tracker/issues/554#issuecomment-623377293