web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error: Cardinality not...
Finance | Project Operations, Human Resources, ...
Suggested answer

Error: Cardinality not specified is not allowed

(0) ShareShare
ReportReport
Posted on by junior AX 1,552

 [AxDataEntityViewProjectInvoiceEntity/Metadata/ProjInvoiceOnAcc/DataSources/ProjInvoiceJour/DataSources/TaxTrans/Relations/QueryDataSourceRelation1/Cardinality]:NotSpecified is not allowed; the only allowed values are ExactlyOne, OneMore, ZeroMore or ZeroOne for the data source ProjInvoiceJour table TaxTrans relation ProjInvoiceJour cardinality.. 

This is the entity(everything is inner joined). The reason i joined with TaxTrans is because i want to get the TaxCode

The standard relation cardinality between projinvoicejour and taxTrans is not specified

So what should I do

 

1157.image-_2800_6_2900_.png

I have the same question (0)
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator on at
    RE: Error: Cardinality not specified is not allowed

    If you have tableA and VendTable and for tableA you are attaching VendTable with some relation called Vendaccount and AccountNum, then you need to give cardinality and related cardinality right.

    So if tableA can have 10 vendors with same I'd like Vend1 and in VendTable we have one Vend1. Now that means 1 Vend1 in VendTable can have 10vendors in tableA right? Similarly from tableA for 10 vendors 1 vendor is there in VendTable right?

    Assume like a mapping. So cardinality for tableA is zeromore or onemore. OneMore when atleast one related record should be present in this table A for the VendTable. And at VendTable means related cardinality would be exactly one. Means atleast one record should be there related to tableA.

    So if you understood this, based on the tables there add the cardinality for that relation.

  • junior AX Profile Picture
    junior AX 1,552 on at
    RE: Error: Cardinality not specified is not allowed

    Hi bharani,

    But this is a standard relation so I'm not sure what I should do with it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 835 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans