Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
How can you build a filter that compares two fields with each other?
Example:
Filter on "qty_received" not equal to "product_qty"
The aim is to display all order lines that have not been delivered or not fully delivered. In my opinion, the model would be "Purchase Order Line".
In the PO overview you can see the delivery status, which is great, but I need this at purchase order line level for each individual product ordered, hence the above model.
Hello,
Go to Purchase > Reporting > Purchase
Use the Pivot view
Set the Measures like following:
Click on Insert in Spreadsheet
Add a new column and add the formula like the following:
You can filter only the FALSE and easily see what is not received
So, without any customization, you can achieve this
You can add a compute boolean field in
Purchase order line model
this field set to true if qty_received & product_qty are equal.
then filter records that have true/false value in boolean field
That sounds good! @all: many thanks
Yes, I realize that - but how can I set a filter on this table in the way described? I have hundreds of purchase transactions and don't want to go through them all individually.
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
1
janv. 24
|
1924 | ||
|
1
oct. 23
|
2135 | ||
|
|
1
sept. 23
|
1905 | ||
|
0
févr. 23
|
2703 | ||
|
3
août 23
|
2902 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
If you are going to the Purchase > Reporting > Purchase, you can select "Measures" to see the QTY Received or Billed etc and you can compare the lines