Open Forum

Inventory COGS table

  • 1.  Inventory COGS table

    SILVER CONTRIBUTOR
    Posted Mar 31, 2020 05:06 PM

    Hi!  Thanks in advance for your help!  I have been making do with a query, but it just occurred to me I wonder if there is a better way.

    Each month I pull a refreshable quick query for COGS from the inventory item table to run some calculations on cost and quantity by product class.  Currently, I need to remember that PTDCOGS00 and PTDQtySls00 is actually for January, PTDCOGS01 is Feb, and so on.  That's no big deal.  But my question is...at year end I have to sum all of the fields together to get a total.  Is there a total already in the system I could use?

    Thanks!

    Cathy

    #communitycares
    #communitycauses

    ​​

    ------------------------------
    Cathy McCarter
    Financial Analyst
    Innovative Wireless Technologies
    Lynchburg VA
    ------------------------------


  • 2.  RE: Inventory COGS table

    TOP CONTRIBUTOR
    Posted Mar 31, 2020 05:17 PM
    Hi Cathy,

    There is a QQ for Inventory History.  This stores YTD by year for total cost and QTY.  I believe this is what you are looking for....

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Director of Finance
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------