Skip to main content

Notifications

Microsoft Dynamics AX forum

Transfer invoice data to payment journal during Payment proposal transfer

Posted on by Microsoft Employee

Hi,

I have created new fields in vendor invoice form (VendInvoiceInfoTable) and they will be filled in by user when they create Vendor Tax Invoice.

 

I want to transfer these new fields to payment journal lines when user creates payment proposal and transfers the lines. My problem is , here transfer happens from VendTrans and CustVendPaymProposalLine Tables and my new fields are present in in VendInvoiceInfoTable.

 

any idea?



*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Transfer invoice data to payment journal during Payment proposal transfer

    Hi Andre,

    I created these new fields in VendInvoiceJour Table and not in VendTrans as I can refer them from VendTrans whenever needed. but my problem is when i post the vendor tax invoice these fields are not reflected in VendInvoiceJour table. I am setting those fields in method 'initfromParmTable' of table 'VendInvoiceJour'.  I am not sure where to set these fields so that it would copy data from VendInvoiceInfoTable to VendInvoiceJour table.

    Any hint would be appreciated. Thanks.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,888 Super User 2024 Season 2 on at
    RE: Transfer invoice data to payment journal during Payment proposal transfer

    I would suggest to also create the fields on the VendTrans table and fill these fields during posting if the invoice. Then you can easily also use them when creating the payment proposal. You won't have to search for the vendor invoices then which will result in minimal performance inpact.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,888 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,247 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans