Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Sage300 v6.0 using RDP.
only one user has problem.
FR Preview is normal.
When generate report by print destination as file.
a blank error message open.
the file select screen's capture is adnormal
If ok, it will hanged.
Any hints?
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…
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…
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, 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…
Hi,
If I tried to run Financial Designer I get this error
cmdStart : Error on running Installed Addin And XLStart in xla macro.
I put macro settings to enable all macros but not luck, Any idea?
Thank you
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
…
How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.
How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…
Have a question about Excel conditionally formatting within the Financial Reporter.
I have a FR report with different columns for each division......is it possible to format that column either red or green depending on if that division is showing a…
Hi
We have a client running 6.1 Sage ERP 300 with SP 4 installed.
They are using Excel 2013 32 bit which PU2 says makes compatible but when we run we get an error saying it cant open excel as excel.
I ran a repair on excel in control panel.
Ran…