Facing an issue in building an inbound ER file for VendorInvoiceLineEntity and attempting to assign an accounting distribution template to the line..
The AccountingDistributionTemplateId(Template ID): String field does not resolve . It is actually the same with DMF entity - It systematically returns an error cannot find the template even if it exist .
So I tried using TemplateID(TemplateId : int 64 ) instead. This works but require to pass the proper AccountingDistributionTemplate RecId ),
To that end I added to my model : Table records for AccountingDsitribtuionTemplate ( DataAreaId(string),LegalEntity(Int64),Name(string),RecId(Int64 ) and calculated fields to filter according to TemplateId Name and the company/legal entity to get the appropriate AccountingDsitribtuionTemplate.RecId
For some reasons system always appeared to return records from the DAT company( if name exist in DAT ) or else Nothing ( when no matching name in DAT )
- The LegalEntity field can not be used . Always reporting error "Evaluating expression for path 'LegalEntity'.Cannot find 'LegalEntity' field in 'AccountingDistributionTemplate' table"
- AccountdistributionTemplate ( confirmed via Debug set below ) return all records with DataAreaId = DAT
Is this some bug or do I miss something ? . It makes it impossible to get the specific template ID define for a Legal entity . I actually filtered in 2 time to follow recommendations on Filter with DataAreaId , but this does not help ( beside DataAreaId is not an actual field in the actual table LegalEntity is , but as a string ) . Also tried with table record being set to Cross company or not which make no difference , This is quiet confusing
Debug more returning AccountDistributiontemplate Table records . Return DataAreaId= DAT on all records and throw error on LegalEntity
the actual table ( systablebrowser )
