Sage 300

Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?

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…

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…

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

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…

Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.

Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan

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?

When I print my PO to PDF the amount is displayed by #### symbols. Is this a formatting error? I attached a snapshot of what it looks like. Thanks!

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…

I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?

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…

How do I suppress inactive accounts in FR I have tried ACTIVESW=1 in column B but it does not suppress the account # in column A

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…

I created a folder (new Object) that contain customized reports in Sage 300 premium (version 2016). When I run these reports Sage crash and closed with no error message. The reports I created work well in another PC. What can be the problem?

I have a client wanting to use the free BI reports provided by Sage called the Customer Aged Trial Balance S300-SQL(C4-0-5) or the Detailed AR Aged Trial Balance S300-SQL(C133-0-4) Unfortunately, both aging reports cut off by Doc Date and for…

Sage 300. I have written a report in Crystal which runs great from crystal but generates nothing when I add it to the reports Menu in SAGE. I get a bit of an hourglass but no output. It is setup for preview.. Any tips on how to troubleshoot this?

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not using…

We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.

Hi, A client has been printing an FR Report for many months now but then she suddently started to receive an error message this week: "Initializing FR Error (12) : Fail in starting Print Financial Statements" I tried a few of the usual MS-Excel…