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

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

  • 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans