65000 Rows when Export to Excel

manisharma31
manisharma31 Member Posts: 285
edited 2008-10-07 in NAV/Navision Classic Client
I am receiving an error when posting an Invoice.
Error(Excel allows only 65000 rows,Compress the data filter)
Have any one receive this error before,what is the solution.
Regards,
Manish

Answers

  • Tomas
    Tomas Member Posts: 420
    manisharma31 wrote:
    I am receiving an error when posting an Invoice.
    Error(Excel allows only 65000 rows,Compress the data filter)
    Have any one receive this error before,what is the solution.

    Do you print anything to excel when posting invoice?
    65000 is a limit of rows Excel (older than 2007) can hold in one sheet.
    Tomas,
    Dynamics NAV Enthusiast
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    It is not standard NAV that lines are send to Excel, when posting invoices. So I guess you can safely say that nobody has seen this error before ;-)

    You should contact your partner who has customized your database.
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • manisharma31
    manisharma31 Member Posts: 285
    There is no Customization done in Nav by partner.
    In Codeunit 424,Function Createfile ,there is this standard code written for Excess 65000 Rows in Excel.
    You can find it in Nav 5 also.
    Regards,
    Manish
  • Waldo
    Waldo Member Posts: 3,412
    Ok ... but this codeunit isn't run when posting an invoice, is it?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog

Categories