• Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
  • Sage 300 Database on Azure SQL

    Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet. I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
  • Any issue with other app databases in same instance as Sage?

    A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…