Report COGS By Account Summary
From Fishbowl Advanced
This report shows a summary of COGS value, per COGS account, and then is broken down by part and sales order number. It then totals per COGS account and also gives a grand total at the end.
The 
Modify Report button allows the following report filters to be customized:
- OPTIONAL TAB
- Product Number - Select a specific product number to run the report for. Leave this field blank to run for all products.
- COGS Account - Enter a specific COGS Account to run the report for. Leave this field blank to run for all products.
- Date Range - Select the date range to run the report for. This date looks at the PostDate for the Sales Order on the POSTSO table in the database, meaning the date the order is shipped. If you backdate the shipment, it will show up on that date. Partial shipments will show up as separate line items, but all parts on the sales order will use the first date shipped.
- Closed Short - Choose to show/hide this type of status by checking/unchecking this checkbox.
- Fulfilled - Choose to show/hide this type of status by checking/unchecking this checkbox.
- Partial - Choose to show/hide this type of status by checking/unchecking this checkbox.
- Format Report for Exporting - Removes the page breaks and displays the report on one long page for exporting to CSV, Excel, and other formats.
- Show Part Details - If checked, the COGS Amount is shown for each part, instead of just the total.
- PRINTER TAB - Allows a default printer to be specified for the report in each location group.