{"id":535,"date":"2019-03-03T18:42:00","date_gmt":"2019-03-03T18:42:00","guid":{"rendered":"https:\/\/builder-help.gjgardner.com\/?page_id=535"},"modified":"2020-12-18T21:24:05","modified_gmt":"2020-12-18T21:24:05","slug":"franchise-scheduled-tasks","status":"publish","type":"ht_kb","link":"http:\/\/help.gjgardner.com\/nz\/hc\/getting-started\/franchise-scheduled-tasks\/","title":{"rendered":"Franchise Scheduled Tasks"},"content":{"rendered":"<h1><b>Scheduled Tasks<\/b><\/h1>\n<p><span style=\"font-weight: 400;\">The system performs a set of scheduled tasks on a regular basis. The following tasks are performed:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Delete &#8216;INACTIVE&#8217; users<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Send ToDo list daily<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Check Paypal overdue payment<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sub-contractor Warnings<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Bulk Update\/Recalculate<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Finalize Job(s)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Monthly Slab Report<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Monthly Sales Report<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job List Report<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Contracts Manager Update<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job Handover Report (Monthly)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job Scheduled Handover Date<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Builders Insurance Threshold<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Builders Insurance Expiry weekly<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Builders Insurance Expiry daily<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Supervisors Weekly Progress<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Synchronize with Xero<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Publish Price Book to WEB<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Send EoM Reports<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Perform current DB replication to Sandbox<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Calculate Average Cost of House Plan Estimates per month<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Send SMS\/Emails according to Milestone Events<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Automatic acceptance of Purchase Orders<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Send ToDo&#8217;s according to the triggers of Schedule Task<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Send Errors during Bulk Update or Scheduled Tasks Email<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Leads to WEB<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Contacts to WEB<\/span><\/li>\n<\/ul>\n<h2><b>Delete &#8216;Inactive&#8217; Users<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task is used for automatic deletion of user accounts being inactive for more than 30 days. In the result of execution of this task, the following actions are performed:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system deletes the user Google account.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system deletes the user Keycloak account.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system removes all the records about shared GDrive folders with the user account.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system sets the user account status as \u2018Deleted\u2019.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The task is performed sequentially in the following order:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for Corporate level<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for each Master Zone level<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for each Office level<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Send ToDo List daily<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task is used for the automatic sending of the Inbox ToDo tasks by email to all active users in the system. The system finds all the ToDo tasks that are due as of the current date or that are overdue, and includes them into the email with ToDo tasks. The system includes the subject of a ToDo task, its date and link to the task in the Inbox.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task is performed sequentially in the following order:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for Corporate level<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for each Master Zone level (for active only)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">for each Office level (for active only)<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Check PayPal overdue payment<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task checks transactions and blocks the Office if any overdue payment is detected. The system fetches all Master Zones from a specific region and checks all the active offices of the Franchisee type for overdue payments. If any overdue payment is found, the system sets the office status as \u2018Blocked\u2019. The system also sends the Office Blocked email.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This email is sent to the following recipients:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Users with the Franchisee system role from the office;<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">All users with the Master role from the Master Zone of the blocked office.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Sub-contractor warnings<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task generates ToDo tasks for contacts of Supplier\/Creditor type and the Sub-Contractor type with expired documents for legal work or documents that approach the expiration date. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system checks whether contacts of the Creditor\/Supplier type have any of the following legal documents with the expiration date within the next 14 days or already expired:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">contract end date<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Liability expiration date<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Insurance expiration date<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">License expiration date<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">The system generates ToDo tasks for each contact attribute which already expired or which approaches the expiration date. ToDo tasks are added to Inbox.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day<\/span><\/p>\n<h2><b>Finalize Jobs<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task finalizes Jobs that have been already completed or handed over within the time period exceeding the number of months specified in the System Variables.. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system sends an email with the report on finalized Jobs.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system looks up for Jobs (excluding all DPP Jobs) for each Office which has Jobs with no finalized date or the ones that were completed within the time period that exceeds the number of months for automatic job finalization. The number of months may vary depending on the Office settings.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The system also looks up for DPP Jobs with the blank Not Proceeding date which the last updated date exceeds the number of months for automatic DPP job finalization. The number of days may vary depending on the Office settings.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">The task performs the following:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For each found regular Job, the system sets the Finalized status and sets the Finalized Date as a current date.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For each found DPP Job, the system sets the Not Proceeding status and sets the Not Proceeding Date as a current date. The system sets the Will Not Complete status for the Sales Folder which this DPP Job attributed to.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The system also collects all the finalized Jobs and sets them as Not Proceeding Jobs. Additionally, the task sends the report on these jobs within an email to the general email box of the Office and to the Email recipients specified on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday<\/span><\/p>\n<h2><b>Monthly Slab Report<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task generates a PDF report on all the Jobs with the Slab Date within the reporting month. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system collects all the Jobs that meet any of the following criteria:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Slab Date or Initial Draw Date is within the previous month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Contract type is \u2018Display\/Show Home\u2019 and Slab Date or Initial Draw Date is within the 6-month interval as of the previous month.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Once the system collects all the Jobs and groups them per Office, it creates separate PDF files with the Monthly Slab\/Initial Cost Draw Report for each Office. Then the task sends it by email to the general email box of the Office and to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every 1st day of the month<\/span><\/p>\n<h2><b>Monthly Sales Report<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task generates the Monthly Sales Report on Jobs with the specified Sale Date and Council Approved Date. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task looks up for all Jobs which Sale Date or Council Approved Date falls into the previous month period. Then the task groups the found Jobs against the office they attribute to and generates a separate PDF report per each office. Then the task sends them by email to the general email box of the Office and to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every 7th day of the month<\/span><\/p>\n<h2><b>Job List Report<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task collects all Jobs (including finalized Jobs) of the specific office and generates a PDF report. Then the task sends them by email to the general email box of the Office and to the email recipients on the Master and Corporate levels. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every 1st day of the month<\/span><\/p>\n<h2><b>Job Handover Report (Monthly)<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task collects all Jobs (skipping Finalized Jobs) with the specified Handover Date that fall into the reporting period or Jobs that are identified as Due for Handover (having the Completion Date specified but with no Handover Date) and generates a PDF report. Then the task sends it by email to the general email box of the Office and to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task is performed sequentially for each office in the Active or Blocked state. The task creates a separate report per each office. The report is generated for the previous month.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every 3rd day of month<\/span><\/p>\n<h2><b>Job Scheduled Handover Date<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task collects all Job Schedule End Dates for all Jobs being in the construction state within the reporting period.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task is performed sequentially for each office in the Active or Blocked state. The task collects all Jobs per each office which meet any of the following criteria:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">State is neither Finalized nor Not Proceeding.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job Completed Date is either empty or specified but the Handover Date is empty.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job is under construction.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The report aggregates Job Schedule End Dates for all Jobs being In the Construction and in breakdown by week for the reporting period. Then the task sends it by email to the general email box of the Office and to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Thursday<\/span><\/p>\n<h2><b>Supervisor\u2019s Weekly Progress<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task collects and shows the progress on each Job on weekly basis. The generated PDF document is sent to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task is performed sequentially for each office in the Active or Blocked state. The task creates a separate report per each office. The system generates the report on Jobs that match the following criteria:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job has the Authority to Commence confirmation.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job has a supervisor assigned.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The Completed Date is either empty or specified but the Handover Date is empty and the State is neither Finalized not Not Proceeding.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Job is under Construction.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday \/ every last day of the month<\/span><\/p>\n<h2><b>Calculate Average Cost of House Plan Estimates per month<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task is gathering data for calculating the average cost of House Plan Estimates per Office. The calculated average cost of House Plan Estimates is further shown in the dashboard widget.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task is performed sequentially for each office in the Active or Blocked state. The task creates a separate report per each office on the first day of every month.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system pulls all active House Plans that are not used for Quick Quotes and for Sales Estimates. Then the system calculates the average cost of the found House Plans per office.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every 1st day of the month<\/span><\/p>\n<h2><b>Perform current DB replication to Sandbox<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task is used for replicating the current database stand to the Sandbox stand. This task is performed sequentially for each office in the Active or Blocked state. This task replicates the database dump of the Business Portal per each region and database of the Jasper Reporting Service database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every week (during the week-end)<\/span><\/p>\n<h2><b>Automatic acceptance of Purchase Orders<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task accepts pending Purchase Orders on the delivery date. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task finds all the Job Orders in the Pending status and additionally checks the following criteria:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Estimate Delivery is entered manually and the delivery date is older or equal to the current date.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Estimate Delivery is based on the Construction Schedule and the start date of the Cost Center task (which exists in the Job Estimate) is older or equal to the current date.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The task sets the Accepted status to all the found Purchase Orders.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Contracts Manager Update<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task sends the Contracts manager Updates to intranet. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system looks up for Jobs that were updated or created since the last synchronization. The system generates the XML file and publishes the Contracts Manager to the intranet. Additionally, the system requests generation of Monthly Contracts Manager Report in Jasper Reports system. Then the task sends it by email to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: <\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">every first day of the month;<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">on the 6th day of the month;<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">every Friday.<\/span><\/li>\n<\/ol>\n<h2><b>Builders Insurance Threshold<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task checks that the Available Builder\u2019s Insurance amounts are less than 10% of the insured amounts and sends an email with a PDF report with the reporting data to the email recipients on the Master and Corporate levels. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If the 12 Month Fixed Date policy reporting period is used, this task checks any of the following points:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Available Annual Aggregate Amount is less or equal to 10% of the Annual Aggregate Amount (excluding GST)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Available Incomplete Aggregate Amount is less or equal to 10% of Incomplete Aggregate Amount<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Available Number of Policies is less or equal to 10% of Number of Policies<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">If the 12 Month Rolling Date policy reporting period is used, this task checks that the Available Annual Aggregate Amount is less or equal to 10% of the Annual Aggregate Amount (excluding GST).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system generates the report on each office. Depending on the reporting method, the system requests generation of the Builder\u2019s Insurance Report or Builder\u2019s 12 Month Rolling Insurance Report. The system sends an email with the attached report by email.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday<\/span><\/p>\n<h2><b>Builder\u2019s Insurance Expiry weekly<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task checks whether the Office Builder\u2019s Insurance policy is about to expire or has already expired is expired and sends an email with a ToDo task on a weekly basis. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task checks that there is one month left before expiration of the Builder\u2019s Insurance Policy as of the current system date if the 12-month fixed date is used for the policy reporting method. If it has expired, the system creates an email with information about the office with the expired Builder\u2019s Insurance. This notification is sent to the email recipients on the Master and Corporate levels.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In addition to the email, a ToDo task is created for recipients specified on the Master and Corporate levels,<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday<\/span><\/p>\n<h2><b>Builder\u2019s Insurance Expiry daily<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task checks whether the Office Builder\u2019s Insurance is expired and sends an email with a ToDo tasks on a daily basis. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task checks that the Policy Start Date has not expired as of the current system date if the 12-month fixed date is used for the policy reporting method. If it has expired, the system creates an email with information about the office with the expired Builder\u2019s Insurance. In addition to the email, a ToDo task is created for recipients specified on the Master and Corporate levels,<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day<\/span><\/p>\n<h2><b>Synchronize with Xero<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task performs synchronization of records on the Builder Portal and Xero. This task is performed sequentially for each office in the Active or Blocked status with the configured integration with Xero.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task synchronizes the following things:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><b>Cost Centers<\/b><span style=\"font-weight: 400;\"> \u2013 synchronizes and updates Cost Centers in one direction &#8211; from Builder Portal to Xero. The task will do the following:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">create Cost Center Tracking Option in Xero if it was deleted manually in Xero by mistake.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">update the title of Tracking Option if needed.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">change the status of Tracking Option as \u201cArchived\u201d in Xero if the Cost Center was marked as deleted on the Builder Portal.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">delete or archive any Tracking Option created in Xero manually which should not be there as does not exist on the Builder Portal, &nbsp;<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><b>Job Number (tracking category)<\/b><span style=\"font-weight: 400;\"> \u2013 synchronizes and updates Jobs numbers in one direction &#8211; from Builder Portal to Xero. The task will do the following:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">create Job Tracking Option in Xero if it was deleted manually in Xero by mistake.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">update the title of Tracking Option if needed.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">change the status of Tracking Option as \u201cArchived\u201d in Xero if the Job was set as \u201cFinalized\u201d or \u201cNot Proceeding\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">delete or archive any Tracking Option created in Xero manually which should not be there as does not exist on the Builder Portal.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<ol>\n<li style=\"font-weight: 400;\"><b>Contacts <\/b><span style=\"font-weight: 400;\">\u2013 synchronizes contacts in both directions &#8211; from BP and Xero. For verifying the synchronization direction the system checks whether the updates were made and if the updates were made in both system the data of the latest update will be taken. All the contacts of the Customer or Supplier type that were created in Xero are also created in the system during the synchronization.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Invoices <\/b><span style=\"font-weight: 400;\">\u2013 synchronizes Invoices between the Builder Portal and Xero that are in the Not Synchronized status. The task additionally fetches Invoices in the ACCREC and ACCRECCREDIT types that were updated since the last synchronization time. The task creates new Invoices (with Positive or Negative Draw) in Xero. For verifying the synchronization status, the system compares the contact checksum in the Builder Portal with the contact checksum in Xero. All the Invoices that were created in Xero are also created in the system during the synchronization.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Overpayments <\/b><span style=\"font-weight: 400;\">\u2013 synchronizes Overpayments that are pending the receiving in Xero with the Builder Portal or the ones that were updated since the last synchronization time. The task also synchronizes Overpayments from Xero with the Builder Portal. For verifying the synchronization status, the system compares the overpayment checksum in the Builder Portal with the overpayment checksum in Xero.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Journals <\/b><span style=\"font-weight: 400;\">&#8211; synchronizes Journals per account ID between Xero and Builder Portal.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Publish Price Book to WEB<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task publishes the Price Book of the Web type to the intranet. This task is performed sequentially for each office in the Active or Blocked state with the configured integration with intranet.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task checks whether the automatic publishing of the Price Book is enabled for the office and stops execution of the task if integration is not configured. The task checks that the Price Book is released and not withdrawn.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task publishes the Price Book that has at least one House Plan that are liable for publication, ignoring the House Plans that are used for Quick Quotes and Sales Estimates. The task takes all the appropriate House Plans and generates the XML file for publishing it to the intranet. Additionally, the task checks the existence of Items and Components in the Price Books, so it prepares an XML file with the Cost Centers and an XML file with Items and Components for publishing. Once the XML files are generated, they are sent to intranet according to the configured integration with intranet. The last Published Date is updated per Office to show the current date<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: on the date configured in the <a href=\"\/nz\/setup\/system-variables\/setup-system-variables-estimating\/\" target=\"_blank\" rel=\"noopener noreferrer\">System Variables<\/a>.<\/span><\/p>\n<h2><b>Send EoM Reports<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task sends EoM reports for the previous month. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task generates separate reports per each Office in Jasper Reports and sends an email with the office-specific reports to the Corporate users, as follows:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Monthly Deposits<\/b><span style=\"font-weight: 400;\"> \u2013 report on the monthly deposits for the previous month everywhere.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Monthly Contracts<\/b><span style=\"font-weight: 400;\"> \u2013 report on the monthly contracts for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Job Profit \u2013 Finalized Jobs<\/b><span style=\"font-weight: 400;\"> \u2013 report on the job profit from finalized jobs for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Aged Receivables (Summary)<\/b><span style=\"font-weight: 400;\"> \u2013 report on Debtor&#8217;s balance according to the Jobs for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Profit on Finalized Jobs (YTD)<\/b><span style=\"font-weight: 400;\"> \u2013 report on the profit from Finalized Jobs for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Sales Profit Forecast (YTD)<\/b><span style=\"font-weight: 400;\"> \u2013 report on the Sales Profit Forecast for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Franchisee Monthly<\/b><span style=\"font-weight: 400;\"> \u2013 report on the performance of the Franchisee for the current month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Work in Progress<\/b><span style=\"font-weight: 400;\"> \u2013 report on the Jobs that have not been finalized or on Jobs in the Not Proceeding status.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Profit and Loss<\/b><span style=\"font-weight: 400;\"> &#8211; report on the profit and loss for the past month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Balance Sheet <\/b><span style=\"font-weight: 400;\">&#8211; balance sheet for the past month.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Executive Summary<\/b><span style=\"font-weight: 400;\"> &#8211; summary report on monthly totals and some common business ratios over the past month.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Frequency: on the 8th day of the month<\/span><\/p>\n<h2><b>Send ToDo&#8217;s according to the triggers of Schedule Task<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task creates ToDo\u2019s according to the triggers of the Schedule Task. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task finds ToDo\u2019s in Schedules that fire on the current date. The task checks whether these ToDo\u2019s meet any of the following criteria:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Relate to the Construction or Pre-Construction schedule, and that are used in the not finalized or proceeding Job.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Relate to Sales Schedule where the Sales Folder is active.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Relate to Warranty Schedule and the Job is proceeding.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The task generates ToDo\u2019s for specified users. In addition, it sends iCalendar files to the assigned active User Resource of the Schedule Task per each ToDo.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Send SMS\/Emails according to Milestone Events<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task sends SMS and email upon occurrence of the milestone event. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task detects criteria of milestone events and determines whether there any milestone events for sending an email or SMS. The task pulls the individual system role or the group system role on the behalf of which an email or SMS is sent from. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task considers which individual system role an SMS\/email is sent from, as follows:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">From Estimator, Supervisor, or Job Admin only Job-related date milestone events can be sent.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">From Salesperson: Quote related or Job-related milestone events can be sent.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">If SMS\/email is sent from a Group system role, all types of milestone events can be sent.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task determines the milestone event type. Afterwards the task determines who the notification is sent to:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Individual system role<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Group system role<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Customer<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Supplier<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">The tasks considers which individual system role an SMS\/email is sent to, as follows:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">To Estimator, Supervisor, Job Admin only Job-related milestone events can be sent.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">To Salesperson, either Quote related or Job-related milestone events can be sent.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">If SMS\/email is sent to a Group system role, all types of milestone events can be sent.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If SMS\/email is sent to a Customer, either Quote-related or Job-related milestone events can be sent.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If SMS\/email is sent to a Supplier, only subcontractor milestone events can be sent.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task creates an SMS or email based on the pre-defined template and adds it into the queue for sending.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Send Errors during Bulk Update or Scheduled Tasks Email<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task sends an email notification if an error during execution of bulk update or scheduled task occurs. This task is performed sequentially for each Office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This task looks up for the following:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">bulk update tasks that resulted in a failure with no attempts remained.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">scheduled tasks that resulted in a failure or partial success.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">The system sends an email with information about the error and the bulk update or scheduled task that was impacted by this issue. The email is sent from the current region support account to all the recipients from the Master zone.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The record about the task execution is tracked in the Scheduled Tasks Log.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every day (at night)<\/span><\/p>\n<h2><b>Leads Sales to WEB<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task transfers new Leads-Sales to web\/intranet. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task finds all Leads that have been created since the last synchronization for each Office individually. If the Contact <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then the system finds all Sales that have been completed since the last synchronization for each Office. If a Lead becomes a Sale within the same week, the system reports him\/her both as a Lead and a Sale.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The system groups the found Leads and Sales against the Referred By field. Afterwards, the task generates an XML file with Leads-Sales and counts the number of Sales and Leads. For each Sale and Lead, the task determines the reporting month and year based on the Sale Date and Added Date. If the Sale Date and Added Date fall in different months or years, two separate records in the file are created.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once the file is generated, the system uploads it to Intranet using the credentials specified in System Variables.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday<\/span><\/p>\n<h2><b>Contacts to WEB<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">This scheduled task transfers new Contacts to web\/intranet. This task is performed sequentially for each office in the Active or Blocked state.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The task finds all Contacts that have been created since the last synchronization for each Office individually. If the Contact has multiple Contact Types assigned, the system treats each Contact Type as a separate Contact.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then the system generates the Contacts XML file which includes the following information:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">External ID<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Contact Type Code<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Type<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Business Name (if applicable)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Last Name<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">First Name<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Addressee<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Street 1<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Street 2<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Suburb<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">State<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Postcode<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Local Authority<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Phone 1<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Phone 2<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Status (active\/inactive)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Mail Status (Y for Customer type, N for other types)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Last Contact Date<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Last Contact Reasons (SMS, Email, Doc, Meeting)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Fax<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Email<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For Contacts of the Customer type, additional information is retrieved:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Date of Birth<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Partner Name<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Partner Date of Birth<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Parent 1 Name<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Parent 2 Name<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Parent 1 &#8211; Date of Birth<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Parent 2 &#8211; Date of Birth<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kids<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For Contacts of the Creditor\/Supplier type, additional information is retrieved:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Provides (Supply, Install, Supply and Install)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Category<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Once the file is generated, the system uploads it to Intranet using the credentials specified in System Variables.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Frequency: every Friday<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Scheduled Tasks The system performs a set of scheduled tasks on a regular basis. The following tasks are performed: Delete &#8216;INACTIVE&#8217; users Send ToDo list daily Check Paypal overdue payment Sub-contractor Warnings Bulk Update\/Recalculate Finalize Job(s) Monthly Slab Report Monthly Sales Report Job List Report Contracts Manager Update Job Handover&#8230;<\/p>","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[7,95],"ht-kb-tag":[],"class_list":["post-535","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-getting-started","ht_kb_category-needs-update"],"_links":{"self":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/535"}],"collection":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":5,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/535\/revisions"}],"predecessor-version":[{"id":5677,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/535\/revisions\/5677"}],"wp:attachment":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/media?parent=535"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb-category?post=535"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb-tag?post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}