Unable to fetch purchase invoice details

Markandey_Pandey

Hi all,

I am customizing the "Transfer Receipt" Report to have some details from "Purchase Invoice Header" table, here most of the fields are retrieved from the table to the report but "Anount To Vendor" vale is not comming.


//Fetching Invoice Details
Transfer Receipt No. (this is a field i have added to Purch. Inv. Header" atble.
GIN->Text
GateEntryNo->Text
GateEntryNo->Text
VendorInvNo->Text
InvoiceAmt->Decimal

following is the code i have written under Transfer Receipt Header - OnAfterGetRecord()

PurchaseInvHeader.RESET;
PurchaseInvHeader.SETRANGE("Transfer Receipt No.","Transfer Receipt Header"."No.");
IF PurchaseInvHeader.FIND('-') THEN
BEGIN
GIN:=PurchaseInvHeader."Your Reference";
GateEntryNo:=PurchaseInvHeader."Gate Entry No";
GateEntryDate:=PurchaseInvHeader."Gate Entry Date";
VendorInvNo:=PurchaseInvHeader."Vendor Invoice No.";
InvoiceAmt:=PurchaseInvHeader."Amount to Vendor";
END;

all values are comming except VendorInvNo.
VendorInvNo is having 0 always.

can anybody guide me why "Amount To Vendor" value is not retrieved.

kriki

[Topic moved from 'General Chat' forum to 'NAV/Navision' forum]

ssingla

Use Calcfield before assigning value of amount to vendor.

Markandey_Pandey

ssingla wrote:

Use Calcfield before assigning value of amount to vendor.

thanx

ssingla

Just out of curiosity : Do u have a senior backing you up or you are on your own???

Markandey_Pandey

ssingla wrote:

Just out of curiosity : Do u have a senior backing you up or you are on your own???

Yes, on our own, although i had gone for a online technical training, that was not good enough and Application Designer Guide is also having basics.
We are in touch with other partner (they have done more than 10 implementation).