Finance | Project Operations, Human Resources, ...

I bind Vendor first name to my formula designer in Electronic Reporting , but it does not appear in my report.

(0) Share

Report

Posted on by Zahra Mirzazadeh

156

Hello

I bind Vendor first name to my formula designer, but it does not appear in my report.

I created a query :

select dp.FIRSTNAME ,d.NAME,D.* from VENDTABLE as v
inner join dirpartytable as D on v.PARTY=d.RECID
inner join dirpersonname as DP on DP.PERSON=D.RECID and d.PARTITION=dp.PARTITION

it works well, but in formula designer when i bound to this path, first name doesn't appear.

GIG_Join.GIG_VendInvoiceJour_TR.'>Relations'.VendTable_InvoiceAccount.'DirPartyTable()'.'<Relations'.'DirPerson.DirPartyTable_Person'.DEL_FirstName

In above path Firstname doesn't apear .but for below path another filed (name) appears.

GIG_Join.GIG_VendInvoiceJour_TR.'>Relations'.VendTable_InvoiceAccount.'DirPartyTable()'.'<Relations'.'DirPerson.DirPartyTable_Person'.Name

Anyone can guide me?

Best Regards

Zahra

I have the same question (0)

All responses (13)

Answers (0)

Zahra Mirzazadeh 156 on at

Like (0)

Report

Hello again

I should say i found a view it is (DirPartyNameView) it has Firs Name and Last Name of Vendor.But I Can't find it in the designer Formula.

How shall I do?

Best Regards

Zahra

Was this reply helpful? Yes No
Jeremy Driscoll on at

Like (1)

Report

When you say the FirstName doesn't appear, do you mean the data or the field? Have you tried following the steps in this tutorial:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-join-data-sources

Maybe instead of a query, joining table records would work better.

Jeremy Driscoll

Microsoft Support Engineer

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

You don't need to join anything VendInvoiceJour table has vendName method you can map directly to a field.

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear Jeremy

thank you for your response,

I mean when I use this below query it shows first name .

select dp.FIRSTNAME ,d.NAME,D.* from VENDTABLE as v

inner join dirpartytable as D on v.PARTY=d.RECID

inner join dirpersonname as DP on DP.PERSON=D.RECID and d.PARTITION=dp.PARTITION

but when I find it in formula designer and run the report it doesn't show data of first name.

By the way, I used Table Query, but when I run the report first name is null.

Thank you in advance for any assistance.

best regards

Zahra

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear ievgen

Thanks for yot response, Yes there is VendName Method but it is a Combination of first name and last name of Vendor, I need first name and last name separately. How can get to those via VendInvoiceJourTable.

Thanks.

Best Regards,

Zahra

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (1)

Report

Stupid simple solution is to split the string with SPLIT function and get name and surname out of it. Otherwise using relations you should be able to get vendor table, get party from there and select DirPerson table filtered by that party. But keep in mind that party could be organization that does not have first and last name.

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear ievgen ,

I bind this Path :

select dp.FIRSTNAME ,d.NAME,D.* from VENDTABLE as v

inner join dirpartytable as D on v.PARTY=d.RECID

inner join dirpersonname as DP on DP.PERSON=D.RECID and d.PARTITION=dp.PARTITION

in formula designer:

Vendtable.'>Relations'.DirPartyTable_FK.'<Relations'.'DirPerson.DirPartyTable_Person'.DEL_FirstName

I have VendTable and want to get to Firstname. But when running this Report, First name doesn't have any data.

I got Stuck on this issue!

Thank you in advance for any assistance.

Best Regards,

Zahra

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

What party type does it have? Organization or person?

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear Ievgen,

I mean Personal vendors .

Many thanks,

Best Regards,

Zahra

Was this reply helpful? Yes No
Zahra Mirzazadeh 156 on at

Like (0)

Report

Dear All,

Can anyone help me?

Best Regards,

Zahra

Was this reply helpful? Yes No