Tuesday, November 25, 2014

Dynamics NAV - How to import New company Opening Balances

On each account card that you want to update directly, enable the "Direct Posting" tickbox on the account card. This allows direct posting to the account without a subledger transaction.

For AR and AP balances, setup the initial posting groups to debit and credit the same accounts so there is a net 0 movement on the account. The actual balances can then be entered as journals if you tick the "Direct Posting" for those accounts

  • Create a General Journal Batch for OPENAR
  • Set the Bal type to "account", and the Bal Account No. to your Ar account number
  • This will cause the ar entries to cancel themselves out in the gl, and then you can enter your gl balances separately.
  • Configure the General Journal Screen to the format of your data
  • Copy and paste your entries as rows



For Bank and Inventory Balances
http://www.dynamicsnavconsultant.com/tag/beginning-balance/

Solution here
http://support.microsoft.com/kb/944227

2 comments: