Finance | Project Operations, Human Resources, ...

Adding Customer Telephone to Sales Invoice

(0) Share

Report

Posted on by Lionel07

495

Hello Everyone, Can someone assist me in adding customer telephone number to the sales invoice form. The problem I am having is that "locator" in the table LogisticsElectronicAddress(field for the telephone number) is not apart of the dataset that makes up the report. I have added the field but it didn't work. is there any sample example out there? can someone point me in the right direction pls? Thanks for the help.

I have the same question (0)

All responses (7)

Answers (0)

Pedro Tornich 955 on at

Like (0)

Report

Hello,

Are you referring to the Sales Invoice form or report?

Can you please share more details or screen shots to clarify which dataset is used and why the locator field is not part of it?

Also, can you share a screen shot of your solution, so we can try to figure out what may be wrong.

Was this reply helpful? Yes No
Lionel07 495 on at

Like (0)

Report

Hi Pedro, am referring to the salesinvoicere report.

Please see the image of what I would like to achieve. The area with blue writing is where i want the customer telephone number to go.

On the report in VisualStudio Tools the customer telephone number field is not in any of the datasets. (I have expanded the fields.)

I am contending that the customer telephone number is stored in this table LogisticsElectronicAddress because when right-click the field and select personalize, this is what it shows.

ContactInfo_Locator
LogisticsElectronicAddress(LogisticsElectronicAddress).Locator

Please help thanks much.

Was this reply helpful? Yes No
Suggested answer

Pedro Tornich 955 on at

Like (1)

Report

This report is based on a Data Provider, so you will need to add the field to the corresponding temporary table and then you will need to add code to the data provider to fill your field.

Was this reply helpful? Yes No
Lionel07 495 on at

Like (0)

Report

yes, I understand thus far.. would you happen to have any sa,ple code? or point me where i can see an example?

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Lionel07,

Please take a look at link below that has some good links to get started.

community.dynamics.com/.../how-can-i-customize-sales-invoice-report-in-dynamics-365

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Lionel07,

Do you have any further questions on this thread. If your question has been answered, please take time to help verify the answer.

Was this reply helpful? Yes No
Lionel07 495 on at

Like (0)

Report

Hello Satish, am still trying to complete this implementation.

Was this reply helpful? Yes No