Problem in standard function - Export to Excel

wfmun

I tried to export posted sales invoices (listing) but i received this error when i clicked on Nav 5.0 toolbar's "Export to Excel" icon.
Problems During Load
Problems came up in the following areas during load:
Table
This file cannot be opened because of errors. Errors are listed in:
C:\Docume~1\leemei\locals~1\tempor~1\content.mso\fccfca28.log

The log file created shows the following errors:-
XML ERROR in Table
REASON: Bad Value
FILE: C:\Documents and Settings\leemei\Local Settings\Temp\Posted Sales Invoices.xml
GROUP: Cell
TAG: Data
VALUE: 2096


Can anyone please assist?
many thanks in advance....

wfmun

Dear all,
I can do the direct export for Posted Purchase Invoice, but not for Posted Sales Invoice. My guess is that the no. of records for Sales Inv is larger & excel worksheet has limited rows (65K lines?)?

If it is true, how do we tackle this?

Luc_VanDyck

Do you really have > 65000 lines in one (1) Sales Invoice?

You can use Excel 2007, which has a limit of 1048576 rows.

wfmun

Thanks for your reply Luc.

Do you really have > 65000 lines in one (1) Sales Invoice?

No. there is only 800+ sales invoices lines - for all sales invoices.

User has no problem if she copy and paste manually to Excel. the problem lies at the creation of XML file.

TonyH

Is there a character in one of your "Fields" in the sales invoice that would conflict with the way an xml document is created? i.e. />

T