Browse By Tags

  • Link JrnlHdr to itself

    I added the JrnlHdr to the report twice in hoping the link the second JrnlHdr to itself. How do I do this? My first instance JrnlHdr is restricted to JrnlHdr.JournalKey_Journal 11 - Sales Orders. While my second is restricted to JrnlHdr.JournalKey_Journal…
  • Invoice Matching Data

    Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. Regards, Dave
  • dé-comptabiliser une facture

    Bonjour Je suis débutante sur Sage et j'ai accès à une base de test SQL "bijou". Je souhaite de dé-comptabiliser une facture et apporter les modifications nécessaires. Serait-il possible de me fournir la requête SQL appropriée ? Merci d'avance.
  • cannot access database (error=40960) sage 300

    I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?
  • Limited version of Actian Zen

    Long time ERP consultant here, but new to Sage 50. I have years of experience with Actian Zen (fka Pervasive SQL). But at a Sage 50 install, where the heck is Actian Control Center? Where would I go to write a simple SQL statement? Also missing are DDF…
  • User is unable to print from Sage 2022

    A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…
  • add Invoice header text after posted

    Is there a way to add Invoice header text after the invoice has been posted? I'm looking in the tables and there is a code but where is the actual text placed? any help appreciated. thanks.
  • SAGE ERP on DBCS OCI

    Hi all, It looks SAGE ERP is compatible only with Non-CDB Oracle DB. So this will create problems if we would adopt DBCS as SAGE ERP DB, correct? Any similar experience on SAGE to share? Is there any workaround you can suggest in order to make…
  • 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
  • Sage 300 2012 Expected Delivery date.

    I have a client working with Sage 300 2012. Does a field exist that provides the expected delivery date? If so, what table/field would contain that?
  • Understanding date in STOJOU table

    I am only looking to find specific inventory movements in the STOJOU table and need a way to determine the Type of the Transaction I see the TRSTYP_0 field but cannot find the definition of what those values represent. Can anyone help?
  • Upgrade Sage 300 from 2023 PU2 to 2024 PU1 creates extra users in the database management system

    I have successfully upgraded my Sage 300 install from version 2022 PU2 to 2024 PU1. Thus far no problems have been found running it. On the Database Server, in MS SQL Server Management Studio however, multiple new users were created during the install…
  • Information about transaction under accounts and related documents

    Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…
  • sage 50 database verification tool has found a problem in your company file that it was unable to fix

    Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…
  • Asset Database

    Hello. I am new to using Sage and have next to no notes left from my predecessor and no one else on my team seems to have much info, if at all, on the software. I have noticed in some areas (although now I can't find it of course) where it mentions "Asset23…
  • Vault and Store question

    Error: "Failed to Establish the Vault and Store Databases" During database setup. Above error showed up. New server 2022, new MSSQL 2019, new Sage 300 2024. ODBC tested successfully new install, no Vault/Store in shared data directory mapped…
  • open new database , but error activating

    We have one laptop running Sage 300 version 2023 (Product Update 1) and have error activating New company. After Click Data Activation > Proceed below error pop up. Please advise
  • Company missing in select company to archive

    I have a very odd issue, in SC100 Database Administrator I can see my companies for tune up, etc., but when I select Archive Company Data, no companies show up in drop down list. Anyone ever seen this? Ideas on a fix? Thx!
  • Sage 100 contractor error... you are not a user in this database

    Hello all.... I am receiving this error once every few days on every workstation. I have to restart the server and everything is fine. It usually does it in the middle of the night. We recently installed a new server. Any ideas?
  • Roll Back Update to Database Administrator

    I just did the year end update to Sage 100 Contractor from 24.3 to 25.x without realizing that my server was running WS2012. When I try to open Database Admin, it says the machine is capable of being the database server. Is there a way to roll back…
  • Conexion a todas las tablas de Sage 50 accounting version 2023

    Buenas tardes, disculpen una consulta como puedo conectarme a todas las tablas de sage 50 account, ya que ODBC solo lee los reportes de kristal report atte.
  • PURGING DATE

    in running the purge data process, how does this affect inventory data view? If I purge 5 years of date, 2010 - 2015, will the inventory history on items still show in the "ALL TRANSACTIONS" view or only the history since 2015? WIll this also change…
  • Where is my data file kept for Sage 50?

    The description for Sage 50 says " Desktop accounting software with cloud connectivity". Is my data kept solely on my desktop, or is it in the cloud (or both)??
  • Equivalent to Pervasive Control Center

    New to Sage 50 but I have done some Peachtree work years ago, as in 12+ years ago. I am trying to write crystal reports but I would really like to see what is in each table to facilitate this. In my old Macola days, when it used Pervasive (now Actian…
  • Product Line Details

    Looking to see if anyone can direct me to a table that houses the details from Product Line entries on ITMMASTER.