Tag Archives: Microsoft Dynamics SL

‘The available filters for this report can’t be displayed.’ received when viewing reports in the Management Reporter Web Viewer

If an invalid year/period to post value is found by Management Reporter in the SL application database(s) it will add it to the MR data mart and can cause this error. Using the SQL select statements below, confirm that the date values returned refer to only valid years.  There should not be any blank values or anything too […]

Plumbline Consulting Partners with Integrity Data to Bolster ACA Portfolio and will now be offering, Integrity ACA – Dynamics SL Edition to the Dynamics SL Community.

Findlay, OH – Plumbline Consulting, the premier resource for Microsoft Dynamics Partners and ISVs, has partnered with Integrity Data, a longstanding leader in Payroll and Human Capital Management for Microsoft Dynamics. “The intricacies and complexities of Affordable Care Act compliance demand a comprehensive solution that can be perpetually updated based on the ever-changing nature of […]

Tables are missing in Crystal Database Expert

When you select Database Expert for either selecting new tables or for connecting your Crystal report to the correct ODBC, you expand the database and cannot see any tables. 1. Right-click the database in Database Expert 2. Choose options 3. Uncheck all boxes except Tables 4. Close the menu 5. Again, right-click the database 6. […]

Project Revenue Recognition in period 01 results in large amounts being posted

Revenue is recognized incorrectly for all previous years because Project Controller was not properly closed prior to running for period 01. Closing Project Controller Module advances balance forward for projects. 1. Open Project Controller Setup screen. Change Current period back to 12-xxxxx (xxxxx represents last fiscal year) 2. Run Close Period for Project Controller to […]

Loan Management System Credit Types

How do the Credit Types in LMS work? Actual Payment – A standard type loan where interest decreases over the term and principal increases correspondingly keeping all payments the same except for the last one. The amount of interest is calculated based on the actual payment date. Add On – With Payoff – The loan […]