Nav Purchase Transaction Impact on Chart of Account

Purchase Cycle :

When a Item is purchased in MS Dynamics NAV using purchase order and purchase invoice some accounts are credited and other accounts are debited. So for functional side we must know what is the major impact. Let's see the impact in detail.

Step 1. Create an Item.

Choose any of the default Item Template to complete the Item Setup.

Step 2. Create Purchase Quote and click on Create Order.

Once this is done your quote will be converted to Order and we are receiving the order and now we will check what is the impact of receiving on accounting level.

+ in NAV means Debit and - means Credit for accounting purpose only.

For Inventory concept of sign is same.

Step 3 : When we receive a PO there is no impact on Accounting Side.

Step 4 : Lets post the Receipt using purchase Invoice Page.

When we post the invoice we get this final result.

In this final result we will check the COA in GL Entry which Account is debited and which account is credited.

1.G/L Entry :

Vendor Account Credited by 750

and

Purch. Payable Account is debited by 600 and VAT 150

What is the impact of payment for vendor invoice on G/L Account?

Now, vendor account is debited 

5410 is debited by 750

&

5310 Liability Account is credited by 750.

Top 10 Points While Setting Up New Company in MS Dynamics NAV

1. Define No. Series

You have to decide which No. Series You are going to use and record for future discussion with 

client. These No. Series are defined under :-

1. Sales & Receivables Setup.

2. Purchase & Payables Setup.

2. Decide about Payment Tolerance?

This implies whether an invoice is settled at less amount than actual means 1059.00 $ can be settled at 1050.00 $ so ask from your client.

3. What are the major setups needed to start the transaction?

1. GL SETUP

2. Sales & Receivables SETUP

3. Purchase & Payables Setup.

4. Inventory Setup.

5. VAT and TAX SETUP as per your localisation.

4. Document Exchange Service & XBRL 

If data exchange is required from MS Dynamics NAV Financial Management PEPPOL Format

Extensible Business Reporting Layout required by system.

5. Types Of Costing Method

For inventory decision FIFO LIFO Average Specific or Standard.

FIFO :- Inventory Valuation will be based on cost last received 

LIFO:-  Inventory Valuation will be based on cost First received

AVERAGE:- Inventory Valuation will be based on average of all.

SPECIFIC:- Inventory Valuation will be based on serial No. of Items and Inv. Val. will be based on exact units in stock.

STANDARD :- Inventory Valuation will be based on FIFO but the only difference is that the incoming cost which are based on an estimated cost that you set up on an ITEM. It is mainly used with Manufacturing.

6. How will you close the company?

Will there be any subsidiary coming in the company decide the designing of COA accordingly.

7. Decide about the Posting Groups?

Specific , General and Tax Posting Group present in MS Dynamics NAV.

1. Customer Posting Group 

2. Vendor Posting Group

3. Inventory Posting Group

4. Bank Account Posting Group

5. Job Posting Group

6. Fixed Asset Posting Group

7. Gen. Business Posting group

8. Gen. Product Posting Group

9. VAT Posting Setup / Tax Setup.

8. How will you do Payment Reconciliation ?

Will there be any data exchange framework requirement for details you may check Table series 1200.

So these are few major points which a Functional consultant must be aware before delivering the project to client.

30 Things you should know about Microsoft Dynamics NAV

Hi ,

This post is related to upgradation of our skills as MS Dynamics NAV Developer if you are junior ,

Senior , Fresher or manager in an organisation. Below is list of 30 most well upgraded Links which

we all should know , if we are working in MS Dynamics NAV as Technical or Functional

Consultants.

No One is Perfect , But practice can make anyone PERFECT.

So visit and subscribe these links to upgrade yourself as much as possible.

1. https://mbs.microsoft.com/partnersource

2. https://explore.dynamics.com/

3. How many types of Discounts you can provide to your customer in Navision?

    We can provide 3 types of discounts in NAV:-

     Line Discount , Invoice Discount , Payment Term Discount.

4. When Last Direct Cost is updated?

 
     Last direct cost is updated when a purchase invoice is posted in the system and this price is

     appearing in Lines of document.

