Plumbline Solutions - Software Consulting Services

Newsletter - November 2005

What do I do if I have a Microsoft Solomon batch that is suspended and will not release?

Use the results of QC_Data_Check, APDebug, or ARDebug to troubleshoot the batch problem.

Open Microsoft SQL Server Query Analyzer and follow the steps below.

Using SQL Server 2000:

1. In Query Analyzer, select the appropriate application database.

2. Click Tools, click Options, and then click Results.

3. In Default results target, select Results to Text.

4. In Results output format, select Tab Delimited.

5. Click OK.

Using SQL Server 7.0:

1. In Query Analyzer, select the appropriate application database.

2. Click Query, and then click Current Connection Options.

3. Click the Advanced tab.

4. In Result Output Format, select Tab Delimited.

5. Click OK

6. Click Query, and then click Results in Text.

For suspended Accounts Payable batches, run the following query against the Microsoft Solomon application database in Query Analyzer:

APDebug ‘xxxxxx’
(where xxxxxx represents the six-digit batch number of the suspended batch)

For suspended Accounts Receivable batches, run the following query against the application database:

ARDebug ‘xxxxxx’
(where xxxxxx represents the six-digit batch number of the suspended batch)

For suspended Inventory batches, run the following query against the application database:

QC_Data_Check ‘xxxxxx’, ‘yyyy’
(where xxxxxx represents the six-digit batch number of the suspended batch and yyyy represents the ID of the company you are working in)

If you are not sure what the company ID is, running the following SELECT statement will provide it:

SELECT CpnyID from GLSETUP

After you run a query, save the results so they can be reviewed in Microsoft Excel. To do this, click in Results (the lower pane in Query Analyzer), go to the File menu, and then click Save As. Enter a file name, leave the default extension of .rpt, and then click Save. Open the results file in Microsoft Excel to troubleshoot the batch.

API – Application Programming Interface

SOAP – Simple Object Access Protocol

UML – Unified Modeling Language

XSLT – Extensible Stylesheet Language Transformations

Click this link to Search for Terms!

Plumbline Solutions provides software engineering services for Microsoft^® Independent Software Vendors (ISV) and Microsoft Business Solutions (MBS) Channel Partners. We offer software development, application support, and technology consulting, with a dedicated focus on delivering excellence and building lasting relationships.

Automated Software Testing

A number of Microsoft partners have used Microsoft Solomon Tools for Visual Basic or the Microsoft Business Portal Software Development Kit (SDK) to create custom modules. Testing these products can mean a significant investment of time and effort to ensure the desired quality level before release to the customer. This investment must take place at initial development time, and it is repeated for later enhancements to the product.

Plumbline Solutions can help with this effort by offering our extensive experience in automated testing. We utilize industry standard automated tools and strategies when testing Microsoft Solomon, Microsoft Business Portal, and other enterprise-critical software. We can assist you in creating reusable tests that will help you release a quality product now and application enhancements later.

Not sure of the next step?

Contact Plumbline Solutions. We have the know-how needed to design, implement, and test development projects using the Microsoft Business Portal SDK.

For more information please contact Paul Komosinski at 419-421- 0270, extension 109, or pkomosin@plumblinesolutions.com

Do you want to track additional detail on your purchase orders during the approval process?

In Microsoft Dynamics™ SL 6.5, you will find that a new module, Requisitions, has been added to augment the core purchasing application. This module offers various levels of approval processing during the life of a requisition.

The software can be customized if you need to see specific data for tracking purposes on the requisition header or detail lines. This could mean adding tables, fields, and look-ups, which can all be done by utilizing Tools for Visual Basic.

Plumbline Solutions would be happy to assist you with any necessary customizations from older versions of Requisitions or assist you with new customization. In addition to helping with your software customization needs, Plumbline Solutions also offers custom training, designed to get your consultants and support staff ready to ”hit the ground running” with this new addition to Microsoft Dynamics SL. We can even tailor the training to suit your customers’ needs.

Please contact Todd Michael at 419-421-0270, extension 114, for more information.

United Way Campaign

Plumbline Solutions is a company that believes in building lasting relationships with customers, partners, team members, and the community. Plumbline is giving back to the community by raising funds for the United Way. Through the generosity of team members, Plumbline reached its 2005 campaign goal one full month ahead of plan!

For more information visit our web site at http://www.plumblinesolutions.com

If your customers frequently wait longer than they would like for help with a Microsoft Solomon technical issue, Plumbline Solutions can help!

We offer superior customer care services for Microsoft Solomon Dynamics SL. Our tenured support staff is certified and has experience in releases from Solomon Software 2.06 through all current Microsoft Solomon releases. We also provide technical expertise in all Series: Financial Management, Distribution, E-Commerce, Project Management and Accounting, Field Service Management, and Analytics. In addition, we offer basic support for the Foundation Series and Microsoft Business Portal.

Support services are offered on a short-term or long-term basis and can be tailored to your unique needs. For more information, contact Todd Michael at 419-421-0210, extension 114, or toddmich@plumblinesolutions.com

Here is some helpful insight our employees have learned from working in the technology industry.

Creating an Issue List

* To create and Issue List in Business Portal, Issue list assign, prioritize and follow the progress of issues from start to finish. SharePoint allows you to create these lists, and Business Portal does as well. To create an Issues List, you would go to Site Settings > General Settings > Create > Lists and then choose Issues from the list of choices.

Verifying The XML Version                     * To verify the version of XML running on a workstation you can download the Xmlversiontext.exe file from the Microsoft Download Center and run it to capture the version information. (This can be helpful when you are troubleshooting certain FRx error messages.)
ISV Link Exchange                     Looking for a third-party application or vertical solution that can be used with Microsoft Solomon?

Try accessing Plumbline’s ISV Link Exchange. It shows all of the Microsoft Solomon-related add-on products. Best of all, it is fast, friendly, and provides what you’re looking for.
If you would like us to add a link to your company’s Web site, contact Adam Lauth,
marketing@plumblinesolutions.com or by phone at 419-421-0270, extension 119.

Name: Linda Contreras

Team: Application Development Consulting

Background: Worked for more than ten years in the insurance industry as a licensed property and casualty insurance agent in Ohio. Owned a small business in the transportation/service industry for ten years, serving as financial officer.

Role: Currently provides technical support, specializing in the Distribution modules.

Likes best about ADC: It's never boring. There are always lots of opportunities to learn new things and take on challenges

Hobbies: Quilting and rollerblading (but not at the same time).