When running 5-1-1-22, the raise history field is not showing correctly, yet when going into the employee file and using the Raise History button, it shows as it is supposed to.
Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
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…
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…
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…
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…
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.
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…
I am creating a new report for a client and after saving and re-running, the first custom tab has been partially overwritten by four columns of CompanyCode, Rollup Type, Rollup Type Description, and Rollup Code.
The standard Rollup tab is still hidden…
