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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Populating custom data...
Microsoft Dynamics AX (Archived)

Populating custom data from salestable to custinvoiceJour

(0) ShareShare
ReportReport
Posted on by munsif 1,536

hi expert, i have query regarding populating custom data from sales table to custinvoicejour table, for this i just add a relationship between my custom table ,sales table ,and custinvoice jour table, but not data are populating,

plz help me.

Regards.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    5400 Profile Picture
    5400 7,162 on at

    can you mapped your custom field in below method to populate in custInvoiceJour.

    Data Dictionary-Tables-  custinvoiceJour - methods-InitFromSalesTable

    like

    this.customfield1 = salesTable.customField1.

    etc. It should work.

  • munsif Profile Picture
    munsif 1,536 on at

    thanks for your reply, my custom fields are populating in custinvoicejour table, but not all,i checked one by one, but not good result yet!

  • 5400 Profile Picture
    5400 7,162 on at

    can you past your code in details.

  • munsif Profile Picture
    munsif 1,536 on at

    in custinvocie jour initFromsalesTable method,

    this.consultant=salesTable.Consultant;

    this.ProjecReference=salesTable.ProjecReference;

    this.Architect=salesTable.Architect;

    data in last two columns are populated from salestable but for the first field not populating, is there mistake my code, or where can i put my code in salesTable method?

  • 5400 Profile Picture
    5400 7,162 on at

    Please check this field is sysnced in custInvoiceJour table or not. Is value exist in sales Table. It should populate. if the field is not sync please synchronize the tbale or close AX or restart AOS. It should work.

    Hope, Same field is not mapped again with different field.

  • munsif Profile Picture
    munsif 1,536 on at

    value exist in salesTable,

  • 5400 Profile Picture
    5400 7,162 on at

    Please check EDT both the field and restart the AOS. It should work.  

  • munsif Profile Picture
    munsif 1,536 on at

    i try & test both, but not good one?

  • Verified answer
    5400 Profile Picture
    5400 7,162 on at

    Please put the debugger in same line and check how the value is getting vanish before insert to custInvoiceJour Table. you can solve yourself within 2 min.

  • Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at

    can please share the query

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans