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.
Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023.
I am in January 2024 and I am unable to go back to that specific date (November 31, 2023)
Is there an alternative way to retrieve this report?
My error…
Hi
Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300
Regards
Hi,
We have encountered an issue whereby we are receiving the following error messages:
1. PrintReport: Error on opening the xla macro
2. Problem is found in running Financial Reporter Addin
We do not have application support in-house and have…
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?
Hello,
Does anyone know how to enter in Sage expected billings/ invoices for projects ?
Goal - cashflow forecast
And also where to find a report for this filtered by project.
Thank you!
sage300 v7 (2023) sp1
fresh install. I can't get user activity to show any details. it comes out blank. running it as admin
the company has had users using it for a month now
What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help!
Thanks in advance.
Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…
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…
I see there are 4 tables for KN module. KNNOTEH is the main one.
KNNTDIS is apparently to make a list of notes that have been dismissed, however, these records remain if you restore the note so this cannot be where Sage records the note status. KNSEQ…
Hi,
One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2?
They need to run FR, but encounters the following errors:
Description: PrintReport…
Hello everyone, this there a way to print multiple invoices under a customer number at once? (I use Sage300)
Example: A customer sends me a list of multiple invoices that they need. I don't want to search each invoice individually and save as a pdf…
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?
I have chart of accounts with two segments i.e MAIN & MAIN SUB
1234 Repair and maintenance
1234-01 Repair and Maintenance - HQ
1234-02 Repair and Maintenance - TZ
1234-03 Repair and Maintenance - ZM
On printing financial reports only Main…
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…
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…
Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error....
Automation error The object involved has disconnected from its client.
This only seems to happen for specific user. When logged…
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…