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

Dynamics AX 2012 R3 PurchLine 与 PurchReqline 的表关系/Relation between PurchLine and PurchReqline Tables in Dynamics AX 2012 R3.

网络文摘 alirazazaidi 69浏览 0评论
In one of SSRS Report requirement, client wants to see Purchase order quantity, Invoice Quantity against items purchase requisition Quantity.   Instead of writing a query on ItemId and InventdimId, I found out of the box function In PurchReqLine table. This method return the reference of Purchline. With reference of Purchline, I can get Purchase order Number and get Item Invoiced quantity.  
PurchLine       purchLine;

PurchReqLine reqline;

 

_purchLine = reqline.purchLine();

 

 
The relationship between Purchline and PurchReqline is RecId, Purchline contains the Reference RecId of PurchReqline.  
PurchLine       purchLine;

 

if (this.PurchId && this.LineRefId)

{

select firstonly purchLine

where purchLine.PurchId           == this.PurchId    &&

purchLine.PurchReqLineRefId == this.LineRefId  &&

!purchLine.IsDeleted;

}

发表我的评论
取消评论

表情

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

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