Changing the dimension values

siimsand

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?

Slawek_Guzek

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?

allenyyzhou

Hi,

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

siimsand

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

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

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?

siimsand

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.

Slawek_Guzek

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?

siimsand

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.