Method:Classic General Q&A

Re: Sales Order Line Grid - Item Dropdown 1st Column empty

robert.cowart — Mon, 28 Jul 2014 15:55:02 GMT

Greg,

Thanks! That worked.

Re: Sales Order Line Grid - Item Dropdown 1st Column empty

Method_Greg — Fri, 25 Jul 2014 16:08:00 GMT

Hello Robert,

Regerate your tables. First, exit out of the screen designer if you are currently in it. Navigate to Customize -> Tables / Fields and find three tables: Item, SalesOrderLine and SalesOrder. For each table, click the name to bring up the field list. Then click Finished Editing Fields. Go back to your screen designer for Sales Order. You should now see Full Name vis Item in the dropdown. Select it and click Save. You should be good to go.

Greg

Sales Order Line Grid - Item Dropdown 1st Column empty

robert.cowart — Fri, 25 Jul 2014 15:06:34 GMT

I need to add a filter to the Sales Order Line grid in the sales order screen. When I enter the Item column's Advanced dialog in the grid Wizard, the 1st column value is empty. After I add the filter I need then hit the Save & Close button, Method says: "Please select a value for 1st Column". There is no Item FullName value selectable in the 1st Column list. Thats effectively whats in the first column of the dropdown with this "empty" 1st column value in the out of the box form. Why is 1st column empty? The first available value in the 1st Column dropdown is ParentFullName via Item. This is not an Item value though so if I pick ParentFullName via Item, the dropdown stops displaying Items.FullNames list its supposed to. This seems broken to me. I need to add a filter that makes sure there is a description. There is existing IsActive filter but I need a "Description Is Not Empty" filter.

Why can't I exist the Advanced dialog on the grid object with an empty 1st column value? Its empty when I enter the dialog. Obviously the Item FullName is needing to be used but the Advanced dialog won't let me select it. Please fix this.