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