• Creating a new company from some of the historical data.

    I have a client that has recently been purchased by a larger entity. The new company would like to change the fiscal year and purge all historical detail from before the acquisition. Their preference is to start a totally new company that only has detail…
  • 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…