Isolate which of those lines actually results in the error, by placing a BRApi.ErrorLog.LogMessage call in between each. I'd also check your variable types, they look confused - you take a CellAmount (Decimal) and put it in a String variable, then convert it to Integer, then store it in a Decimal...?
I agree with MikeG that could be done more easily with the proper Scenario property. If you really want to give the user control of that property, just build a Dashboard that will modify that property.
Hi Jack,
Thanks for the responce.
I tried initially with Integer and it didn't work. Then was playing with other data types.
Currently we are handling handling through Text 3 and changing the metadata scenario property to the number of periods required.
The actual seeding periods into Forecast scenario will vary from time to time in our application, and we don't want to update the Scenario metadata properties, because we need to follow a huge change management process.
I will try to use the error log and see if it gives anythings.
