• 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…
  • Foreign currency translation report

    Hi, I'm new to SAGE, is there any function to navigate the foreign currency translation report?
  • 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…
  • 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?
  • 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…
  • 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…
  • 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…
  • 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…
  • Crystal Report Printing Error

    I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…
  • Sage 300 2024 - FR Web Screens

    Hi, I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade. When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine. Sage 300 2024…
  • AP vendor transaction report preview

    How can I filter AP vendor transaction report to get actual result with GL transaction report.
  • How can I configure/place custom reports for web screen?

    I have several custom reports (crystal reports). Now I want these reports to be also accessible via web screen. Which directory should I put my reports?
  • SQL Login failed error in Crystal Reports

    We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…
  • Sage 300 business intelligence reporting trees

    We have created a report using the trees - which works Now we have another scenaria with organic and non organic stores - the problem here is organic can consist of dept 11, 22,23,30 etc Non organic 12,18,32,etc How can I drag all the trees into…
  • I/C Physical Inventory Quantity report showing some products On hold

    What causes an item to show as 'On hold' in the last column titled Status. We have looked around and can't find what causes that to happen.
  • Aatrix's Certified Payroll Report won't generate

    After choosing job and employees, the next step is "Generate". Upon clicking that link I get a message that simply says an error has occured and for me to check the viewer. In the log viewer it reads, "Object reference not set to an instance of an object…
  • Sage Intelligence Reporting - Need currency conversion rate in Sales Master Report

    I'm using "Sales master by Customer and Items" report in Sage Intelligence and I need to see the USD currency customers converted to CAD currency amounts. The report displays all USD vs CAD customers in their own currency but would like to have the USD…
  • What is the proper report to use to view orders invoiced but not shipped?

    What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.
  • Bank Reconciliation Status report as of a specific date

    I need to find the details of what withdraws and deposits were outstanding at 10/31/22. The reconciliation status report seems to give me what is outstanding at this moment in time for anything processed through 10/31/22, not exactly what I need. I have…
  • How to change the report format?

    Hi We are using Sage 2017 version, Please advise how to change the report format. All report comes with the name who left our company. Our sage cannot be opened via web browser (becouse of no cloud version?) and ther are no "setting" botton on my…
  • Received not Invoiced report?

    Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?
  • Overdue Customer Report Needed

    We need a simple way to query a report for on hold accounts and their outstanding payment amounts. I thought I could use some of the data provide from the AR Customer Inquiry table, but I can't seem to find what that table is called? We need - Customer…
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…