Revision history for ProjectManagementPercentCompletion
No Differences
Additions:
~contractid - this will only be populated when the project is created - creating the contracts
~reference - the line reference
~description - line description/activity
~materialbudget - excluding the labour
ProjectLineLabourBudget
~reference - line number
~labouritem - determines type of labour
~hours - budgeted hours for this line
~labouritem - FK stockmaster with patent stockcategory of a labour type
~reference - the line reference
~description - line description/activity
~materialbudget - excluding the labour
ProjectLineLabourBudget
~reference - line number
~labouritem - determines type of labour
~hours - budgeted hours for this line
~labouritem - FK stockmaster with patent stockcategory of a labour type
Deletions:
Additions:
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as """stock""" items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy """project""" item all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
Deletions:
Additions:
To provide accounting for larger projects which span multiple activities and where turnover will be taken on the basis of percentage of completion of the whole project. Given that we already have contract costing module, we can make use of the existing contract functionality to allow bills of materials and other costs to be set up against a contract. The project is a level above the contract where each project will be made up of 1 or more """contracts""" from existing webERP functionality.
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as �stock� items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy �project� item � all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
5) Customer�s PO number
6) Project Manager � from a new table of employees (where project manager flag is true) and Project designer from the same table of employees (where the employee is flagged as a designer).
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA � "New Project Advice" from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
9) The agreed price of the project to the customer (in the customer�s currency)
~Total project value � from the project sales order as at date
~Variations � not yet on the project sales order as at date
~Material costs ordered not yet received � from outstanding POs for the project contracts (lines)
~Expected material costs to go not ordered � input field but calculated in the first instance
4) Once happy with the turnover/GP taken the sales values a final process can post to the GL the turnover to be taken (GP drops out of the turnover less the COGS � posted directly as each project cost goes directly to the COGS GL codes). GL postings of turnover are just the incremental amounts based on the new sales value less any previous turnover already taken on this project. A field in the project master records the turnover taken and is updated by this process.
New functionality is required to create Sales invoices for these project items � without specifying a quantity � but allowing for entry of a narrative and amounts. Eg. Progress instalment 20% $100,000. Creating a project invoice will not create any GL entries to income but instead CR progress billings/Taxes and DR Debtors
Timesheet entry allows entry of labour � need new table of employees and each related to a labour type. GL posting in accordance with �stock� category for this labour type.
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as �stock� items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy �project� item � all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
5) Customer�s PO number
6) Project Manager � from a new table of employees (where project manager flag is true) and Project designer from the same table of employees (where the employee is flagged as a designer).
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA � "New Project Advice" from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
9) The agreed price of the project to the customer (in the customer�s currency)
~Total project value � from the project sales order as at date
~Variations � not yet on the project sales order as at date
~Material costs ordered not yet received � from outstanding POs for the project contracts (lines)
~Expected material costs to go not ordered � input field but calculated in the first instance
4) Once happy with the turnover/GP taken the sales values a final process can post to the GL the turnover to be taken (GP drops out of the turnover less the COGS � posted directly as each project cost goes directly to the COGS GL codes). GL postings of turnover are just the incremental amounts based on the new sales value less any previous turnover already taken on this project. A field in the project master records the turnover taken and is updated by this process.
New functionality is required to create Sales invoices for these project items � without specifying a quantity � but allowing for entry of a narrative and amounts. Eg. Progress instalment 20% $100,000. Creating a project invoice will not create any GL entries to income but instead CR progress billings/Taxes and DR Debtors
Timesheet entry allows entry of labour � need new table of employees and each related to a labour type. GL posting in accordance with �stock� category for this labour type.
Deletions:
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as “stock” items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy “project” item – all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
5) Customer’s PO number
6) Project Manager – from a new table of employees (where project manager flag is true) and Project designer from the same table of employees (where the employee is flagged as a designer).
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA – "New Project Advice" from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
9) The agreed price of the project to the customer (in the customer’s currency)
~Total project value – from the project sales order as at date
~Variations – not yet on the project sales order as at date
~Material costs ordered not yet received – from outstanding POs for the project contracts (lines)
~Expected material costs to go not ordered – input field but calculated in the first instance
4) Once happy with the turnover/GP taken the sales values a final process can post to the GL the turnover to be taken (GP drops out of the turnover less the COGS – posted directly as each project cost goes directly to the COGS GL codes). GL postings of turnover are just the incremental amounts based on the new sales value less any previous turnover already taken on this project. A field in the project master records the turnover taken and is updated by this process.
New functionality is required to create Sales invoices for these project items – without specifying a quantity – but allowing for entry of a narrative and amounts. Eg. Progress instalment 20% $100,000. Creating a project invoice will not create any GL entries to income but instead CR progress billings/Taxes and DR Debtors
Timesheet entry allows entry of labour – need new table of employees and each related to a labour type. GL posting in accordance with “stock” category for this labour type.
Additions:
2) Selection of the project type from the list of project items defined in stock master. The dummy project item will have a "project stock category" record that will determine how it is posted and also the stock category it belongs to will allow the set up of the COGS GL posting and Sales GL Posting GL codes.
6) Project Manager – from a new table of employees (where project manager flag is true) and Project designer from the same table of employees (where the employee is flagged as a designer).
6) Project Manager – from a new table of employees (where project manager flag is true) and Project designer from the same table of employees (where the employee is flagged as a designer).
Deletions:
6) Project Manager – from a new table of project managers
Additions:
~status
Additions:
~exworksdate
~designer bool
---Project Reviews (AKA: Sales Values)---
Provided there are no outstanding uncompleted sales values. At any point in time a process to create a sales value worksheet that summarises the costs incurred on a project (across all contracts for that project) the current project value from the sales order and the costs expected to go for each labour type defined. Before any sales value worksheets have been created these expected costs to go will be derived from the total NPA as summed across all contracts less any costs incurred. Similarly, the labour types defined will have the labour to go calculated in the same way across all contracts. The sales value worksheet will allow for the materials yet to go to be over-ridden and similarly for the amount of labour hours for each defined labour type. Also a confidence factor that can be used to abate the proportion of turnover/profit taken on the project. Each worksheet will have a status that can be:
~designer bool
---Project Reviews (AKA: Sales Values)---
Provided there are no outstanding uncompleted sales values. At any point in time a process to create a sales value worksheet that summarises the costs incurred on a project (across all contracts for that project) the current project value from the sales order and the costs expected to go for each labour type defined. Before any sales value worksheets have been created these expected costs to go will be derived from the total NPA as summed across all contracts less any costs incurred. Similarly, the labour types defined will have the labour to go calculated in the same way across all contracts. The sales value worksheet will allow for the materials yet to go to be over-ridden and similarly for the amount of labour hours for each defined labour type. Also a confidence factor that can be used to abate the proportion of turnover/profit taken on the project. Each worksheet will have a status that can be:
Deletions:
~ContractID
~LabourType
~Plannedhours
Provided there is no outstanding uncompleted sales values. At any point in time a process to create a sales value worksheet that summarises the costs incurred on a project (across all contracts for that project) the current project value from the sales order and the costs expected to go for each labour type defined. Before any sales value worksheets have been created these expected costs to go will be derived from the total NPA as summed across all contracts less any costs incurred. Similarly, the labour types defined will have the labour to go calculated in the same way across all contracts. The sales value worksheet will allow for the materials yet to go to be over-ridden and similarly for the amount of labour hours for each defined labour type. Also a confidence factor that can be used to abate the proportion of turnover/profit taken on the project. Each worksheet will have a status that can be:
Additions:
To provide accounting for larger projects which span multiple activities and where turnover will be taken on the basis of percentage of completion of the whole project. Given that we already have contract costing module, we can make use of the existing contract functionality to allow bills of materials and other costs to be set up against a contract. The project is a level above the contract where each project will be made up 1 or more “contracts” from existing webERP functionality.
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as “stock” items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy “project” item – all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA – "New Project Advice" from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
~projectmanager FK employees
~designer FK employees
~projectdescription
~completiondate
~contractid
Each contract can currently have its own bill of materials constructed plus any number of other "nominal" cost items that are not currently defined as “stock” items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy “project” item – all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA – "New Project Advice" from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
~projectmanager FK employees
~designer FK employees
~projectdescription
~completiondate
~contractid
Deletions:
Each contract can currently have its own bill of materials constructed plus any number of other cost items that are not currently defined as “stock” items in the stockmaster. Purchase orders and invoices can specify individual contracts to be allocated to. A project will have a single project sales order for a dummy “project” item – all subsequent variations will appear as additional project item lines with the narrative line for each order line describing the project and variations.
8) Any number of lines spelling out the specific requirements of the project with estimated costs (the NPA – new project advice from the project costing) Each line can have any number of labour type quantities extended at each labour type rate. Eg. Design, Engineering, Manufacturing
~projectmanager
~Materialbudget