BMI Microsoft Dynamics NAV Blog

Microsoft Dynamics NAV / Navision "Out-Of-Balance" AP Check Error

Posted by Amy Valenzano on Jan 30, 2014 10:31:00 AM

I have come across a few different situations where a user has printed computer checks out of Navision where the check printed fine, but when the user goes to post the payment journal an “out of balance” message appears and the journal cannot be posted.  

Here is an example of a Payment Journal where the checks have been printed correctly and the Total Balance is zero.

Payment Journal view after checks have printed correctly.


When going to post this error message appears.

"Out of Balance" error posting Payment Journal
 

The reason for the error is because the data is not listed in order of Vendor No so
that when Navision goes through the posting process the balancing credit amount
line is not directly after the debit lines.  To resolve this error without voiding the checks and rearranging the data, you can simply re-sort the journal by changing the sort option from the
default “Journal Template Name,Journal Batch Name,Line No.” key to the “Journal Template Name,Journal Batch Name,Posting Date,Document No.”

Topics: Navision, Dynamics NAV, Dynamics NAV, Microsoft, Dynamics NAV 2013, Microsoft Dynamics NAV 2013, Navision Training, Microsoft Dynamics NAV, NAV Training, Microsoft Dynamics Training

Training For Your Navision / Dynamics NAV Business Software

Posted by Karen Lengel on Jan 15, 2014 8:31:00 PM

It’s early in the New Year, and a great time to evaluate your business software internal training plans. 

Has it been over a year since you have implemented your Microsoft Dynamics NAV / Navision solution? If so, some of your staff would benefit from a refresher, or a “Question and Answer” session. What about re-assignments of your resources? You may have personnel who were originally trained in one area, but have since added another responsibility to their plate.  Are you sure they have a full understanding of how to use the Software?

Here are some things to consider:

1. New hires who are trained solely by other users may be missing some important points that would be covered by a professional MS Dynamics NAV consultant.  Ideally, this training is done with an internal manager alongside who can address any policy questions that arise while a MS Dynamics NAV consultant will ensure that all aspects of the functionality are fully explored.

2. Existing personnel who have taken on additional responsibilities or who have changed roles often self-train and would benefit from formal training.  Do you know what they may be missing?

3. Devoting some time during the year for training will allow certain questions to be raised that might otherwise remain unmentioned (and therefore unresolved).  Giving your MS Dynamics NAV users a forum to ask their questions is a great way to start the year!

Contact your BMI Project Manager to make a plan that works for you and get the most out of your business software.

Topics: Navision, Navision Training, Microsoft Dynamics NAV, NAV Training, Microsoft Dynamics Training

Fiscal Year-End Closing Process for Microsoft Dynamics NAV / Navision

Posted by Amy Valenzano on Jan 13, 2014 4:46:00 PM

Now that it’s the beginning of a new year, Business Management International (BMI) will receive many support calls requesting assistance on the process of closing the year-end.  This is not a difficult process, but because it’s only performed once a year it’s easy to forget.

Before running the fiscal year-end closing process you will want to tie out your G/L to various sub-ledger reports within Navision.  Below is a suggested list of functions to perform.

  • Ensure all Purchase/Sales Order receipts/shipments have been posted                       

  • Ensure all Purchase/Sales Invoices related have been posted            

  • Run Periodic Activity | Adjust Cost-Item Entries                                      

  • Run Periodic Activity | Post Inventory Cost to G/L                                  

  • Run Inventory to G/L Reconcile Report (inventory invoice accruals)               

  • Reconcile Inventory to G/L and calculate Accrual Entries                     

  • Calculate Depreciation for Fixed Assets

  • Run AP to GL Reconcile Report (non-inventory accruals)

  • Enter all Cash Receipts                                         

  • Run Aged Accounts Payables and Aged Accounts Receivables           

  • Reconcile Aged A/P and Aged A/R to General Ledger            

  • Perform a Bank Reconciliation                                                                                         

  • Enter any Accrual, Reversing, Recurring General Journals (such as: Depreciation, Payroll, Accrued A/P and A/R)

  • Run Financial Account Schedules                       

Once these items have been performed and your end of the year numbers tie out you are ready to process the year end closing.

