how to update field values in vend Table form to vendor transaction form when an purchase order form post status invoiced

(0) Share

Report

Posted on by Community Member

Hi ..

create a new filed in vendor table field name is remarks . create the same field in vendor transaction .. i mean vendor form - transaction button . when we post purchase order invoice, i want vendor table remarks to be flown to vendor transaction form ..

for this where i need write coding to insert r update the field values .. any one suggest me some information for this

*This post is locked for comments

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi Kavin,

I'm not sure of your requirement, you are saying the "Remarks" field is available in VendTable and you want to update the same in VendTrans during posting, instead why don't you write a display method on VendTrans and get the value from VendTable directly.

though if you want to do it that way, then have a look at Class PurchInvoiceJournalPost > PostCustVend (method) which will create the vendTrans record during invoice post.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

Hi Kavin,

I wonder why you want to duplicate data. What is the business requirement here? Would perhaps a display method a solution?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ganesan , thanks for your information .. may i know the version .. i m using 2009 dynamics ax . and i not have class name like purchinvoicejournalpost ... can you tel me some more information for this ...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Oh okay, in that case you should look at PurchFormletter_Invoice > CreateVendTrans

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ganesan .. can you please say me where i want to write display method ........

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

the requirement given to me for adding one field in vend table for once purchase order is posting invoiced means i want the filed values in vend table was updated the field in vend trans after status is posted to invoice in po .... so here i m using the field in vend table

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Since your source is VendTable (Table) and you want the data to be flowed down to VendTrans (Table) you can write a display method on VendTrans table to get the data from VendTable and display.

but if you could tell me what exactly your requirement is i can give you more specifics.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i want to create a new field (Remarks) in Vendtrans and Vendtable during invoicing of purchase order the field in Vendtable must be flown to Vendtrans that is Vendor transaction form . this my requirement Ganesan .............

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

/// This remarks field will get inserted into VendTrans Form from the VendTable while invoicing of purchase order

// this.Remarks = vendTable::find(this.OrderAccount).Remarks;

i use code in table insert method but my client asking me to do in class ... i not know how to use class for insert this field values for this .............. can you suggest me some more information for this

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

and this will be used in some invoice reports / invoice inquiry forms i guess, in that case you do not have to create the field in VendTrans table, just create the field in VendTable, and write a display method in VendTrans table. you can use this display method on form / report to display this information.

Since vendTrans will have the vendaccount and using that you can find the related vendTable record and get the remarks field value.

Was this reply helpful? Yes No

Community site session details

how to update field values in vend Table form to vendor transaction form when an purchase order form post status invoiced

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

how to update field values in vend Table form to vendor transaction form when an purchase order form post status invoiced

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates