230
Hi Folks,
*This post is locked for comments
Allan,
Ah yes. I think I understand what is happening. If you look at your new row format that you built with the Add Rows functionality, you will see that some rows have a "C" in column E of the row format. You can take this "C" setting to mean "Change the sign of the values on this row". This is useful in reports like Income Statements where you wish to show revenue as a positive value in the report. It causes our problem here in the Trial Balance though.
When using the Add Rows function, FRx checks a setting in the GL if available that tells it if each account normally holds a Credit balance. If it does, the "C" gets applied to that row by default. It only happens this way when using the Add Rows feature. BUT you can manually apply the "C" to any row you wish (helpful in CashFlow reports) and delete it where you do not want it. Like now with the Trial Balance.
Go ahead and delete all the "C" values, you can highlight the whole column at once and delete them. If you put a total at the bottom of the report it will also help you tell if you have things right. If the total is not zero then there is a problem. If the total just does not show up, that is probably because it IS zero and you have the report set to not show zero rows.
Save the row and run the report again.
Let me know how it goes and if this fixes your issue. It may be beneficial for you to attend one of our FRx webinars. We could help you get a handle on the basics and you can see if our training classes might be a good idea.
You can email me at Rob.Iversen@MSXGroup.com or visit our website http://MSXGroup.com for more details.
Thanks
Rob
I got the report to work once i fixed the row format and added accounts from Gl as you suggested.
My issue is that now, the trial balance that GP produces does not match with the trial balance which FRX produces. This is imminent for certain GL accounts only especially when the net change in amount is negative. Could you shed light into why this may be happening?
Allan Fernandes
Allan,
It looks like you have a 12 character account code in the row, but FRx thinks you have a 17 character account mask. If you built this row format by hand, try a different approach.
In a new Row format, click the Edit menu then Add Rows from Chart of Accounts. If you want full accounts here in rows then make sure to change all the #'s to &'s for all your segments. Then click OK. You should receive a row format with every full account in your GL and hopefully they match the number of characters FRx thinks your mask should be. Save that row then try running your report with that.
Let me know how it works out at Rob.Iversen@MSXGroup.com. You can also visit our website http://MSXGroup.com for more information about our services, support options, training classes and FREE webinars.
Thanks
Rob
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
