Flexible Matrix like Forecast form

[Former Member]

I want to make a form which is almost the same as Forecast form in SAP B1.

It has to have the matrix of which columns are flexible and variable according to the selection of period.

On top of it the matrix has to be changed whether the view is Daily one or Weekly one or Monthly one.

Does anybody have an idea to build my codes to deal with the database structure and the User Defined Object?

[Former Member]

Hi,

Forecast form in B1 is quite complicated than some other forms. It will involve a few tables and a good design. If you have question from the beginning, my suggestion is to have more simpler projects before commit to this.

Thanks,

Gordon

[Former Member]

Can any expert give me some guide?