Giter Club home page Giter Club logo

Comments (4)

pasgou avatar pasgou commented on August 20, 2024

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')
Créer une requête
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:
Utiliser une requête (exemple)

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.

sbidoul avatar sbidoul commented on August 20, 2024

Clever solution.

from mis-builder.

pasgou avatar pasgou commented on August 20, 2024

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.

github-actions avatar github-actions commented on August 20, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.