Viindoo
Odoo Community
Odoo Enterprise
Enter past stock operations on the dates they happened
For administrators and consultants bringing a company's stock history into Odoo during the initial deployment
Manually input the confirmation date for past inventory operations.
Odoo Community · Odoo Enterprise · OPL-1 · English, Vietnamese
Extends Backdate Operations Access Rights, which holds the access rule and the uninstall of the whole back-date cluster.
Purpose and life cycle
Back-dating is a discouraged operation. A stock operation recorded on a past date is not recorded when the work happened, so routine use weakens the reliability of stock and valuation figures.
This module serves one situation: the initial deployment, when a company enters its past stock data, for example last month's receipts and deliveries or the opening counts of a date before go-live. When that work is done, the administrator uninstalls the back-date modules from Apps. They can be installed again later if the need returns.
Keep it for the data entry, not for day-to-day warehouse work, and grant the back-date group only to the people who do that entry.
What changes for your team
Past receipts, counts and scraps keep their real date
Without it, every stock operation is stamped with the moment it is validated, so history entered today is dated today.
→ Validating a transfer, applying an inventory adjustment or validating a scrap asks for the date it really happened. A future date is refused.
Opening stock is valued in the right period
A valuation dated on the day of data entry puts last month's stock in this month.
→ The stock moves and the valuation line carry the date you entered. With automatic valuation, the journal entries follow it too.
You decide who may enter a past date
Without a rule, anyone who validates stock could also choose its date.
→ Only members of the stock back-date group see the date dialog. Trust is per person: a member can back-date in every application they work in, not only Inventory.
Features
Recording past operations
- ✓ Transfers validated on a past date and time
- ✓ Inventory adjustments applied on the date of the count
- ✓ Scraps validated on the actual scrap date
- ✓ The date field starts at the current date and time
- ✓ A date in the future is refused
Where the date lands
- ✓ The transfer, its stock moves and its move lines
- ✓ The last inventory date of the counted location
- ✓ The stock valuation line of the operation
Control and exit
- ✓ One group grants the right, person by person
- ✓ Everyone else validates at the current time, with no dialog
- ✓ Uninstalling keeps every recorded operation and its dates
Ready on day one
The date dialog
It opens on the existing Validate and Apply buttons of Inventory. The module adds no menu and changes no screen for people outside the group.
First step for the administrator
Add the people who enter past stock data to the stock back-date group, and remove them when their entry is done. The Documentation tab shows where.
Built on it
Keeps the accounting date in step with past stock operations. It installs itself when stock accounting is present, and adds an accounting date to the inventory dialog.
Records past manufacturing on its real date: posting inventory, marking manufacturing orders as done and back-dating work orders.
Before you decide
Should we keep it installed after go-live?
No. It is meant for entering past stock data during the initial deployment. Uninstall the back-date modules when that is done; they can be installed again if the need returns.
Can I allow back-dating in Inventory only?
No. Membership of a back-date group lets that person back-date in every application where they can work. Give it only to people you trust with a past date on any document.
What do we lose when we uninstall?
No recorded transfer, adjustment or scrap, and no valuation figure. The stock back-date group, its membership and the date dialogs go; afterwards every stock operation is recorded at the moment it is validated.
Does it change anything for the rest of the warehouse team?
No. A person outside the group validates stock operations as usual, at the current date and time, and never sees the dialog.
Can a date later than today be entered?
No. The dialog accepts the current date and time or a past one, and refuses a future date with a message.
Try it, then ask us
The Documentation tab holds the guide for administrators and data-entry staff. The live preview of this listing opens the transfers list on a demo database.
Inventory Backdate
For administrators who set up back-dating, and for the warehouse people they trust to enter past stock operations.
Inventory Backdate lets a trusted person record a stock operation on a date in the past: validating
a transfer, applying an inventory adjustment, or validating a scrap. Without it, the system stamps
every stock operation with the moment it is validated.
Note
Extends Backdate Operations Access Rights - see its
documentation. That guide covers the cluster as a whole,
including the steps to uninstall it.
Purpose and life cycle
Back-dating is a discouraged operation. A stock operation recorded on a past date was not recorded
when the work happened, so routine use weakens the reliability of stock and valuation figures.
This module exists for one situation: the initial deployment, when a company enters its past stock
data (for example last month's receipts and deliveries, or the opening counts of a date before
go-live). When that work is done, the administrator uninstalls the back-date modules from Apps.
They can be installed again later if the need returns.
Do not keep the module installed for day-to-day warehouse work, and do not grant the back-date
group as a convenience.
What is removed by the uninstall and what stays is listed in When the data entry is done. The
steps are in the guide of Backdate Operations Access Rights.
Who can back-date
Back-dating stock operations is a right granted to a person through one group:
| Group |
Lets its members |
| Stock Backdate Operations |
Record stock operations dated in the past |
The group also gives the Inventory user access, so a member can work in the Inventory application.
Important
Trust is granted per person. Being a member of a back-date group lets that person back-date in
every application where they can work, not only in Inventory. Give the group only to people you
would trust with a past date in any document.
A person who is not a member of the group validates stock operations as usual, at the current date
and time, with no dialog.
Setup (for the Administrator)
Open Apps, search for Inventory Backdate and click Install. Backdate Operations
Access Rights is installed with it.
Activate the developer mode, then open Settings ‣ Users & Companies ‣ Groups.
Open Extra Rights / Stock Backdate Operations. The Notes tab states what the members can
do.
In the Users tab, add the people who enter the past data.
Remove them from the group when their data entry is done.
Stock operations dated in the past
For a member of the group, the action that records a stock operation opens a dialog with one date
field, filled with the current date and time. Keep it to record the operation at the current time, or enter the date
and time at which the operation really happened, then click Validate. Cancel closes the
dialog and records nothing. A date in the future is refused with the message "You may not be able to
specify a date in the future!".
Validate a transfer on a past date
- Open Inventory ‣ Operations ‣ Transfers and open the receipt or delivery to record.
- Click Validate. The dialog Validate with a Back Date opens.
- Enter the real date and time in Transfer Date and click Validate.
The transfer, its stock moves and its move lines carry the date you entered.
Apply an inventory adjustment on a past date
- Open Inventory ‣ Operations ‣ Adjustments ‣ Physical Inventory.
- Enter the counted quantity of a line (or click Set to count the on-hand quantity), then click
Apply.
- Enter the date of the count in Inventory Date and click Validate.
The adjustment moves carry the inventory date, and the last inventory date of the location is set to
it. When Stock Account Backdate is installed, the dialog also shows Accounting Date, which
starts at the day of Inventory Date; see its documentation.
Validate a scrap on a past date
- Open Inventory ‣ Operations ‣ Adjustments ‣ Scrap, open or create a scrap order, or click the
scrap button of a transfer.
- Click Validate.
- Enter the date of the scrap in Actual Scrap Date and click Validate.
The scrap and its moves carry the date you entered.
Effect on stock valuation
The date you enter is carried to the stock valuation. In Inventory ‣ Reporting ‣ Valuation, the
Date of the valuation line of a back-dated operation is the date you entered, not the day you
recorded it. With automatic stock valuation, the journal entries are dated the same way; see the
documentation of Stock Account Backdate.
When the data entry is done
Uninstalling the back-date modules (see the guide of Backdate Operations Access Rights) keeps every
recorded transfer, adjustment and scrap with its dates, and the stock valuation. It removes the
group Stock Backdate Operations, with the back-date membership of every person, and the
back-date dialogs: afterwards every stock operation is recorded at the moment it is validated.
Installing the modules again requires granting the group again.
FAQ
- A user validates a transfer and no date dialog opens.
- The user is not a member of Stock Backdate Operations. Add the user to the group, then ask
them to validate again.
- Can the date be later than today?
- No. The dialog accepts only the current date and time or a past one.
- Can I give back-date access for Inventory only?
- No. The group applies in every application where its member can work.
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.