Sage 300

Sage 300 2019 PU7 While sending A/R Invoices/Statements via Email, the system sends some e.g. 50-90 and returns the Error below; "Description: Mail delivery failed. Use the Email tab on the Company profile screen to send a test email and confirm that…

Will there be an update to the 1099 forms since the government forms are now 3 to a page?

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.

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…

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!

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

- in a test environment I have setup 3 contacts - made sure the "consent" is checked - I assign those three contacts to a customer - mark them to receive AR invoices - send a single invoice and receive the error Mail delivery failed. Use the Email…

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…

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…

Is the above configuration compatible? I've adjusted all the settings for activeX and macros but the add-in refuses to load. The client upgraded their workstations to Windows 10 from Windows 7. I assume that's the cause of the problem but sure and I…