Sage 100

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…

Hi Everyone, I am wondering if there is a script that can be written in Excel to look up an item number in SAGE and return the required date back to the excel sheet? Following the screenshots below I would like to have excel pull the next required date…

We're using the SODAMAS90 4.0 ODBC driver from sage. Our excel is part of office 365, so it is the latest version. We were able at one point in time (a few weeks ago) to run queries in excel via Data > Get Data > From Other Sources > From Microsoft Query…

Is there a way when exporting from the Item List screen to Excel to keep the Item Codes in "text" format? When exported, some items we have lose their beginning numbers when not in text form. Any help is appreciated. Thanks!

Which data files contain Inventory Code and my custom Inventory Category Codes? I need to use them for a sales report by on of the categories using Excel's Data Query.