Adding an Existing Field to the Selection Criteria

Question

I want to add a field (Ship Via) to be available in the Selection Criteria Window when running the "Sales Order Printing" Report. I saw in one of the Forums that i have to add an UDF to the Report for it to show up in the Selections. I added that Field as an UDF but it is still not showing up in the Selections. (the field does show up on the report though) 
 Can anyone please help me? 
 See the screenshots below

Kevin M · Accepted Answer

Adding to the work table doesn't affect the selection grid. You have to add a field to the report's parent table. For SO printing, add a field to SO_SalesOrderHeader. 
 Before you ask, Sage restricts the stock fields available in Selection... so if you want something like ShipExpireDate or ShipVia, you'd need a UDF and script to mirror the Sage field value into the UDF.

Sage 100

Adding an Existing Field to the Selection Criteria

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING