Sage 100

Hi All,

Is there anyway to add a field to a report screen. 

I am looking to add the Sales Order Number on the BM-Component Requirement Report - preferably the grid.

Thanks. Jacquie

------------------------------
Jacqueline Hoyte
Director of Client Services
Integrated Data Technology, Inc.
------------------------------

I've written scripts to load the grid with bills based on a shortage analysis. A similar script could source bills from a sales order. The grid isn't modified. The script runs externally and loads the grid behind the scene. The report can then be run by the script or manually.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-224-6642
------------------------------

To have that report allow a user to filter by sales order numbers, it would require MD customization because that report doesn't even include any code to look at SO_SalesOrderDetail.

If you were to do an inner join on the bill number being equal to the item code in SO_SalesOrderDetail, you could use a run time parameter in the crystal report for the report setting to filter for one or more sales orders.  You would like have to change the grouping and sorting to make sure you get accurate report results because the original record in the work table will be duplicated for each record that matches in SO_SalesOrderDetail.  The SalesOrderNo and LineKey will make the records unique.

------------------------------
David Speck II
Blytheco LLC
------------------------------