• CUSTOMER STATEMENTS

    Why is it impossible to print statement of accounts reports in SAGE 300 simultaneously across a number of workstations? When one of the users in a given workstation tries to print a report and their is another user who has opened this module, the error…
  • Item cost price and selling price

    Hi dears, is there is a report in sage 300 that shows the cost price and selling price for the items, or how can i extract them.
  • Is there a way to determine what check form was used for a specific payroll run

    We have a customer that says their ssn's are mased on top but not on the bottom check stub. We have several versions of the payroll check forms due to different requirements. Is there a way to know which form they actually used? I can see thier default…
  • Need a crystal report expert to design new customer report in Sage 300 ERP

    Need a crystal report expert to design new customer report in Sage 300 ERP
  • Sage Intelligence - Server execution failed error (2024 PU1)

    Hi Team I have installed Sage Intelligence for Sage300 Cloud 2024 PU1 when i run the program it comes back with and error Server execution failed. please assist if anyone has come across this
  • Foreign currency translation report

    Hi, I'm new to SAGE, is there any function to navigate the foreign currency translation report?
  • Web screens - cannot print some reports

    Sage 300 V2024 - web screens. Printing some reports and forms result in An Unexpected Error with message "A problem occurred when generating the report. Please try again". This happens with OE forms (Order Confirmation, Shipment, Invoice), PO forms…
  • Check stub with too many invoices

    It's been about 10 years since I've used Sage products and I just started a new job using Sage 300 Premium 2022. I'm having a difficult time printing checks when some of the checks are paying enough invoices that the check stub prints on another page…
  • Sage 300 2023 and Custom Crystal Report

    Failed to retrieve data from the database error is received from Sage user interface when running a custom report created when client bought sage. Report works on sage 2014, 2019, 2020 and 2022 environments but doesnt on 2023 version. At crystal level…
  • SAGE 300 - GL - Financial Reporter Design Horizontal

    Hi Support We have an FR reporter that is written by segments code in vertical format per outlet. We want to achieve the same format in horizontal format. Is there a way to achieve this. CURRENT FORMAT - Department listed in vertical format …
  • Intelligence Reporting Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

    V2024 logged Sage 300 as Administrator, when run any reports, we get above error, even when firewall is off. Everything else in Sage in fine. Please help.
  • Check register is showing a reversed check as missing

    We have a client who posted a check for March 15 and then reversed the same check for March 15. When we run the check register for March 15 - March 15 for all reconciliation statuses, it says that check is missing. They want to see it as reversed. Is…
  • 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…
  • How to change Auto Connect Server in Business Intelligence Report Manager?

    Hi guys, This is all greyed out, how to make changes? Thanks,
  • Financial Reporter Account Reference Syntax

    Ok Financial Reporter gurus. I cant figure out the correct syntax for account references with multiple segments. I have a client with an account segment that use 3 segments. I want to select a range of accounts that can filter on the 3rd segment. For…
  • Zero balance accounts showing up in Financial Statements even with Z in column C

    We are currently running Sage 300 2022 pu7. The zero balance accounts previously did not show up, but after the updates (we updated 5, 6, 7 on the same evening) - the zero balance accounts are showing up. I read in the support pages that there was supposed…
  • Sage 300 2023 pu 5 Printing ODBC reports shows Failed to open the Connection

    I have just upgraded a client to Sage 300 ERP 2023 pu5 When I print a pipe delimited report or form to preview it works fine, but when I print an ODBC based report it shows "Failed to open the connection". It doesn't matter if it is a custom report…
  • Expected Ship Date and OEORDH

    I notice OEORDH has a column EXPDATE but our customer service says it does not reflect the same date in the report they need. What is the column and what table is the expected ship date located?
  • 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?
  • 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…
  • 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