| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 2142 |
| Technical Name |
nexterp_sgr_returo |
| License | OPL-1 |
| Website | https://www.nexterp.ro |
Romania - SGR RetuRO Operations
Seals, pickup events and stock-move generation for handing over collected SGR packaging to RetuRO.
Overview
Operational layer for retailers who need to physically hand over collected SGR packaging to RetuRO and submit the monthly reports required by HG 1074/2021. Where the other SGR modules track empties as they come in, this one is the missing piece that takes them out.
Manage the seal lifecycle from available (received from the
transporter) to used (handed over) to confirmed (acknowledged by
RetuRO at the sorting centre). Build pickup events by warehouse,
transporter and RetuRO partner — confirming a pickup creates the stock
transfer from the SGR Returns location to the customer location in
one click and stamps the seals as handed over.
Generate the three CSV reports RetuRO requires every month from a
single wizard: sales (packaging placed on market), seals handed
over during the period and consumer returns. The exports come
out as semicolon-delimited UTF-8 CSV ready to email to
raportare_comercianti@returosgr.ro on the first day of each month.
Built & supported by NextERP Romania
Romanian Odoo specialists, here for the long run — from implementation to localization and day-to-day production support.
What we do
Odoo Solutions
From quick-start rollouts to multi-company deployments and custom modules built for your processes.
Romanian Localization
SAF-T (D406), e-Factura, e-Transport, D300 / D390 / D394, ANAF integration, full chart of accounts and fiscal positions.
Our Services
Implementation, customization, migration, integration, support and consultancy — Romanian-speaking, SLA-backed.
Features
- Partner roles —
res.partner.is_sgr_returoflags the RetuRO system administrator;is_sgr_transporterflags logistics operators picking up bags. Both fields appear on the partner form and act as filters on pickup pickers. - Default RetuRO partner on the company —
res.company.sgr_returo_partner_idpre-fills the destination on every new pickup so warehouse users never have to look it up. - Serialized seal lifecycle —
nexterp.sgr.sealtracks each seal serial throughavailable → used → confirmed, with a unique-serial per-company constraint and a Receipt Reference field for the delivery note number. - Pickup events —
nexterp.sgr.pickup(sequenceSGR/PICKUP/00001) with lines per SGR category, the seals tab, totals, mail thread and a state machinedraft → done → reconciled(pluscancel). - One-click stock transfer — confirming a pickup creates a
stock.pickingfrom the warehouse's SGR Returns location to thestock.stock_location_customers, with one move per pickup line. - Reconciliation step — Mark Reconciled on the pickup transitions
the linked seals to
confirmed, matching RetuRO's confirmation at the sorting centre. Cancellation reverts seals toavailableso long as the linked picking is not yet done. - Three monthly RetuRO exports — the
nexterp.sgr.report.wizardproduces semicolon-delimited UTF-8 CSV files for sales placed on market, seals handed over and consumer returns, with optional warehouse filter. File names followSGR_<report>_<from>_<to>.csv. - Tracked & audited — pickups inherit
mail.thread/mail.activity.mixinso every state change leaves a trail and questions from RetuRO can be answered with proof.
Configuration
1. RetuRO administrator partner
Open Contacts and create (or open the existing one for) RetuRO SGR SA. Flag it RetuRO Administrator under the SGR roles group on the partner form. The demo data set ships this partner pre-created.
2. Default RetuRO partner on the company
Open Settings → Companies → [your company] and set RetuRO Partner to the contact created above. This becomes the default value on every new pickup, so warehouse users don't have to set it manually.
3. Transporter partners
For each logistics operator picking up bags from your sites, create a contact and flag it SGR Transporter. You can have multiple transporters; the pickup form lets you choose the right one per handover.
4. Seal stock
When the transporter delivers fresh seals and empty bags, register each seal under Inventory → Reports → SGR → RetuRO → Seals:
- One row per seal serial.
- Set Receipt Reference to the transporter's delivery note number for traceability.
- State stays
Availableuntil used on a pickup.
You can register them one at a time from the list view, or use the standard Import feature with a CSV file supplied by the transporter.
5. Warehouse SGR Return Location
Make sure each warehouse used for SGR has its SGR Return Location
configured (this is the standard nexterp_sgr field). Confirming a
pickup requires this location to be set — that's where the stock
transfer will source the empties from. If it's missing, the module
raises a clear error pointing back to the warehouse form.
6. Sequence
The SGR/PICKUP/00001 sequence is created automatically on install
through data/sequence_data.xml. Tweak it under Settings →
Technical → Sequences if you need a different prefix or padding.
How it works
Pickup workflow
A. Empties pile up in SGR Returns
Day to day, empties received from consumers land automatically in the warehouse's SGR Returns location:
- through
nexterp_sgr_poswhen the cashier uses the SGR Return button at the till; - through a manual customer-return picking when the return is taken at a counter outside POS.
B. When the transporter comes for pickup
- Go to Inventory → Reports → SGR → RetuRO → Pickups → New.
- Pick the date, warehouse, transporter and RetuRO partner (the last one defaults from the company setting).
- Lines — add one row per SGR category with the quantity handed over. Quantities must match what is physically in the SGR Returns location; the Total Deposit Value updates live based on the deposit rate effective on the pickup date.
- Seals Handed Over — link the seals applied to the bags. Pick
from seals currently in
Availablestate, or create new ones inline if the transporter brought unannounced ones. - Confirm. The module generates a stock transfer from SGR
Returns to the Customers location, transitions the linked seals
to
Used, and stamps the picking origin with the pickup name (SGR/PICKUP/00001). - When RetuRO confirms the counts at their sorting centre, reopen the
pickup and click Mark Reconciled — the seals move to
Confirmed.
C. Cancelling
If you confirmed a pickup by mistake, click Cancel on the pickup.
The module refuses if the linked stock transfer is already done
(cancel that first); otherwise it reverts the seals to Available
and sets the pickup to Cancelled.
Monthly RetuRO reports
- Open Inventory → Reports → SGR → RetuRO → Export Monthly Reports.
- Pick the period (defaults to the current calendar month) and, optionally, a warehouse filter.
- Click each of the three buttons; each one downloads a CSV file.
| Button | Filename | Content |
|---|---|---|
| 1. Sales | SGR_sales_<from>_<to>.csv |
Out-to-customer SGR moves: packaging placed on market with deposit per unit and total value |
| 2. Seals Handed Over | SGR_seals_handed_over_<from>_<to>.csv |
One row per seal handed over to the transporter during the period |
| 3. Consumer Returns | SGR_consumer_returns_<from>_<to>.csv |
In-from-customer SGR moves: empties received from consumers with the deposit refunded |
CSV format is UTF-8, semicolon-delimited, with a header row.
Email the three files to raportare_comercianti@returosgr.ro on the
first day of each month, for the previous month (per
HG 1074/2021 and contractual obligations). RetuRO returns an
autofactura through e-factura within 10 working days, covering both
the deposit and the handling fee (TG).
Seal management tips
- Use the Available / Used / Confirmed filter on the seals list to spot serials that haven't moved in too long.
- Archive seals you've damaged or lost before use, so the list stays clean.
- Reverting a
usedseal toavailablemanually is restricted to the stock manager group — do it only after a clean pickup cancel.
Screenshots
Captured from a running Odoo instance.
Nexterp sgr pickup action
Nexterp sgr seal action
Nexterp sgr report wizard action
Versions
19.0.1.0.0 (2026-05-25)
- Changelog tracking starts at this release.
Discover the NextERP suite
Other modules from the same publisher, built to work together.
NextERP Romania
Odoo implementation, customization, Romanian localization and long-term support since 2018.
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