5. Summarize the WorkFlow Process in Navision?

    Setups required for the workflow configuration in NAV 2016 onwards:

    Setting up approval users (including setting up a user in Windows and in Microsoft Dynamics            
    NAV).

    Create a user in active directory

    Create a user in NAV and link with Windows directory
   
    Set up Approval

    Set up a workflow user group

    Setting up notifications for approval users:

    Create a notification schedule

    Create a notification setup

    Modifying and enabling an approval workflow:

    View the workflow template

    Create a new workflow

    Starting the job queue that dispatches notifications: (if required by client customization)
    Job queue setup
   
    Requesting approval of a purchase order, as user A:
   
    Create purchase order, after login from user A
    Send the request to approve
    Receiving a notification and then approving the request, as user B:
    Login from user B and approve the purchase order.

6. What are the types of Journal Entries in Nav?

   General Journal , Standard Journal , Recurring Journal , Reversing Journal.

7. Why document date is used or use of posting date and document date?

   Document date is used for all major calculation in system like Payment Terms and Methods while 

   Posting Date is date when it is posted in the system or document last date to change.

8. What is the use of OnHold Field in CLE is used for?

   To specify a code for user to hold the payment means if user wants to stop some payment due 

   to settlement then it is used.

9. How to process prepayment in Navision?

  I will not disscuss here whole process you can check on MSDN. I am just providing summarised 

  step to setup.

  1. General Ledger Setup Field Check Prepayment VAT.

  2. Sales & Receivables Setup Prepayment Calc.

  3. Gen. Product Posting Grp. Define Accounts.

  4. Sales & Receivables Setup. & Setup No. Series For Prepayment.

10. Diffrence between Cash Receipt Journal and Payment Journal?

 Main Difference is you can use check Functionlity with PAyment Journal which is not available 

with cash receipt Journal.

11. What is the use of Remaining Amt. on CLE and Open Field?

Original Amount and Remaining Amount columns on CLE & VLE. If the Remaining Amount column is zero, the full payment has been received.

if the checkbox is not selected in the Open column, the invoice is fully settled.

12. What is Payment Registration Functionality in NAV?

This functionality of MS Dynamics NAV provides you to check all the payments that needs to be 

received or paid. You can also post the payment directly from here. Pth is as below in Cronus

CRONUS International Ltd./Departments/Financial Management/Cash Management

13. What is Data Exchange Framework in NAV?

This framework is basically designed for payment and bank reconciliation in MS Dynamics NAV.

You can look at table and codeunit in 1200 series and can use the functionality to import any type of 

data format in the navision.

How Purchase of an item Impacts our Navision and its ledgers?

This is regular impact of MS Dynamics NAV in Cronus Database provided by Microsoft.

SO to summarise the whole scenario let me give a brief.

To purchase an Item you can do a Purchase Order or Purchase Invoice. Many a times we create a 

Quote to send our Vendors.

Quote as such has no impact on ledgers.

If you make a receipt of Order it will update your

ILE and Posted Receipt is created for the same Order.

If you post the invoice for the same order or directly creating the invoice of an Item then it will,

update your all ledgers as follows

Vendor Ledger Entry

Detailed Vendor Ledger Entry

G/L Entry

Value Entry

Tax Entry / Vat Entry if applicable.

IF Reservation is applicable you will get separate Lines of Items in ILE else all will be summarized.

Seven Questions To Ask At Functions Used In Nav.

Hi All,

This post is all about functions which are available in MS Dynamics NAV for Technical customisations.

So the First we have present is :-

1. STRSUBSTNO

Syntax :-

NewString := STRSUBSTNO(String [, Value1] ,...) 

It replaces all the %1 , %2 used in message.

Example:- 

STRSUBSTNO('Your balance is %1',Customer.Balance);

2.STRPOS

Syntax:-

Position := STRPOS(String, SubString)

It provides you the position of the string.

Example:-

Position := STRPOS('Navision','v');

3.STRLEN

Syntax-

Length := STRLEN(String);

It provides the length of the string .

Example :

Length := STRLEN('MSDYNAMICSNAV');

4.INCSTR

Syntax:-

NewString := INCSTR(String)

It increases the integer part in a string.

Example :

NewString := INCSTR('APU12');

Result will be APU13

5. COPYSTR

NewString := COPYSTR(String, Position[, Length])

It copies a part of string into new string.

Example :

Str := COPYSTR('Apurwa', 1, 3);    

6. MAXSTRLEN

MaxLen := MAXSTRLEN(String);

It returns the maximum String Length of the Variable.

Similarly, we have STRLEN to return the Actual String Length of a variable.

7. PADSTR

Str := PADSTR('MS DYNAMICS NAV', 50, 'd'); 

