Unable to copy and Past into Excel

elmarfv

Hi guys,

I am having a problem with form 408 "G/L Balance by Dimension" in version 4.0. I used to be able to copy from the form directly into Excel, but now I only get the headings of the fields, but not the value of them. Is there a setup I am missing or is this the way the new Navision works now?

ara3n

works fine on 4.0 Sp2 client.

kriki

[Topic moved from Navision Attain forum to Navision forum]

johnson_alonso

It should be work too in NAV 4.0. I think there is maybe something worng with the header (filter functions) or codeunit. this following C/AL coding I copied from my editor:

SetCommonFilters(AnalysisViewEntry);
AnalysisViewEntry.FIND('-');
AnalysisViewToExcel.ExportData(
AnalysisViewEntry,LineDimCode,ColumnDimCode,ShowOppositeSign,
ShowInAddCurr,AmountField,PeriodType,ShowColumnName, DateFilter,GLAccFilter, BudgetFilter,
Dim1Filter, Dim2Filter, Dim3Filter, Dim4Filter, AmountType, ClosingEntryFilter, ShowActualBudg, BusUnitFilter);

C/AL Local:
Name DataType Subtype Length
AnalysisViewToExcel Codeunit Export Analysis View
2. etc.

Rgds,
Johnson


http://sea-navision-community.blogspot.com
mailist:
sea-navision-community-subscribe@yahoogroups.com