最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Relation between VendInvoiceInfoTable and VendInvoiceJour Dynamics Ax 2012 R3

网络文摘 alirazazaidi 1463浏览 0评论

Relationship between VendInvoiceInfoTable and VendInvoiceJour. Is Parm Id. This problem occurs when we need some customization on vendor Invoice form and values of these fields required in reporting. Due to minor nature no impact on calculation. For getting these fields to VendorInoviceJour required complex customization, God knows what will broke or long way of testing require for it. So best way to fetch it form VendorInvoiceInfoTable.

I test it on SQL Server on contoso data  with following Query

select parmid,* from vendinvoicejour where parmid in(
select parmid from VendInvoiceInfoTable where PURCHID=’000003′)

 

Its works for me.

Reference: https://community.dynamics.com/ax/f/33/t/187795

 

 

 

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址