It can be used to select a part of a string on behalf of length and add a string if we want in a part.

8. DELCHR

NewString := DELCHR(String [, Where] [, Which])

To delete a particular character from a string.

You can use where as =,>,<,<>,AND,NOT

9.CONVERTSTR

Str := CONVERTSTR('MS DYnamics Nav', 'D', 'L');

It converts some string to another if present in the orignal string.

10. UPPERCASE & LOWERCASE

It converts a string in Lower and uppercase of orignal string.

11. SELECTSTR 

It retrieves the part of comma separated in a string.

Str := SELECTSTR(2, 'MS ,DYNAMICS ,NAV');

12. DELSTR & INSSTR

It deletes and inserts a part of string in orignal String.

Str := DELSTR('MS DYNAMICS NAV', 3, 8);

Str := INSSTR('MS DYNAMICS NAV', 'Anand', 8);

Thanks for giving your time to read this blog. Please do comment if you want more such post.

these are the system functions provided in MS Dynamics NAV.

How to insert a new Logo in new company using MS Dynamics NAV?

Logo Implementation in NAV 2017

Requirement
New Logo to be inserted in Company Information Table.

Steps :-
We need to delete the Cronus Logo from Company Information Page. To do this Search Company Information in RTC Search Bar. 

Right Click on the by default Cronus Image & delete the picture. Again Right Click and Select Picture. New logo will ready to print in all Reports.

What is System Indicator in NAV 2017 ?

System Indicator in NAV

Defination :

System Indicator is a Field in NAV Company Information Table 79 which can be used for showing any Text in RTC Client as Shown in below screenshot.








I hope you can use it for indication on your Test or Live RTC to remember on which client you are working.

How to implement images in MS Dynamics NAV 2017?

Image for Customers and Vendors

With NAV 2017 , you can have your Customer and Vendor imges attached on thier card also you can see in NAV Web Client how attractive the feature is implemented.

To implement the same NAV has created 2 new tables Customer Picture and Vendor Picture with the use of Addin in NAV. To implement the same you to check the actions and define the pagelink as defined in NAV Demo.

So Let's Enjoy the meal. And have nice development ahead with your partners.

Whats new in G/L Accounts of NAV 2017?

 NAV 2017 

We can adjust our chart of accounts according to differents Categories in Navision. And these categories may be further divede into another different Categories.

2 other new tabs are also defined for Consolidation and Cost Accounting , these new tabs are basically defined to consolidate te Debit and Credit account of this particular GL Account.

In The Page also we have new functionality as follows.

To get most updated news about navision kindly visit this blog regularly and subscribe by Email below so we can reach you everyday.

What is Sales Price and Purchase Price in Navision?

Sales Price & Purchase Price 

These are the price which we can define for a particular item. It can be used and categorised on different basis. We can also define prices for different Dates in a month.

How to define it :- 

We can use these prices in normal indian business scenarios where we want to give some discounts to specific Customers and Vendors as per the requirement.

To define the special prices GOTO Item and search for special prices at home and navigate ribbon.

Advantage:-

In the Sales Price we can define the Direct unit cost of items according to specific customers.

We can also create different customers and accordingly we can define the Sales Price for the items.

We Can also define Price for all Customers. 

The same can be used for Vendors but here we can only define to buy from a particular vendor.

Error while defining Sales & Purchase Price :-

Now , after defining the prices in Sales Price and Purchase Price the issue arises why the sales price is defined correctly instead the system picks up the Last Direct according to the Method defined for stock. For fast solution please check these points.

1. Quantity Field must be blank for accurate transaction of Direct Unit cost in Purchase/Sales Line.

2. Currency Field must be blank or same as in sales/purchase lines.

Starting Date and Ending Date must have a value.

Please comment if still the prices are not picking correctly. or for any other customization.

Why are 2 Allow Posting Dates in G/L Setup and User Setup are present in MS Dynamics NAV ?

Two Different allow posting dates in General Ledger Setup and User Setup?

Yes one is for common users and one is for particular users.
Here the defined dates will be checked once a posting routine action is done in Navision.

But what is the priority base? Which will be selected if both are defined.

Priority will be given to User Setup first then G/L Setup.
For E.g.
In G/L Setup Dates are : 01012016..01022016
In User Setup Dates are : 01122015..31122015 for user XYZ.

Then while posting first user setup will be checked. That means if user XYZ is posting on date 29122015. Then will be able to post. Hope you understand the concept.