General Discussions

Please write your queries HERE!!!!!

MB5-858
(Managing Microsoft Dynamics Implementations Certificate)

Navision 4.0 White Papers


Here I am providing a link to download Microsoft Dynamics NAV 4.0 White papers. The technical white paper is very import to understand basic structure of the process. Link taken from mibuso.

---     Navision 4.0 White Papers (25 MB)

The following list white papers are available in above link

1. Advanced costing
2. Agility and manufacturing
3. Business Analytics
4. Business Notifications
5. Commerce Portal
6. Commerce Portal Hosting
7. Costing
8. CRM
9. InterCompany Postings
10. Item Tracking
11. Manufacturing Foundation
12. Quick Guide Manufacturing Foundation
13. Reservation & Action Messaging
14. Supply chain management
15. Supply Planning
16. System Requirements
17. The New Navigation Pane
18. Warehouse Management System (business & technical white paper)
19. Wholesale distribution
20. XBRL Specifications
21. XBRL

--Happy Reading

No. of Sessions Connected to the server


Sometimes we will get a message from the server states that your license will not permit more users. It means that Users are trying to connect the server more that license defined.


The following way you can see the total no. of users connected.


Go to File -> Database -> Information

Click Current Session drill down button then you can see who are connected to server and also you can find the Idle time against each user. 

-- Happy Reading

Password Change:

Please look into the procedure to change password from existing to new or for the first time.
First login to your database and choose company from the selection.

Click Tools -> Security ->Password

By Typing Old Password, New Password, Re-enter New Password then Click Ok.

After that re login the database again with new password


-- Happy Reading

Costing Accounts


When we post purchase and sale transactions the cost of an article/Item, the costing effect will go to various accounts in G/L if "Expected Cost Posting" & "Automatic Cost Posting" is true in inventory setup.


The following procedure will illustrate you which account system will pick for what transaction.


PURCHASE:
GRN/MIR (Goods Receipt Note/ Material Inward Receipt)
    Invt. Accrual Acc. (Interim) - Cr
    Inventory Interim - Dr

Invoice (Purchase Invoice)
    Invt. Accrual Acc. (Interim) - Dr
    Inventory Interim - Cr
    Direct Cost Applied - Cr
    Stock A/C- Dr

(Note: If you use the option "Receive and Invoice" then Expected costing 
          accounts will not effect)

SALES:

DC/SHIP (Delivery Note)

    Cost of Goods Sold (Interim) - Dr

    Inventory Interim - Cr

Invoice (Sales Invoice)

    Cost of Goods Sold (Interim) - Cr

    Inventory Interim - Dr
    Cost of Good Sold - Dr
    Stock A/C- Cr

(Note: If you use the option "Ship and Invoice" then Expected costing 
          accounts will not effect)

--Do revert me for queries

--Happy reading

G/L Account Where - Used List?


Sometimes the transactions are posting to wrong accounts that we cannot identify from where system is picking up that account or where we tagged?

MS Navision has function called "Where-Used List". This function will show where the selected G/L account has been used.


Chart of Accounts -->Account (Menu) --> Where-Used List


See the following e.g :
I want see where my "Sales, Retail - Dom." has been used. See the following. I have selected G/L account then applied where - used list button

Output is :

Creates Line No. automatically for new record

Navision can automatically assign Line No. to a new record if the Line No. is part of the primary key fields. This can be done by setting the AutoSplitKey property in the Form to Yes. By default the AutoSplitKey property is set to No.

Let's consider the following example. When I enter a new sales line record in Sales Order form, Navision will automatically assign Line No. = 10000 to the first Sales Line record. Now, if I enter the 2nd Sales Line record, Navision will automatically assign Line No. = 20000 to the new record. If I insert a new record between the 1st and 2nd record, Navision will automatically assign Line No. = 15000 to the new record.

All this can happen because Autosplitkey property in Form 46 - Sales Line is set to Yes. In order for AutoSplitKey feature to work, the last field in the primary key must be an integer, BigInteger, GUIDor decimal field. If you look at the Sale Line table, the Primary key is 'Document Type,Document No.,Line No.', where Line No. is an integer field.

(Post taken from Navision-girl.com)

Gen. Posting Type must be Specified when posting journal entries.


When you try to post a journal entry to selected G/L Account, the following error message prompt up:

Gen. Posting Type must be specified.

This problem occurs because you have specified Gen. Prod. Posting Group for the G/L Account selected. To solve this problem, you can either:

1) Remove the Gen. Product Posting Group from the journal lines

OR

2) Remove the Gen. Product Posting Group from the G/L Account Card and then reselect the G/L Account in Journal lines.

NAV Tech Days 2011

http://www.mibuso.com/downloads.asp?category=navtechdays2011