Keeping it simple

Moving from Paper to Electronic for Vendor Payments… and save $

Most SL / GP users are still paying their vendors via checks. The cost of check stock, envelopes, stamps, stuffing time, and mailing time all add up. Maybe your company should look at switching away from this old method to electronic fund payment methods.

 

For SL users, here is a link to a short demo on a great integrated solution from Sandler Kahne for EFT payments: Save-Time, Save-Money with this add on module.

 

    http://www.sksoft.com/scrncams/APEFTVideo1.html 5 minute demo

 

 

Five new advantages of ACH payments

Sending electronic payments through the automated clearing house (ACH) network — provides you cost savings, convenience, reliability, and security. And with technological advances and new ACH applications, now you have the ability to:

1. Accelerate electronic billing and payment. Use the ACH network to move online bill-pay consumers from paper to electronic bills. You'll reduce accounts payable and accounts receivable costs, improve efficiencies, and increase remittance and bill-payment posting accuracy.

2. Enhance supplier relationships. Checks sent by mail can get lost or stolen, and you don't know how long it will take for them to arrive or when funds will clear. As a result, suppliers might not get paid on time. ACH payments post directly to accounts and settle within one to two days, so there's no speculating when transactions will clear. An added bonus: If you pay suppliers promptly and consistently, you'll often benefit from early-pay discounts.

3. Optimize funds availability. Use ACH debits to concentrate cash from multiple accounts into a single account for investments or loan payments. It's easy and inexpensive to put available funds to work.

4. Improve cash forecasting. With ACH transactions, you know exactly when your account will be credited or debited — an increasingly important function in this economic environment. Domestic ACH transactions settle the next business day; international ACH transactions settle on a set schedule. You may also specify future settlement dates.

5. NEW FEATURE Reduce international transaction costs. When global ACH transactions replace wires, the cost savings are impressive. This act can save as much as 90 percent of their costs of making payments. And global ACH payments have no lifting fees, so payment recipients are happier, too. (I.e. Use ACH instead of international wire transfers)

 

Multicurrency accounts (MCAs) offer another level of cost reduction. By making global ACH payments from MCAs, you collect and pay in local currencies, virtually eliminating costs for currency trading, foreign exchange risk, or concerns about managing hedging programs.

 

Maybe 2010 is time to move your company to the 21^st century for vendor remittances.

 

Regards,

 

Jeff Cozens

How to create exception reports in Solomon

Most of our pre set up reports in Solomon are created with Crystal report writer. Although we have a powerful way to create quick exception type reports using the select tab on a typical report, many SL users are frustrated by the fact that we do not have lookup or F3 possible values for the field column. This is an example of programmer vs. customer interface which means we need to understand what the programmer called a field by the name the programmer originally gave to the field. Here in lies the problem. What programmer think are good names, may not be what you think these names should be.

A tip which can help you get past this problem is to take advantage of your customersource membership. Log in to customersource and in the search customersource field type: Report Assistant. You should be able to find several report assistant brochures which can help you learn about reporting with various modules. Being a graphical person, the part of these report assistance is screen like this:

 

 

From this screen you can learn the name of the key table that the data was originally posted to (i.e. batch, apdoc, aptran) and the field name. Know this information it is really a cake walk to get selected data for your exception report.

 

Another thing people forget that you can select on a field which is not displayed on the report and still create an exception report. For instance, in the report, General Leger Detail you can find information about a specific AP invoice number by creating this type of selection statement:

 

    

 

Where you are looking for ap invoice 1234 in the current GL period.

 

Good luck with your new tool, Report Assistant.

Regards,

 

Jeff Cozens

 

Ps. Contact me if you need more help finding report assistant documents.

 

Protecting your FRX Reports

Got a panic call the other day from one of our clients They had been modifying the row logic for a couple of their FRX reports, but failed to save the original versions. "Help, I really blew it today. How do we recover the missing Frx reports. ?" Our options did not look too good until I realized that she had a backup spec set for all of their FRX reports. This tip applies to anyone running FRx (i.e. Dynamics SL, GP, and Nav) and hopefully can save your "bacon" like it did for this client. We were back up and running in less than 30 minutes, and my customer was very happy.

 

To follow this tip, you need to be able to log into FRX Designer. Once you are in the program, click on the menu item at the top called Company, then the sub menu called information.

 

In the left frame of this screen, click on the main Frx company that you want to backup. (i.e. SSI New)

 

Under the frx System information tab, write down the name of the specification set; (i.e. SOLADV). Next close out of this form.

 

Next click on the Company menu at the top, and then the sub menu: Specification Sets. This will get you to this window.

 

Click on the spec set you wrote down in the first step, the then click on the menu Export:

 

Next for each of the four tabs: click on the tab then click on the select all button, to cause all rows on that tab to be selected.

 

 

 

After confirming that all items were selected (see info at bottom left corner), click on the Export button and export out. I like to add the date to the export tdb file to keep in clear in my mind when the export was run.

 

 

Click to save button and you have successfully backed up your entire catalog, rows, columns and tree components for your Frx reports. This is a good file to archive to a save spot. We will be using, however, this file for the next step.

 

 

Staying in the Specification set form, click on the new icon, and assign a name and description in the first two fields. (i.e. SSI_bkup_1009)

 

Click the save button at the top.

After saving this empty spec set, we are going to import the saved building block components from the tdb file, we just created. Click on the import file and select the saved tdb file.

 

 

Click the open button to continue, which imports these saved definition to a new spec set.

The import step may take a few seconds. Once done, exit the screen for specification sets and re enter the screen. Select in the left hand frame, the newly created spec set, then click on the export button, this will display all of the saved components in the four areas of catalog, rows, columns and trees.

 

When a crisis for a lost report occurs, you can recover your lost report definition by using either the saved tdb file or use your backup spec set to create a new tdb file. Taking 5 minutes to set up this simple system can save you hours of frustration, if the problem ever occurred.

 

Call us if you have questions….. Be save with your frx report definitions, since an ounce of prevention, is worth a pound of cure….

 

Regards,

 

Jeff Cozens

 

 

 

Microsoft Dynamics ERP Construction Offer

Microsoft Dynamics SL and Microsoft Dynamics GP promotion targeting small and medium sized Professional Services businesses in the United States and Canada that wish to take advantage of the rich functionality offered by Microsoft Dynamics ERP.

EXECUTIVE SUMMARY
Microsoft is excited to announce the "Construction Offer" - a Microsoft Dynamics promotion targeting small and medium sized Professional Services businesses in the United States and Canada that wish to take advantage of the rich functionality offered by Microsoft Dynamics SL and Microsoft Dynamics GP. For a limited time, Microsoft is offering a discount of up to 20% for new customers when they purchase Microsoft Dynamics SL or Microsoft Dynamics SL Advanced Management ("AM") or Business Essential ("BE") edition user licenses.

The SL project series is very robust for both professional services and construction companies.

Call if you need more information.

 

Jeff Cozens