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

Ignatius
Ignatius Member Posts: 18
edited 2009-03-18 in NAV/Navision Classic Client
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 !

Answers

  • ara3n
    ara3n Member Posts: 9,258
    what kind of changes?

    Do you have two tabs with two subforms?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Ignatius
    Ignatius Member Posts: 18
    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
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Ignatius
    Ignatius Member Posts: 18
    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
    Ignatius Member Posts: 18
    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
    Ignatius Member Posts: 18
    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 !!!

    :D =P~ \:D/

Categories