How to view Transaction Vs Storage Report in Adempiere Retail
A Transaction Report shows details of all product movements — like sales, purchases, returns, or transfers.A Storage Report shows where products are currently kept and in what quantity.
User Access
Who Can Access
- Admin
- Back Office
- Purchase Manager
- Manager
What User Can Do
- Track Product Movements
- Check Transaction History
- Generate Reports by Date or Type
- View Current Stock Levels
- Identify Low or Overstocked Items
Pre-Requisite Activities
- Product Master Data
- User Access Rights
- Transaction Types
- Stock Entry Update
- Barcode/Labeling
- Regular Stock Audits
Business Rules
- Record All Movements
- Real-Time Updates
- Date Range Filtering
- Storage Limits
- Location Setup Required
- Track Expiry or Condition (if applicable)
User Interface
STEP 1: To select a Transaction Vs Storage Report.

STEP 2: To enter a Dynamic report Default add this field.Then to click the Start check box and to run the Process.

STEP 3: Once to complete the process to show the report based on given parameter.



STEP 4: Code-A product code is a unique identifier assigned to a specific product, typically used by manufacturers, retailers, and distributors to manage and track inventory, sales, and other logistics.
Product name-A product name is the name given to a specific item, good, or service that a company or manufacturer offers for sale to customers. It is used to identify the product and distinguish it from others in the market.
TRX QTY- typically refers to the transaction quantity in a business or financial context. In Business/Inventory Management,In Financial or Trading Context,In Supply Chain or Logistics.
STR QTY-likely refers to Storage quantity typically refers to the amount of space available or the volume/amount of items that can be stored in a particular storage facility or system. It can be used in various contexts, such as Physical Storage,Data Storage,Inventory Management The specific meaning depends on the context in which “storage quantity” is being used, but it always relates to the amount of items or data that can be stored.
MRP- stands for Material Requirements Planning. It’s a system used in manufacturing and inventory management to plan and manage the materials needed for production.
S price-The selling price is the amount of money a seller charges a buyer in exchange for goods or services. It is the final price at which a product or service is offered for sale to customers, and it typically includes factors like the cost of production, profit margin, and any additional expenses (e.g., taxes, shipping fees).
Landed cost-Landed cost refers to the total cost of getting a product from the supplier to its final destination, ready for sale.Product cost,Shipping or Freight charges,Import duties or tariffs,Customs fees,Storage costs.
Tax-Tax is a compulsory financial charge or levy imposed by a government on individuals, businesses, or other entities to fund public expenditures and services.
Department-A Product Department is a business division or team within an organization that focuses on the development, management, and marketing of products or services.
Category-A product category is a classification or group of similar products that share common characteristics or serve a similar purpose.
Sub Categories-A product subcategory is a more specific group or subset within a broader. Subcategories help companies and consumers drill down into more precise groups, making it easier to identify and compare products that are similar in more specific ways.
For example:
-Product Category: Electronics
-Subcategories: Smartphones.
Brand-A product brand refers to the identity and image of a specific product or product line.
Locator-A product locator is a tool or system that helps customers find a specific product in a store, online, or across multiple locations.