Insight News       

A monthly newsletter from                
Microsoft Gold Certified Partner                
AVF Consulting                

 

 

March 2009


President's Letter  
News and Events
EFSnet Update Tips and Tricks


Upcoming User Group Meetings

At AVF Consulting we are constantly striving to help clients get the most out of their investment in Microsoft Dynamics NAV. We feel that user group meetings are an excellent way for us to get to know your business better, while also providing customers the opportunity to hone the skills that will benefit them in their everyday operations. With that in mind, AVF is excited to announce that we will be hosting two user group meetings in the spring of 2009.

Our first meeting is specifically designed for K12 School District clients and will be hosted in Harrisburg on March 19 from 9 am to 4 pm.  The meeting agenda will feature training topics selected based on feedback from customers, as well as an open discussion of the future improvements to the solution. Attendees will also get a sneak peak of the re-branded name and logo for Microsoft Dynamics NAV for School Districts. For more information and an agenda, see the events section below.

We are also hosting a Technical User Group Meeting for all AVF clients. 
The meeting is tentatively scheduled for Wednesday, April 22  and will be held at our offices in Baltimore, Maryland.  The agenda for the meeting will revolve around technical issues such as security, backups, and disaster recovery options. We will communicate more details as we get closer to April. Register here if you are interested in attending!

Return to the top

AVF Consulting - March Newsletter - News and Events

Excel Training Presented By Jet Reports (Jet Reports Not Required)

On March 20th at 11:00am join Jet Reports for a free, one-hour Excel training course dedicated to showing you very useful features within Excel that make your everyday tasks easier and faster. Topics discussed will not be specific to Jet Reports so anyone interested in improving on their Excel skills is welcome to attend.

Topics covered by an Excel Certified expert at Jet Reports include:

  • Relative Cell Referencing
  • Data Validation
  • IF Statements
  • Date formatting
  • and more 

Interactive exercises will be included and practice material will also be delivered. We hope you are able to take advantage of this valuable opportunity for reviewing and learning functionality within the Microsoft Office application you rely on most.

Click here to register for the training session.

Return to the top


Pennsylvania School District User Group Meeting

AVF Consulting is hosting a User Group Meeting for all Pennsylvania School Districts on Thursday, March 19, 2009.

*Registration for event closed

When: March 19, 2009
9:00 am - 4:00 pm, light breakfast and lunch provided.

Where: Holiday Inn Harrisburg East
4751 Lindle Road
Harrisburg PA 17111
Hotel Tel #: (717) 939-7841

Training Sessions Include (click here for detailed agenda):

  • Working through Jet Reports real life-examples
  • human resources and payroll
  • fixed assets
  • vendor bidding
  • business rules/workflow management

Return to the top


Technical User Group Meeting

 


On Wednesday, April 22, 2009 AVF Consulting is hosting a technical user group meeting at our offices in Baltimore. Topics of discussion will cover technical topics such as security, backups, disaster recovery options

More information, including how to register to attend, will be communicated in the next few weeks!

Return to the top

AVF Consulting - March Newsletter - EFSnet Change

Important EFSnet Update! 

In September of 2008, we informed ChargeLogic customers that FirstData was eliminating the EFSnet payment gateway. FirstData had previously announced that EFSnet would cease to be operational on March 31, 2009. On Friday, February 27, we were informed that, due to overwhelming feedback from merchants, FirstData has delayed the elimination of the EFSnet payment gateway.  We have been told that the gateway will be up through the end of August 2009. FirstData has also decided to provide an emulation server to take the place of EFSnet as a result of this feedback. FirstData will be sending a letter to all merchants discussing these changes and providing a URL for the emulation server.

It is our understanding that utilizing the emulation server URL, ChargeLogic customers using EFSnet can continue to process transactions just as they always have, with the following exceptions:

  • Transaction query methods will no longer be supported.  In ChargeLogic, this equates to the automated reconciliation functionality.
  • TeleCheck through EFSnet will not be supported.
  • STAR Check through EFSnet will not be supported.
  • Level III data will no longer be accepted.  Level II data will still be accepted.

The emulation server is still in testing by FirstData and AVF has not had an opportunity to test ChargeLogic on the emulation server. We will begin testing as soon as the URL is available.

In an effort to ensure that all ChargeLogic customers were prepared for the transition, we informed our EFSnet customers that they would need to upgrade to the most current version of ChargeLogic and have their systems reconfigured for the Buypass platform or that they needed to switch to another payment gateway that was supported by their current ChargeLogic version by March 31st. The announcement of the emulation service means that any ChargeLogic customers still using EFSnet may not be required to perform an upgrade or switch payment gateways.

In response to the information received on the February 27, work on all ChargeLogic customer upgrades scheduled as a result of the EFSnet sunsetting have been suspended. If you wish to proceed with the ChargeLogic upgrade or if you have any questions regarding your ChargeLogic upgrade or EFSnet, please contact Steve Schmidt at 443-279-1034 or sschmidt@avfconsulting.com.

AVF Consulting - March Newsletter - Microsoft Dynamics NAV Tips and Ticks
Period-end Processes
You are not required by Microsoft Dynamics NAV to close periods, however, there are many month-end activities that can be performed if you wish to do so. The following is a list of those procedures, which may or may not be necessary for your company.

General Ledger
Specify system-wide and user-specific Posting Date ranges. Depending on your business needs, you may want to restrict user posting date ranges at the start of the period-end process.

Sales & Receivables

  • All Sales Orders, Invoices, Credit Memos, and Return Orders are posted
  • All Cash Receipt Journals have been posted
  • Update and Post Recurring Journals related to Sales & Receivables
  • Run the Aged Accounts Receivables report and reconcile A/R to the general ledger
  • Run the Delete Invoiced Sales Orders batch job

Purchases & Payables

  • All Purchase Orders, Invoices, Credit Memos, and Return Orders are posted
  • All Payment Journals have been posted
  • Update and Post Recurring Journals related to Purchases & Payables
  • Run the Aged Accounts Payable report and reconcile A/P to the general ledger
  • Run the Delete Invoiced Purchase Orders batch job

Fixed Assets
All Maintenance costs have been posted through the FA Journals or Invoices

  • Post Adjustments
  • Post Appreciation
  • Post Depreciation
  • Update and Post Recurring Fixed Asset Journal

Intercompany

  • Process Intercompany Postings

Tax and Intrastat

  • Calculate and Process Tax
  • Report Intrastat

Tasks to be Performed Sequentially
The following processes, which affect Manufacturing, Inventory, and General Ledger, should be performed sequentially.

Manufacturing
Within Manufacturing, the following processes should be performed sequentially.

  • All Consumption and Output has been posted
  • All completed Production Orders have been changed to a status of Finished

Inventory
Within Inventory, the following processes should be performed sequentially.

  • Make all necessary Inventory adjustments
  • Run the Adjust Cost - Item Entries batch job
  • Run the Post Inventory Cost to G/L batch job
  • Run the Inventory Valuation report and reconcile Inventory and COGS to the general ledger
  • Run the Inventory Valuation - WIP report and reconcile WIP to the general ledger

General Ledger
Within the General Ledger, the following processes should be performed sequentially.

  • Make all necessary G/L adjustments
  • Update and post Recurring Journals
  • Process Consolidations

 Run Account Schedules:

  • Open the Account Schedule window, and click Print.
  • Fill in the Account Schedule request form and click Print.

Specify system-wide and user-specific Posting Date ranges

Return to the top

 

 

Copyright 2010 AVF Consulting. All Rights Reserved.