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) / Add field in form Open...
Microsoft Dynamics AX (Archived)

Add field in form Open vendor invoices from Posting Invoice Journal..

(0) ShareShare
ReportReport
Posted on by fajar 3,805

Hi all..

in form Invoice Journal, i have field custom in lines journal.

But, i want, if i post this transaction, i can transfer this field in form Open vendor invoices.

i check in class LedgerJournalCheckPost, but i can't find method for insert in table VendTrans.

Please help me.

Thanks..

*This post is locked for comments

I have the same question (0)
  • Hajish Profile Picture
    Hajish 460 on at

    Check in PostTrans

  • fajar Profile Picture
    fajar 3,805 on at

    Thanks Hajish,

    in class LedgerJournalCheckPost\postTrans, where i can put my code for insert my custom field? thanks..

  • Suggested answer
    Rohin Profile Picture
    Rohin 4,624 on at

    Do you want to insert into vendTrans table from ledgerJourTrans (where your custom Field exist) ?

    if So, Look at vendTrans table method "initFromLedgerJournalTransApproval()" write your code there.

  • fajar Profile Picture
    fajar 3,805 on at

    Thanks Visvash,

    Before i post in this forum, i was try for add in table VendTrans\initFromLedgerJournalTransApproval.

    public void initFromLedgerJournalTransApproval(LedgerJournalTrans _ledgerJournalTrans)

    {

       this.Invoice            = _ledgerJournalTrans.Invoice;

       this.DocumentNum        = _ledgerJournalTrans.DocumentNum;

       this.DocumentDate       = _ledgerJournalTrans.DocumentDate;

       this.Approver           = _ledgerJournalTrans.Approver;

       this.Approved           = this.Approver ? _ledgerJournalTrans.Approved : NoYes::No;

       this.TransType          = _ledgerJournalTrans.TransactionType;

       this.PaymMode           = _ledgerJournalTrans.PaymMode;

       this.PaymSpec           = _ledgerJournalTrans.PaymSpec;

       this.PaymReference      = _ledgerJournalTrans.PaymReference;

       //this my code

       this.PIL_NumberSPP      = _ledgerJournalTrans.PIL_NumberSPP;

    }

    But, if i cek in form Open Vendor Invoices, this field PIL_NumberSPP not found.

    Please help.

  • Rohin Profile Picture
    Rohin 4,624 on at

    Your field is exist in VendTrans Table, so can you please check if its value is populated in VendTrans Table ( by table Brower in AOT) ?

  • Rohin Profile Picture
    Rohin 4,624 on at

    Well , I have just saw the above table method (initFeomLedgerJournalTransApproval()) is called on postTrans() method of class LedgerJournalCheckPost . And it is called only if the JournalType is Approval . So i would like to ask that are you using Approval Journal type??

  • Suggested answer
    Hajish Profile Picture
    Hajish 460 on at

    Table fields will be available in VendTrans method.

    I hope you can implement your logic there.

  • fajar Profile Picture
    fajar 3,805 on at

    Thanks Visvash,

    I try open table VendTrans, but value in field PIL_NumberSPP is null.

    use VendTrans\initFromLedgerJournalTransApproval, i try for write value in my field.

    public void initFromLedgerJournalTransApproval(LedgerJournalTrans _ledgerJournalTrans)

    {

      this.Invoice            = _ledgerJournalTrans.Invoice;

      this.DocumentNum        = _ledgerJournalTrans.DocumentNum;

      this.DocumentDate       = _ledgerJournalTrans.DocumentDate;

      this.Approver           = _ledgerJournalTrans.Approver;

      this.Approved           = this.Approver ? _ledgerJournalTrans.Approved : NoYes::No;

      this.TransType          = _ledgerJournalTrans.TransactionType;

      this.PaymMode           = _ledgerJournalTrans.PaymMode;

      this.PaymSpec           = _ledgerJournalTrans.PaymSpec;

      this.PaymReference      = _ledgerJournalTrans.PaymReference;

      //this my code

      this.PIL_NumberSPP      = 'ABC-123';

    }

    But, in table vendTrans value for my field is null.

  • Hajish Profile Picture
    Hajish 460 on at

    try after CIL generation

  • Rohin Profile Picture
    Rohin 4,624 on at

    I believe that you are not using approval Journal Type so that field is not populated by this method..

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans