Open and close data input in DP.

[Former Member]

Hi,

We have two periods in the future (actual and next) and we need open and close

actual year for input with macros.

We have built two macros to open and close actual year for input. The macro

to close the input is working OK (COL_INPUT( 0 )). the macro to open the input (COL_INPUT( 1 )) works OK too,

but the color doesn´t change, It goes on in grey color instead of white color.

We have used some operators (ROW_BG(), ROW_FG()...) to try to change the color but doesn´t change.

Did you Know how to bulid the macro to open actual year changing to white color?

Thanks in advance.

Raúl.

[Former Member]

do you mean it is grey but you can still enter data?

check what your "input from" date is on the planning book design(data view tab)

I have seen this happen too... But, since you are using the column input macro you can let your input from be right from the beginning and use the macro to make it open and closed at the relevant years(means you set the column_input (0) for history too

the KF that should not be edited is set in the setting "output only"

[Former Member]

Yes, it is grey but i can enter data.

I have done an example with years in future and do the same (the color goes on grey and doesn´t change to white).

The KF is setting "input/output" in the planning book.

Thanks,

Raul.

[Former Member]

btw, am not sure if you need two macros

you just need one col_input(0) to close the periods you dont want to enter data. The rest of the columns will be open anyhow

[Former Member]

Hi

Have you set the rows to input/output in the planning book definition?