Hi Anitha,
Thanks for your reply.
I am trying to create a report with the below fields. I am using only one Table
: VendPackingSlipTrans
VendPackingSlipTrans Table : fields
purchId
ItemId
Name
Purch_Unit
PackingSlipId
DeliveryDate
Ordered
Qty
Remain
for the purchase price field in the report of the Item i have created a method
on PurchLine Table
display real ItmPrice()
{
PurchLine purchLine;
;
select PurchPrice from purchLine
where purchLine.ItemId == this.ItemId && purchLine.PurchId == this.purchId;
return purchLine.PurchPrice;
}
Since PurchasePrice & DeliveryTerms fields are not available in
VendPackingSlipTrans Table
I have created a field : Real in the report Body Properties are :
Table : PurchLine
DataMethod : itmPrice
& the same way i am following for Delivery Terms.
display str DelTerms()
{
PurchTable purchTable;
;
select Payment from purchTable
where purchTable.PurchId == this.PurchId;
return purchTable.Payment;
}
PO Item Name
from
VendPackingSlipTrans Table
UOM
from
VendPackingSlipTrans Table CURRENCY
from
VendPackingSlipTrans Table Price
from
Method on
PurchLine Table ORDER QTY
from
VendPackingSlipTrans Table
RECD. QTY
from
VendPackingSlipTrans Table BAL. QTY
from
VendPackingSlipTrans Table STATUS
from
VendPackingSlipTrans Table PAYMENT TERM
from
Method on
PurchLine Table GRN No
from
VendPackingSlipTrans Table GRN Date
from
VendPackingSlipTrans Table Delivery Schedule 1
Delivery Schedule 11
MFS 40% kg sar 2.5 250 250 0 Closed 30days
Hope this is clear for you, Kindly advice me how solve this issue.
BR
Khan.
----- Forwarded Message ----
From: Anitha Santosh <mail2eani...@gmail.com>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tue, April 6, 2010 9:06:00 AM
Subject: Re: [Axapta-Knowledge-Village] Display methods...
Khan,
I guess you have attached the method in Body part of the report design.
what is the table name property in the Body ??
If the table name is not "PurchLine" , the values will not be displayed.
Mail me if you have further doubts.
Regards,
AnithaSantosh
On Sun, Apr 4, 2010 at 7:53 PM, Khan Axapta <axaptak...@yahoo. com> wrote:
>Hi Friends,
>
>I am a new guy doing Technical stuff AX.
>
>I am creating a report from VendPackingSlipTans
>I have created 2 display method on PurchLine Table to display
>Purchaseprice & PaymentMethod
>
>display real ItmPrice()
>{
> PurchLine purchLine;
>;
> select PurchPrice from purchLine
> where purchLine.ItemId == this.ItemId && purchLine.PurchId == this.purchId;
>info(this.ItemId) ;
>info(purchLine. ItemId);
> return purchLine.PurchPric e;
>}
>------------ --------- --------- --------- --------- ---------
>
>display str DelTerms()
>{
> PurchTable purchTable;
>;
> select Payment from purchTable
> where purchTable.PurchId == this.PurchId;
> return purchTable.Payment;
>}
>------------ --------- --------- --------- --------- --
>
>
>I am using these methods in VendPackingSlipTran s to display purchasePrice &
>PaymentMethod.
>
>But when i run the report both coloumns are coming blank.
>
>Kindly Advice what might be the reason.
>
>
>
>
