Automatically display the dimensions as we select the batch

vyanku

Hi,
I create a batches for different sites. I also create dimensions for different sites. I apply restrictions on the posting of general journal for entering dimension and it is working verywell.
Now problem is client want that when he select the batch of perticular site then dimension of that perticular site should be display in the posting line automatically.
So I create field "dimension" in "General Journal Batch' table and apply lookup property to "Shourtcut dimension 1" field in "Gen. Jnl. Line" table Then it shows me dimension of that perticular batch. But when I post that line It will not display in any ledger entry. ](*,)
It will display only when we insert dimension manually. ](*,)
What should I do to solve this problem???
Any suggession please........ [-o<

Mbad

Sounds like your field doesnt get populated. Do you end your lookup by setting global dim1 (or shortcut dim 1) = Your lookup data? Basicly you should end your lookup with text = SomeData.

vyanku

How can I end my lookup?

the property of the field in Gen. Jnl. Table is like this

Lookup("Gen. Journal Batch"."SBU-Project code" WHERE (Name=FIELD(Journal Batch Name)))

vyanku

Basicly you should end your lookup with text = SomeData.

Will u please explain this???