Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Populating custom data from salestable to custinvoiceJour

Posted on by 1,534

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

  • munsif Profile Picture
    munsif 1,534 on at
    RE: Populating custom data from salestable to custinvoiceJour

    boss, actually i want to pass custom fields from salestable to custinvoiceJour table, for this i create custom table ,make relationship with salesTable also with custinvoiceJour,the data is populating in saleTable correctly, i also follow same behavior for custinvocieJour and called my custom field in initFromSalesTable method of custinvoicejour, problem is that some custom fields are populating,but one of custom field not populating,

  • Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at
    RE: Populating custom data from salestable to custinvoiceJour

    can please share the query

  • Verified answer
    5400 Profile Picture
    5400 7,160 on at
    RE: Populating custom data from salestable to custinvoiceJour

    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.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: Populating custom data from salestable to custinvoiceJour

    i try & test both, but not good one?

  • 5400 Profile Picture
    5400 7,160 on at
    RE: Populating custom data from salestable to custinvoiceJour

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

  • munsif Profile Picture
    munsif 1,534 on at
    RE: Populating custom data from salestable to custinvoiceJour

    value exist in salesTable,

  • 5400 Profile Picture
    5400 7,160 on at
    RE: Populating custom data from salestable to custinvoiceJour

    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,534 on at
    RE: Populating custom data from salestable to custinvoiceJour

    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,160 on at
    RE: Populating custom data from salestable to custinvoiceJour

    can you past your code in details.

  • munsif Profile Picture
    munsif 1,534 on at
    RE: Populating custom data from salestable to custinvoiceJour

    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!

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans