• Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • Where to Find General Ledger Account Balances in Sage 300 ERP?

    Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…
  • 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
  • cannot access database (error=40960) sage 300 2020

    Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…
  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?
  • User Creation Date and License Type Fields in Sage 300 2014 Database

    Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…
  • loading data error

    Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks
  • installation 2016 Server 2008

    We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions? We're also looking at the possibility of using server 2016. Is there any chance…
  • number change

    When I go to Item number change and processing I have an error message: Cannot open database "ccs.net.ccscom" requested by the login.The login failed. Any idea
  • Application Object Model (AOM) for AH61C Sage Accpac HRMS Payorll Link for Sage Accpac 6.1C

    Is there an AOM for the AH61C module? I have not been able to find anything in the KB or the online documentation after installing.