Closing Accounting Periods:

When the fiscal year is over, you must close the periods.  Once closed, you cannot open or change the periods.

  • Select Financial Management, General Ledger, Periodic Activities, Fiscal
    Year, Accounting Periods

  • Click Close Year

You will then get a message to confirm what periods you are closing

Close Accounting Periods

  • Click YES to close the year

You will notice that a check has been placed in the Closed and Date Locked fields of the Account Periods window.

Close Income Statement Accounts

  • Select Financial Management, General Ledger, Periodic Activities, Fiscal Year, Close Income Statement

 Close Income Statement

  • Fill in the appropriate information then click OK.  This function will calculate the balance at the end of the year for all Income Statement G/L Accounts and create a journal entry in the Template and Batch you specified.  You will then need to go to the journal and post the closing entries.

Topics: distribution software, Navision, Dynamics NAV, distribution software, Dynamics NAV, Microsoft, Dynamics NAV 2013, Microsoft Dynamics NAV 2013

Dynamics NAV (Navision) and EDI

Posted by Craig Greitzer on Apr 15, 2013 4:23:00 PM

Microsoft Dynamics NAV (Navision) works extremely well with EDI.  BMI has many EDI customers working with Form 810, Form 830, Form 850 and Form 856. 

Once the mapping with your trading partners is complete, EDI integration is seamless with Dynamics NAV.  Whether you require EDI Purchase Orders, Invoices, Advanced Shipping Notices or Order Acknowledgements, using Dynamics NAV with EDI has never been easier.

Don't lose out on business because you can't transact EDI business for those business partners that require it.

Click here to learn more about Dynamics NAV (Navision) and EDI. 

Topics: EDI Form 810, EDI Form 830, EDI Form 850, EDI Form 856

Microsoft Dynamics NAV 2013

Posted by Craig Greitzer on Feb 28, 2013 11:35:00 AM

dynamicsnav2013logo

 

BMI has been enjoying our recent implementations of Dynamics NAV 2013. The Role Tailored Client (RTC) makes it easy for people to work with the functionality they need to perform their jobs. There are out-of-the-box roles available which can be customized and new roles can be created. The RTC features the "ribbon" which users of Office will be familiar with. The ribbon can also be customized.

Reporting has been an especially interesting aspect of NAV 2013 as the old report writer has gone away and Microsoft Visual Studio has taken its place. You can also use SQL Reporting Services and other third party reporting tools.

The RTC has a more visual feel than the "Classic Client" and various "parts" can be inserted on the user's home screen. Parts can be customer lists, vendor lists, Outlook email, sales graphs, etc. Each user can customize their own parts.

Click here to go to our Dynamics NAV page.

 

Topics: Dynamics NAV 2013, Microsoft Dynamics NAV 2013

Smooth Dynamics NAV Software Conversions Aided By MS Excel

Posted by Karen Lengel on Oct 3, 2012 5:20:00 PM

In my experience with many companies during a major Dynamics NAV software implementation, “Going Live” appears to be very similar to running a marathon. In recent years, books have been published giving runners a guideline for preparation - starting with the basics and eventually achieving a level of fitness suitable for race day. Ultimately, the degree of “smoothness” of a Dynamics NAV software conversion and the final successful result is highly dependent on the “fitness level” of the key users as the go-live approaches. In both cases – running a marathon and completing a Dynamics NAV ERP implementation – the level of preparation directly affects the outcome!

One key area that is often excluded from preparation when converting to Microsoft Dynamics NAV  is the general education in standard MS Office software – in particular Excel. There are so many aspects of the project where Excel is used that a company must investigate the many low-cost and even free sources of Excel training as a requirement for key users. Continuing education classes offered at facilities easily accessible to the users are a possibility, or make use of materials found on-line. Years ago, I invested in a small MS Office training video library that was made available to the users in our office, and it was a worthwhile investment. Given the use of Excel in data migration, reporting and even testing activities during a project, it has become critical for end-users to have a solid working knowledge of Excel, and it is even necessary to have at least one user with advanced capabilities.

Implementing Dynamics NAV software in your distribution business will be greatly aided by having users that are conversant with Excel.

