Trouble exporting Sales Quotes (NAV 5.0 to MS Excel 2007)

Ignatius

Hello everybody !

When I try to export (NAV 5.0 SP1) a sales quote to MS Excel 2007 from the Sales Quote card (Sales&Marketing->Order Processing->Quotes), an error occurs (not in list mode).

The window error shows:

Tittle: HTML Importation errors (in spanish: Errores de importación HTML)

Error during the downloading process in the following areas (Error durante el proceso de carga en las siguientes areas):
Book config (Configuracion del libro)

This exportation rules well with original Cronus database.

Somebody have an idea about this error?

My module Sales Quote (or Sales Order) have some changes from the standard NAV 5.0 SP1.


Thanks !

ara3n

what kind of changes?

Do you have two tabs with two subforms?

Ignatius

Hi ara3n !

No, Sales Quotes card or Sales Order card are similar. Like the standard version, this cards have only 1 subform and the same number of tabs in the header.

We only have some new fields in the header and in the subform (in Sales Quotes Lines).

ara3n

Do the field have any special fields such / & ? I would try to move the customization one field at a time till you find the cause.

Ignatius

The difference in fields between CRONUS and MY COMPANY:

SALES HEADER

CRONUS
151 Quote No. Code 20
8725 Signature BLOB

This fields ARE in CRONUS and NOT in my Company.

MY COMPANY
50000 Rechazada Boolean
50001 Importe total Decimal
50002 Motivo Code 10
50003 Cód. Preventa Code 10
50004 Nº Oferta duplicada Code 20
50005 Mantener lineas Boolean

This fields ARE in MY COMPANY and NOT in CRONUS.


SALES LINES

MY COMPANY
50000 Ppal. Boolean

This fields ARE in MY COMPANY and NOT in CRONUS.

None of the new fields have strange characters like '/' or '&'.

¿Are style sheets "guilty" of this problem? ¿Or new fields o fields missing ("Quote No." and "Signature")?

I haven't found the answer...

Thanks.

Ignatius

Any idea about this problem?

I have tried several things but don't work...

I don't know if the problem depends of fields, style sheets, form properties, ... ](*,)

Thanks in advance !

Ignatius

Finally, the answer appears...

I see it in other topic "Problem send to excel in NAV 5.0":

viewtopic.php?f=23&t=32745

The problem was that are restrictions to the names of worksheets in Excel:
-Maximum of 31 characters
-May not be empty
-May not contain any of the following characters : \ / ? * [ ]

We use " / " char in Sales Quotes and Sales Orders codes.

Without " / " char, the "Send to excel (Ctrl + T)" button runs perfect !!!

=P~ \:D/