The following are the list of data integrates from Finance and Operations to Project Operations as part of dual write initial sync or as and when data created or updated in the Finance and Operations.

Project groups

Project groups created or updated in Finance and Operations will be synced to Project Operations using dual-write and available for selection while creating or updating company parameter settings, opportunity lines and projects.

Go to Project management and accounting > Setup > Posting > Project groups

Shared categories

Shared project categories created or updated in Finance and Operations will be created or updated in Project Operations as Transaction categories using dual-write. Only records with “Can be used in Project” marked as “Yes” will be synced to Project Operations.

Go to Project management and accounting > Setup > Categories > Shared Categories

Project resources (Workers)

Resources created or updated in Finance and Operations will be created or updated in Project Operations as Bookable resource using dual-write. The resource will be synced only after the Project setup is configured in Finance and Operations. New field Resource Id is added in the Project Operations Bookable resource form to update the Resource ID of resource integrating from Finance and Operations.

Go to Project management and accounting > Project resources > Resources list

Resource roles

Roles created or updated in Finance and Operations will be created or updated in Project Operations using dual-write. New fields Role Id and Company added to Resource categories form in Project Operations to update the Role integrating from specific legal entity.

Go to Project management accounting > Setup > Resources > Resource roles

Price groups

Price/discount group records created or updated in Finance and Operations will be created or updated in Project Operations using dual-write where Price/Discount group type = Price type and Module = Customer as Price lists.

Go to Sales and marketing > Price and discounts > Customer price/discount groups

Role cost/sales prices

Sales prices created or updated in Finance and Operations will be created or updated in the Project Operations using dual-write as Price list for role prices. It is applicable for the hour sales prices created or updated in Finance and Operations where “Role ID” is not blank, “Valid for” = All, “Sales price model” = Qty. and following fields are blank.

  • Category, Resource, Project ID, Project contract ID, Customer account and Price group

Go to Project management and accounting > Setup > Prices > Sales price (hour)

Cost prices created or updated in Finance and Operations will be created or updated in the Project Operations using dual-write.

Go to Project management and accounting > Setup > Prices > Cost price (hour)

Note – Only “Cost price (hour)”, “Sales price (hour)” configured by role will be synced between Finance and Operations and Project Operations.

Actual transactions

Project transactions posted or updated in Finance and Operations will be created or updated in the Project Operations actuals using dual-write. Only project transactions created in Finance and Operations will be synced to Project Operations and the sync is applicable only for transaction types Hour, Expense and Fee. In case of Hour and Expense transaction it will create or update two actual transactions i.e., A cost transaction and a revenue transaction where-as in case of Fee transaction only revenue transaction will be created or updated in Project Operations.

Contract reason codes

Contract reason codes created or updated in the Finance and Operations will be created or updated in the Project Operations and vice versa.

Go to Project management and accounting > projects360 Setup > Contract management > Contract reason codes