Comments (4)
I have searched a solution without development.
Here is my Solution =
In queries, add an item on account move line to fetch partner, credit and debit, with a domain corresponding to the account you want to select (in France, for example, I want select clients account only, and the account is '411100')
In KPI's, you can create a line and use the queries. Here I want to have the positive balance of clients only.
As in query I didn't add an accumulation method, we obtain a list. It was difficult to me to find a way to use this list but try to print the list to understand and the light will illuminate your brain as my own.
Here is the expression:
Explanation :
[partner_id.debit - partner_id.credit for partner_id in partner] gives a list of amount calculate with "partner_id.debit - partner_id.credit".
We calculate the sum of element (elt) where elt is positive or null.
Pro : I have the right amount without compensation between positive and negative partner's accounts
Cons : I don't have the detail anymore.
My way.
from mis-builder.
Clever solution.
from mis-builder.
Problem with my solution : the comprehensive list do not order the sum by partner but by sign. If someone could test this and give ideas ...
from mis-builder.
There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.
from mis-builder.
Related Issues (20)
- [15.0] mis_builder: non-admin user permission issues HOT 6
- [12.0] Show distributed data if distributed analytic labels are used. HOT 6
- [14.0] issue with source type "Sum Columns" in mis reports HOT 2
- Do not to show the empty column when filter is in effect HOT 1
- Multi-line expression does not work HOT 1
- [15.0] mis.committed.purchase not deleted when PO is reset to draft
- [15] Cannot add a comparison column like Actual - Commited HOT 2
- MIS budget: Invalid field 'user_type_id.include_initial_balance' in leaf HOT 10
- Migration to version 16.0 HOT 2
- Question: CI for detect unreleased dependencies is working in non oca repos?
- [14.0] MIS Budget: Invalid field account.move.line.payment_state in leaf ('payment_state', '=', 'paid') HOT 17
- Add **Undefined** to Analtyic Account Filter HOT 2
- Better error message when using invalid domains in expressions or analytic filters HOT 1
- [15.0] mis_builder: not included all transaction during selected period. HOT 1
- Can not update a multi kpi from the kpi line HOT 4
- [16.0] mis_builder: hide mis.report.kpi in report when no data to show HOT 3
- Migration to version 17.0 HOT 4
- Error MIS BUILDER in odoo 16 (Docker) HOT 7
- Error when uninstall mis_builder HOT 2
- [v16] Question -- No more "account analytic" in account_move_line, will the analytic_distribution can be used as account_move_line domain filter?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mis-builder.