Browse By Tags

  • 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…
  • Running Sage 300 (2019) off cloud paging. Error=100 during Database Loading

    Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…
  • Sage 300 Retail Database could not be opened

    Problem: When opening the Admin module an error “Database could not be opened” appears Cause: Incorrect setup or access to the database Resolution: Ensure you have you created the System DSN using the 32bit version of the ODBC? Ensure that…
  • Error when query table from custom database

    Hi all, I have a custom database(not company database) to store information to be retrieve by all companies in a custom form. I am able to query its table using plain query in MSSQL Management Studio. With Sage 200, I am able to make a connection…
  • error system.OutofMemoryException creating report in Report Writer

    Error: Knowledgebase article says: "Error: Exception of type System.OutOfMemoryException was thrown running the 6-1-2 report (version 19 and earlier) Enhance export to MS Excel engine Exception of type System.OutofMemoryException was thrown Job…
  • Error Updating database with new update

    Hello, Please find below an error I've gotten when updating the database with the new installed update. Thank you.
  • Sage300 runtime / Database error Operation = Get

    Our Sage users constantly keep getting there errors throughout the day spontaneously * Database error (operation=GET . error=****) [Microsoft] [SQL Server Native Client 11.0] Communication Link Fail. Please refer this error to your database administrator…
  • get Field value in macro into a variable Vb.net.

    I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…
  • SQL Database corruption

    While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this? Priti
  • 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
  • Data Integrity Check

    Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • Database Connection Error: HY000: when trying to add Master_PRM_Employee File to new crystal report.

    I am using Sage 300 CRE 13.1.24 (13.1.0 Rev 7). I am using Crystal Reports XI Release 2 for Sage. I have my ODBC setup using my 32-bit ODBC administrator. My problem is that when I try to create a new report, I can add any file I want in my database to…