Navision Roadmap 2008-2017

Difference Between Requisition and Planning Worksheet

Requisition worksheet will come with basic license ... thus, it provides basic functionality. In the other hand, if you require more complex planning functionality, you should buy planning worksheet. And, what are these differences between Requisition and Planning Worksheets in terms of functionality? Lets find out this:

Requisition Worksheet:

•  It is included in the Business Essentials
•  It is intended for replenishment of Purchase and/or Transfer orders
•  It allows to run Regenerative Plan
•  It sets Pegging info
•  It is MRP focused

Planning Worksheet:

•  It also allows replenishment of Production Orders
•  It allows to run Regenerative Plan
•  It sets Pegging info
•  It is MRP and MPS focused (Material Requisition & Master Production Schedule)
•  It provides Planning warnings
•  It is prepare for Net Change planning
•  It has a Error Log
•  And, it can interact with Requisition Worksheet by creating entries

But before doing MRP or MPS, Please check the Item card planning parameters and Prodcution forecast entries.

--Happy Reading

See the following Important Links

1. COGS Setup?

      How to Setup COGS - CPA Way? (By Alex Chow )

2.   What Objects Can you read from your license?

      Objects Availabity With Your License (By Luc Van Dyck )

    

-- Happy Reading

Description not posting to ILE & VE from Purcahse Order

Q:  My Client has informed me that when ever he posting Purchase order with Items then the Item description is not posting to "Item Ledger Entry" and "Value Entry".

A:  We had customized the following way in Code Unit 22 "Item Jnl.-Post Line"
      
       InsertItemLedgEntry(): Written the below code before insert
          
        IF RecItem.GET(ItemLedgEntry."Item No.") THEN
             ItemLedgEntry.Description:=RecItem.Description;

       InsertValueEntry(): Written the below code before insert

      IF RecItem.GET(ValueEntry."Item No.") THEN
            ValueEntry.Description:=RecItem.Description;

   That's It. My client is happy :)



--Happy Reading

C/SIDE Solution Development

C/SIDE Introduction

Inconsistency Error at PO in NAV 5.0 SP1

There was an interesting query at one of my client in india. Consider the following:

Query: When user is Posting  Purchase order in NAV 5.0 SP1 and he is getting "Inconsistency Error". And User confirmed me that the error is coming only in the case of Partial Receipt.

Resolution: When I go into the detail analysis I couldn't find anything. All values are extremely correct then I used Single Instance Codeunit, there I come to know what exactly happening in the system.

In the case of Partial Receipt the all my Debit values are going as per the Partial Receipt but the problem is in my Credit value. System is not ignoring tax values of non receipt. These values are adding into my vendor Credit balance.

Then, for time being I suggested the User to post the invoice without "Excise Prod.Posting Grp" and "Tax Group Code" of non receipt Items. Because if Codes are not there then tax of those items will be zero.

Later, we rectified this issue in NAV 5.0 SP1

Readers, If you get same error apply above logic and check once.

--Happy Reading

 

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