How to identify =Code.getdata (9,1) is for Company name in Sales Invoice

Chetan
Chetan Member Posts: 15
in NAV Three Tier
I SEE in Sales Invoice report

there is a code like this --> =Code.getdata (9,1)

it refers to company name

how do i know that 9,1 = company name?
Chetan
Bangalore

Best Answer

  • Capone
    Capone Member Posts: 125
    edited 2015-12-03 Answer ✓
    http://navfreak.com/2015/10/11/dynamics-nav-reports-rdlc-setdata-getdata-and-line-numbers/

    Or you use the following list. This is from report 206 version NAVW18.00,NAVSE8.00.
    GetData(LineNo, 1):

    1 =Code.SetData(Cstr(Fields!CustAddr1.Value) + Chr(177) +
    2 Cstr(Fields!CustAddr2.Value) + Chr(177) +
    3 Cstr(Fields!CustAddr3.Value) + Chr(177) +
    4 Cstr(Fields!CustAddr4.Value) + Chr(177) +
    5 Cstr(Fields!CustAddr5.Value) + Chr(177) +
    6 Cstr(Fields!CustAddr6.Value) + Chr(177) +
    7 Cstr(Fields!CustAddr7.Value) + Chr(177) +
    8 Cstr(Fields!CustAddr8.Value) + Chr(177) +
    9 Cstr(Fields!BilltoCustNo_SalesInvHdr.Value) + Chr(177) +
    10 Cstr(Fields!VATRegNo_SalesInvHdr.Value) + Chr(177) +
    11 Cstr(Fields!YourReference_SalesInvHdr.Value) + Chr(177) +
    12 Cstr(Fields!No_SalesInvHdr.Value) + Chr(177) +
    13 Cstr(Fields!HdrOrderNo_SalesInvHdr.Value) + Chr(177) +
    14 Cstr(Fields!PostingDate_SalesInvHdr.Value) + Chr(177) +
    15 Cstr(Fields!DueDate_SalesInvHdr.Value) + Chr(177) +
    16 Cstr(LineNo Cstr(Fields!PricesInclVATYesNo_SalesInvHdr.Value)) + Chr(177) +
    17 Cstr(First(Fields!DocDate_SalesInvHdr.Value)) + Chr(177) +
    18 Cstr(Fields!SalesPurchPersonName.Value) + Chr(177) +
    19 Cstr(Fields!DocumentCaptionCopyText.Value) + Chr(177) +
    20 Cstr(Fields!PaymentTermsDesc.Value) + Chr(177) +
    21 Cstr(Fields!ShipmentMethodDesc.Value) + Chr(177) +
    22 Cstr(Fields!CompanyAddr1.Value) + Chr(177) +
    23 Cstr(Fields!CompanyAddr2.Value) + Chr(177) +
    24 Cstr(Fields!CompanyAddr3.Value) + Chr(177) +
    25 Cstr(Fields!CompanyAddr4.Value) + Chr(177) +
    26 Cstr(Fields!CompanyAddr5.Value) + Chr(177) +
    27 Cstr(Fields!CompanyAddr6.Value) + Chr(177) +
    28 Cstr(Fields!CompanyInfoPhoneNo.Value) + Chr(177) +
    29 Cstr(Fields!OrderNoText.Value) + Chr(177) +
    30 Cstr(Fields!EMail.Value) + Chr(177) +
    31 Cstr(Fields!HomePage.Value) + Chr(177) +
    32 Cstr(Fields!CompanyInfoVATRegNo.Value) + Chr(177) +
    33 Cstr(Fields!CompanyInfoGiroNo.Value) + Chr(177) +
    34 Cstr(Fields!CompanyInfoBankName.Value) + Chr(177) +
    35 Cstr(Fields!CompanyInfoBankAccNo.Value) + Chr(177) +
    36 Cstr(Fields!PricesInclVAT_SalesInvHdrCaption.Value) + Chr(177) +
    37 Cstr(Fields!InvNoCaption.Value) + Chr(177) +
    38 Cstr(Fields!SalesInvPostingDateCptn.Value) + Chr(177) +
    39 Cstr(Fields!BilltoCustNo_SalesInvHdrCaption.Value) + Chr(177) +
    40 Cstr(Fields!CompanyInfoBankAccNoCptn.Value) + Chr(177) +
    41 Cstr(Fields!CompanyInfoBankNameCptn.Value) + Chr(177) +
    42 Cstr(Fields!CompanyInfoGiroNoCaption.Value) + Chr(177) +
    43 Cstr(Fields!CompanyInfoVATRegNoCptn.Value) + Chr(177) +
    44 Cstr(Fields!CompanyInfoPhoneNoCaption.Value) + Chr(177) +
    45 Cstr(Fields!PageCaption.Value) + Chr(177) +
    46 Cstr(Fields!ReferenceText.Value) + Chr(177) +
    47 Cstr(Fields!SalesPersonText.Value) + Chr(177) +
    48 Cstr(Fields!VATNoText.Value) + Chr(177) +
    49 Cstr(Fields!SalesInvDueDateCaption.Value) + Chr(177) +
    50 Cstr(Fields!DocumentDateCaption.Value) + Chr(177) +
    51 Cstr(Fields!PaymentTermsDescCaption.Value) + Chr(177) +
    52 Cstr(Fields!ShptMethodDescCaption.Value) + Chr(177) +
    53 Cstr(Fields!EMailCaption.Value) + Chr(177) +
    54 Cstr(Fields!HomePageCaption.Value) + Chr(177) +
    55 Cstr(Fields!PlusGiroNoCaption.Value) + Chr(177) +
    56 Cstr(Fields!CompHasTaxAssessCaption.Value) + Chr(177) +
    57 Cstr(Fields!CompanyInfoRegisteredOffice.Value) + Chr(177) +
    58 Cstr(Fields!CompanyInfoPlusGiroNo.Value) + Chr(177) +
    59 Cstr(Fields!BoardOfDirectorsLocCaption.Value), 1)
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?
    http://www.navfreak.com

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Please check this blog
    http://www.dynamicsnavconsultant.com/2010/07/how-to-define-setdata-and-getdata-in-rtc-reports-in-dynamics-nav-navision/

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Chetan
    Chetan Member Posts: 15
    Hi Mohana,

    Thanks for your response.

    Kindly note that I am using NAV 2013R2 & Report Builder 3.0 in which, with in the layout I was not able to trace any small hidden field in red, on the upper left corner of the layout which consists of GetData/SetData string.

    Could you please suggest me, Is it a better option to modify the existing Sales Invoice or Create a new layout to meet customers requirement.

    Thanks in advance.
    Chetan
    Bangalore
  • Capone
    Capone Member Posts: 125
    edited 2015-12-03 Answer ✓
    http://navfreak.com/2015/10/11/dynamics-nav-reports-rdlc-setdata-getdata-and-line-numbers/

    Or you use the following list. This is from report 206 version NAVW18.00,NAVSE8.00.
    GetData(LineNo, 1):

    1 =Code.SetData(Cstr(Fields!CustAddr1.Value) + Chr(177) +
    2 Cstr(Fields!CustAddr2.Value) + Chr(177) +
    3 Cstr(Fields!CustAddr3.Value) + Chr(177) +
    4 Cstr(Fields!CustAddr4.Value) + Chr(177) +
    5 Cstr(Fields!CustAddr5.Value) + Chr(177) +
    6 Cstr(Fields!CustAddr6.Value) + Chr(177) +
    7 Cstr(Fields!CustAddr7.Value) + Chr(177) +
    8 Cstr(Fields!CustAddr8.Value) + Chr(177) +
    9 Cstr(Fields!BilltoCustNo_SalesInvHdr.Value) + Chr(177) +
    10 Cstr(Fields!VATRegNo_SalesInvHdr.Value) + Chr(177) +
    11 Cstr(Fields!YourReference_SalesInvHdr.Value) + Chr(177) +
    12 Cstr(Fields!No_SalesInvHdr.Value) + Chr(177) +
    13 Cstr(Fields!HdrOrderNo_SalesInvHdr.Value) + Chr(177) +
    14 Cstr(Fields!PostingDate_SalesInvHdr.Value) + Chr(177) +
    15 Cstr(Fields!DueDate_SalesInvHdr.Value) + Chr(177) +
    16 Cstr(LineNo Cstr(Fields!PricesInclVATYesNo_SalesInvHdr.Value)) + Chr(177) +
    17 Cstr(First(Fields!DocDate_SalesInvHdr.Value)) + Chr(177) +
    18 Cstr(Fields!SalesPurchPersonName.Value) + Chr(177) +
    19 Cstr(Fields!DocumentCaptionCopyText.Value) + Chr(177) +
    20 Cstr(Fields!PaymentTermsDesc.Value) + Chr(177) +
    21 Cstr(Fields!ShipmentMethodDesc.Value) + Chr(177) +
    22 Cstr(Fields!CompanyAddr1.Value) + Chr(177) +
    23 Cstr(Fields!CompanyAddr2.Value) + Chr(177) +
    24 Cstr(Fields!CompanyAddr3.Value) + Chr(177) +
    25 Cstr(Fields!CompanyAddr4.Value) + Chr(177) +
    26 Cstr(Fields!CompanyAddr5.Value) + Chr(177) +
    27 Cstr(Fields!CompanyAddr6.Value) + Chr(177) +
    28 Cstr(Fields!CompanyInfoPhoneNo.Value) + Chr(177) +
    29 Cstr(Fields!OrderNoText.Value) + Chr(177) +
    30 Cstr(Fields!EMail.Value) + Chr(177) +
    31 Cstr(Fields!HomePage.Value) + Chr(177) +
    32 Cstr(Fields!CompanyInfoVATRegNo.Value) + Chr(177) +
    33 Cstr(Fields!CompanyInfoGiroNo.Value) + Chr(177) +
    34 Cstr(Fields!CompanyInfoBankName.Value) + Chr(177) +
    35 Cstr(Fields!CompanyInfoBankAccNo.Value) + Chr(177) +
    36 Cstr(Fields!PricesInclVAT_SalesInvHdrCaption.Value) + Chr(177) +
    37 Cstr(Fields!InvNoCaption.Value) + Chr(177) +
    38 Cstr(Fields!SalesInvPostingDateCptn.Value) + Chr(177) +
    39 Cstr(Fields!BilltoCustNo_SalesInvHdrCaption.Value) + Chr(177) +
    40 Cstr(Fields!CompanyInfoBankAccNoCptn.Value) + Chr(177) +
    41 Cstr(Fields!CompanyInfoBankNameCptn.Value) + Chr(177) +
    42 Cstr(Fields!CompanyInfoGiroNoCaption.Value) + Chr(177) +
    43 Cstr(Fields!CompanyInfoVATRegNoCptn.Value) + Chr(177) +
    44 Cstr(Fields!CompanyInfoPhoneNoCaption.Value) + Chr(177) +
    45 Cstr(Fields!PageCaption.Value) + Chr(177) +
    46 Cstr(Fields!ReferenceText.Value) + Chr(177) +
    47 Cstr(Fields!SalesPersonText.Value) + Chr(177) +
    48 Cstr(Fields!VATNoText.Value) + Chr(177) +
    49 Cstr(Fields!SalesInvDueDateCaption.Value) + Chr(177) +
    50 Cstr(Fields!DocumentDateCaption.Value) + Chr(177) +
    51 Cstr(Fields!PaymentTermsDescCaption.Value) + Chr(177) +
    52 Cstr(Fields!ShptMethodDescCaption.Value) + Chr(177) +
    53 Cstr(Fields!EMailCaption.Value) + Chr(177) +
    54 Cstr(Fields!HomePageCaption.Value) + Chr(177) +
    55 Cstr(Fields!PlusGiroNoCaption.Value) + Chr(177) +
    56 Cstr(Fields!CompHasTaxAssessCaption.Value) + Chr(177) +
    57 Cstr(Fields!CompanyInfoRegisteredOffice.Value) + Chr(177) +
    58 Cstr(Fields!CompanyInfoPlusGiroNo.Value) + Chr(177) +
    59 Cstr(Fields!BoardOfDirectorsLocCaption.Value), 1)
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?
    http://www.navfreak.com
  • LCosta
    LCosta Member Posts: 33
    Hi Chetan,

    It really depends on the number of changes you wanna make.
    When the requirements in the layout structure are just too many, I simple export the report in .txt, give it another ID, import back and just make the changes in the layout part, since the NAV structure remains the same.

Categories