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…
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,
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…
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…
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…
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 ?
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.
Hello,
I am new to using Sage 300 and I have a problem with printing. When I select any of the Print Destination options and check Data Integrity, a log file should be printed (or opened in another window for Print Preview). However, the check is performed…
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…
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…
I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
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…
I have a report written over a Single View. The tables used include: GLAFS, ARCUS, OEINVH, OEINVD, OECRDH, OECRDD, ICITEM. When I run my report in Crystal it runs fine. When I attempt to add it to the ACCPAC SAGE300 Reports menu I receive a popup warning…
I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report.
Any & all help is greatly…
We are using Sage 300 Premium 2018 (Accpac) with the Job Costing module.
I don't have a method of auditing the balance of the WIP balance sheet account. The balance is climbing, and it is as if transactions are being "dead-ended" there and not flushed…
Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on.
Windows Server 2016 with SQL Server 2014.
When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines.
Appreciate if anyone has seen this before and has a solution…
We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
I've set a few criteria in optional field in Order Entry module, user will insert their data to each of the created optional field, now how can i show Optional Field data which have a few lines to reporting? It should showing all Order Confirmation although…
I have searched the knowledgebase and i have not seen the answer.
The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok.
I get this error whenever I click "Print" and when Excel tries to run the report…
