Changing the dimension values

Hello!

I've created a new Code-type field in the General Ledger Setup table. I've also previously created a table "Author" for creating authors for books with all kinds of fields. There is a Code-type field "Sign", which represents the Author by "AB", "CD", etc.
1) By creating a new author with a Sign, the Code-type field in the GLS table should automatically change to be the same.
2) Also, changing the author's sign should also change the dimension sign value in the Default Dimensions page.
3) Choosing an author for created items (books), the Default Dimensions field dimension sign value should also automatically change. Removing or emptying the author field for a created book should also empty the Default Dimensions field "dimension sign value".

Any suggestions/directions, how to do this?

Best Answer

Answers

  • allenyyzhouallenyyzhou Member Posts: 142
    Hi,

    What is the purpose of the Code-type field in GL Setup table?
  • siimsandsiimsand Member Posts: 28
    Hi,

    What is the purpose of the Code-type field in GL Setup table?

    The purpose of it is to contain the Code-type sign of the dimension.
  • kvbkvb Member Posts: 107
    siimsand wrote: »
    Hi,

    What is the purpose of the Code-type field in GL Setup table?

    The purpose of it is to contain the Code-type sign of the dimension.

    You have a lot of authors and only one record in GLS.

    What is the purpose of the Code-type field in GL Setup table?
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    Do you mean that the "Code-type field" content in the GL Setup table is supposed to keep the default value for your dimension and its content is supposed to be copied automatically FROM the G/L table TO the Author record?

    From your description, it looks like the data is supposed to flow FROM the Author record (and you can have many of them) TO the G/L Setup table - where there is usually only one record. In effect, in your G/L Setup table, you would have only one dimension value remembered, and that would be the dimension entered on the most recent Author record created.

    Or maybe you want to build a table where you can store all unique dimension values entered on Author record?
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • siimsandsiimsand Member Posts: 28
    edited 2018-01-03
    Do you mean that the "Code-type field" content in the GL Setup table is supposed to keep the default value for your dimension and its content is supposed to be copied automatically FROM the G/L table TO the Author record?

    From your description, it looks like the data is supposed to flow FROM the Author record (and you can have many of them) TO the G/L Setup table - where there is usually only one record. In effect, in your G/L Setup table, you would have only one dimension value remembered, and that would be the dimension entered on the most recent Author record created.

    Or maybe you want to build a table where you can store all unique dimension values entered on Author record?

    Yes, that is exactly what I mean. But no additional tables need to be created.
  • siimsandsiimsand Member Posts: 28
    This was not a Yes/No question.

    Which functionality are you interested in?

    1. A default dimension from G/L Setup field transferred to new Author?
    2. The last dimension used on Author remembered in G/L Setup field?
    3. A table with all unique dimensions assigned to Author record?

    The number 1.
Sign In or Register to comment.