Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Agreements form ...
Finance | Project Operations, Human Resources, ...
Answered

Sales Agreements form doesn't show data from table

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi to all,

I have a big problem, would really appreciate someone's help with this.

I need to import new Sales Agreements headers and also lines, I am importing it from excel via job, so far I have imported the mandatory fields into salesAgreementHeader table which are cust account, currency, agreement classification, and sales number sequence, and  I am seeing them in the table but not on the form. Any solution?  Is there any particular properties that I should be looking for that forbid me to see them on the form?

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Sales Agreements form doesn't show data from table

    Great that the issue is resolved!

    You can look at  initalizeQuery method in the list page interaction class - SalesAgreementListPageInteraction. You can see the query range added here.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Agreements form doesn't show data from table

    I can't thank you enough

    that was the issue, everything Is good now

    can you point me on the path where you find the filter on the form, so i would know other time 

    Thank you again, and have a great day 

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Sales Agreements form doesn't show data from table

    I think I found the issue that you might be having. The field "CustomerDataAreaId" should be populated with the customer record data area Id.

    There is a filter in the list page based on this field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Agreements form doesn't show data from table

    thank you for you answer ,

    I checked now, it was not. I put it now , but still no luck on the form 

    Any more ideas maybe?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Sales Agreements form doesn't show data from table

    When you check the data, could you check if the field SellingLegalEntity is populated in the imported records?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Agreements form doesn't show data from table

    Yes, I am putting the curext()=="legal entity number" first when doing the job, as for the customization I really don't know since I am  new here 

    is there anything in particular that I should be looking for ?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Sales Agreements form doesn't show data from table

    Hi SIwannaS,

    Did you cross check if the you imported the data into the correct legal entity? Also, do you have any customizations done to SalesAgreement form?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans