Customer No. with TableReleation property

[amulaj]

We are using Business Central for our invoicing. We are now planning to install and set up the CCMS App. Our BC Tenant already has Customer data in the Microsoft Customer Table.

It would help us greatly if we could use the same Customer No. in CCMS. To achieve this, we would need to create a TableRelation to the Microsoft Customer Table. The TestTableRelation property should be set to false to support both clients with Microsoft Customer data and clients without.

Only the TableReleation on this table needs a change:
table 62000 "D4P BC Customer"

All other "Customer No." fields are referencing the "D4P BC Customer" table.

[bc4all]

I think not everyone would use it with own customers so I would suggest either have a separate field like "Customer No." or an action from the standard Customer to create a Customer in CCMS.

Maybe in this case it is better to do your company PTE depended on CCMS?

[amulaj]

@bc4all thank you for your feedback. I have tried to fix it with a new setup field. My suggestion with the changes has been created as a pull request.