Method:Classic General Q&A

Re: Lookup Unit of Measure In Grid

Blake C — Sat, 31 Dec 2011 16:28:34 GMT

Without knowing the inner technical workings of how Method develops it's stack, I could only speculate on efficiency. In our case, either way it's a lookup...whether it's through a linked field (your solution) or looking up the information upon Item selection (mine).

The linked field is a better overall solution b/c it doesn't require custom actions to achieve the same result...something I didn't think about at the time. I seem to forget about those Linked Fields.

Re: Lookup Unit of Measure In Grid

fran — Fri, 30 Dec 2011 12:11:38 GMT

Blake,

I was also having a sync error with unit of measure... I have come to conclusion I do not like UOM. I finally ended up adding a linked field to the item table for the base abbrevitation...my conflict error went away for this.

So....which approach is more efficient for searching; usage, etc or does it matter...

doing a lookup for the value from the item table...

or adding the value as a linked field to the item table. then grabbing the data from the item table.

Fran

Re: Lookup Unit of Measure In Grid

Blake C — Mon, 05 Dec 2011 21:41:40 GMT

Thought I would share an update on getting UOM on my Estimate and SO line items working correctly...

When syncing with QB, Method was having a conflict trying to map 'By the bag' or 'By the gallon' UOM. It was trying to map and sync the UOM on an Item using these phrases rather than the 'bag' or 'gallon' abbreviations.

I had to do a lookup of the UnitofMeasureSet_RecID for the line item, then get the UOMSet BaseUnitName as the value to insert into the line item UOM. This successfully mapped to QB.

Hope this info is useful to others.

Re: Lookup Unit of Measure In Grid

Blake C — Wed, 30 Nov 2011 16:52:47 GMT

Thx, the where clause really is what I was looking for...it just wasn't obvious to me for some reason.

I'll give it a shot.

Thx.

Re: Lookup Unit of Measure In Grid

Method_Michael — Wed, 30 Nov 2011 15:41:11 GMT

Blake-

You would have to edit the Estimate/Sales Order/Invoice screen and edit the Text Changed Event on the Item from down on the grid.

You would probably only need to add 1 action Retrieve Value From table , (Retrieve UnitOfMeasure from Item table where FullName = Value from Screen Item) and then enter it into a field.

-Michael

Lookup Unit of Measure In Grid

Blake C — Tue, 29 Nov 2011 23:15:28 GMT

I want to add to the action that fires when an Item (most of my items come from ItemInventory) is selected for an Estimate/SalesOrder/Invoice line item.

What I want to do is have a particular item's Unit of Measure inserted on the line item.

It seems I need to do a lookup but I'm just not sure exactly what values I need and where they come from.

Anyone done this?

Thanks,

Blake C.