You’re offline. This is a read only version of the page.
Hello,
Using Smartlist Builder, I created the following Smartlist:
Sales Trans History --------> (Linked by Customer Number) ME Batch Invoice_MSTR_HDR ------> (Linked by Contract Number) ME_Batch_Invoice_MSTR_DTL
I'm trying to pull Sales Records, linking it to Recurring Billing Contracts by Customer Number and Line Items on those Contracts so that I can bring billing frequency into the Sales Transaction Query. It seems to pull duplicate records in some cases where a Recurring Contract has more than one Line Item. For example, if a customer has a Contract containing two line items that were both billed on the same day, it will duplicate both line items so that the customer has four line items. Does anyone have any ideas that I can look into on why this might be the case? Is it more likely that it is an issue with the Smartlist Design and Table Linkage, or the way I refine the query via the dropdowns in the Smartlist Query?
Thanks for your help
Collin
*This post is locked for comments
The way that I have done this before is the following:
Hope that helps.
Hi,
I haven't had the chance to look at this specifically, but when it happens to me it is problem with how I've linked the tables together. You may need to link them using more than one field.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (