web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Sales Agreements form doesn't show data from table

(0) ShareShare
ReportReport
Posted on by

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?

I have the same question (0)
  • Verified answer
    Gunjan Bhattachayya Profile Picture
    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
    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
    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
    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
    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
    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
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans