Dimension Description as a new field on pages

[jamieshepard]

I need to display the description of dimension values when they are selected on transaction pages (journal entries, purchase and sales lines). in other words, a new field that autopopulates the description of a code that is populated on the same line record.

What type of field do i create?
or what are the exact steps i need to get this working using only the simple object designer.

[hougaard]

You want a FlowField ... Subtype = Lookup

Check this: https://youtu.be/gnq2PUSozDU

The table you need to lookup into is the Dimension Value table.

[jamieshepard]

Beautiful! Thanks for such a prompt response.

[A picture containing drawing Description automatically generated]https://synoptek.com/ Jamie Constantine Senior Functional Consultant: Delivery, Dynamics 365 Business Central 570.878.1722 m @.https://twitter.com/Synoptek @. https://www.facebook.com/synoptekservice/ @.*** https://www.linkedin.com/company/synoptek/ The information in this email, and any attachments, may contain confidential information and is intended solely for the attention and use of the named addressee(s). It must not be disclosed to any person(s) without authorization. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are not authorized to, and must not, disclose, copy, distribute, or retain this message or any part of it. If you have received this communication in error, please notify the sender immediately.

From: Erik Hougaard @.> Sent: August 27, 2023 1:51 PM To: hougaard/Simple-Object-Designer @.> Cc: Jamie Constantine @.>; Author @.> Subject: Re: [hougaard/Simple-Object-Designer] Dimension Description as a new field on pages (Issue #275)

You want a FlowField ... Subtype = Lookup

Check this: https://youtu.be/gnq2PUSozDUhttps://urldefense.proofpoint.com/v2/url?u=https-3A__youtu.be_gnq2PUSozDU&d=DwQCaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=P9OnUFmASLscYNIydQeN7hNErTUYQHV3140konOQiIw&m=ucnccgtOlmfR8n13g47_hYBBansqkhb7TMNqdWeCnjp9m3nmcwtJO2FpggvbEbxo&s=yTHp6c9HmObCk0iWqCDtRKKMZu0-Zv-rk_s1dVQO0gE&e=

The table you need to lookup into is the Dimension Value table.

— Reply to this email directly, view it on GitHubhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_hougaard_Simple-2DObject-2DDesigner_issues_275-23issuecomment-2D1694724938&d=DwMCaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=P9OnUFmASLscYNIydQeN7hNErTUYQHV3140konOQiIw&m=ucnccgtOlmfR8n13g47_hYBBansqkhb7TMNqdWeCnjp9m3nmcwtJO2FpggvbEbxo&s=17PCkVOWurILuWIhE8rrJ86dEoYMjDaQ8dZyncjRDqg&e=, or unsubscribehttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_BCFUOUNZ6OV4VGREAUHAWQTXXOCILANCNFSM6AAAAAA4AORWEM&d=DwMCaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=P9OnUFmASLscYNIydQeN7hNErTUYQHV3140konOQiIw&m=ucnccgtOlmfR8n13g47_hYBBansqkhb7TMNqdWeCnjp9m3nmcwtJO2FpggvbEbxo&s=qzRcxVs8I_gO_2bAni6Xlm1gzWb1EPQV8Ixs5f6O6Ds&e=. You are receiving this because you authored the thread.Message ID: @.**@.>>

[jamieshepard]

oh, so close. The plot thickens..... want to have the dimension name for all 8 of the dimensions. As the global dimensions are the only real fields on purchase line table, i can get those dimension names to populate. Thank you!

Any ideas for how to get the shortcut dimensions? it seems like a multi- table flowfield then lookup. 'Find dimension code from dimension set ID table, then find the dimension code name from the dimension value table'. Or should i create a new fields on the purchase line that creates the shortcut dimensions as real fields, then create an additional new field that uses the new code field to find the dimension name?

[hougaard]

You're out of luck right now, the two-steps-over lookup cannot be accomplished without writing code :(

(I'm considering adding something to calculated fields for that, but so far just in the ideas phase)

You can of course create new fields, but that would become double values as those fields would have to maintained manually..