Hi All,
I am looking at using the "Save Settings" option for reports to generate "repeatable" routines for the users.
To give you some context, I am dealing with the "Phys. Inventory Journal", and my requirement is specifically around report Object 790 (Calculate Inventory). We have a large number of different ways users need to run this, depending on the location and material type they are counting. I have saved each of the configurations, and they are available in the drop down on the request page.
The issue is that the "Posting Date" is saved within the settings, and as soon as you select the saved settings, all options change to read only / non editable. Running the calculation with the wrong date is obviously not of any use.
The work around for the users is to run the "Calculate inventory" with the saved settings, then rerun it with "Last Used Settings" and then edit the posting date. Obviously this is not ideal, especially with the queries returning large data sets.
Can anyone point me in the direction of how to set the fields on the request page to editable after the saved settings have been selected?
Thanks
Jordan
0
Answers
I have looked at CU 1590 - request page parameters helper and at table 2000000196 - object options. but havent found a way so far to load the saved settings from the blob field of the object options table to the request page of the report and make them editable afterwards.
Does anyone have an idea of how to come around?