I've gone through several lines on the gross margin report vs my Atlas report. For every invoice that was not on my report, the sales order had the error message below in yellow.
It appears to happen if an address gets updated or removed. Sometimes the delivery address is different on the header and the lines. I don't know if that has anything to do with it, but it was an observation.
So, now that I have tracked down the problem, I have no idea at this moment how to make report find an address that is no longer there.Anyway, is there another table that would be better for me to use that holds the original invoice information? Or a method to find all the sales orders where the address is no longer effective so we can fix them?Thanks in advance!Sam
from CustInvoiceTable ci
join LOGISTICSPOSTALADDRESS lpa
on ci.DELIVERYLOCATION = lpa.RECID
join LOGISTICSPOSTALADDRESS lpa2
on lpa2.[LOCATION] = lpa.[LOCATION] and lpa2.VALIDTO = '2154-12-31 23:59:59.000'
where lpa.VALIDTO < CURRENT_TIMESTAMP
If you've found this thread useful, dive deeper into User Group community content by role