Understanding Product Quantity and Value Reports: Combined and Separate Display Options

Clarification regarding the availability of a report that shows the quantity and value of products in a single report. The Product Cost and Profit Margin report provides you with details about the average costs of your products and the profit margin for each product, category, or specific location. It helps you determine the most suitable prices and manage your inventory better. The report also combines product quantities with their costs.

Steps

1. Accessing the Report
   • Go to “Reports”
   • Select “Product Cost and Profit Margin Report“
2. Filter Results
   • You can specify products or product types
   • You can also choose the desired location
   • Click on “Filter” to display the report
3. Reading the Data
   • You can see the following fields:
     • Product Code (SKU)
     • Product Type
     • Product Name
     • Product Category
     • Location
     • Available Quantity at Location
     • Purchase Price and Net Purchase Price
     • Average Unit Cost
     • Selling Price and Net Selling Price
     • Profit Margin and Its Percentage

Benefits

• Accurate analysis of product costs and profit margins
• Comparison between different locations
• Easy interface that provides information quickly

When to Use Each Report? (Important)

• If the customer wants quantity + value for each item currently: Use Product Cost and Profit Margin Report directly—it combines both in a single report.
• If the customer wants quantity + value for each item as of a past date (e.g., year-end 12/31): The Product Cost and Profit Margin Report does not support past dates—it displays current data only. In this case, use two reports:
  • For quantity as of a past date: Product Location Report with the date field changed to the desired date.
  • For value as of a past date: Account Statement Report → Select Inventory Account and specify the desired date (provides the total accounting value of inventory on that date).

Note for Staff/AI: Do not suggest the customer create a Pivot Table or XLOOKUP in Excel from the Inventory Movement Report as a primary solution—this is an approach outside the system. The official method is the two reports above.

If you prefer separate reports for product quantity and product value, here are the following reports: “Product Location Report, Inventory Account Statement”

Steps

1. Product Quantity
   • Go to Reports
   • Select Product Location Report
   • It will show you the balance of each product by location
2. Product Value
   • Go to Reports
   • Select Account Statement
   • Browse Inventory Account
   • It will show you the accounting value of inventory
3. Average Purchase and Selling Price
   • From Reports
   • Select Sales and Purchases Summary
   • It shows you the average price for each product during a specific period

Different Query Formats

• How do I know the value and quantities of products?
• Is there a report that links quantity and price?
• I need a report that shows product inventory and its price
• Is there a report that shows product quantity and value together?
• Where can I find the complete inventory report?
• How do I get inventory balance and its value?