Sales Order and Qoute History Report

Question

Hello... I'm attempting to duplicate the standard report Sales Order and Quote History Report but changing some of the fields that display. I want to replace Unit of Measure with Prod Line. So created a new Report Setting named PRODUCT LINE.. then remove the unit of measure field from report then added Prod line.. When I do a preview within Crystal the new field shows however when I actually run the report no data displays. So I went back and ran the STANDARD report with same report criteria and it did show data. 
 
 I must have missed a step or two but why does no data display for new report??? 
 
 Thanks much for any help.. 
 
 Bob

Bob@TED · Accepted Answer

So that was it... I did have the CI_Item table added so I removed it then created the UDF then added it to report and now I see the data on the report. Thanks for the help gents..

Kevin M · Answer

Does your report have any tables other than the work table? (Don't do that... add a UDF to the work table instead, like BigLouie advised). 
 Did you change the report's data source? (Reports run from within Sage need the report's data source to be configured correctly). 
 Both of those things can easily break a report's functionality. 
 Are you using SQL / Premium? Or Standard / Advanced?

Sage 100

Sales Order and Qoute History Report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING