News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Add Customer Purchase ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Add Customer Purchase Order number to Customer Account Statement ER Document

(0) Share

Report

Report

Posted on by Hetal Gore

47

Hi

I am hoping someone can help

I would like to add the Customer Requisition to the Customer Account Statement - Derived from the Microsoft ER Config:

I have added the table to the format and tried mapping the field directly, but at run time the first value is picked not the value corresponding to the customer.

I have tried to complete an IF statement but it will always comes out as FALSE.

Can you advise how i can get the correct Customer Requisition to appear for each customer account statement?

Kind Regards,

Hetal

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Gaurangkumar Jani 4,511 User Group Leader on at

Like (0)

Report

RE: Add Customer Purchase Order number to Customer Account Statement ER Document

Hi Hetal Gore,

What you need is not available in existing ER format and model.

I would suggest extending the model by adding additional field on the line transaction and map with this field from customer invoice table.

Please let us know if this helps.

Thanks,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2

Martin Dráb 230,433 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans