{"id":946,"date":"2023-08-31T10:08:12","date_gmt":"2023-08-31T10:08:12","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=946"},"modified":"2025-04-14T07:54:52","modified_gmt":"2025-04-14T07:54:52","slug":"open-job-backlog","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/standard\/projectpro-basic\/open-job-backlog\/","title":{"rendered":"Ch 08 – Open Project Backlog"},"content":{"rendered":"

Contents<\/b><\/p>\n\n\n\n<\/tr>\n\n\n\n
INTRODUCTION<\/a><\/td>\n<\/tr>\n
OPEN PROJECT BACKLOG<\/a><\/td>\n<\/tr>\n
1. Projects Setup<\/a><\/td>\n<\/tr>\n
2. Process<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

INTRODUCTION<\/b><\/p>\n

Open Project Backlog indicates the billing value which has not been invoiced till date. This can be calculated by subtracting the Invoiced Price from the Contract Price. The Open Project Backlog can be created by running the batch for all projects or for a certain set of Projects. It can also be created by running the batch individually for each project.<\/p>\n

<\/a>OPEN PROJECT BACKLOG<\/b><\/p>\n

1. Projects Setup<\/b><\/p>\n

The Project Setup has two setups available for Open Project Backlog feature:<\/p>\n

a) Enable Project Backlog Feature<\/u> \u2013<\/b> If enabled, the closing of \u201cParent\u201d or \u201cMaster\u201d Projects will be dependent upon whether all its sub-level Projects are closed prior. The user will be alerted if there exists \u201cOpen\u201d sub-level Projects, preventing the closing until all sub-level Projects are set to \u201cCompleted\u201d. <\/p>\n

Note:<\/b><\/u> The \u201cManager Status\u201d of the project must be set to \u201cRunning\u201d, for it to be included in the open project backlog calculations.<\/em><\/p>\n

b) Include Sub-levels in Project Backlog Calcs<\/u> \u2013<\/b> If enabled, the Master Project will show combined value (Master + Sub-Levels) under the \u201cOpen Project Backlog\u201d column on the Projects list, while the sub-levels will be shown with their individual Backlog values as well.
\nNote:<\/b><\/u> The \u201cManager Status\u201d of the project must be set to \u201cRunning\u201d, for it to be included in the open project backlog calculations.<\/em><\/p>\n

\"null\"<\/p>\n

2. Process<\/b><\/p>\n

To demonstrate the functionality, a Project, a Change Order, and a Sub-Project is created with value $70,000, $15,000, and $5,000 respectively.<\/p>\n

\"null\"<\/p>\n

a) Conditions:<\/b><\/p>\n

For Updating the values under \u201cOpen Project Backlog\u201d column, certain conditions must be followed:<\/p>\n

1. \u201cManager Project Status\u201d field must be set to \u201cRunning\u201d on the General fast tab of the Project card.
\n2. \u201cStatus\u201d field must be set to \u201cOpen\u201d on the Constants\/Manager fast tab of the Project card.
\n3. The Open Project Backlog batch can be from,
\na) Project card ribbon, Actions → Run Open Project Backlog → Run Open Project Backlog
\nb) Search \u201cCalculate Open Project Backlog\u201d.<\/p>\n

\"null\"<\/p>\n

A window will open as below. The user can run the batch wide open for all projects or apply the filter for a specific project to update the values.<\/p>\n

\"null\"<\/p>\n

Apply the filters as required and click on OK to run the batch. If all the conditions mentioned above are fulfilled, then it will update the values in the \u201cOpen Project Backlog\u201d and column on Projects list.<\/p>\n

According to the example taken, certain billings were done and as per the formula for calculating the open project backlog (Contract Price \u2013 Invoiced Price),<\/p>\n

1. Master Project will show the Open Project Backlog value as $48,500, which includes the value of Master Project $40,000, Change Order $3,500, and Sub-Project $5,000.
\n2. The Open Project Backlog value for Master Project shows the combined value due to the Projects Setup \u201cInclude Sub-Levels in Project Backlog\u201d.
\n3. Along with this, the batch also updates the value in \u201cBillable\/Invoiced Difference\u201d column using the same formula. The only difference is that this column will always show the value for each individual project.<\/p>\n

\"null\"<\/p>\n

The details get updated on the Project card as well, see below highlighted.<\/p>\n

\"null\"<\/p>\n

Last Run Open Project Backlog Value \u2013<\/b> This is the same value that gets updated on the Projects list.<\/p>\n

Last Run Open Project Backlog \u2013<\/b> Specifies the date the Open Project Backlog batch was last run.<\/p>\n

Open Project Backlog Updated \u2013<\/b> Specifies if the open project backlog has been cleared for both the master and sub-level projects. This auto-sets to True, if Last Run Open Project Backlog Value field shows zero value on calculating the open project backlog.<\/p>\n

b) Closing a Project:<\/b><\/p>\n

As per the Projects Setup \u201cEnable Project Backlog Feature\u201d, you can close or update the Status to \u201cCompleted\u201d on a Master Project only if has no open sub-level projects available which have been run through by Open Project Backlog process.<\/p>\n

If still the user sets the status to \u201cCompleted\u201d, then for the Master Project system will give an error as below and will stop you from closing the project.<\/p>\n

\"null\"
\n
\n\"null\"
\n
\n\"null\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Contents INTRODUCTION OPEN PROJECT BACKLOG 1. Projects Setup 2. Process INTRODUCTION Open Project Backlog indicates the billing value which has not been invoiced till date. This can be calculated by subtracting the Invoiced Price from the Contract Price. The Open Project Backlog can be created by running the batch for all projects or for a … <\/p>\n

Continue reading “Ch 08 – Open Project Backlog”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,23,38],"tags":[],"class_list":["post-946","post","type-post","status-publish","format-standard","hentry","category-projectpro-basic","category-projectpro-basic-2","category-projectpro-basic-3","entry"],"_links":{"self":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/comments?post=946"}],"version-history":[{"count":21,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/946\/revisions"}],"predecessor-version":[{"id":1469,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/946\/revisions\/1469"}],"wp:attachment":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/media?parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/categories?post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/tags?post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}