The Product Movement Report is an essential tool that helps you track all documented movements of your products, such as sales, returns, purchase orders, stock returns, and more. It provides detailed insights into the quantity changes of your products across all sales channels, including Rewaa's platform and integrated e-commerce stores (Salla, Zid).
⚠️ Manually adjusting product quantities in the Products Inventory section without official invoices will not be reflected in the reports or the product movement history.
Accessing the Report
Navigate to: Reports > Inventory > Product Movement.
Search for specific products using their name or SKU.
Use the filter option to refine results further by time period.
Report Structure
The report is divided into two sections:
Header Section: Displays company name, report title, and selected time period.
Details Section: Lists all product movements with a scrollable table showing comprehensive details.
Key Data Columns
The report includes the following details:
Product Name.
SKU: Unique identifier for the product.
Location: The branch where the transaction occurred.
Transaction Type
(POS Sale): Sales invoices.
(POS Return): Return invoices.
(Purchase Order): Purchase orders.
(Return Stock): Stock returns.
(Remove Stock): Stock removals.
(Stock Count): Stock counts.
(Transfer Stock): Stock transfers.
(Sale Order): E-commerce sales invoices (Zid, Salla, WooCommerce).
(Return Order): E-commerce return invoices.
Transaction Reference: Invoice number for each transaction.
Transaction Date: The date of invoice issuance.
Quantity before the operation: Stock quantity before the transaction.
Transaction Quantity: Quantity added or removed based on the transaction type.
Quantity after the operation: Stock quantity after the transaction.
Retail Price (Inclusive Tax).
Cost (Exclusive Tax).
Channel: Source of the invoice, such as Rewaa's POS or integrated e-commerce stores.
Exporting the Report
To export the report:
Click Export and select xlsx.
The file will be downloaded to your device.
FAQ
1. Can I print the report directly from the platform?
No, the platform currently supports exporting to Excel but does not have a direct print feature.
2. Can I export the report for a specific product only?
Yes, you can filter the report by product name, SKU, operation type, or date.
Use the Filter option.
Choose the desired parameters.
Click Apply
Then Click Export and select xlsx.
3. How can I view more search results per page?
Select the number of results per page from the dropdown at the bottom of the table (up to 200 results).
Use the navigation buttons to move between pages.
4. Can user access to this report be restricted?
Yes, follow these steps: Go to Settings > Users > ⚙️ > Edit User.
Choose Custom under user permissions.
Go to the Reports section.
Enable all permissions under the Reports List to grant the user full access.
Expand Inventory Reports and enable permissions for the Product Movement as needed.
Click Save Custom User to apply the settings.
When a user accesses their account, reports will be displayed based on the assigned permissions.