Skip to Content

Material ageing report

Hi Experts,

I need material ageing report on inventory cube.it should show from how many days material has been in storage location.

the report format should be like

0-30days   valuefor30days   31-60days  valuefor31-60days -----------  totalvalue.

please provide logic how to do this.

Regards,

Naveen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 31, 2014 at 12:26 PM

    Hi,

    For doing ageing reports need to have 2 dates ,

    Do  u have date field which contains relevant info  , difference will be based on system date or fixed date.

    Regards,

    Seshu.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 11:03 AM

    Hi Navneet,

    Check in the infocube, There is a dimension 'NET DUE DATE'.

    Make selection for key figure you want to show and use 'NET DUE DATE VARIABLE'.

    For example-0S_NETDUEDATE_R0

    0S_NETDUEDATE_R1

    0S_NETDUEDATE_R2

    0S_NETDUEDATE_R3

    0S_NETDUEDATE_R4.

    Regards

    Devesh

    Add comment
    10|10000 characters needed characters exceeded