The Cost Change Report allows you to track changes in product costs over time. These changes can impact selling prices and net income, making it essential to monitor them regularly. This report is based on purchase invoices issued from the platform and helps you analyze cost trends.
How Costs Are Calculated
Product costs are calculated using the average cost method as follows:
(Total current value + Total added value) ÷ (Total current quantity + Total added quantity).
Accessing the Report
Navigate to:
Reports > Stock Control > Cost Change.
Search for products using:
Product name
SKU
Purchase invoice number.
Use the filter option to refine search results by date range and other criteria.
Report Details
The report consists of two sections:
Header Section: Displays company name, report title, and selected time frame.
Detailed Section: Provides data on cost changes for each product based on selected filters.
Key data points include:
PO Number: Purchase invoice reference.
PO Date: Date of purchase invoice issuance.
PO Location: Branch where the product is stored.
Product Name: Name of the product in inventory.
Product Rate: Units on which the cost change is measured.
Product SKU: Unique identifier for the product.
Initial Cost: First cost entered for the product during its addition to inventory.
Product Cost Before PO: Cost per unit before the purchase order.
Product Quantity Before PO: Quantity available before the purchase order.
Product Cost in PO: New cost per unit in the purchase invoice.
Product Quantity in PO: New quantity added via the purchase invoice.
Product Cost After PO: Cost per unit after issuing the purchase invoice.
Product Quantity After PO: Total quantity after issuing the purchase invoice.
Exporting the Report
To export:
Click Export and select xlsx.
The file will download to your device.
FAQs
1. Can I print the report directly from the platform?
Direct printing is unavailable. Export the report as an Excel file and print it from your device.
2. How can I search for a specific product to view cost changes?
Use the filter option to search by product name or SKU in the designated column. Enter the desired details in the appropriate fields and apply the filter to view the results.
3. Can I export the report for a specific product only?
Yes. Use filters to refine the report for the product, then export the results as an xlsx file.
4. How can I view more results on a single page?
Adjust the results per page setting at the bottom of the table. You can view up to 200 results per page.
5. How can I find the initial cost of a product?
Search for the product in the report. The Initial Cost column displays the original cost entered in the inventory.
6. Can I restrict user access to this report?
Yes. Navigate to:
Settings > Users > ⚙️ > Edit User.
Disable Read and Export permission under Reports > Stock Control Reports > Cost Change.
Click Save Custom User to apply the settings.
When a user accesses their account, reports will be displayed based on the assigned permissions.