Changing the dimension values

siimsand
siimsand Member Posts: 28
in NAV/Navision Classic Client
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

  • allenyyzhou
    allenyyzhou Member Posts: 142
    Hi,

    What is the purpose of the Code-type field in GL Setup table？
  • siimsand
    siimsand Member Posts: 28
    allenyyzhou 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.
  • kvb
    kvb Member Posts: 107
    siimsand wrote: »
    allenyyzhou 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_Guzek
    Slawek_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
  • siimsand
    siimsand Member Posts: 28
    edited 2018-01-03
    Slawek_Guzek wrote: »
    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.
  • siimsand
    siimsand Member Posts: 28
    Slawek_Guzek wrote: »
    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.

Categories