Line Section (Sub)Total by InterAcct
by InterAcct Software Pty Ltd https://interacct.com.au/odoo$ 20.30
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Sales (sale_management) • Invoicing (account) • Discuss (mail) |
| Lines of code | 136 |
| Technical Name |
ia_line_section_total |
| License | OPL-1 |
| Website | https://interacct.com.au/odoo |
| Versions | 15.0 16.0 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Sales (sale_management) • Invoicing (account) • Discuss (mail) |
| Lines of code | 136 |
| Technical Name |
ia_line_section_total |
| License | OPL-1 |
| Website | https://interacct.com.au/odoo |
| Versions | 15.0 16.0 17.0 18.0 |
Order Line Subtotal by InterAcct
Function to provide sub totals in Sale/Purchase Order and Quotations when entering an order in Odoo.
This works independently to the Section Headings, so can get a sub total of any list of items on the order.
Order Lines in Standard Odoo
What Standard Odoo does without the module
Standard Odoo does allow you to group together lines under headings, but there are no totals to these lines until you print the Quote off, then you see the lines.
Order Lines with the Sub Total Module with Section Headings
We have this function work with having Sub Headings in your Quote
And below is what it looks like with the module in use, and when the user has used the Section option as well.
But see below and we don't need Section Headings if we don't want to.
Order Lines with the Sub Total Module without Sections
We have this function work without having Sub Headings in your Quote
And below is what it looks like with the module in use, and when the user has not used the Sections. You can add these sub totals whereever you like.
Let's continue and step through an example on how this works."
Step 1 - Add First Sub Total Line
Adding Sub Total for Office 2
The first step is the click on the subtotal option which you will see at the bottom of the list of Products.
Then add in the description you want to use. In this case we are using Sections so I will just name it the Office 2 Total
Since this has added to the bottom of the list you will see it has included the total of all the existing lines.
Next we will add the Sub Total for Office 1, which will reduce the total showing for Office 2.
Step 2 - Add Second Sub Total Line
Adding Sub Total for Office 1
The next step is to press "Add Subtotal" again.
This time we are adding in the line for Office 1 Total, so that is what we will call the description.
This time note, that the Values of the sub total is zero, because there are no lines between "Office 2 Total" and "Office 1 Total"
So, the next step we will move the Office 1 Total into position.
Step 3 - Move Sub Total Line into Position
We now need to move the Office 1 Total line above the Office 2 Section.
The next step is to drag the Office 1 Total Line above the Office 2 section heading
This will make the Office 1 Total line use only those lines in the Office 1 Section to calculate the totals.
And also change the Office 2 Total to only include the products after the prior Office 1 Total
This is the final step, but next we will have a look at what that looks like.
Final Result
Both Sections now show the correct Sub Totals
So once this movement has been made, you can now see that the Sub Totals values are showing correctly.
Also note, that you can add a Sub Total in whereever you like, but as soon as you do, then the following Sub Total will be reduced by the new value of the new Sub Total line.
Need something else?
Does this module not quite do what you need?
Do you need Multiple Sub Total Levels, so that you can have sub totals within sub totals? Or something else?
Register your request at interacct.com.au/odoo/apps, and select your priority.
You can even select an option to get the change developed for free. There are many options for you.
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