This section details out the project transactions integration using dual-write. When project transactions are posted or updated in Finance and Operations, then they will be created or updated in Project Operations using dual-write. Only project transactions created in Finance and Operations will be synced. This process can be initiated through periodic task ‘Create actuals in PO’ in Finance and Operations and it can be executed through batch as well.
Go to projects360 integrations > Periodic tasks > Project Operations integration > Create actuals in PO
Hour transactions
Actual time transactions recorded will be created or updated in Project Operations from Finance and Operations. This syncing process will create or update two ‘Actual’ transactions in Project Operations i.e., a ‘Cost’ and ‘Revenue’ transaction.
Cost transaction
Details of field specifications in Project Operations when the actuals are integrated from Finance and Operations:
| Fields | Description |
| Record Id | ‘Record Id’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Transaction Class | Fixed value: ‘Time’ |
| Transaction Type | Fixed value: ‘Cost’ |
| Not-to-exceed Status | ‘Not Applicable’ |
| Adjustment Status ID | If ‘Invoice status’ is ‘Adjusted’ in Finance and Operations, then set as ‘Adjusted’ in Project Operations. Otherwise, set as ‘Unadjustable’. |
| Document Date | ‘Project date’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Project Contract ID | Initialize by ‘Contract’ field from Project in Project Operations. |
| Project Contract Line | Initialize by ‘Contract Line’ from Project in Project Operations. (Write-In Product) |
| Project Contract Line Customer | Initialize by ‘Contract Line’ from Project in Project Operations. (Customer associated) |
| Project ID | ‘Main project’ (Project level zero) related with Project Id from ‘ProjEmplTrans’ in Finance and Operations. |
| Task ID | If ‘Activity number’ is populated in ProjEmplTrans, then use Task Id related with activity in Finance and Operations. If there is no activity but there is a parent project, then use Task Id related with subproject in Finance and Operations. |
| Resource role ID | ‘Role Id’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Resource Id | ‘Resource’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Transaction category ID | ‘Category’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Contracting Unit | Blank |
| Resourcing Company | ‘Legal entity’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Resourcing Unit | Blank |
| Quantity | ‘Hours’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Unit of measure | Defaults from Transaction category |
| Price | ‘Cost price’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Amount | ‘Total cost amount’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Tax | Blank |
| Extended Amount | ‘Total cost amount’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Currency | ‘Sales currency’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Billing Type | Convert ‘Line property’ field using parameters ‘Billing type defaults’ from ‘projects360 integration parameters’ |
| Created On | Date and time on which transaction is created in Project Operations. |
Revenue transaction
Details of field specifications in Project Operations when the actuals are integrated from Finance and Operations:
| Fields | Description |
| Record Id | ‘Record Id’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Transaction Class | Fixed value: ‘Time’ |
| Transaction Type | If ‘Invoice’ field from ‘ProjEmplTrans’ in Finance and Operations has a value, then apply ‘Billed Sales’ value. Otherwise, apply ‘Unbilled Sales’ value. |
| Not-to-exceed Status | ‘Not Applicable’ |
| Adjustment Status ID | If ‘Invoice status’ is ‘Adjusted’ in Finance and Operations, then set as ‘Adjusted’ in Project Operations. Otherwise, set as ‘Unadjustable’. |
| Document Date | ‘Project date’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Project Contract ID | Initialize by ‘Contract’ field from Project in Project Operations. |
| Project Contract Line | Initialize by ‘Contract Line’ from Project in Project Operations. (Write-In Product) |
| Project Contract Line Customer | Initialize by ‘Contract Line’ from Project in Project Operations. (Customer associated) |
| Project ID | ‘Main project’ (Project level zero) related with Project Id from ‘ProjEmplTrans’ in Finance and Operations. |
| Task ID | If ‘Activity number’ is populated in ProjEmplTrans, then use Task Id related with activity in Finance and Operations. If there is no activity but there is a parent project, then use Task Id related with subproject in Finance and Operations. |
| Resource role ID | ‘Role Id’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Resource Id | ‘Resource’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Transaction category ID | ‘Category’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Contracting Unit | Blank |
| Resourcing Company | ‘Legal entity’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Resourcing Unit | Blank |
| Quantity | ‘Hours’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Unit of measure | Defaults from Transaction category |
| Price | ‘Sales price’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Amount | ‘Total sales amount’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Tax | Blank |
| Extended Amount | ‘Total sales amount’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Currency | ‘Sales currency’ field value from ‘ProjEmplTrans’ in Finance and Operations. |
| Billing Type | Convert ‘Line property’ field using parameters ‘Billing type defaults’ from ‘projects360 integration parameters’ |
| Created On | Date and time on which transaction is created in Project Operations. |
Expense transaction
Actual expense transaction recorded will be created or updated in Project Operations from Finance and Operations. This syncing process will create or update two ‘Actual’ transactions in Project Operations i.e., a ‘Cost’ and ‘Revenue’ transaction.
Cost transaction
Details of field specifications in Project Operations when the actuals are integrated from Finance and Operations:
| Fields | Description |
| Record Id | ‘Record Id’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Transaction Class | Fixed value: ‘Expense’ |
| Transaction Type | Fixed value: Cost |
| Not-to-exceed Status | ‘Not Applicable’ |
| Adjustment Status ID | If ‘Invoice status’ is ‘Adjusted’ in Finance and Operations, then set as ‘Adjusted’ in Project Operations. Otherwise, set as ‘Unadjustable’. |
| Document Date | ‘Project date’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Project Contract ID | Initialize by ‘Contract’ field from Project in Project Operations. |
| Project Contract Line | Initialize by ‘Contract Line’ from Project in Project Operations. (Write-In Product) |
| Project Contract Line Customer | Initialize by ‘Contract Line’ from Project in Project Operations. (Customer associated) |
| Project ID | ‘Main project’ (Project level zero) related with Project Id from ‘ProjCostTrans’ in Finance and Operations. |
| Task ID | If ‘Activity number’ is populated in ProjCostTrans, then use Task Id related with activity in Finance and Operations. If there is no activity but there is a parent project, then use Task Id related with subproject in Finance and Operations. |
| Resource role ID | ‘Role Id’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Resource Id | ‘Resource’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Transaction category ID | ‘Category’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Contracting Unit | Blank |
| Resourcing Company | ‘Legal entity’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Resourcing Unit | Blank |
| Quantity | ‘Quantity’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Unit of measure | Defaults from Transaction category. |
| Price | ‘Cost price’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Amount | ‘Total cost amount’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Tax | Blank |
| Extended Amount | ‘Total cost amount’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Currency | ‘Sales currency’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Billing Type | Convert ‘Line property’ field using parameters ‘Billing type defaults’ from ‘projects360 integration parameters’ |
| Created On | Date and time on which transaction is created in Project Operations. |
Revenue transaction
Details of field specifications in Project Operations when the actuals are integrated from Finance and Operations:
| Fields | Description |
| Record Id | ‘Record Id’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Transaction Class | Fixed value: ‘Expense’ |
| Transaction Type | If ‘Invoice’ field from ‘ProjCostTrans’ in Finance and Operations has a value, then apply ‘Billed Sales’ value. Otherwise, apply ‘Unbilled Sales’ value. |
| Not-to-exceed Status | ‘Not Applicable’ |
| Adjustment Status ID | If ‘Invoice status’ is ‘Adjusted’ in Finance and Operations, then set as ‘Adjusted’ in Project Operations. Otherwise, set as ‘Unadjustable’. |
| Document Date | ‘Project date’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Project Contract ID | Initialize by ‘Contract’ field from Project in Project Operations. |
| Project Contract Line | Initialize by ‘Contract Line’ from Project in Project Operations. (Write-In Product) |
| Project Contract Line Customer | Initialize by ‘Contract Line’ from Project in Project Operations. (Customer associated) |
| Project ID | ‘Main project’ (Project level zero) related with Project Id from ‘ProjCostTrans’ in Finance and Operations. |
| Task ID | If ‘Activity number’ is populated in ProjCostTrans, then use Task Id related with activity in Finance and Operations. If there is no activity but there is a parent project, then use Task Id related with subproject in Finance and Operations. |
| Resource role ID | ‘Role Id’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Resource Id | ‘Resource’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Transaction category ID | ‘Category’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Contracting Unit | Blank |
| Resourcing Company | ‘Legal entity’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Resourcing Unit | Blank |
| Quantity | ‘Quantity’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Unit of measure | Defaults from Transaction category |
| Price | ‘Sales price’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Amount | ‘Total sales amount’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Tax | Blank |
| Extended Amount | ‘Total sales amount’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Currency | ‘Sales currency’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Billing Type | Convert ‘Line property’ field using parameters ‘Billing type defaults’ from ‘projects360 integration parameters’ |
| Created On | Date and time on which transaction is created in Project Operations. |
Fee transactions
Actual fee transactions recorded will be created or updated in Project Operations from Finance and Operations. This syncing process will create or update only one ‘Actual’ transactions in Project Operations i.e., a ‘Revenue’ transaction.
Revenue transaction
Details of field specifications in Project Operations when the actuals are integrated from Finance and Operations:
| Fields | Description |
| Record Id | ‘Record Id’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Transaction Class | Fixed value: ‘Fee’ |
| Transaction Type | If ‘Invoice’ field from ‘ProjRevenueTrans’ in Finance and Operations has a value, then apply ‘Billed Sales’ value. Otherwise, apply ‘Unbilled Sales’ value. |
| Not-to-exceed Status | ‘Not Applicable’ |
| Adjustment Status ID | If ‘Invoice status’ is ‘Adjusted’ in Finance and Operations, then set as ‘Adjusted’ in Project Operations. Otherwise, set as ‘Unadjustable’. |
| Document Date | ‘Project date’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Project Contract ID | Initialize by ‘Contract’ field from Project in Project Operations. |
| Project Contract Line | Initialize by ‘Contract Line’ from Project in Project Operations. (Write-In Product) |
| Project Contract Line Customer | Initialize by ‘Contract Line’ from Project in Project Operations. (Customer associated) |
| Project ID | ‘Main project’ (Project level zero) related with Project Id from ‘ProjCostTrans’ in Finance and Operations. |
| Task ID | If ‘Activity number’ is populated in ProjCostTrans, then use Task Id related with activity in Finance and Operations. If there is no activity but there is a parent project, then use Task Id related with subproject in Finance and Operations. |
| Resource role ID | Blank |
| Resource Id | Blank |
| Transaction category ID | ‘Category’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Contracting Unit | Blank |
| Resourcing Company | ‘Legal entity’ field value from ‘ProjCostTrans’ in Finance and Operations. |
| Resourcing Unit | Blank |
| Quantity | ‘Quantity’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Unit of measure | Defaults from Transaction category |
| Price | ‘Sales price’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Amount | ‘Total sales amount’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Tax | Blank |
| Extended Amount | ‘Total sales amount’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Currency | ‘Sales currency’ field value from ‘ProjRevenueTrans’ in Finance and Operations. |
| Billing Type | Convert ‘Line property’ field using parameters ‘Billing type defaults’ from ‘projects360 integration parameters’ |
| Created On | Date and time on which transaction is created in Project Operations. |
Go to Projects > Projects > Actuals tab
