Adding Quote amount to vmbrowse.ini

unknown

Hi,

A user asked if it was possible to see the total Quote amount as a screen column when browsing through the quotes. When browsing through the quotes, data is coming from the QUOTE table. The quote amounts are contained in the QUOTE_PRICE table.  I recall way way back that by modifying vmbrowse.ini one could pull in fields outside of the default set of fields to choose from. Is this the best way to accomplish this task?  

I created an SQL view on the database containing 2 fields QUOTE_ID, and AMOUNT.   That's as far as I got.  Any help much appreciated.

unknown

Follow-up.  I was able to modify the vmbrowse.ini file by adding the following text in the Quote section:

[quote]
version=40
table=QUOTE,zv_QuoteAmount
title=Quotes
key1=ID
key2=ID
sort=ID
order=1
where=QUOTE.ID=zv_QuoteAmount.QUOTE_ID

Now when browsing through the Quotes a user can see the quote Amount 

The problem now is that when selecting a record it returns blank fields i.e. doesn't select a record.

Infor support was saying they couldn't help with this and were suggesting that I look into using Preferences. I haven't come across a similar situation where Preferences could help.