
Currently the trial balance produced in Solomon displays Liability credits as positive on the trial balance is there anyway in Solomon to print a logical TB where credits are negative? It is a big source of frustration every time I look at the TB.
I know that the determination of the credits are set by the Type (Asset/Liablity/Income/Expense) in the Chart of Account set-up/maintenance. If I was to configure Solomon to treat all of the BS as an asset and all of the P&L as a expense so the logic of the TB holds true would there be any impact elsewhere on the system? We also use an old version of FRX I don't think the running of reports would be impacted by this as all reports use TB codes.
Be grateful of anyone's advice.
Thanks
Craig
*This post is locked for comments
I have the same question (0)A true accountant at heart you must be.
Solomon is not going to let you change the account type once you have posted to that account so unless you come at this from the back door (e.g., SQL update queries) you will not be able to do what you suggested. Even if you did, you would have to reverse the signs on all the liability and revenue account net posting in the accthist table for every entry already made. You would also have to go into the FRx report definitions for any reports that reflect liabilities and revenue changing the natural balance indicator. Then, if you enter budget information or statistical information, those would have to be adjusted.
All in all, I would not consider your suggest idea. As an alternative, you could create your own FRx version of the trial balance where you leave the natural balance indicator blank on all liability and revenue accounts. Or, you could modify the standard GL trial balance report in Crystal Reports to invert the sign on liability and revenue accounts and save that modified version in the usrrpts folder. Either of these choices would give you what you want without "fooling mother nature" like you were thinking.