AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Auto generating scheduled users Expand / Collapse
Author
Message
Posted 1/2/2009 3:50:35 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/15/2009 5:52:04 PM
Posts: 33, Visits: 59
I have Ayanova setup to automatically generate a monthly workorder on the 1st for all customers.  We only want to have the one workorder to put everything on instead of 4 or 5 weekly ones every month for each customer.  Since we go onsite every week on the same day and time, is there a way to setup the Scheduled User and the start date/time and stop date/time so that it auto generates?  I don't want to have to do this 4 or 5 times for every customer every month. 
Post #4450
Posted 1/2/2009 3:56:55 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi Barney

I think what you mean is you want a workorder created that has more than one Item in it - each item having its own Scheduled User record for a different week of the month.

Take a look at the forum topic http://forum.ayanova.com/Topic4216-116-1.aspx

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4451
Posted 1/5/2009 5:11:28 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/15/2009 5:52:04 PM
Posts: 33, Visits: 59
In the link it says:

'In the first workorder item enter something like "1st week service" and in that workorder item create a Scheduled Users record with the Start Date same as the Next Service Date Sept 1 2008 8AM selecting the scheduled user and entering Stop Date of Sept 1 2008 9AM etc'

What will happen if I enter the 1st week PM Scheduled User Start date and Stop date as the Monday Sept 1st 2008 and set the desired day of the week to Wednesday?  Will it show up on the schedule as Monday Sept 1st or Wednesday Sept 3rd?

Post #4459
Posted 1/5/2009 6:27:19 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
PM's generate based on the Service Date.

So the first service workorder will generate on the Service Date specified with the Scheduled Users records set as you initially specified

And than the PM will update itself for the next Service Date to be on a Wednesday if that was the specific day of the week you specified. And will also update the Scheduled Users start date accordingly in relation to the Service Date as well.

So for example if you first create a PM with a specific Service Date of Sept 1 2008 with desired day of the week as Wednesday and the Scheduled User also for Sept 1 2008 and have it set to generate once a month, than the first service workorder generated would have a Service Date of September 1st as will the Scheduled User record as that is what you specified.

And once the first workorder is generated, than the PM will be updated by itself to a month later on the closest Wednesday following October 1st as will the Scheduled User record

And the next month after that workorder is generated the PM will be updated by itself to a month later on the closed Wednesday following November 1st which would be November 5th 2008 as would the Scheduled User record's Start date.

And so on.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4461
Posted 1/6/2009 12:35:06 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/15/2009 5:52:04 PM
Posts: 33, Visits: 59
I'll give it a try.  Another problem I ran into is now that I've created the additional items, when I print out the workorder, it shows the Item summary listed for all 4 weeks.  So it prints out the first week's Item summary followed by the Service Details, then it goes back to the Item summary 3 more times for the additional 3 weeks that I haven't gotten to yet since it's still the 1st week.  How can I prevent those additional 3 weeks from displaying in the print out?
Post #4463
Posted 1/6/2009 12:59:16 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi

A report template prints what its template has been set. If you have workorder item datafields, it will print all workorder items

What you could do is "tell" the report template in a script to only print based on something.

For example, you might create a script so that the workorder item band data only prints if the Workorder Item Status equates to certain text (that is one of your specific Workorder Item Statuses)

Or another example, you might create a script that if a certain field is empty, not to print. For example check out the Template section of this forum such as http://forum.ayanova.com/Topic3895-100-1.aspx?Highlight=onbeforeprint+script 

If you would like me to do this for you, please provide that as outlined in the forum topic http://forum.ayanova.com/Topic3447-100-1.aspx and I can provide a quote to do so.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4464
Posted 1/6/2009 1:33:08 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/15/2009 5:52:04 PM
Posts: 33, Visits: 59
When I try the script I get the following error:

There are errors in the following script(s):
Detail2.OnBeforePrint, line2: error CS0117: 'DevExpress.XtraReports.UI.DetailBand' does not contain a definition for 'GetCurrentColumnValue'

I made 2 changes: Detail2.GetCurrentColumnValue and also changed to (LT_WorkorderItem_Label_Summary") Here is what I have:

private void OnBeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{   string s=Convert.ToString(Detail2.GetCurrentColumnValue("LT_WorkorderItem_Label_Summary"));
                        if(string.IsNullOrEmpty(s))
                            {
                              e.Cancel=true;
                              return;
                            }
}

Post #4465
Posted 1/6/2009 1:37:12 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi

  1. Please post report template support questions in the Report Templates section of this forum for support with report templates.
  2. Reference this topic http://forum.ayanova.com/Topic4450-116-1.aspx#bm4465
  3. Also attach a copy of your report template that you have the question about
  4. And  identify the field or band you placed the script in
  5. And the error that you receive.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #4466
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 6:55pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.094. 7 queries. Compression Disabled.