How to add customer details and customer ledger entry i

suryateja

hi everybody,

i need to add customer details and ledger entries in same column in export to excel............is it possible please help me

mohana_cse06

Can you be more clear?
in same column or row?

suryateja

In same column..

mohana_cse06

mohana_cse06 wrote:

Can you be more clear?

with example..

suryateja

okay for example

cus001 surya

1000000
8498
89438

// i want this loan details to be started from the column
exactly beside customer details in export exel
i.e cus001 surya 10000
8498
89438

julkifli33

suryateja wrote:

okay for example

cus001 surya

1000000
8498
89438

// i want this loan details to be started from the column
exactly beside customer details in export exel
i.e cus001 surya 10000
8498
89438

which nav version do you use?

suryateja

I use NAV 2009 SP1

suryateja

hi experts,
please check my code and help me

in pre data item

Row := 1;

in on after get record()

EnterCell(Row,1,Customer."No.",TRUE,FALSE,'helo');
EnterCell(Row,2,Customer.Name,TRUE,FALSE,'helo');
EnterCell(Row,3,Customer."Phone No.",TRUE,FALSE,'helo');
EnterCell(Row,4,Address,TRUE,FALSE,'helo');
EnterCell(Row,5,Customer."Search Name",TRUE,FALSE,'helo');
Row := Row + 1;

mohana_cse06

what is the problem/question here in your code?
What is last parameter 'helo'?

You are incrementing row number after exporting Customer details..increment it after exporting loan details..

suryateja

Hi mohana,
thanks for reply ... am a fresher here i written this code for practise... will u please tell me how should i increment row after exporting loan details

mohana_cse06

Please contact your ssenior in office and ask for training.. :thumbsup: