web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Debit and Credit logic on Solomon TB

(0) ShareShare
ReportReport
Posted on by 65

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)
  • Suggested answer
    Community Member Profile Picture
    on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans