Browse By Tags

  • FR - Print Financial Statements - Run-time error '0' when trying to print to file

    Our client has the issue when trying to print their financial statements to file using the Print Financial Statements Icon (Sage 300 2023.4) The report generates no problem to Preview. We have Checked there are no other excel add-ins ticked…
  • Intelligence reporting module

    While working on the Bank reconciliation of previously January 2024 and lately February 2024, I am facing issues in the Sage Intelligence Reporting module. The bank statement figures do not match at all with the A/R and A/P entries. The Income statement…
  • Work Order Module

    I'm new to Sage. I'm wondering if there is a module for Sage 300 that allows one to create a work order, track its progress, and interface with the inventory system so that when a tech needs a part for a repair, it can be scanned and allocated to that…
  • Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • 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
  • Importing Production Quantities in Sage 300.

    Does anyone have any experience importing Production Quantities installed into Sage? We are looking to simplify the process of getting data from our production tracking timekeeping tool back into the Job cost report in Sage.
  • 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
  • Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?
  • Why does ROE not bring in data for box 15c for some employees, but does for others?

    I've been working with Sage 300 Canadian Payroll for over a decade and this is the first I have seen this. When generating ROE for a particular employee, usually it will auto populate Box 15C with all their pay periods starting at the most recent one…
  • HOW TO GENERATE A PREVIOUS BANK RECONCILIATION REPORT?

    Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…
  • List of Open Batches VIA WEB API

    Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards
  • Sage 300 2023 error "Cannot connect to Sage 300 Signon Manager" after pu3 is installed

    We installed pu3 for Sage 300 2023 and got passed the signon and changing the password for the first time. Now we are getting "Cannot connect to Sage 300 Signon Manager" when trying to log in with the new password. Has anyone had this problem? I have…
  • Database error (operation=GET-LE, error=105)

    Dear Gurus, I am using SAGE 300 Premium 2018. I installed and loaded SAMSYS, SAMINC and SAMLTD. I am at the General Ledger Module --> G/L Transactions, trying to browse Journal Entries. Whenever I scroll to the end of the entries, I will get this…
  • Sage 300 2023 Print 1099

    It was my understanding that the Print 1099 screen went away and Sage is to use Aatrix now for 1099 processing. We have two sage servers for two different clients. The 2021 version uses Aatrix. We upgraded the other one to 2023 (previous version was pre…
  • Error while installing Workstation Setup

    Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…
  • SAGE 300 ERP RollOver

    Hello Everyone, I recently created a new year(2024) for a client's company, but the document date and posting date are 2024 instead them being DECEMBER 31, 2023. Now, I am not sure if it's an error or it's okay. My idea is to reverse the entry and repost…
  • Get your Sage 300 US & CA SR1 Payroll tax update (Q4 2023) now!

    What’s new in Sage 300 US Payroll (Q4 SR1 2023) State and Local legislative updates. For more detailed information about the update read the Release Notes . What’s new in Sage 300 CA Payroll (Q4 SR1 2023) For detailed information about the update…
  • Getting this this error in sage 300 2023 trying to print

    ActiveX component can't create object
  • Sage 300 Standard -2023 (AP Vendor Code automation).

    Is there an AP code automation where If a vendors first letter starts with an H the auto generation vender code is H-00001 if the vendor start with a Q it is auto created to a Q-00001.
  • 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…
  • Wanted, Crystal Report Designer - Sage 300 ERP 2023 web Uis

    Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output: 1. Opening balance on account at every point in time the report is printed ie yearly or monthly, 2. outstanding invoices unpaid…
  • SAGE 300 2023 unable to print

    When I try printing I get this error. Error Code: -2147467259 Method '~' of object '~' failed