How to add customer details and customer ledger entry i

suryateja · 2012-04-03

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 · 2012-04-03

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

suryateja · 2012-04-03

In same column..

mohana_cse06 · 2012-04-03

mohana_cse06 wrote:

Can you be more clear?

with example..

suryateja · 2012-04-03

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 · 2012-04-03

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 · 2012-04-04

I use NAV 2009 SP1

suryateja · 2012-04-04

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 · 2012-04-04

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 · 2012-04-04

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 · 2012-04-04

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

How to add customer details and customer ledger entry i

Comments

Categories