Sage 300

My client is running Sage 300 Premium Edition Version 2020. They want their Balance Forward Customer Statement to have a running balance. The challenge we are encountering is that the client has done adjustments so the adjustment amounts are not factored…

Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…

Has anyone changed the Reorder report to use the Preferred vendor instead of the report just using Vendor Type 1. I realize the report is using a DataPipe and the prevendty isn't given under ICITEM for this report so it looks like I will have to build…

After entering data for a time period for payroll when i go to print the report there is only regualar hours and ovetime hours listed no per diem. ive looked extensivly and cannot find how to add this to the report someone plz help thanks.!

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?

What is the syntax to add a budget colunm of a specific year? How to specify 2020 budget column to the report?

Hi there, I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column? Thanks, Zia

We are currently running Sage 300 version 2021. We are looking at buying a Crystal Reports license. What would be the recommended Business Objects (Crystal reports) to buy ? I would have preferred the 2021 version of Crystal Reports but l am not sure…

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!

Does one really needs to have full installation of Office on the Terminal Server running Sage 300 or would the Office runtime files suffice especially where Users access the Server/App via RDP sessions? Would the runtimes files allow the Admin to modify…

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…

Hi all, ever since we upgraded to Sage 2018 and now 2020 we are having issues with the Aged Trial Balance Reports mainly in AR. When running open for a customer the report now lists $0 adjustments. If we uncheck adjustments they of course are not listed…

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…

Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…

I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…

Hello Team, Our client who uses sage 300 ERP requested for a report of all AP invoices and AR invoices for a vendor and customer respectively. Specifically, the invoices that have been paid for in the past and yet to paid. What report can we spool…

My client has 3 databases on their Terminal Server, they also use Customisation Directories. \COMPANY-A\CUSTOM\GL66A\ENG \COMPANY-B\CUSTOM\GL66A\ENG \COMPANY-C\CUSTOM\GL66A\ENG When Printing Financial Statement using Print Financial Statement…

We are using Sage300c 2020 web screen, when we print a report we are able to see it on-screen {Preview}. But, unable to print to printer or export

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…

Hi All, I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.

In Sage 2017 & 2020 the FR View Fails but gives no error. Below is the update I uninstalled. It breaks the variance report on newer Windows versions, but not on older versions. Security Update for Microsoft Excel 2016 (KB4484338) 32-Bit Edition…