x Want to participate? Join the group to interact

  • Opening Balances of GL

    Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.

  • How can I store MAS authentication in an Excel ODBC link?

    I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…

  • Sage 100 Data clean up best practices

    Hello everyone, We have been using Sage 100 and it's earlier incarnations for over 20 years. Our data sets are quite large, especially sales and invoice history and inventory. What is the best practice, or what do you all do to maintain your data sets…

  • Identify the real cost of a FIFO item

    We use FIFO and item costs can vary depending on when we buy them, I need to be able to calculate the cost of an item based on the cost tier. I looked on ARINVOICEHISTORYDETAIL and it appears this table pulls the cost from Std. Cost and not the tier it…

*Community Hub is the new name for Sage City