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.
We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…
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,
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…
2020 year's sales tax was easy. I just ran the tax tracking report for the relevant fiscal periods and sort by tax class, which for us is 1 for taxable items and 2 for non-taxable.
But this year, the same report for both this year and last double counts…
Hi there,
What FR function should I use in order to create a report showing department side by side? Also, is there a way to combine two departments?
Thanks,
Zia
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…
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…
This is not a question, just information: Recently, Crystal Reports started giving message "Unspecified Error" on certain reports, after working fine for many years. I have determined that there is suddenly an issue between Sage 300 desktop and Crystal…
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…
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…
HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format. for example: this is the original report…
Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.
Client has been running fine and this just this week we have been getting errors trying to use Financial reporter.
I suspect a microsoft update but they are saying none applied. (I know don't belive them ) either way I need to know what one it was …
I am attempted to show the total of the misc costs on an invoice. I have created a calculated field for the misc costs that is equal to the extinvmisc only when the linetype is <> 1. This does calculated correctly, but when I use a sum formula it is three…
Hi Guys,
Would a kind soul please help me ?
Here is the case:
I installed SAGE 300 2017 Workstation on a new PC running Windows 10 Pro.
The only but about the installation was a warning message as follows: “There was a problem registering the…
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.
Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018.
When trying to print preview any default sage reports get error message.
Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment..
After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…
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…
