Customers Integration

This feature is introduced to integrate the Customers created in Project Operations be seamlessly integrated with Business Central. The standard functionality of Customer creation in Project Operations is synchronized with Business Central through the Dataverse Connection setup.

Any changes (creation, modification, update, deletion) made to Customers in Project Operations will automatically synchronize with Business Central. Ensures consistency and accuracy of customer data across both platforms.

A new ‘Company’ and ‘Company Name’ fields have been introduced on the Customer details form in Project Operations. Users can define which company in Business Central to integrate the customer with, ensuring customers are linked to specific companies in Business Central.

Sales > Customer > Customer details > evergreen tab

Fields Description
Company
  • Editable and Mandatory field
  • User will define the company available in Business Central from the drop-down list
Company Name
  • Indicates the Company Name

Integrate Customers in Business Central

A new table, “Dataverse Customers” has been introduced in Business Central to streamline the integration of customers from Project Operations. This integration ensures seamless synchronization and supports both manual and automatic updates between Project Operations and Business Central.

Users can create, modify, update or delete customers from Project Operations directly into Business Central.

Users can select a record in the Dataverse Customers form and manually trigger the “Create Business Central” button. This action will create customers in Business Central or update existing records if modifications are made in Project Operations.

A “Coupled” field in the Dataverse customers table switches to “Yes” upon successful creation of the customers in Business Central.

Customers (from Navigation Menu) >Dataverse > Dataverse-Customers

Fields Description
Name
  • Indicates the name of the customer
Primary contact name
  • Indicates the Name of the Primary contact
Relationship type
  • Indicates the customer type
Street 1
  • Indicates the Street details
Street 2
  • Indicates the Street details
Zip/Postal Code
  • Indicates the zip/postal code
City
  • Indicates the city of the customer
Country/Region
  • Indicates the country/region of the customer
Coupled
  • Is a Yes or No field which indicates if data is coupled with BC Customer Table or not
Modified on
  • Indicates the date when it was last modified

Customers (from Navigation Menu) > Business Central > BC Customers

Automatic Integration

Dataverse customers table facilitates automatic integration of customers from Project Operations to Business Central. Users have the option to configure batch processes that automatically create or update customers in Business Central based on changes made in Project Operations.

Administration (From Navigate menu) > Job Queue Entries

Customers deletion

A new table, “Dataverse Deleted Customers” has been introduced in Business Central to streamline the integration of deleted customers from Project Operations. This integration ensures seamless synchronization and supports both manual and automatic deletion between Project Operations and Business Central.

Users can select a record in the Dataverse Deleted Customers form and manually trigger the “Create Business Central” button. This action will delete Customers in Business Central.

A “Coupled” field in the Dataverse Deleted Categories table switches to “Yes” upon successful deletion of the customers in Business Central.

Automatic Integration

Dataverse Deleted Customers table facilitates automatic integration of customers deletion from Project Operations to Business Central. Users have the option to configure batch processes that automatically deletes the contacts in Business Central.

Customers (from Navigation Menu) >Dataverse > Dataverse Deleted Customers

Customers (from Navigation Menu) >Business Central >BC Deleted Customers

Fields Description
Staging Processing Status
  • Indicates the status of the staging process
Deletion Initiated From
  • Indicates from where the deletion was initiated
BC Table Name
  • Indicates the BC table name
BC Value
  • Indicates the BC customer’s name
BC Deletion Description
  • Indicates the description of the deletion status
BC Record ID
  • Indicates the ID of the record deleted in Business Central
CDS Table Name
  • Indicates the name of the PO table in which the record has been deleted
CDS Record ID
  • Indicates the ID of the record deleted in PO
CDS Company ID
  • Indicates the Company GUID
CDS Company Name
  • Indicates the Company name
Record Created At
  • Indicates when the record was created
Record Created By
  • Indicates who created the record

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment