×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Deferred Reports reliability

Deferred Reports reliability

Deferred Reports reliability

(OP)
I've been asked to automate the inventory resets and MRP regens to run overnight.  I used the Macola deferred reports about 10 years ago and gave up because I couldn't get it to run more than a week without having to check on it - kind of defeated the purpose of a scheduled report.  I see that the scheduler has not changed in 10+ years and have also seen old threads on this issue, so I'm not optimistic that my deferred reports experience will be any different this time.  I guess I'm asking if anyone is successfully using deferred reports or if anyone has developed a working substitute.  I know this is not a high priority for Exact, but would it be too much to ask to have a services-type scheduler for deferred report processing?  

RE: Deferred Reports reliability

Your alternative on the resets is to write the SQL code to do this and schedule it as a SQL job in Enterprise Manager.  MRP Regen is a bit of a stretch for this though.

On regular reports, not processes like you are suggesting, there are a number of crystal report schedulers out there that are very affordable.  You'd need to recreate the report in Crystal but if you start with the ICR this is pretty easy.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Deferred Reports reliability

We use deferred reports to run the mrp merge and regen twice daily and it's pretty much just as you described. The processes may run fine for a couple days or a couple weeks before problems start. You might miss schedules for no reason and if the server reboots (ms update) while the "report" owner is logged in there is a good chance of the schedules magically deleting. Either way expect that Exact support will be of no help as the "scheduler was never meant to automate MRP processes".

We have gotten around it by training one of the planners here to create and automate the processes and to understand the report spooled to his printer at the end of the process.

Good luck.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close