Sage 300

ICBOM01.rpt gives connector error when processing CSV file made by ICCOMP.DLL V2020 I get no error if I suppress the sub-report so I know it is that sub-report showing BOM details Error happens on server with O365 and another server with no Office installed…

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. Does anyone know how to prevent A/R Summary Credit Notes from appearing on the sales tax report? The system assumes that these credit notes are sales-related but only the OE credit notes are sales related. We have a tax code that calculates no…

Recently migrated client to Windows Server 2022 (RDS) Sage 2023 PU1. Printing anything takes forever - 18 seconds running AP Account Sets report. When I test the same report on SAMLTD it renders in a few seconds. There is no Customization Directory…

We have gone to the Crystal Reports and cannot for the life of us figure our what this number represents? It didn't change when I printed the PO (as in it would roll up one for each time printed), it also did not change when I added lines or modified…

Can anyone let me know what report/file the use to send a check file to their bank for Positive Pay? The file needs to be in excel.

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, 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, Did anyone encountered the same error code when print Financial Statements in Sage 300 2024? After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button? Client is using Microsoft Excel…

Good Day Sage 300 PU4 Client recently upgraded to above. The FR report runs successfully but is no longer suppressing zero value lines even though this is defined in column c. I have tested on 32bit Excel and it works correctly. The client uses 64bit…

I would like to sort the results of the report for a rage of accounts based upon the values produced. for instance: cost of sales accounts, detailed by d(acct) for 4 separate columns from J, K, M, N and then SORT THEM by column M in decreasing values…

Upgraded to Sage 300 2023 PU1. Web screens work fine except cannot export to pdf. Gives the above error. Have tried changing the app default for *.pdf

The full story is that our client of over 20 years has had to move their system from their local server to an Azur server at short notice. Everything is working fine except when they print the AR invoice form, both the customized form and the default…

I downloaded the Sage Intelligence Report Utility and installed the PJC reports for Sage 300. When I try to run the reports on a database, I get the following Execution Error Description : It was not possible to connect to the database. The error returned…

need to take you back i have an FR report in the typical Vertical format with departments coming one after the other Admin Electrical Engineering i want this in horizontal format, the departments next to each other, column H, I, J for example…

I have a fairly basic FR Financial using the FRTRNA function and it's only showing drilldown information on the first detail row. Any suggestions?

Hello , i am running the Budget vs actual report on financial reporter. our fiscal period is April to march but when i run the report lets say on December it shows budget only up to December, is there a way i can run the reports any months and it compares…

Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?

on a system that had been successfully funning BI for months i am suddenly recieving the error object reference not set to instance of an object when trying to run a BI report. It doesn't matter what report I run even a sample report. In fact if I just…

when I adjust the MaxDetails formula field in the APCHK01 crystal rpt for printing cheques it does not move the total of the net paid up. I have the section set to print at the bottom of the page. If I click that off the total will print directly below…

I'm looking for a report that will show the posted transactions (or batches) by user. (Or a list of all transactions/batches for a select date, with a column showing the user). Any help?

I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…

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…

Recently upgraded my standalone workstation version of Crystal Reports to the 64 bit variety. Now I get the "u2lcapw.dll" error on all Sage 300 Crystal reports (2023 PU1). I've done all the usual copying of the u2* files from both c:\windows\crystal and…

We just upgraded a client to Sage 300 2023 on their existing server. After the upgrade, printing their customized PO form prompts to enter SQL name and password. Even when I enter the correct credentials, it fails with "login failed" message. I thought…