Exact Globe+

Generating overview of work in progress of projects

Menu path

Projects ➔ Projects ➔ Work in progress

Introduction

In project-based businesses, the project may require several phases of work before its completion. The work completed for each of the phases may be registered as work in progress (WIP), which may include the cost for labor hours, used materials, and third parties (direct cost). At this menu path, you can generate an overview of the project transactions, which can then be generated as WIP entries to record the costs incurred in a project.

What version are you using?

The information in this document is based on product update 398. If you have versions lower than this, certain features explained here will not be applicable.

Fields

Warehouse

Select a warehouse to display the transactions for projects that are linked to this warehouse. Select All to display the project transactions that are linked to all warehouses.

Note: This is available only if you have E-Warehouse Management in your license.

Project manager

Type or select a manager to display transactions for projects with this project manager. Leave this blank to display projects transactions with any project manager.

Project

Type or select a project or range of projects to display the transactions linked to the selected projects. Alternatively, select the All check box to display all project transactions.

End date

Type or select a date or range of dates to display the transactions for projects with end dates matching the selected dates. Alternatively, select the All check box to display the project transactions with any end dates.

Include: Related

Select this check box to display the transactions of child projects that are linked to the selected parent project.

Note: This is enabled only when you have selected the projects with type Internal at Project.

Include: Zero (Actual)

Select this check box if you want to include transactions with a zero amount in the Revenue (Actual), Costs (Actual), or WIP (Current) column in the overview.

Project type

Select the Internal, Fixed, Time & Material, Training, or Production check box to display the transactions for projects with the corresponding type. You may select more than one.

Project status

Select the Proposed, Active, Completed, or Blocked check box to display the transactions for projects with the corresponding status. You may select more than one.

Group by

Select Item or Project to group the project transactions accordingly.

Scenario

Type or select a budget scenario to display project transactions that are linked to the selected scenario.

Ordered by

Type or select a debtor to display the transactions for projects that are ordered by the selected debtor. Leave this blank to display the transactions for projects that are ordered by any debtor.

Invoice to

Type or select a debtor to display the transactions for projects that are invoiced to the selected debtor. Leave this blank to display the transactions for projects that are invoiced to any debtor.

WIP method

Select the Percentage of completion cost recognition, Percentage of completion revenue recognition, Percentage of completion cost recognition (budget), Percentage of completion revenue recognition (budget), Completed contract method, Cost of sales method, To be invoiced, WIP cost and revenue transfer, or WIP cost and revenue check box to display the transactions for projects that use the selected WIP methods. You may select more than one.

Notes: Once the WIP cost and revenue transfer or WIP cost and revenue check box is selected, the following changes will take place:

The Percentage of completion cost recognition, Percentage of completion revenue recognition, Percentage of completion cost recognition (budget), Percentage of completion revenue recognition (budget), Completed contract method, To be invoiced, and the Cost of sales method check boxes at WIP method will be cleared and disabled.

The Transaction date and Reporting date options and the date field will be disabled.

The Training and Production check boxes at Project type will be cleared and disabled.

The Include: Zero (actual) check box will be cleared and disabled.

The Partial release check box is enabled. To display an overview of projects with WIP to be generated or partially released, you need to define the Work in progress (Change) and Work in progress (Balance) general ledger accounts at Project settings and select the WIP cost and revenue transfer or WIP cost and revenue and Partial release check boxes. The overview will display the defined information, regardless of the transaction or reporting dates. For more information, see Project Settings and Overview of Work in Progress of Projects to be Generated or Partially Released. To display an overview of projects with WIP to be generated or fully released, you need to define the WIP revenue, WIP costs, Transfer revenue to WIP, and Transfer cost to WIP general ledger accounts at Project settings and select the WIP cost and revenue transfer or WIP cost and revenue check box but clearing the Partial release check box. The overview will display the defined information, regardless of the transaction or reporting dates. For more information, see Project Settings and Overview of Work in Progress of Projects to be Generated or Completely Released.

Project will be displayed at Group by and the field disabled.

Transaction date/Reporting date

Select the Transaction date or Reporting date as a filter to display the project transactions. You are required to fill in the transaction or reporting date at to.

to

Type or select a date to display the project transactions that occurred before and on the selected date. This date could be the transaction date or reporting date depending on your selection in the previous field.

Proposal

Select the Suggestion (Recognized costs) check box if you want to display the suggested recognized cost for the project transactions.