BMI Microsoft Dynamics NAV Blog

Amy Valenzano

Recent Posts

Navision / Dynamics NAV - Cannot View Data In Balance by Dimension

Posted by Amy Valenzano on Mar 19, 2014 12:00:00 PM

I've had a few support calls from clients where their Navision executables have just been upgraded and now the Balance by Dimension form does not show any data.  The entire form is uneditable. 

This is a fairly common issue when the Navision executables are upgraded to NAV 2009 or higher. 

The code in form 408-G/L Balance by Dimension needs to be modified to the following (bold is the fix)

DimCodeToOption(DimCode :
Code[20]) : Integer

CASE DimCode OF

  '' :

    EXIT(-1);

  UPPERCASE(GLAcc.TABLECAPTION) :

    EXIT(0);

  UPPERCASE(Text001) :

    EXIT(1);

  UPPERCASE(BusUnit.TABLECAPTION) :

    EXIT(2);

  UPPERCASE(GLSetup."Global Dimension 1 Code") :

    EXIT(3);

  UPPERCASE(GLSetup."Global Dimension 2 Code") :

    EXIT(4);

  ELSE

    EXIT(-1);

END;

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

Dynamics NAV / Navision / MS Dynamics Data Entry Tips

Posted by Amy Valenzano on Mar 4, 2014 5:44:00 PM

Data entry can be time consuming work.  Navision allows some shortcut data entry keys that can speed up the data entry process.    

       Date Entry

  • type t to enter today's date in a date field.
  • type mon (or equivalent) to populate the date field with the day of the week
  • type y to enter the date range of the year when entering a date filter
  • set the Work Date in Nav by clicking Tools, Work Date and entering the date you wish to use.  Now siply enter w to populate the date field with that date.

       Other shortcut keys

  • F8 will copy the data into one cell with the data in the cell above
  • Crtl+F8 will open the Zoom window and show each field in that table and the value for the record you are working on
  • Shift+F8 will open the Sort window which will allow you to resort the data you are working on
  • Ctrl + W allows you to automatically send the data you are viewing on the Navision screen to Microsoft Word
  • Ctrl + E allows you to automatically send the data you are viewing on the Navision screen to Microsoft Excel

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

Opening Microsoft Dynamics NAV / Navision Reports in Excel

Posted by Amy Valenzano on Feb 6, 2014 5:12:00 PM

 

Navision

Many times I have wished there was an option to print a Dynamics NAV / Navision report to Excel but there are only a select few reports that come out of the box with this capability.  I have, in the past, saved the report as HTML then opened that in Excel.  This does work, to some extent, but often requires quite a bit of time consuming re-formatting and clean up. 

I’m excited to say that we have become aware of a better option to pull a Dynamics NAV / Navision report into Excel.  Save the report out of Navision as an HTML file and then open that in Excel as previously stated.  From this point, save this file as a .csv (comma delimited) file.  Open the newly saved .csv file in Excel and you will get the data in a much more manageable format with a lot less cleanup and re-formatting required.

Give this a try and let us know how you make out.

 

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

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, Microsoft, Microsoft Dynamics NAV 2013, Dynamics NAV 2013, 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, Microsoft, Microsoft Dynamics NAV 2013, Dynamics NAV 2013