Share
Report
5We have a SmartList that was created in an older version of GP showing all of our open orders and if PO's have been created for each sales line. We now have GP 2010 and when we run the report where we have it pulling the Promised Date from the PO if there is no date in there it pulls over as 1/1/1900. This field never had anything in it so when we did a Find/Replace for =DATE(1900,1,1) and the replacement was NO ESD it would only put the replacement in the lines that had the date. However, now it is putting it in every line as every line has that date.
Is there something we need to do in GP SmartList so if there is no PO's linked to that particular sales line no date goes into the export of the SmartList?
Any help would be greatly appreciated.
Kim
*This post is locked for comments
All responses (
Answers (
