Ageing Analysis - with bucket logic data source at Ms-Navision 5.00 Version

[vikasmahajan]

Dear All,

Does anybody have charts of calculating age wise outstanding of stock (Inventory ) logic from MS Navision System ,

Please share logic how to do this.

-----------------------------------------------------------------------------------------------------------------

Item Name            0-30     31-60    61-90    91-180    >180    Tot Inv Value

-----------------------------------------------------------------------------------------------------------------

Xyz                          10       20          40        7            3                    80

Vikas

[Gysbert_Wassenaar]

You can use the class function nested in an if statement:

Load

     if(Something>180,'>180', class(Something,30)) as BucketsOfSomething

     FieldX,

     FieldY,

     etc

From ...somewhere...