Hi all
I want to know how the opening entrys to GL Accounts were made in the Cronus Database. I'm using NAV4 SP3 and there are several entries refering to a Journal called G/L OPEN. I cant find the journal (probably deleted i guess) and there is no Bal. Account No. for these entries.
Thanks in advance for your help.
0
Comments
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
But my question is more of a user nature probably. How do you post you balance to a new company. Lets say you're migrating to NAV and want to post currrent values to G/L accounts. Whats the correct procedure? Can anyone give an example?
Txs in advance.
Once you have created your GL accounts, you create a GL Journal with the balance from your old system to post to the account in NAV.
How you do it may differ depending how much hictorical detail you want nav to EG Balanace at date for each moth for the last year or you could just have a 1 line entry for summed amount
You have to discuss with your partner or business leaders how they want it
Thats what i thought would happen. But where can i find a more detailed help for that(step by step guide would be great)? A user manual would be great? I have user manuals for 3.60 from Navision (the original company) and need to update to 4.0 SP3?
(is it me or Navision help system for final users is getting thinner?!?!)
8)
Yes! I do get it David ... talk to NSC they'll solve your problem...
I'm just trying to learn a little bit more about company configuring.
But txs for the help anyway.
RIS Plus, LLC
It does depend a lot on why you are doing this.
There are many different ways to post opening entries, and its not really possible to say "this is the correct way to do it". In fact the different processes really have nothing to do with Navision, they are general business issues.
Also the opening entries in Cronus were a bit hap-hazard, they were the results of three or four different companies attempts all merged, so not an ideal thing to copy. That's why I bumped the "contact your partner" post because really someone needs to analyze your needs and then make BUSINESS DECISIONS, not programmer like decision and it could be very dangerous to get advise from people that don't know your full company's background.
On the other hand if you are just learning for your own knowledge (which is a great thing) that's a differnt story. But lately I am seeing a lot of clients with badly damaged systems because of good advise used out of context.
To make an informed decision you need to know what is going on in the backround(and i do not mean code).
The most "suggested" way would be to use a suspense account and then balance the other accounts based on this suspense account.
I do understand that the process of doing this (and even the timing) is crucial and depends of a lot of factors (ad is to be done by a financial manager and NOT a programmer)
I'm following your approcach to learning NAV - try do get a real good grasp of everything the app does and then go to C\SIDE. I started (in your opinion - wich i agree) the wrong way - learn app specific code and started from there. That solved my immediate problem .. but not my long term problem.
Starting with Cronus and course 8384A you can learn the basis about using NAV and get a little grasp about configuring.
The tip about Cronus is very important because i found the entries to have the field System-Created Entry = Yes and was trying to determine how was that done but Journal used isnt in the company (INIC CONT?!?!).
In conclusion i'm just focused on the way this initial setting of the company state was done in Cronus.
Maybe u could dedicate a page to this in your Wiki?
oooorrr maybe if I got bored one night, I might do something like this.....
Cronus Widgets
A good consultant would never need to create Suspense account if it does not exist on the Chart of Accounts provided by the client.
ERP Consultant (not just Navision) & Navision challenger
I'm not sure how in your area accountants are defined, but from where I work, if to be classified as an accountant, they must be accredited ACCA, which I believe designing a Chart of Accounts is as easy as ABC to them. The only issue here is how to map their CoA to how Nav refers to its mandatory accounts. Creating go-live entries is the job of the consultant, providing the go-live entries or opening balances is the job of the accountant.
ERP Consultant (not just Navision) & Navision challenger
With many many NAV implementations the accountant has come froma back ground of smaller sites, Quickbooks, Sage etc. In these systems there are wizards to create the COA. They use this for 10 years, then you give them a blank piece of paper and say design the COA your business would best benefit from and understandably many struggle. Yes these are fully qualified people, but it is also experience and the personal qualities that make up a big part of what they can do. A few years ago I had a phone call from a NAV site who had employed an accountant of 10 years experience, she had worked in a large organisation and had moved to a smaller business. She had not in 10 years had anything to do with a VAT return or Intrastat, and simply did not know how to do them - this was naturally irrelevant of the system.
I am not saying every implementation is like this, there are many accountants with experience of implementations and designing COA's and in recent years the preference of these accountants is to also use a take on account at go live purely for reconciliation reasons and to spot where balances are not matching.
I have not given my personal preference, and I am not advocating an approach, just saying what I have experienced in recent years actually implementing NAV.
http://dynamicsuser.net/blogs/alexchow/ ... lance.aspx
:whistle:
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
These cases fall into the category where the accounts do not balance in the first place, where balance from one system does not equal another system & definitely need the Suspense account if accepted by the consultant as opening balances.
ERP Consultant (not just Navision) & Navision challenger
True and it is choice of client then. As i have done this sometimes as asked by the client. That is why in this post http://www.mibuso.com/forum/viewtopic.php?f=23&t=33369
i said , it depends and i got the reply that
So i thought better to move out of topic as it is all about what we have seen during the implementations, may be we haven't seen any other option as well if it exists.
can i know how many ways i can update the opening balances .
Because
posting.php?mode=quote&f=23&p=169939
please throw some use ful information .