• Finding the best date to use for when an record was last modified

    I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…
  • Sage 300 Data Activation missing

    Please i cannot find DATA activation on my Administrative Services in sage ................Did i do anything wrong ?Please help.
  • How to create 2 test databases to sync with CRM?

    I have a live 300 (2014) system with 2 live databases. I've installed Sage CRM 7.3 as part of a new project. While I do the dev, I don't want to sync their live databases. What is the process for making 2 new databases that are copies of the live databases…
  • Running Sage 300 off two sql servers

    Good day everyone. I just want to find out if its possible to run accpac from two seperate SQL servers? To have one SQL instance run from server 1 and another on server 2 but one accpac installation looking into the two two instances?
  • Deleting Item records in sage 300

    Here is the scenario, there is a group of inactive items that haven't been used for at least 2 years in the system. Am I allow to delete the item records? What is the effect of deleting the item records? Example, item number 00001 has an old receipt and…
  • Deactivating one module, one company only

    We need to ship data to someone for development purposes. The live data contains PR information that we do not want to share, nor is it relevant to the development. My thought is that we would create a test company, populate with all live company data…
  • GL entries posting

    Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?
  • Crystal Reports and Sage 300 ERP 2014

    I have written a report on my Sage 300 ERP 2014 system. When I test it on a clients system (Sage 300 ERP 2012, no Crystal Reports), I am asked to login to the database. This report has parameters. I tested another report with no parameters. It renders…