Sage 100 2021: Exporting List Boxes To Excel Results In Wrong Cell Formatting Applied

On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied.  On the 2021 systems, this was observed when exporting from the Invoices tab's list box in both Customer Maintenance and Vendor Maintenance and when exporting from the Transactions tab's list box in Item Maintenance.

Below are screenshots using the ABC demo data.

Here are the screenshots from 2020.

Here are the screenshots from 2021.

So it appears that 2021 is one column off across the board when applying the correct format as you can see with the following columns.

Top Replies

  • David,

    In Sage 100 2021, there were some changes made to the logic that does the export to excel to correct some issues.  Unfortunately, those changes caused the formatting of the cells to be off.  We have created a defect for this issue and will be evaluating it for correction.

    Thank you,
    Kent

  • in reply to Kent Mackall

    Thanks for the update.

  • Great report, David.

    Spotted KB 114332 has been created on this.

    Column formatting is off one column when exporting a List Box to Excel on Sage 100 2021

    Created on 01-27-2022 | Last modified on 01-27-2022

    Summary

    Column formatting is off one column when exporting a List Box to Excel on Sage 100 2021

    Resolution

    Sage Engineering is currently resolving this issue.

    Additional information

    This issue is expected to be resolved on Sage 100 2022.0 & Sage 100 2021.4

    This issue will not be resolved on 2021.3

    This issue occurs on the following versions onlly:

    • Sage 100 2021.0
    • Sage 100 2021.1
    • Sage 100 2021.2
    • Sage 100 2021.3