Hello,
It will be much easier to use this.
In the VendPackingSlipTrans theres is a method purchline. It will not be
accurate if your condition is just itemid. Need to know the InventTransId.
Display real ItmPrice()
{
;
Return this.purchline().PurchPrice;
}
The data will not show if you haven’t put a datasource on the display method
you put in the report.
Hope this will help you.
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of Khan Axapta
Sent: Tuesday, April 06, 2010 3:28 PM
To: mail2eani...@gmail.com
Cc: AX Knowledge; development axapta
Subject: [development-axapta] Fw: [Axapta-Knowledge-Village] Display methods...
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 <mailto:mail2eanitha%40gmail.com> >
To: axapta-knowledge-vill...@yahoogroups.com
<mailto:Axapta-Knowledge-Village%40yahoogroups.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.
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
