Delivery project (PRO)
The Delivery project (PRO) application is a useful, yet complex application that binds together information from various sources to display information to enhance cost and progress control. The applications that are used in unison are; Delivery project (PRO), Delivery project snapshot (PROSS) and Finance project (PRJ). This topic will mainly cover Delivery project (PRO) and Delivery project snapshot (PROSS).
Limitations and conditions
All Sales orders (COA) added to a Delivery project (PRO) must be from the same Customer (CUS).
Only one Finance project (PRJ) for each Delivery project (PRO).
Only for Production work orders (PWO) derived from a Sales order (COA). In other words, the Production work order (PWO) must be linked to the Sales order (COA).
Production work orders (PWO) that are not liked to Sales order (COA), will not be presented in Delivery project (PRO).
The Delivery project (PRO) will not display information related to Service orders (CSO).
The Delivery project (PRO) is not designed to interact with Project order (POD).
Overview
The Delivery project (PRO) application is divided into the two main areas; PRO area and Delivery project area, as visualized in the screenshot below.
The PRO area
The PRO area is used for the creation and selection of Delivery projects (PRO).
To access the information provided by a snapshot, one must first be created in the Delivery project (PRO) application.
From the Delivery project (PRO) application, click the Create a new project button in the lower left corner in the PRO area.
Select or search for the intended customer in the Customer drop-down menu.
Type a name for the project in the Project name field.
Optionally, select or search for a finance project in the Finance project drop-down menu.
Click the Create button to create the delivery project.
The displayed information can be tailored by clicking the Column settings icon and choosing which columns are to be displayed. The table below describes the available columns.
Columns | Description |
|---|---|
St | Displays a status icon indicating the status of the Delivery project (PRO).
|
Project id | Displays the Delivery project's (PRO) unique identifier number used to identify the document in RamBase. Note that it is the same number displayed in the program field at the top in the RamBase header. |
Project name | Displays the name set in the Project name field in the Delivery project area. Note the dotted line, indicating it is editable in all statuses. |
Customer id | Displays the Customer's (CUS) unique identifier number used to identify the document in RamBase. Writing CUS/ followed by the identifier number, in the Program field at the top in the RamBase header, will access the Customer (CUS) application on the customer with the identifier. |
Customer name | Displays the Customer (CUS) name. |
Finance project | Displays the name of the Finance project (PRJ) connected to the Delivery project (PRO). The name is derived from the selection made in the Finance project drop-down menu, in the Delivery project area. |
The Delivery project area
The Delivery project area displays information and allows actions as listed below:
Project name field - An editable field displaying the project name. Type the intended name for the delivery project.
Customer name field - An informational field displaying the customer name.
Finance project drop-down menu - Connect the Delivery project (PRO) to a Finance project (PRJ). Note that the Delivery project must be in Status 1 for a Finance project (PRJ) to be connected. Click the View icon to open the Finance projects (PRJ) application. If none are connected, the application will list all Finance projects (PRJ). If a Finance project (PRJ) is connected, the application will open on the connected Finance project (PRJ).
Notes field - A free text field where relevant information can be added.
Delivery project (PRO) tabs
The Snapshots tab
Snapshots can be made at any time if the Delivery project (PRO) is active by using the Create snapshot button in the context menu. The process will run automatically every night, and present a new snapshot if there are any changes since the previous snapshot. This is useful in identifying progress, as unchanged Snapshots will not be updated.
From the list in the PRO area, select, or search for, the intended project.
Select the Create snapshot option in the context menu.
Click on the Snapshots tab in the Delivery project area to start a batch to calculate the new snapshot.
Wait 5 seconds, then refresh the browser.
A snapshot should now be listed in the Snapshot tab.
To select which information is displayed, click on the Column settings icon and hover over Columns. Then select the intended columns. The selection of data can be exported to Excel via the Export to excel option in the Column settings. The Reset to default view is also useful in resetting column width and placement, since columns can be dragged and dropped to suit the user. A description of the columns are listed in the table below.
Column | Description |
|---|---|
Date | An informational field displaying the date when the snapshot was created. |
Milestone | A milestone is a measure of progress for the Delivery project (PRO), noted by the snapshot. The informational field is derived from the Milestone input field in Delivery project snapshot (PROSS) application. |
Last day of period | The last day of the accounting period. |
Sales value | The sum of the total value of the connected Sales orders (COA). |
Accrued income | Calculated based on completed percent. |
Invoiced value | The sum of all Customer invoices (CIN) connected to the Delivery project (PRO). |
Planned cost | Planned production cost. |
Accrued cost | Sum of all ongoing and finished productions. The Accrued cost is also split and detailed with the following columns:
|
Planned time | Planned time on all connected Production work orders (PWO). |
Accrued time | Sum of time on all connected and finished Production work orders (PWO). |
Planned material cost | Planned material cost from Production work orders (PWO). |
Accrued material cost | Cost of all materials that are picked for Production work order (PWO) and sub Production work orders (PWO). |
Planned operation variable cost | The planned operation variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Accrued operation variable cost | Accrued operation variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Planned operation fixed cost | The planned operation fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Accrued operation fixed cost | Accrued operation fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Planned added fixed cost | The planned added fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Accrued added fixed cost | The accrued added fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Planned added variable cost | The planned added variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Accrued added variable cost | The accrued added variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Total income | The sum of Invoiced amount and Other income (Invoiced amount + Other income). |
Total cost | The sum of the accrued totalt cost, other cost of goods, wages and other expenses (Accrued total cost + Other cost of goods + Wages + Other expences). |
Profit | The difference of the total income and total cost. (Total income - Total cost). |
Other cost of goods | The Other cost of goods field displays goods purchased directly to the Delivery project (PRO). For example requisition purchases, including direct postings in the General ledger (ATR). The goods are not connected to the inventory flow. The link between the Other cost of goods field and the General ledger (ATR) is the PRO_OTHERCOSTOFGOODS account group in the Report account group (ACG) application. |
Other expenses | The Other expenses field displays expenses derived from Supplier invoices (SIN) for services and non-goods like tools and indirect cost. The product types X-Expenses and V-Value added service can be used on requisition Purchase orders (SPO). Direct postings can be registered in the General ledger (ATR). The link between the Other expenses field and the General ledger (ATR) is the PRO_OTHEREXPENSES account group in the Report account group (ACG) application. |
Other income | The Other income field displays income derived from Customer invoices (CIN) for services and non-goods like freight and testing services. The product types X-Expenses and V-Value added service can be used on outgoing Customer invoices (CIN). Direct postings can be registered in the General ledger (ATR). The link between the Other income field and the General ledger (ATR) is the PRO_OTHERINCOME account group in the Report account group (ACG) application. |
Wages | The Wages field displays cost related to personnel cost like wages, but also other costs like travel can be put into this group. The Wages field is presented together with other key-figures for the Delivery project (PRO). This field is connected directly to the General ledger (ATR) through the account group in the Report account groupd (ACG) application: ACG/PRO_WAGES. |
Inventory | Inventory value for a Delivery project (PRO) is sum of all inventory in the related Finance project (PRJ). NoteInventory purchased to the Finance project must not be used on Sales orders (COA) outside the Delivery project (PRO). |
| Click the Arrow icon to open the Delivery project (PROSS) snapshot application on the intended date. The user can also select the date and press ENTER to open the Delivery project (PROSS) snapshot application. Read more about the Delivery project (PROSS) snapshot application in the corresponding section. |
The Orders tab
The Orders tab displays an overview of the Sales orders (COA) added to the Delivery project. To view details on a Sales order (COA) in the Orders tab, click on the View icon in the Order id column.
Click the Add order to project button in the Delivery project area.
Select or search for the intended Sales order (COA) by clicking the Order lookup drop-down field. Filters can be added by clicking the Filter builder icon, and the displayed columns can customized by clicking the Column settings icon.
If adding multiple Sales orders (COA), check the Create another check box.
Click the Create button to add the Sales order (COA) to the Delivery project (PRO).
Note
A Sales order (COA) or Sales order (COA) items can only be added to one Finance project (PRJ).
If a Sales order (COA) is not connected to a Finance project (PRJ) and is added to a Delivery project (PRO), it will also be added to the Finance project (PRJ) connected to the Delivery project (PRO).
The table below describes the available columns in the Orders tab.
Columns | Description |
|---|---|
St | Displays the status of the Sales order (COA) with a corresponding icon. |
Type | Displays the information derived from the Type field in the Sales order (COA) application. |
Created at | Displays the registration date of the Sales order (COA). |
Customer ref no | Displays the customers reference number derived from the Sales order (COA). |
Sellers ref no | Displays the sellers reference number derived from the Sellers ref. no in the Sales order (COA) header. |
Customers ref | Displays the customers reference number derived from the Sales order (COA). |
Currency | Displays the currency set on the Sales order (COA) in the Currency drop-down menu in the Finance area. |
Sub total | Total amount of the object in object currency, excluding VAT. |
VAT | Displays the VAT amount. |
Total amount | Sub total + VAT |
Fee amount | Fee amount in transaction document's currency. |
Freight amount | Freight amount in transaction document's currency. |
The Billing tab
The Billing tab will show all Customer invoices (CIN) connected to a Delivery project (PRO). Also includes Customer invoice plan (CIP) or Sales credit notes (CCN).
Icon | Column | Description |
|---|---|---|
| St | Indicates the status of the document. |
| Invoice id | An informational field displaying the invoice document name and identification number. Click the View icon to open the relevant application for the document. In example, the invoice name and identification number CIN/00000 will open the Customer invoice (CIN) application on the related invoice. |
Date | Lists dates relevant for the document type:
| |
Type | Displays the information derived from the Type field in the Sales order (COA) application. | |
Product | Lists the name of the Product (ART) being invoiced. | |
Customer Ref No | Displays the customers reference number derived from the Sales order (CIN). This is set while the Sales order (CIN) is in Status 1 (Pending registration). | |
Quantity | Lists the Product (ART) quantity of the selected invoice. | |
Net price | Final price per unit after deducting all discounts etc. | |
Net amount | Final price of items after deducting all discounts etc. |
The Chart tab
The Chart tab can be used to visualize the Delivery project (PRO). Select which checkboxes to display the intended information.
Checkbox | Description |
|---|---|
Sales backlog | Number of Sales orders (COA) connected to the Delivery project in Status 2, 3, 4, 5, 6 and 8. |
Accrued income | Total accrued income from the connected Sales orders (COA). |
Invoiced amount | The total invoiced amount on the Sales orders (COA) connected to the Delivery project (PRO). |
Planned cost | Planned production cost. |
Accrued cost | Sum of all ongoing and finished productions. The Accrued cost is also split and detailed with the following columns:
|
Planned hours | Planned hours from the connected Production work orders (PWO). |
Accrued hours | Total registered time of the Work log elements from the Production work order (PWO) application. Includes all completed and ongoing work log elements. |
Planned material cost | Planned material cost from Production work orders (PWO). |
Accrued material cost | Cost of all materials that are picked for Production work order (PWO) and sub Production work orders (PWO). |
Pln fixed added cost | The planned added fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Acr fixed added cost | The accrued added fixed cost of the Production work order (PWO), derived from the structure in the KITDOC,multiplied by the production quantity. |
Pln var added cost | The planned added variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Acr var added cost | The accrued added variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Pln fixed opr cost | The planned operation fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Acr fixed opr cost | Accrued operation fixed cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Pln var opr cost | The planned operation variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Acr var opr cost | Accrued operation variable cost of the Production work order (PWO), derived from the structure in the KITDOC, multiplied by the production quantity. |
Context menu options in the Delivery project (PRO) application
The context menu is found in the top right corner and is opened by clicking the Context menu icon.
The options are context based on the Delivery project's (PRO) status.
Create snapshot - available for Delivery projects (PRO) in Status 4.
Close project - available for Delivery projects (PRO) in Status 1 and 4. Will set the Delivery project (PRO) in Status 9.
Open for edit - available for Delivery projects (PRO) in Status 4 and 9. The Delivery project (PRO) is set to Status 1.
Activate project - available for Delivery projects (PRO) in Status 1 and 9. The Delivery project (PRO) is set to Status 4.
Widgets
From the RamBase Home the user can add widgets displaying information from the Delivery project (PRO) application by clicking the +Add widget button in the top right corner. The following widgets are available:
DeliveryProjectCostWidget - Project: Delivery cost
DeliveryProjectIncomeWidget - Project: Delivery income
DeliveryProjectWorkHoursWidget - Projects: Delivery work hours
Delivery project snapshot (PROSS) application
A snapshot in the Delivery project (PRO) application generates an overview of useful information. The Delivery project snapshot (PROSS) application is used to display even more detailed information.
To open the Delivery project snapshot (PROSS) application, click on the Arrow icon or press ENTER on the intended snapshot in the Snapshots tab, in the Delivery project (PRO) application.
The tables below lists fields, functions and columns used to handle the information provided by the Delivery project snapshot (PROSS) application.
Overview
The user can select which columns are to be displayed by clicking the Column settings icon. The selection of columns can be saved to templates by selecting the + Add template to list option in the Column settings. The template can be selected by clicking the Current view drop-down list.
The Delivery project snapshot (PROSS) will display the selected template upon reentering the application.
Header
The header is found at the top of the application and is comprised of some editable fields, and mostly informational fields.
Field | Description |
|---|---|
Customer | An informational field displaying the customer name. |
Milestone | An input field where the user can define the project milestone, the snapshot represents. |
Snapshot date | Date the snapshot generated. |
Completed % | An input field where the user can define the snapshot's representation in project completion, in percent. |
Sales value | The sum of the total value of the connected Sales orders (COA). |
Invoiced value | The sum of all Customer invoices (CIN) connected to the Delivery project (PRO). |
Accrued income | Calculated based on completed percent. Can be overwritten by entering adding a percentage to the Completed % field in the header. |
Currency | The currency derived from the Sales order (COA). |
Planned cost | Planned production cost. |
Accrued cost | Sum of all ongoing and finished productions. The Accrued cost is also split and detailed with the following columns:
|
Planned time | Planned time on all connected Production work orders (PWO). |
Accrued time | Sum of time on all connected and finished Production work orders (PWO). |
Planned material cost | Planned material cost from Production work orders (PWO). |
Accrued material cost | Cost of all materials that are picked for Production work order (PWO) and sub Production work orders (PWO). |
Other cost of goods | Connected to a dedicated Report account group (ACG) based on the users inclusion of General ledger (GL) accounts. Read more in the Limitations on using the Report account groups (ACG) section. |
Other expenses | Connected to a dedicated Report account group (ACG) based on the users inclusion of General ledger (GL) accounts. Read more in the Limitations on using the Report account groups (ACG) section. |
Other income | Connected to a dedicated Report account group (ACG) based on the users inclusion of General ledger (GL) accounts. Read more in the Limitations on using the Report account groups (ACG) section. It is recommended to exclude General ledger (GL) accounts that are used for Customer invoices (CIN). |
Wages | The Wages field displays cost related to personnel cost like wages, but also other costs like travel can be put into this group. The Wages field is presented together with other key-figures for the Delivery project (PRO). This field is connected directly to the General ledger (ATR) through the account group in the Report account groupd (ACG) application: ACG/PRO_WAGES. |
Total income | (InvoicedAmount + OtherIncome) |
Total cost | (Accrued.TotalCost + OtherCostOfGoods + Wages + OtherExpences) |
Profit | (TotalIncome - TotalCost) |
Inventory | Inventory value for a Delivery project (PRO) is sum of all inventory on the related Finance project (PRJ). |
The Work breakdown structure (WBS) list
The user can select which columns are to be displayed by clicking the Column settings icon. The selection of columns can be saved to templates by selecting the + Add template to list option in the Column settings. The template can be selected by clicking the Current view drop-down list.
The Delivery project snapshot (PROSS) will display the selected template upon reentering the application.
The available columns and functions are described in the table below.
Icon | Column | Description |
|---|---|---|
| Level | Decide the levels displayed in the WBS list. Click the 1 button to display only the Scope level which includes the inital Sales order (COA). |
| Level | Decide the levels displayed in the WBS list. Click the 2 button to display the Scope and Deliverable levels which includes the inital Sales order (COA), the triggered or linked Production work order (PWO). |
| Level | Decide the levels displayed in the WBS list. Click the 3 button to display the Scope, Deliverable and Operation levels which includes the inital Sales order (COA), the triggered or linked Production work order (PWO) and the operation and material information. |
| Level | Decide the levels displayed in the WBS list. Click the 4 button to display the Scope, Deliverable, Operation, Material levels including all sub-productions. |
| Level | Export to excel. Click the Export to excel button to generate and download a .xlsx file. This function will only export the selected columns in the Column settings. |
| Status | An icon indicating the status of the Sales order (COA) or Production work order (PWOD). |
Order id | Lists the order and identification number of the document, in example PWO/00000, Click the View icon to enter the primary document or alternatively type the order and identification number in the Program field. | |
| Order id | Clicking the View icon will open the relevant application for the order. A Sales order (COA) id, in example COA/00000, will open the Sales order (COA) application on the order in question. A Production work order (PWOD) id, in example PWO/00000, will open the Production work order (PWOD) application on the work order in question. |
| Order id | Clicking the Structure icon will open the KITDOC application and display the structure of the part being produced by the Production work order (PWOD). |
Product / Operation | An informational field displaying the name of the product being produced and name of the related operation. | |
Operation / Materials status | This unnamed column, in the Delivery project snapshot (PROSS) application, displays information which can be used to identify which Production work orders (PWO) to prioritize by stating the operation and material status like; Ready to start or In stock. | |
Prod qty | The quantity being produced by the connected Production work orders (PWO). | |
Sales value | The sum of the total value of the connected Sales orders (COA). | |
Accrued income | Calculated based on completed percent. | |
Invoiced value | The sum of all Customer invoices (CIN) connected to the Delivery project (PRO). | |
Planned cost | Planned production cost. | |
Accrued cost | Sum of all ongoing, finished and shipped Production work orders (PWO). The Accrued cost is also split and detailed with the following columns:
| |
Accrued cost active | Accrued cost of all active, in Status 5 and 6, Production work orders (PWO). | |
Accrued cost finished | Cost of all completed Production work orders (PWO), in Status 9, that are forwarded to stock but not yet shipped to customer. | |
Accrued cost shipped | Cost of shipped products. | |
Deviation total cost | This is the difference between total planned cost and accrued cost for each element and total difference at each work package and deliverable level. Only for completed sub levels and at the scope. | |
Accrued total cost % | Accrued cost in percentage of planned cost for elements with deviation. | |
Planned time | Accrued time per operation and total accrued time for each work package and deliverable level. | |
Accrued time | Accrued time per operation and total accrued time for each work package and deliverable level. | |
Deviation hours | The difference between operation planned and accrued time and total difference at each work package and deliverable level. Only for completed sub levels and at the scope. | |
Accrued hours % | Accrued hours in percentage of planned cost for elements with deviation. | |
Delayed days | Operation delay in days. | |
Completed % | Manual input at scope level. This is reset to blank by each new snapshot. | |
Completed % calculated | Calculated completed percentage for the deliveries. | |
Requested delivery | Requested delivery date for the customer order item. | |
Confirmed delivery | Confirmed delivery date for the customer order item. |
Common for columns connected to an Report accounting group (ACG)
It is possible to register cost and income elements directly to the general ledger and connect them to the Delivery project (PRO). To be able to do so, there are a few conditions to consider.
The Delivery project needs to be connected to a Finance project (PRJ).
Values can be registered to the Delivery project (PRO) using accounts that are defined in the Report account groups (ACG) mentioned below.
Report account groupd (ACG) | Delivery project snapshot (PROSS) field |
|---|---|
PRO_OTHERCOSTOFGOODS | Other cost of goods |
PRO_OTHEREXPENSES | Other expenses |
PRO_OTHERINCOME | Other income |
PRO_WAGES | Wages |
These are the fields that are displayed in the Delivery project snapshot (PROSS) application header.
Register either directly to the general ledger using a General ledger posting (ATR) or through a Sales invoice (CIN) or Supplier invoice (SIN). Read about how to book a cost invoice here.
Note the Report account groups (ACG) listed in the application.
Limitations on using the Report account groups (ACG)
Which accounts to group in the Report account groups (ACG) application, can be selected at will, but should should never include accounts that are meant for value flow.
Account groups that includes these Product (ART) types must be excluded:
Part (type P)
Material (type M)
Consumption parts (type C)
Kit and kit assemblies (type K and KA)