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?

Hi there, I searched and couldn't quite find what I was looking for. I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…

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…

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…

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?

Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…

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…

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…

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!

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…

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

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…

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…