This article discusses how to change project (job) planning dates in Graphical Scheduler from Insight Works for Business Central.
Job/Project Planning Lines describe the resources, items, and expenses planned for a project task, including their quantities and planning dates. Newer versions of Business Central use Project terminology instead of Job.
This example displays resource planning lines with resources down the left side and Planning Date across the top. Dragging a line to another date updates its Planning Date. The resource assignment stays the same in this example.
This configuration uses the “Anything” data source.
If you want to change the assigned resource and also the planning date then you can use the “Job Planning Lines” data source instead to simplify the setup.
Create the View
- Open Graphical Scheduler, select View, and choose New.
- Enter EXAMPLE PLANNING LINES in No. and Planning Lines in Description.
- Under Configure What Displays In This View, select Add a Data Source, then Anything (any custom table).
- Use the lookup in Table No. to select Job Planning Line / Project Planning Line (table 1003).
- Under When Is It, confirm Starting Date-Time is set to Planning Date. This should populate automatically.
- Under Where Is It, confirm the automatically populated Capacity Type and Capacity No. mappings use the planning line’s Type and No., and Show In uses the resource tree.
- Under Writing Changes (general), set:
- Allowing Changes: Allow Writes
- Write Validation: Validate
- In the What Order To Change Fields When Writing section that appears, add one rule:
- Sort Order: 10
- Field to Write: Starting Date and Time
- Validation: Validate
This rule updates Planning Date, as mapped in step 5. Leave Capacity No. out of the write rules to keep resource assignments unchanged.
- Close Anything Configuration. Back on the view card, delete the default Production data source so this view displays only planning lines.
- Close the view card, select your new view in the views list, and choose OK.
Display and Reschedule Planning Lines
- Open a Project/Job Card and select Project/Job Planning Lines.
- Create or select planning lines with Type = Resource, a resource in No., and a Planning Date within the scheduler’s displayed date range.
- Return to Graphical Scheduler and select Refresh.
- Drag a planning line horizontally to another date, then check the underlying planning line to confirm its Planning Date changed.
Note: Setting Allow Writes alone is insufficient. The write rule specifies which field Graphical Scheduler can change.
Alternatively the “Job Planning Lines” data source option that is available in the “Add a Data Source” step could be used, which will by default allow both the planning date and the resource to change.
Still need help?
Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.