Value from Different Table

Lamba · 2012-07-18

I have to flow a value from a custom table to Sales Quote report(Report Id-204).

The Scenario is :

As i go to the item card there is a custom field Shade.The lookup of the shade field opens a table.
There are two fields in shade table namely code and desc.
I have to flow the Shade's Description as per the corresponding item no. selected in the sales Quote line.

How it could be done.

mohana_cse06 · 2012-07-18

What did you try?

Lamba · 2012-07-18

I have tried with the following code on the Roundloop's OnAftergetRecord trigger:

Item.SETRANGE("No.","Sales Line"."No.");
Pack.SETRANGE(Pack.Code, Pack.Description);
IF Pack.FINDFIRST THEN
REPEAT
PackDesc :=Pack.Description;
UNTIL Pack.NEXT = 0;
MESSAGE('%1',PackDesc);

still the value in the Msg is blank.

mohana_cse06 · 2012-07-18

Lamba wrote:

Pack.SETRANGE(Pack.Code, Pack.Description);

What is the purpose of above code?

Lamba · 2012-07-18

I got it by the following code:

Item.RESET;
Item.GET("Sales Line"."No.");

Pack.RESET;
Pack.SETRANGE(Pack.Code,Item."Pack Code");
IF Pack.FINDFIRST THEN
PackDesc :=Pack.Description;

Thanx for your time.

mohana_cse06 · 2012-07-18

Lamba wrote:

Item.RESET;
Item.GET("Sales Line"."No.");

No need to use RESET with GET..

What if the Sales Line type is Resource or G/L Account? :-k

dans · 2012-07-18

it's also a good idea to check if sales line No. is blank or not.

Value from Different Table

Comments

Categories