I've customized the Sales by Customer report to sh...
# accountingm
MaryPeace
11/14/2019, 10:16 PMI've customized the Sales by Customer report to show/exclude some thing we want to see. The output insists on showing duplicates of some lines, and I can' figure out why. I can export and remove duplicates in Excel, but I'd prefer the report to be correct in the first place. Any thoughts on what criteria I'm missing?
j
Jon Kears
11/14/2019, 10:27 PMit's likely one of the fields you've added is causing the duplication. Can you give a list of the extra fields you've put in?
m
MaryPeace
11/14/2019, 10:31 PMI just reviewed the canned report to my report and it seems ( i created this months ago) I changed them all...
MaryPeace
11/14/2019, 10:32 PMmessage has been deleted
k
KevinJ of Kansas
11/14/2019, 10:51 PMIt's your address fields - it's including the billing address and the shipping address
KevinJ of Kansas
11/14/2019, 10:52 PMTry including just shipping address fields.
KevinJ of Kansas
11/14/2019, 10:52 PMYou're just getting "lucky" here that the billing address and shipping address have the same state/zip
KevinJ of Kansas
11/14/2019, 10:52 PMSo it looks like duplication, when it's really not.
m
MaryPeace
11/15/2019, 4:10 PMit IS duplication in my report
MaryPeace
11/15/2019, 4:12 PMAnd removing the billing address in my report did not correct the duplicate line
MaryPeace
11/15/2019, 4:13 PMmessage has been deleted
MaryPeace
11/15/2019, 4:13 PMbut nice thought.
k
KevinJ of Kansas
11/15/2019, 4:41 PMMaybe remove quantity?
2 Views