• Duplicated Invoices

    hi, I'm working with v 2021 Premium. we've had issues with CI_140MB_UpdateDetailToIM.pvc. SO invoice batch posting was interrupted resulting in multiple HeaderSeq numbers being created once posting was refreshed - invoices were duplicated. Looks like…
  • SO_SalesOrderHistoryHeader

    After we post each day the SO_SalesOrderHistoryHeader is not updating the DateLastUpdadted field. This is causing major problems with our B2B site. does anyone know what we may be doing wrong? We just switched to Sage 2019 2 months ago and it seems…
  • Crystal Report: Customer Sales History - Multiple Years, Different Periods

    OK, friends! If either of you can solve this for me, you will be my hero for month! Lol I have created a custom report that is sorted by Customer Number. Main tables involved are AR_Customer and AR_CustomerSalesHistory . I need for this ONE report to…
  • 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…
  • Comparing 3rd party data with Sage 100 ERP data

    I am not sure if this is the right forum and apologize if it is not. Here is my issue. My company uses a manufacturer that is out of state and can get us data 2 different ways, through opening up a web service to us or sending a spreadsheet. These would…
  • Inventory movement

    I'm using MAS 200. I'm looking for a simple way to check inventory movement, ie how many of a certain inventory item have we sold and/or issued in a period of time. I know that I can run inventory sales history reports and inventory issue history reports…