Browse By Tags

  • Excel export has hidden columns

    Using Sage CRM 2023 R2 reports are now exporting 'blank' if exported to XLSX. All of the data is in hidden columns. Any ideas?
  • AR Invoice List

    Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…
  • how to know which check form to select

    we either need to know which check form to select for our current stock of checks or how to know which checks to order and then which check forms to select. is there a way to see how each form displays? or how to we make selection?
  • Fund/Project Income Summary: multi-period report

    Hello, I have been working with the client on the "Fund Income Summary" reports (I believe these could be called “Project Income Summary" in a different type of organization). We have been using quarterly reports and have achieved good results so far…
  • How put negative sign in Gst purchases in balance sheet

    Hi there! I have a problem with our sage 50. I am currently a bookkeeper and I having a problem with GSt purchases in balance sheet. It doesnt show the negative sign, and it's adding the gst sale and gst purchase. The previous bookkeper up the books as…
  • upload bank statement

    Hello - Can I convert my bank statement from pdf format to the .ofx for sage upload? I can't seem to find the option when downloading from my bank.
  • Generate a Report for Customer's Open Sales Order Ship Dates

    Regarding our customer sales orders, we have multiple items that ship from different vendors. Is there a way to enter the estimated ship dates for each line item and then create a report to email to our customer? Currently we create an excel spreadsheet…
  • Account Reconciliation Report Showing Up With Outstanding Deposits that aren't Outstanding

    Hi there! I was reconciling my bank account for the last month of the fiscal year and when I went to print out the reconciliation report (summary with outstanding transaction detail) it is now showing deposits that are outstanding with a little * beside…
  • Report export formula issue

    Good day I have created a report on SAGE which includes a formula to calculate the amount of days a position has been vacant, but when I export this report to excel the formula column just goes to all zero. It seems that the formula is remove with the…
  • 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?
  • Rapport des plus gros clients

    Je cherche a sortir un rapport pour mes 20 plus gros clients. Il me semble que je devrais avoir un rapport qui me permet de voir qui sont mes 20 plus gros clients de 2023. Pouvez vous m'aider avec cette problématique ? -----------------------------…
  • Reports

    Is there a way to find a report for invoices numbers that have been cancelled and redone? Apparently, someone sent out invoices and then did a rebill on several where they got new invoice numbers and these invoice numbers are no longer available. However…
  • Crystal Reports 2020 Database connection Error

    Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
  • How to show Fund (or project) column in General Ledger report

    I'm wondering if there's a way to have a transaction's fund allocation represented in the General Ledger report from Sage 50? My client would like to review all transactions via the General Ledger and see also what fund each is attributed to. Right now…
  • Bank Reconciliations

    My bank reconciliation is out, can I go back and re-reconcile an account? Also, we have EFT payments that get removed from the bank at the end of one month, but don't come out of our account until the early days of the next month on Sage. This is due…
  • Quarterly Governmental Reports

    Hello, We recently upgraded to Sage 2022. In our older version, we had a Quarterly Governmental Report that was available under Payroll - Reports. This report is not listed in the 2022 version. Does anyone know how I can obtain this report? Thanks,…
  • X3 V12 - Barcode Font (IDAutomationHC39M) Not working on Crystal Reports

    On X3 version 6.5 (and version 5) we installed font IDAutomationHC39M.ttf on client computers to get barcodes to show on crystal reports. With V12 I figured I would have to install the font on the server(s). I installed the font on both the application…
  • General Ledger Detail Reports

    Hello. Is it possible to run multiple general ledger detail reports at the same time, but have each account print on a separate page? I have to run up to 14 reports each month for 60 clients and if I could run 60 reports each month instead of 840 that…
  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
  • 2-6-0-21 Check Register Report

    Can anyone advise on what the "*" means next to the date on the Check Register Report 2-6-0-21 ? Thanks for your help in advance!
  • How do I Undo a recent reconciliation so I can rectify something?

    When working with Quickbooks, we have a really easy way to undo a reconciliation to then adjust one transaction and re-save the reconciliation. How do I do that in Sage 100 Contractor?
  • After paying supplier's invoice, it still shows on Aged Payables Report

    I’m using Sage 50 US. When I pay a supplier’s invoice before the due date, the invoice still shows up on the Aging report, but now as a negative dollar amount. The report subtracts that from the total amount due for that column, which makes the total…
  • Gross employee payroll report

    I'm preparing for a general liability audit. I need to report employee wages (ytd total) by position and worker's comp code. Does a report like this exist???