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

Dynamics Ax 2012 R3 中 VendPackingSlipJour 和 PurchParmTable 的关系 / Relation between VendPackingSlipJour and PurchParmTable Dynamics Ax 2012 R3

Couple of days ago, I was helping a young developer. Who was doing some customization. He added some customization in PurchParmtable and want information in VendPackingSlipJour Table. It was very strange that there is no direct relationship between vendPackingSlipJour and  PurchParmTable.   After Exploring I found that There is ParmId field in VendPackingSlipVersion table. And we can get VendPackingSlipVersion by static method with PurchId and PackingSlipId, DeliveryDate.   This ParmId has relation with PurchParmTable. I wrote down following code snippet to get Value from PurchParmTable, with respect to VendPackingSlipVersion.      
display real _netWeight()
{
PurchParmTable _purchParmTbl;
parmid _id;
_id=VendPackingSlipVersion::findFromInterCompanyPackingSlip((this.PurchId),
(this.PackingSlipId),(this.DeliveryDate)).ParmId;
select *from _purchParmTbl where _purchParmTbl.ParmId==_id;
return _purchParmTbl.NetWeght;
}
  Hopes this help
发表我的评论
取消评论

表情

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

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