Sage 300

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…

Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203. Any advice?

Hi Above the FR was working fine with comparison for Current Year & Last Year in Column H & J. But we want to add in the balance for each branch - J001, J002, J003 & J004. which using the segment 2 before the Current year. So I have tested with…

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've built an FR report. Its very straightforward, I have each individual account listed in column A but grouped together into line items. For example Column A ACCOUNT, ACCOUNT, ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT ACCOUNT, ACCOUNT, ACCOUNT ISSUE 1 I…

I have a report that is pulling info for each my end of years. the .L1, etc works for every year when I use it with BALP, but it only works to L9 when using it with FRFISCAL. My formula is =@FRFISCAL("END","L9"). When I change the 9 to 10 I get the fiscal…

Client wants to exclude certain departments from their financial report and the departments are not sequential. I am trying to exclude them using a formula in Column B. (ACSEGVAL02 != "110") OR (ACSEGVAL02 != "200") It seems that FR does not like…

I would appricate if some one can help me in resolving the issue we are facing. Navigate to ‘General Ledger’ -> ‘Financial Reporter’ and then click on ‘Print Financial Statements’ (Step-1). Select the statement name ‘Balsum01.xls’ and then select…

Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:

Hi All, Problems found when we had started doing new forms/reports for Sage 300 2019. Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…

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…

Hi, Does someone written and willing to share a SQL statement that is an equivalent of FRAMTA("BALP") from the Financial Reporter? I am trying to figure out how our GL Inventory account is calculated. I read one of the discussions to run trial balance…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

Sage 300 Financial Reporter - Income statement is not populating but balance sheet does. Has anyone else seen this and how do we fix?

I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…

A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN

Sage2018 SP2 new server. office 2010, when you launch statement designer comes up with error "cmdStart : Error on opening the xla macro.", if you click close says "cannot run macro RemoveAutoStartFiles" excel macros are enabled and VBA enabled too.…

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 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…

Sage 300 2018 When the Financial Reporter Balance Sheet is run and the user has their language set to Spanish, the results are different then if the user has English as their language. I tested using same user but only changing their language. The…

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.

Client moving to new software per new owners in a couple of months, so do not wish to upgrade Sage 300. Sage 300 v 2012 local install, data on server. Workstation crashed, wiped and reinstalled. External IT firm installed Office 365 with 32 bit Excel…

Hi, I am unable to run any report: I get a message box that says: Initialising FR Error (12): Fail in starting Print Financial Statements and when I push OK, another box, pops up: Error: PrintReport:Error on running StartGL9100 in macro …