Mr.Khan,
Replace "this" key word with your datasource name Like
where purchLine.ItemId == VendPackingSlipTrans.ItemId && purchLine.PurchId ==
VendPackingSlipTrans.purchId;
Hopfully this willl help you.
Regards
Naveed Jadoon
--- On Tue, 4/6/10, Khan Axapta <axaptak...@yahoo.com> wrote:
From: Khan Axapta <axaptak...@yahoo.com>
Subject: [development-axapta] Fw: [Axapta-Knowledge-Village] Display methods...
To: mail2eani...@gmail.com
Cc: "AX Knowledge" <axapta-knowledge-vill...@yahoogroups.com>, "development
axapta" <development-axapta@yahoogroups.com>
Date: Tuesday, April 6, 2010, 12:27 PM
Hi Anitha,
Thanks for your reply.
I am trying to create a report with the below fields. I am using only one Table
: VendPackingSlipTran s
VendPackingSlipTran s 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.PurchPric e;
}
Since PurchasePrice & DeliveryTerms fields are not available in
VendPackingSlipTran s 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
VendPackingSlipTran s Table
UOM
from
VendPackingSlipTran s Table CURRENCY
from
VendPackingSlipTran s Table Price
from
Method on
PurchLine Table ORDER QTY
from
VendPackingSlipTran s Table
RECD. QTY
from
VendPackingSlipTran s Table BAL. QTY
from
VendPackingSlipTran s Table STATUS
from
VendPackingSlipTran s Table PAYMENT TERM
from
Method on
PurchLine Table GRN No
from
VendPackingSlipTran s Table GRN Date
from
VendPackingSlipTran s 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 <mail2eanitha@ gmail.com>
To: Axapta-Knowledge- vill...@yahoogro ups.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 <axaptakhan@ 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.
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
