Open Forum

Expand all | Collapse all

COGS in SSRS Report

  • 1.  COGS in SSRS Report

    Posted 24 days ago
    Good morning,
    I am trying to figure out how I calculate COGS in and SSRS report. I can see the 'actual cost' in the Item Ledger Entries table in NAV and then filter on Type = Output to get COGS. is COGS just Output or is it some other type as well?  I checked the Item Ledger Entry table in my SQL Management Studio and there is not a field for Actual Costs which means that it is probably a calculated field being populated on the Item Ledger Entries Page.
    .
    I am looking to find COGS for items for a specific date range
    For Example:
    Item No.    Sales          Qty         Avg Sales Price             Total COGS        Avg Cost per Unit      Avg Margin per Unit


    Regards,

    Mike

    ------------------------------
    Mike Debner
    Crest Healthcare Supply
    Dassel MN
    ------------------------------


  • 2.  RE: COGS in SSRS Report

    Posted 23 days ago
    Hi Mike:

    Use the Value Entry table.  You may also want Cost Amount Expected or Cost Amount Non-Invt. depending on how your process works.  Sales Amount is there also, for that consider pulling discount amount as well, also on the value entry lines.

    Murphy McConnell
    Sr. Solutions Engineer
    Stoneridge Software

    ------------------------------
    Murphy McConnell
    Stoneridge Software
    Fargo ND
    ------------------------------



  • 3.  RE: COGS in SSRS Report

    TOP CONTRIBUTOR
    Posted 23 days ago
    Mike - have you tried the standard report found in GL 'Cost Shares Breakdown'. If you are FIFO costing this is an out of the box breakdown of Sales, WIP, and on-hand inventory.

    Best Regards

    ------------------------------
    John Grant
    Senior Application Consultant
    Innovia Consulting
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role