Sage 300

Hello, We are finding that we have some customers with open invoices that are not showing in the AR aging report. Has anyone encountered this scenario? Ty.

We have a customer running Sage 300 2019 , Product update 1 in a client server environment. The AP Pre-cheque Register, when it has more than 1 entry , does not display the first entry completely, it only has a line and the total, so it is not possible…

Hi, Our current / prior income statement now shows zero balance rows after upgrading to Sage 2022 and excel 64bit. The report worked with the previous version of Sage and excel 32bit. "Z" is in column C. I have a formula in column J that calculates…

Hi all, my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column. When opening it on old version of Office…

I recently ran PU7 for Sage 300 2020, i was previously using PU1. I did not see PUs 2+. After i reactivated the modules, I attempted to run an A/P Batch Listing when I observed the error message. How can i resolve this issue? Thanks in advance.

balance sheet does not balance, primarily problem with Net income accts not totaling correctly. No errors, just out of balance. installed 64bit addin correctly. Again, when running in designer no issues, running under print Financial statement icon…

Good Day What causes a statement and the ageing not to balance.The Ageing is showing a debit balance but the statement is showing the credit balance. The customer statement Run Date is the current date but the cut off date is 2020. I have changed…

in one of our client , Users cannot print different customer statements concurrently. Is this how sage works? If for example a user has printed a statement for Customer X and while it is still open on his machine, another user tries to print a statement…

My company is not posting cash receipts until the previous month is closed because they cant go back and print and aging with the proper cut off dat to tie to GL. This is causing a delay of up to 2 weeks for accurate agings. Does anyone have a work…

We have one item code, the closing of End Jun 2021 does not equal to opening of Jul 2021. The c losing as at 30 Jun 21 is 15,800 pcs and the o pening as at 01 Jul 21 is 31,596.84 pcs. May I know how to solve this problem? Thanks.

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

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..I have a question regarding Reporting Currency in a multi-currencies company in Sage 300. For example, the based currency is MYR, and the reporting currency is USD. How Sage 300 handle this? And use that USD reporting currency to generate the Financial…

Hi, Been getting this error when running Customer Statements and sending it through email. "Description: Crystal Reports Error: Unable to cast COM object of type 'Microsoft.Office.Interop.Outlook.ApplicationClass' to interface type 'Microsoft.Office…

I'm trying to set up a 12 month rolling income statement. has anyone done this? wondering what FR formula to use. Thanks!!

Hi, how can we obtain a list of all GL entries for a specific document number? Thanks.

im trying to print an invoice when i preview it all looks correct. after printing the alignments are not coming as per the preview. how can i fix this? please need support.

How do I re-run the Job Cost Close Month Report to see if I resolved the issues raised at Close Month in Job Cost? Thank you!

Hi We have a client who has been using a FR Report for years and this week it just stopped the lines it is stopping on are all the ones with the ~ this used to be supported in Fin Report as doing the following so in this instance …

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…

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…

Hi, A customer that has Sage 300 2019 (all programs at server) is having an issue with A/P Vendor Activity. No information showing there and name of columns doesn't appear (I attach screen) !!! This happens in only this user and another one. All others…

I had a client ask this recently and i just had not noticed before. I cannot find an option for this. Am I missing something?

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…

Hi, I'm trying to create an income statement FR report but this time I would like to categorize by account group which I've never done. I've followed all the instructions in the FR manual but its still showing no financial data. Here is the breakdown…