• intelligence reporting

    hi - which report is linked to my data for the income statement and the balance sheet?
  • reports

    hi - I have used QB in the past. You can pull out reports that details each line of an invoice. Does Sage have such a report ?
  • valuation report

    hi when running a item valuation report i get a column that has actual cost / most recent cost and last cost. Which column represents my total value of inventory? Other question is can i pull out a value of inventory from a prior date? If so how would…
  • 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
  • ICBOM01.rpt giving connector error when processing CSV_FILE

    ICBOM01.rpt gives connector error when processing CSV file made by ICCOMP.DLL V2020 I get no error if I suppress the sub-report so I know it is that sub-report showing BOM details Error happens on server with O365 and another server with no Office installed…
  • How to use sage intelligence reporting with optional fields?

    I want to spool sage intelligence report using optional fields that I created on General ledger instead of using General ledger account or General ledger account segments on sage 300. /resized-image/__size/640x480/__key/communityserver-discussions-components…
  • 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…
  • sales tax report

    Hello. Does anyone know how to prevent A/R Summary Credit Notes from appearing on the sales tax report? The system assumes that these credit notes are sales-related but only the OE credit notes are sales related. We have a tax code that calculates no…
  • Slow Printing Sage 2023

    Recently migrated client to Windows Server 2022 (RDS) Sage 2023 PU1. Printing anything takes forever - 18 seconds running AP Account Sets report. When I test the same report on SAMLTD it renders in a few seconds. There is no Customization Directory…
  • T4A Employee Invalid field index 108 in Payroll 7.30 (Latest Tax Table update

    After installation of the latest tax table update, the above message appears along with:A error has occured during the process of T4A extraction. The error returned was 1142. The operation being performed was a viewPut call to paper T4A information. Create…
  • What is This Number On Our Purchase Order?

    We have gone to the Crystal Reports and cannot for the life of us figure our what this number represents? It didn't change when I printed the PO (as in it would roll up one for each time printed), it also did not change when I added lines or modified…
  • Positive Pay file

    Can anyone let me know what report/file the use to send a check file to their bank for Positive Pay? The file needs to be in excel.
  • Problem with Running Payroll Reports and Aatrix Access

    When we attempt to run payroll reports in Sage 300 and access Aatrix to complete the process, we are encountering an "unknown publisher" error message: "Windows has blocked this software because it can't verify the publisher." The error dialog lists…
  • Getting this this error in sage 300 2023 trying to print

    ActiveX component can't create object
  • 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
  • Sage 300 1099 aatrix tax filing missing last and first name

    When we got to file 1099's, the last and first name are missing from the W-2/1099 preparer list where you verify recipient taxpayer identification numbers. The error says "Recipient First and Last Name required." I have sage 300 2021 with the latest tax…
  • Payroll W-2 & AP 1099 year end updates for EOY 2023

    Are there product updates required to print 2023 1099s? There is a new payroll update released, Q42023. Is this the only one - theoretically - that will be required for printing W2's? Thanks in Advance!
  • printing Bonus paper checks after direct deposit ACH was already done

    I need to know how to be able to print paper Bonus checks in 2nd checks entry- when I enter the employee who was in payroll set up as Direct Deposit- but after I entered the info in 2nd check I went in and removed the Net Direct Deposit flag but still…
  • Error on Opening the xla macro

    Hi, We have encountered an issue whereby we are receiving the following error messages: 1. PrintReport: Error on opening the xla macro 2. Problem is found in running Financial Reporter Addin We do not have application support in-house and have…
  • Sage 300 2024 Encountered Error Code: 5 during FR Financial Statements Printing

    Hi, Did anyone encountered the same error code when print Financial Statements in Sage 300 2024? After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button? Client is using Microsoft Excel…
  • Is there a way to preview W2's before the year end.

    Is there a way to preview W2's before the year end.
  • FR Report not suppressing zeros

    Good Day Sage 300 PU4 Client recently upgraded to above. The FR report runs successfully but is no longer suppressing zero value lines even though this is defined in column c. I have tested on 32bit Excel and it works correctly. The client uses 64bit…