Small and medium business | Business Central, N...

Add shortcut dimension value to purchase invoice line

(0) Share

Report

Posted on by kjjson

I am trying to get the dimension name/description to show up on the purchase line so that someone reviewing it and sees the description "Pensacola" instead of just the code "2000". I had followed the guidance from ZHU here https://yzhums.com/5007/ but when I tried to add the name to the table for Shortcut 3, but when I tried to go into table=39 to see if it was showing up on the table before adding it to the page, I get an error "A flow field is part of the query column list, this is not supported. So I am looking as to what I would need to change to this:

field(50102; "SubProperty"; text[50])

{

Caption = 'SubProperty';

FieldClass = FlowField;

Editable = false;

CalcFormula = lookup("Dimension Set Entry"."Dimension Value Name"

where("Dimension Set ID"= field("Dimension Set ID"), "Dimension Code" = const('SubProperty')));

}

All responses (4)

Answers (0)

kjjson on at

Like (0)

Report

RE: Add shortcut dimension value to purchase invoice line

Thanks again, however there are still a few issues. This appears to be for the caption, but what I am trying to do is to get the dimension value for the dimension code. So we have Shortcut Dimension 3 which is using a code of SubProperty. On the purchase invoice line, a user will select a SubProperty dimension of 2000 (or 1000, 3000, 4000, etc), and send the invoice on for approval. The approval user goes and sees a subproperty of 2000, but that doesn't mean a lot to them, and they want to see the actual value name of what 2000 relates to. I have been able to do it with Global Dimensions 1 and 2 through a flowfield to the Dimension Value table as those fields are in the Purchase Line table, but it doesn't appear that the shortcut dimension value is. Any guidance?
Suggested answer

Nitin Verma 21,081 Super User 2024 Season 1 on at

Like (0)

Report

RE: Add shortcut dimension value to purchase invoice line

See like this I mean, you need to check your requirement according to this.

field(50102; "SubProperty"; text[50])

{

CaptionClass = <YourDiemsnion nO. here>

tablerelation = "Dimension Value".Code WHERE (Global Dimension No.=CONST(1))

}
kjjson on at

Like (0)

Report

RE: Add shortcut dimension value to purchase invoice line

Nitin, I appreciate the response, but I do not understand what you mean with defining the captionclass and table relation property, especially on the Gen Journal line table when I am trying to get the dimension value "Name" onto the purchase invoice line.

Kevin
Suggested answer

Nitin Verma 21,081 Super User 2024 Season 1 on at

Like (0)

Report

RE: Add shortcut dimension value to purchase invoice line

Hi,

Instead of Flowfield, you can define the CaptionClass and Table relation property together in your field, for the reference you can check in Table ID -81, Gen. journal Line, Field ID - 24 and 25.

Thanks.