Custom Report: Inventory COGS

Report Description:
Generates a report showing Cost of Goods Sold for a given Payment Date Range. Based on payment date (cash), not invoice date (accrual).

Columns Displayed:

  • Account
  • Item description
  • Color
  • Size
  • Quantity
  • Last Unit Cogs
  • Avg Unit Price
  • Net Cogs
  • Net Price
  • Margin %
  • Net Margin



Download the SQL code as a .txt file


Disclaimer: Custom SQL reports can be used or modified by RGP customers at their own discretion. However, due to the custom nature of each report and the varying size of a customer's database, some reports may be slow to run (or may not run at all).  All support and/or modifications requested of these public, custom reports will follow the standard Custom SQL Report fee structure.

Please also see: Adding Custom SQL Reports

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.