Hi,
Is it possible to identify duplicate entries through a generic inquiry, If possible could you please provide a quick guide to detect the duplicate.
Example - Customer order number in the invoices and memos form can be duplicated. I need to generate a generic inquiry which picks only the invoices with duplicated Customer order number.
Thanks,
Dulanjana
Best answer by Laura03
Yes, in a Generic Inquiry we can count a specific field using the Aggregate column, Grouping tab, and we can filter on the Count of Customer Order Number, for example, Count Order Number > 1. I created this example:
+19Yes, in a Generic Inquiry we can count a specific field using the Aggregate column, Grouping tab, and we can filter on the Count of Customer Order Number, for example, Count Order Number > 1. I created this example:
Hi Laura,
This is exactly what I am trying to do but if you Group on the filed you are counting aren’t you always going to get 1 for an Answer on the count? A Least that is what I am getting.
Thanks,
Mark
You’re correct. You shouldn’t count the same field you’re grouping by. Group by the field you’re checking for duplicates in and then count by the primary record ID.
My situation: Expense Receipts were being created by import scenario AND manually. Because of this, auto-numbering is enabled but I needed a way to identify duplicate entries for receipts created by import scenario. I used the transaction ID (unique from credit card statement) mapped to Ref. Nbr. (EPExpenseClaimDetails.ExpenseRefNbr, optional field). Because it’s optional and not a key field, Acumatica let’s you use the same Ref. Nbr. for different receipts.
In the generic inquiry: Group by ExpenseRefNbr and COUNT ClaimDetailCD. This counts how many expense receipts have the same ExpenseRefNbr.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
