| | How to generate the Stock Movements reports |
| Description | Use the Stock Movements Summary report to see a summary of stock item movements during a specific time period. Double-click a stock item to open the Stock Movements Detailed report, showing all stock movement transactions for the item in the specified period. These reports help calculate sales costs. |
| Resolution | Understanding the Stock Movements Summary report The Stock Movements Summary report includes the following information: | Item Code | The code of the stock item. | | ItemDescription | The stock item's description, as shown on your invoices. | | Quantity In | All Goods In and Adjustments In stock movements for the specified reporting period. | | Quantity Out | All Goods Out and Adjustments Out stock movements for the specified reporting period. | | Value In | The total net value of the stock item for the specified reporting period. Multiply the item's cost price (at the time of the invoice, credit note, or adjustment) by the Quantity In amount to determine this value. | | Value Out | The total net value of the stock item multiplies the cost price at the transaction time by the quantity on the sales transaction or adjustment out.  NOTE: To calculate Value Out correctly, you must have a cost price on your stock item. Changing the cost price after entering the transaction doesn’t affect the Value Out calculation.
| To generate the Stock Movements Summary report - Go to Reporting, More, Stock Movements.
- Click More, Stock Movements.
- From the Period drop-down list, click the time period you want to report on. Choose Custom to enter your own date range in the Start and End fields.
- In the Category field, choose All to see all categories on the report or select a specific category to see only products and services in that category.
NOTE: The Category field displays only if you set up categories for your products and services. See Add and manage categories for more information. - Click Calculate. Optionally, click Export to export it to a comma-separated value (CSV) file or portable document file (PDF).
Understanding the Stock Movements Detailed report The Stock Movements Detailed report includes the following information: | Date | The date of the stock movement. | | Type | The stock movement transaction type appears here. | | Reference | The Sales or Expense Invoice reference. | | Details | The stock transaction details. | | Quantity In | All Goods In and Adjustments In stock movements for the specified reporting period. | Quantity
Out | All Goods Out and Adjustments Out stock movements for the specified reporting period. | | Value In | The total net value of the stock item for the specified reporting period. Determine this value by multiplying the item's cost price (at the time of the invoice, credit note, or adjustment) by the Quantity In amount. | | Value Out | The total net value of the stock item for the specified reporting period. Calculate this value by multiplying the stock item's cost price at transaction time by the quantity on the sales transaction or adjustment out. NOTE: To calculate Value Out correctly, you must have a cost price on your stock item. Changing the cost price after entering the transaction doesn’t affect the Value Out calculation.. | To generate the Stock Movements Detailed report - Go to Reporting, More, Stock Movements.
- Click More and then Stock Movements.
- From the Period drop-down list, click the time period you want to report on. Choose Custom to enter your own date range in the Start and End fields.
- In the Category field, choose All to see all categories or select a specific category to see only products and services in that category.
NOTE: The Category field displays only if you set up categories for your products and services. See Add and manage categories for more information. - Click Calculate.
- Double-click the stock item for which you want to generate the Stock Movements Detailed report.
- Optionally, click Export to export it to a comma-separated value (CSV) file or portable document file (PDF).
|
|