I need help marking invoices which are a duplicate, It should be marked in M-files if the vendor number & invoice number is the same with another incoming invoice, that it is a duplicate, how do I implement this ? Property Calculator ? And what would that look like ? Thank you.
There is no single Property Calculator rule that would do this but you can combine rules to implement similar functionality.
For example structure below would add list of duplicate items to new object.
Condition: Version = 1 makes this calculation to happen only when object is created.
Calculation itself requires 2 parts:
1. Search duplicate invoices and save them to multi select lookup property (Duplicate Invoices -property in picture)
- Objects which vendor number and invoice number are same as created object.
- You might also want to restrict results to some specific class etc.
2. Depending on event handler used, search might find also object itself. You probably want to filter it out from list. That can be done for example by comparing internal ID:s of object. There is example configuration in picture.
This "Duplicate invoices" list can then be used in view conditions, in searches, to trigger email notification, to set separate "Duplicate" boolean property etc.
There is no single Property Calculator rule that would do this but you can combine rules to implement similar functionality.
For example structure below would add list of duplicate items to new object.
Condition: Version = 1 makes this calculation to happen only when object is created.
Calculation itself requires 2 parts:
1. Search duplicate invoices and save them to multi select lookup property (Duplicate Invoices -property in picture)
- Objects which vendor number and invoice number are same as created object.
- You might also want to restrict results to some specific class etc.
2. Depending on event handler used, search might find also object itself. You probably want to filter it out from list. That can be done for example by comparing internal ID:s of object. There is example configuration in picture.
This "Duplicate invoices" list can then be used in view conditions, in searches, to trigger email notification, to set separate "Duplicate" boolean property etc.
© 2024 M-Files, All Rights Reserved.
