Retrospective Product Valuation - Transaction Date Greyed out for the TO

SOLVED

Hello,

In my preview the Transaction date is greyed out for the from date to be To (Inclusive). 

In my instance I am able to amend the from date. Can anyone tell me how to make that from date available ? 

Thank-you

Tracy 

Parents
  • 0
    SUGGESTED

    That cannot be changed as it is hard coded in to the report to be 'To (inclusive)' as otherwise the report could be missing historical data and the calculations in it would be incorrect.

    You could go to Report -> Criteria, remove the existing criteria for STOCK_TRAN.DATE and then add a new one of the same field as this would then allow you to chose a different date range type at run time. However note that if you do this the above will apply and the calculations may be inaccurate depending on the specific dates you apply.

    Hope that helps.

Reply
  • 0
    SUGGESTED

    That cannot be changed as it is hard coded in to the report to be 'To (inclusive)' as otherwise the report could be missing historical data and the calculations in it would be incorrect.

    You could go to Report -> Criteria, remove the existing criteria for STOCK_TRAN.DATE and then add a new one of the same field as this would then allow you to chose a different date range type at run time. However note that if you do this the above will apply and the calculations may be inaccurate depending on the specific dates you apply.

    Hope that helps.

Children