• I upgraded from 2023 to 2024 SAGE 300 but when I tried to login on the web screen, it gave me below error

    when i try to logging via http locally, any help please
  • How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
  • 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…
  • 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…
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • FINANCIAL REPORTS IN DETAILS

    I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…
  • RL1 forms rejected by Ministry of Revenue

    We have a client running Sage 300 2019, Payroll 7.3 and the most recent Tax table update installed. They created their file for RL1 filing (Province of Quebec), and went to efile and receive a message that their transmission is denied The file was not…
  • payment entered in the wrong customer account

    I'm using Sage 300 online. A payment was entered as unapplied cash in the wrong customer account. How do I correct this and put it in the correct customer account. The payment was from November 2019 and was seen now under the wrong customer account…
  • Sage 300 retail runtime error 52 invalid property value when running(Retail admin.exe).

    This has been running fine since 2016 only yesterday the files server run into a problem after running windows updates.The Pos is invoicing fine with out any problems even in the workstation The only problem is in the admin.exe file.I tried greating…
  • Recurring Batch Entries

    Hello Team, I was trying to create a new RECURRING BATCH ENTRIES through the GL Setup >>> Recurring Entries >>> Filling the GL Recurring Entries screen and click Add. After clicking "Add button", this error comes up " Sequence Number Dispenser.…
  • old company data lost during creating a new company

    Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…
  • Joining APOBL/APIBH to something that shows me the Invoice OEINVH, Order OEORDH or even the customer details

    Hi I've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up. Is anyone able to help me please? Cheers Andy
  • One on one training - Intelligence Reporter with Connector

    I am looking for one-on-one training for Intelligence Reporter with Connector. I have done all the Sage training courses so I am comfortable with the feature. I have a strong understanding of relational databases and I have a basic knowledge of programming…
  • Login - SQL Error 40960

    I have a client that just upgrade Sage 300 form 2012 to 2019. When they log in as an administrator everything works fine. When they log in as a regular user and run Sage 300 as an administrator they receive a SQL Error 40960. Any ideas.
  • Error 53 after upgrade from Sage 300c Premium 2017 to 2019

    We are getting "Error Code: 53 File not found." in Purchase Orders only, after an upgrade. Clicking OK allows us to continue - don't see any other errors. Happens only when creating a new PO, upon entering a vendor and entering the first item onto the…
  • Sage 300 v2019 running on Windows Server 2019

    Sage 300 v2019 running on Windows Server 2019. Although the v2019 compatibility guide does not cover this OS and Sage support will not say yes or no if Sage will work. Does anyone have experience using this OS yet?
  • Sage 300 over a WAN

    Is it possible to run SAGE 300 over the corporate WAN (250mbps). If not, why? What is the bandwidth requirement?
  • Sage 300 codes

    Is there a listing of all the codes used in Sage 300? Trying to create a few spreadsheets using pivot tables and need a listing of all codes. Suggestions on where to find these?
  • accounts in General Ledger

    How do I add sub-accounts in my chart of accounts? EX; Account 64000 - Marketing shows I want to add travel, meals, supplies, freight all under this account. Marketing Shows Travel Meals Supplies Freight
  • runtime error 1004 cannot run the macro Remove AutoStart Files

    Sage2018 SP2 new server. office 2010, when you launch statement designer comes up with error "cmdStart : Error on opening the xla macro.", if you click close says "cannot run macro RemoveAutoStartFiles" excel macros are enabled and VBA enabled too.…
  • 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…
  • 941 Form

    Hi there, We are using Sage 300 2016 and we need to know how to automatically put the correct number of employee on the 941 form. 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?
  • 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…
  • Code Changers don't work after Payroll 7.2 upgrade

    Sage 300 2014 PU4 (also 2012 with PU4) with Payroll 7.2 none of the code change products work, system says 'newer version of Canadian Payroll was detected. XXXXX Code Change must be upgraded!' Is there an upgrade available?????