Browse By Tags

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

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

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…

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?

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…

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…

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…

How can I filter AP vendor transaction report to get actual result with GL transaction report.

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?

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 ? -----------------------------…

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…

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…

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…

Currently when we receive a Purchase order we run the stock status report and add the column "Quantity on Sales Orders" to see if anything that came in is on a Sales Order for a customer. It doesn't tell you what the Sales Order number is so you have…

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,…

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…

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…

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.

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!

Almost every default report or form in Sage is garbage. There's fields with letters cut off or numbers cut off or bad calculations. I'm try doing do a simple customer statement and it can't even figure out how to get the aged invoice in the right bucket…

I want a report for a single Non-Stock item to analyze the item's purchase and sales.

I am looking for reporting that shows both purchases and sales with quantities and $ CR/DB. Found reports do not show data on items with Current O/H of zero or do not show the desired detail. Working with LIFO inventory and would also like to be able…

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???

Hello, I am trying to produce a reliable and accurate cashflow statement in Sage 50 Quantum Accounting Canada. To me, a cashflow statement should start with net income, then take into account cashflow adjustments from operating activities, investing…

We are having issues with getting subcontractors who have billed retainage to show up on a report since Sage 300 refuses to create a "bill retainage" button in AP. When I submit reports to management they have no idea a retainage bill from a subcontractor…