Browse By Tags

  • 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?
  • Security for timekeepers

    Hello, I am the Administrator (Supervisor) for our Timeslips program. A few months ago, I set up rights and permission for each Timekeeper. I haven't logged on as Administrator /Supervisor since then. Today I needed to change rights via the Set-up/Security…
  • Sage BusinessVision 2023 SBE Bug Report - Broken indexes (Actian v15)

    Hi ClarkM and Erzsi_I I see that that a similar question was posted by slacka 6 months ago, and remains unfixed. I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
  • missing main.db?

    I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.
  • 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 X3 MFA USING MICROSOFT ACCOUNT

    Good day all, Hoping you can help. We looking at setting up MFA or something similar to MFA for Sage X3 but making use of a users Microsoft account rather than the google account. We would like to provide an additional layer of security where users…
  • Vault and Store changes

    When making changes to a production system such as updating SQL passwords, changing SQL servers, or using a different SQL account, how do we get to the edit screen for the Vault and Store databases configurations? Alternatively, is there a way to make…
  • Declarations Module

    Hello, I'm trying to add the "Declarations" module with it's functions to a specific functional profile. I've tried adding the specific functions to the functional authorizations as well as to a menu profile. The declarations section is not show up…
  • Limiting Bank Access

    Is it possible to limit bank access for a specific user to a particular bank? I have always understood this to work as authorizations for the module and then the functions within the module. If no, is there a way to limit access to the payroll transaction…
  • Unable to complete Database Load - Error 59104

    Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • [SOLVED] OAuth2 authentication option missing (X3 V11)

    Hello, my Syracuse installation does not show the OAuth2 authentication option. Am I missing something? Does my version lack this feature? (Sage X3 V11 LP19) I already modified the nodelocal.js configuration: added an OAuth2 server configuration…
  • OEORDD.UNITPRICE

    Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?
  • 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
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • Export Component List

    I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…
  • Sage Intelligence support MS-SQL password length?

    Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable? My customer change SQL Password to 64bits length… After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.
  • cannot create new System database on Sage 300 v 2023

    Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…
  • 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…
  • Database error (operation=LOCATE, error=0).

    Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
  • Transaction Data Import

    I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…
  • CVE-2022-42889 - Text4Shell

    Just wondering if Sage 300 (or any Sage product) is vulnerable to the new Text4Shell vulnerability? In a recent security scan the following files came up vulnerable file: c:\sage\sage300erp\gs\solr\server\solr-webapp\webapp\web-inf\lib\commons-text…
  • Payment Batch

    Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank
  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…