Topics: distribution software, Navision, Dynamics NAV, Microsoft

The Shifting Information Paradigm and The Effect On Dynamics NAV

Posted by Craig Greitzer on Sep 13, 2012 12:27:00 PM

What does the future of business computing and software look like?  So many things are changing and the pace of change is mind boggling.  Consider that Smartphones and Tablets currently outsell Desktops and Laptops.  This gap will continue to expand.  There will always be some need for larger displays and local computing power and storage but smarter, smaller devices are here to stay.  The younger generation of individuals coming out of college and into the workplace, known as "Generation Y", will only want to work with their Iphone or Android device.  It may take some time before mobile devices can serve all needed information that a person needs to do their job well but I believe it will get there.  Dynamics NAV ERP software is continually looking at the mobile revolution and bringing products to market that will address mobile needs.

Another shifting front, perhaps even more profound than mobile, is the shift to the "Cloud"  Traditional business software deployments, in use today and still being sold, follow the on-premises model.  That model worked pretty well for delivering information to the desktop.  However, the "Cloud" is challenging the on-premises model and continues to see rapid market growth.

Cloud computing deployment has many benefits:

  • Reduced initial Capital Outlay
  • Reduced management of:
    • Backups
    • Virus protection
  • Reduced risk of catastrophe due to:
    • Hardened facilities
    • Redundant power
    • Redundant internet access
    • Quicker disaster recovery

Some business owners are not comfortable having their data in the cloud.  They feel better if their data is in the room down the hall where they can see and touch it. However, owners and managers doing their due diligence will realize that their data is far safer in the Cloud than it is on-premises.

The technology for a full shift to cloud is out there.  Large and small cloud providers are building out facilities and driving down the cost per user and per GB.  The shift has started and it is undeniable and unstoppable.

We'd love to hear you feelings about this.

 

Topics: distribution software, Navision, Dynamics NAV, distribution software

Be A Truly Independent Office Products Dealer

Posted by Craig Greitzer on Aug 10, 2012 6:15:00 PM

Does your business system software allow you to be truly independent?  Can your e-commerce site feature products from any wholesaler or supplier?  OP Revelation from BMI allows you to be truly independent.  Products, from any source, can be imported and/or created and then ranked appropriately by you on your e-commerce site.

Don't tie yourself down to a single wholesaler.  Call today to find out how OP Revelation can help you be truly competitive and find out why our dealers are reporting explosive growth.

Topics: OP Revelation, Office Products Software

How Is Your E-Commerce Site Ranking

Posted by Craig Greitzer on Aug 9, 2012 5:06:00 PM

Millions of e-commerce and web pages are being created every day. If you are not actively managing your search rank, you are destined to be listed so far down on Google and Bing that no one will ever find you. There are many SEO (Search Engine Optimization) companies out there that can help you.

Start by deciding which keywords you want prospective customers to find you with. Check out what your competition is doing on their site. Do some research on your keywords and see where you rank on Google.

A little investment can go a long way in getting your site ranked higher which will ultimately result in more people knowing about you and doing business with you.

Topics: SEO, Search Engine Optimization

Dynamics NAV Software As An Investment, Not As An Expense

Posted by Craig Greitzer on Aug 9, 2012 5:01:00 PM

Too many businesses see technology as an expense and not as an investment. The truly profitable companies with efficient operations know the value of technology. Some of the primary reasons why you should invest in technology are as follows:

1) Provide a modern user experience – Customers and employees expect intuitive experiences with application software that is both easy to use and interactive.

2) Improve productivity and collaboration – Have a single point of data entry that provides access to any authorized individual or group requiring use of that data.

3) Leverage business processes and applications – Today’s software allows integration of users, content and business processes in unprecedented ways.

4) Enhance customer and supplier relationships – Reduce clerical interaction, have a more efficient supply chain and increase customer satisfaction.

5) Increase business visibility and responsiveness – Make it easier for new customers to find you and be more responsive to their inquiries and needs.

Every one of the points above represent ways profits are gained or lost With solutions from Microsoft Dynamics NAV and others, professionally implemented by BMI, there is no reason to be letting old technology drag down your business.

Topics: distribution software, Navision, Dynamics NAV