Product Container Deposit | Beverage Container Deposit
by Omax Informatics https://omaxinformatics.com$ 89.88
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Point of Sale (point_of_sale)
• Discuss (mail) • Inventory (stock) • Invoicing (account) |
| Lines of code | 1150 |
| Technical Name |
product_container_deposit_omax |
| License | OPL-1 |
| Website | https://omaxinformatics.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Point of Sale (point_of_sale)
• Discuss (mail) • Inventory (stock) • Invoicing (account) |
| Lines of code | 1150 |
| Technical Name |
product_container_deposit_omax |
| License | OPL-1 |
| Website | https://omaxinformatics.com |
| Versions | 16.0 17.0 18.0 19.0 |
Product Container Deposit & Refund
OMAX INFORMATICS
Overview
A POS (Point of Sale) Product Container Deposit & Refund app is designed to manage container deposits at the time of Sales and Refunds when containers are returned. It is commonly used in industries that sell beverages or other goods in returnable packaging (e.g., bottles, cans, crates).
This module provides an advanced container deposit management system with automatic container-product linking and seamless POS integration. It streamlines deposit handling by automatically associating container products with their linked items, ensuring dynamic quantity calculations based on product quantities in POS. For refunds, container quantities are automatically adjusted, and container returns are managed separately also, ensuring complete accuracy and efficiency in the process. Additionally, the module includes container balance reports with customer-wise grouping and both PDF and Excel export capabilities for complete tracking and analysis.
Example:
You buy a bottle of soda for $1.50 + $0.10 deposit = $1.60
You return the empty bottle and get $0.10 refunded
Features
- Links container deposits to specific SKUs (e.g., beer bottle, soda can)
- Automatically adds a container deposit product to applicable items at POS order
- Processes refunds when customers return empty containers
- Automatic container inclusion in POS orders order refund order
- Tracks container inventory separately from product inventory
- Container balance reports with customer-wise grouping
- Export reports in both PDF and Excel formats
- Comprehensive container tracking and analysis
- Prevents over-refunding with intelligent limits
- Merges duplicate refund lines intelligently
- Container quantities update automatically when linked products change
How It Works
Container Product Setup
Container Product Configuration
Enable the "Is Container" checkbox on products that serve as containers
- Container Identification: Mark products as containers for deposit management
- Product Association: Link these containers to other products
- Association View: View all products associated with a container directly from the container product form for better management and oversight.
Product Linking
Container Product Associations
Link regular products to their respective container products for automatic inclusion in POS orders.
Note: Container products will automatically be added to POS orders when linked products are selected.
POS Integration
Automatic Container Management
When products with linked containers are added to POS orders, the system automatically includes the container products with calculated quantities.
- Auto-Addition: Container products added automatically
- Quantity Sync: Container quantities match linked product quantities
- Real-time Updates: Dynamic quantity adjustments
- Seamless Workflow: No manual intervention required
- Standalone Support: Containers can also be ordered independently
Refund & Container Returns
Refund Management
Refunds are handled intelligently with automatic container adjustments with fully, partially and separate container refund.
- Auto-Refund: Container quantities are automatically added back when refunding products
- Separate Refunds: Containers can also be refunded independently for maximum flexibility
- Order Refund: When order is refunded, containers are also refunded appropriately
Advanced Refund Quantity Management
Smart Refund Quantity Capping & Validation
The system includes sophisticated refund quantity management to prevent over-refunding and ensure accuracy:
Intelligent Quantity Capping
- Maximum Refund Limits: System automatically calculates maximum refundable quantity = Original Quantity - Already Refunded
- Real-time Validation: Prevents users from entering refund quantities exceeding available limits
- Cross-Order Tracking: Tracks refunds across multiple transactions to maintain accurate limits
- Automatic Adjustment: If requested refund exceeds limits, system automatically caps to maximum available
Duplicate Container Line Prevention
- Smart Merging: When both direct container refunds and linked product refunds exist, system uses linked value (not sum) to prevent double-counting
- Single Container Lines: Ensures only one refund line per container type, regardless of how many ways it's refunded
- Automatic Detection: Detects existing container refund lines and updates quantities instead of creating duplicates
- Conflict Resolution: Intelligently resolves conflicts between direct and indirect refund requests
Example Scenario:
Original Order: 10 products + 10 containers
First Return: 2 products returned → 2 containers automatically returned
Remaining: 8 products + 8 containers
Second Return: 5 containers returned
Remaining: 8 products + 3 containers
Scenario 1: User tries to refund 5 products
→ System checks available containers (3)
→ Automatically sets container refund quantity to 3 (not 5)
→ Final refund: 5 products + 3 containers
Scenario 2: User refunds 2 products
→ 2 containers are automatically refunded
→ Final refund: 2 products + 2 containers
Rule Applied: Containers refunded will always match products refunded,
but never exceed the remaining available container quantity.
Container Balance Reports
Comprehensive Reporting System
Generate detailed container balance reports with customer-wise grouping and comprehensive analysis.
- Customer Grouping: Data organized by customer with subtotals
- Container Analysis: Shows quantity sold, returned, and net containers
- Date Filtering: Filter data up to specific date
- Report Type: PDF and Excel report
- Container Products: Multi-selection field, Products that are containers are listed here
- Customers: Multi-selection field, Customers who have purchased something are listed here
Report Features: Reports are grouped by customer and container product, showing aggregated quantities rather than individual transaction dates for cleaner analysis. If new customers make purchases during the session, they will be listed after the session closes.
Filtering Wizard
PDF Report
Excel Report
Recommended & Suggested Apps
Free Support
Get In Touch
OMAX INFORMATICS
| Our Odoo Services |
|
|
|
|
|
|
|
|
|
|
| For support, query and question contact us. |
|
|
|
Thank you for visiting
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module