Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Hello everyone, I need a crystal report programmer to assist with designing a AR customer statement with following output:
1. Opening balance on account at every point in time the report is printed ie yearly or monthly,
2. outstanding invoices unpaid…
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?
Hi Everyone,
We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along with the…
Hi,
The scenario is like this:
The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how…
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…
We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…
We add inbound freigh as an additional cost on our inventory purchases.
How can I pull a report that tells me how much I'm spending on inbound freight?
Hi there,
Can someone help me out an FR function here. I am new to the FR designer.
I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021
=FR("PERIOD")&" Months Ended "&FR("END…
Hello, I have a client with over 160 customized Sage Intelligence reports. They know that some of these reports have not been used by their 200+ users in a long time. Their IT staff is looking to streamline which reports will need testing as they move…
Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…
Using Sage300c for the first time. browser stucked on https://[IP.ADDRESS]:9113/#/Welcome
Web/ WepAPI already set to allow admin access
Any other suggestions ?
Hi Citiers,
I have searched around and and followed all the tips found here there there with no uck.
I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error.
We got an Windows Server…
Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates.
The custom crystal report on the sage server…
I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…
Hello Team,
Our client who uses sage 300 ERP requested for a report of all AP invoices and AR invoices for a vendor and customer respectively. Specifically, the invoices that have been paid for in the past and yet to paid.
What report can we spool…
I am creating a customized report on sage 300C webscreens intelligence reporting. After selecting a set of rows, when i edit a row it couldn't be save or proceed further. So i have to close the report.
I was doing some research and came across this blog post from Stephen Smith talking about the hidden Crystal parameters. Thought I'd add it here to be picked up by the Sage forum search engine.
(From: https://smist08.wordpress.com/2012/09/15/reporting…
We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work.
The issue is that when we print a report - any report, it runs the database record select and then stops…
Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?
We're trying to determine:
1) How many commitments were…
Hello,
I have a client who uses Sage 300 and I file their sales tax returns for them and I cannot figure out the best report to use to find the sales tax information I need (shipping state, shipping city, amounts) without digging through piles of information…