I have an Open Purchase Orders report that is show...
# ask-stanley-ai
s
I have an Open Purchase Orders report that is showing duplicate POs, but only for some of them - what could be the reason for this? There are no line level fields
c
AI generated answer (using internal Slack threads):
****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The issue of duplicate Purchase Orders (POs) appearing in your report could be due to a number of reasons. Here are a few possibilities: 1. Extra Columns: If you have extra columns in your report, it might cause the report to display extra lines, which could appear as duplicate POs. Try removing the extra column or ungrouping it. 2. Address Fields: If you have included both billing and shipping address fields in your report, it might cause duplication. This is because the report might be including both the billing address and the shipping address for each PO. Try including just one type of address field. 3. Linked Fields: If you have linked fields in your report, it might cause duplication. For example, if you have linked the POs to Sales Orders, and you have both types of orders in your report, it might cause the POs to appear twice. 4. Special Orders: If you have special orders in your report, it might cause duplication. This is because special orders might be linked to POs, causing the POs to appear twice. Try filtering out the special orders. Remember, these are just possibilities. The actual reason might be different based on your specific situation and the way you have set up your report. You might need to experiment with different settings and filters to find the exact cause.
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844787657
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825561643
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825073302
Please provide your feedback on this answer.