FA MANAGEMENT IN NAVISION ERP

HOW TO SETUP A FIXED ASSET

 

1)      Fixed Assets Card

2)      Fixed Assets Posting Group

3)      Depreciation Books

4)      Fixed Assets Journals

 

 

 

In first we have to go Fixed Assets Setup page under finance management->fixed asset->setups->Fa Setup

 

The page has two Tabs:

•   General
•   Numbering

 

Fixed Assets Posting Groups

 

 The Fixed Assets Posting Groups is set up in the FA Posting Group page under finance management ->setup->posting group->fixed asset.

·         posting of purchase orders, invoices or credit memos

·         posting of fixed asset transactions using journals

·         posting journals with the help of the Calculate Depreciation batch job

·         posting journals with the help of the Index Fixed Assets

 

 

 

 

 

 

 

Code: - Here you have to enter a fixed asset posting group code. Each posting group, you set up a code and various account numbers. Then you enter the code in the FA Posting.

The code must be unique - you cannot have the same code twice in one table. You can set up as many posting groups as you like.

 

 

The acquisition cost:-

The total cost for a firm to buy an asset. The acquisition cost includes all legal fees, closing costs, or other increases. Likewise, it makes allowances for discounts.
  
Accum. Depreciation Account:-

This account hits when you post depreciation for fixed assets in this posting group.

Depreciation Expense Acc.:-
 
This account can be inserted automatically by the program when you use the(Expense Acc).
 
1- Calculate Depreciation batch job.
2- Copy Depreciation Book batch job.
3- Insert FA Bal. Account function from the fixed asset G/L journal.

Depreciations Book:- Go to depreciation books-> under setup-> under financial management.
The depreciations books must be set up on the Depreciation Book Card.
To open the Depreciation Book Card, in the Navigation Pane, click Departments, click Administration, click Application Setup, click Financial Management, click Fixed Assets, and then select Depreciation Books.
 

DEPRECIATION BOOK CARD:-

 

Microsoft Dynamics NAV 2009 allows for multiple depreciation books and to set up to additional books on the card.

After the Depreciation Book is set up, one or more depreciation books are attached to an asset, to define how depreciation will be handled for the assets.

 
The General Tab contains the basic setup fields for the depreciations books:-
 
Defaults Final Rounding Amount - makes sure that the fixed asset is fully depreciated over the depreciable lifetime.
 

Default Ending Book Value - prevents the asset from being fully depreciated.

Disposal Calculation Method - specifies Net or Gross as the method.

Subtract Disc. In Purch. Inv. - displays the line and invoice discount that will post to the account contained in the field Purch. FA Disc. Account in the General Posting Setup window.

Allow Changes in Depr. - indicates that the depreciation fields in the FA Depreciation Books are changeable after you have posted entries.

Allow Depr. Below Zero - indicates that the system will continue calculating periodic depreciation when the Calculate Depreciation batch job continues, even if the book value of the fixed asset is zero or negative.

Allow Correction of Disposal - corrects fixed ledger entries of the type Disposal.

Allow Indexation - adjusts the asset values for general price-level changes. Use this option to calculate the value of fixed assets at replacement costs. Do not finish indexation with FA ledger entries that are posted to the general ledger.

Use FA Ledger Check - requires a confirmation that:

1-  Acquisition cost is the first cost booked as a debit and that the disposal cost is the last cost booked.

2-  Depreciable basis has a debit balance, and that the book value is a debit.

3-  Accumulated depreciation, salvage value, and accumulated sales price are all credit balances.

 

 

Use Rounding in Periodic Depr. - indicates that the system will round depreciations to whole numbers.

Use Same FA and G/L Posting Dates - indicates that both dates must differ if these options are cleared. Enter both dates separately.

Allow more than 360 Depr. - Gives the possibility for the fiscal year to consist of more than 360 depreciations days.

 

Integration Tab:
 
The Integration Tab specifies entries to integrate with the general ledger. Enter only one depreciation book to the general ledger so that it does not post two times.

 

 

 

If a company wants to the general ledger integration, use the FA G/L Journal to record the information. If a company does not want to use the general ledger integration, use the FA Journal.

 

Duplication Tab

 

Use the Duplication Tab to indicate duplicate entries in other depreciation books. Duplication is useful when a company use multiple depreciation books. When duplication is set up, Microsoft Dynamics NAV 2009 creates the same entries for all the books. This reduces data entry time.

 

The Duplication Tab contains the following fields.

 

1-Part of Duplication List - indicates that the depreciation book will be a part of the duplication list.

2-Use FA Exch. Rate in Duple - indicates whether to use exchange rates when you duplicate entries from one journal to another.

Defaults Exchange Rate - specifies the default exchange rate.

 

 

FA Journal Setup:

The FA Journal Setup page specifies the default setup of templates and batches that the Microsoft Dynamics NAV 2009 uses to duplicates lines from one journal to another, when the Calculate Depreciation batch jobs create journal lines, or when acquisition costs duplicate in the Insurance Journal.

FA Journals Templates:

There are four journal templates for Fixed Assets:

 

•   FA G/L JournaL

•   FA Journal

•   FA Reclass. Journal

•   Insurance Journal

To open the FA Journals Templates, select Departments, click Administration, click Application Setup, click Financial Management, click Fixed Assets, and then select FA Journal Templates.

 

 

 To be contin....

ACCOUNT SCHDULING

Microsoft Dynamics NAV account schedules can be a powerful tool used to create custom financial statements and analysis reports directly from your general ledger. how to build multiple row and column layouts, how to create dynamic reports , how to incorporate budgets into your schedules, and how to leverage the power of integration to Excel to make your reports even more flexible.

 
Fields to start:-

 Column No. – The column number is completely optional, but highly recommended. This simple element of the column layout will eventually be one of the key features of your account schedule, allowing you to calculate and organize with ease.

Column Header – This is where you’ll define, in words, what you’re showing in each column of your report. Keep it short; there is a 30 character limit.

Column Type: Net Change, Balance at Date, or Formula – There are actually seven options to choose from here, but I recommend that you limit yourself to these three when you’re just getting started. The key here knows what type of accounts you’re reporting on. If you’re using income statement accounts (Revenue/Expense), then you need to use net change. If you’re using balance sheet accounts (Assets/Liabilities), then you need to use Balance at Date. Formula allows you to perform calculations in a column.

Ledger Entry Type :– This column will allow you to define what type of ledger entries you will show. This is where you can choose actual general ledger entries or budgeted general ledger entries.

Formula – If you’ve chosen Formula as the Column Type, this is where you’ll put the formula.

Comparison Period Formula – This column allows you to define date formulas that are used to calculate the amounts shown. I generally recommend that beginning account schedule users start out using the comparison period formula field instead of the comparison date formula field. The comparison period formula field references the accounting periods set up in the fiscal year, so this option seems the most consistent, and is especially necessary for companies that may not follow a calendar fiscal year. Common data labels used in this field are CP for current period or -1CP for previous period and FY for fiscal year or -1FY for prior year.

Shown below are both the design view and the user view of a column layout for a summarized income statement showing year to date and prior year to date information in the columns to demonstrate the use of these six basic options in an account schedule.

Please continue give comment.

 Regards

 vimal

Manufacturing Module Under Navision-2009 r2

HOW TO CREATE A PRODUCTION ORDER

STEP 1:- IN GENERAL TAB, FIELDS ARE

1-  GO TO MANUFACTURING MODULE.

2-  SELECT EXECUTION -----> RELEASED PROD ORDER

3-  SELECT GENERAL TAB LOCATED IN THE NA VISION PANE.

4-  PRESS F3 TO CREATE A NEW PRODUCTION ORDER.

 

     NO. :-

·    Here you can enter the ORDER number. You can use one of the following   methods:

·    If you have set up a default  number series, press Enter to have the program fill in    this field with the next number in the series.

·    You can also manually enter a unique ORDER number.

      SOURCE TYPE :-

·       Here you can select the VENDOR from arrows down option, which contains the list of   VENDORS. From whom we usually buy items.

      SOURCE NUMBER:-

·         Once you have selected the VENDOR number from list, all the relevant fields automatically took the vendor information from VENDOR CARD.

      QUANTITY:-

·          IN THE FIELD, YOU ENTERS THE POSTAL/COUNTRY/STATE CODES OF VENDOR.

·         SELECT IT FROM ARROW BUTTON.

·         THESE FIELDS ARE PARTICULARLY HELPFUL IN GENERATING THE VARIOUS TAX   INFORMATION ON  THE BASIS OF GEOGRAPHICAL AREA.

STEP 2:- IN SCHEDULE TAB, FIELDS ARE

 

      START TIME AND DATE:-

·         Here you can select the Starting time and date for starting the production of that item.

      ENDING DATE AND TIME:-

      Here you can select the Starting time and date for ENDING the production of that item.

STEP 3:- IN POSTING TAB, FIELDS ARE

 

   INVENTORY POSTING GROUP :-

·    Here you can enter the inventory posting group so that the WORK IN PROGRESS  is assigned to the correct G/L account.

·    If the source type is item, the program will copy the inventory posting group from the item card

     GEN PRODUCT POSTING GROUP:-

·    Here you can enter a product posting group to which manufactured items in this production order belong.

·    When you post transactions for this item, this code is used in combination with a posting group code of the posting window. In the posting  window the VAT rate, the VAT calculation type and the accounts in which the postings are made are determined

      GEN BUSINESS POSTING GROUP:-

·     Here you can define a business posting group. The business groups can be set up to group customers and vendors by geographical area (Domestic, EU countries/regions, Overseas, and so on) or type of business.

PROCESSING/REALISING A PRODUCTION ORDER:-

1-  CLICK ON FUNCTION BUTTON BELOW.

2-  SELECT REFRESH.

 

 

1-  A NEW WINDOW APPEARS(AS SHOWN BELOW)

 

1-  SELECT THE STATUS AS RELEASED FROM ARROW DOWN BUTTON.

2-  SELECT THE NO. (Production order no.)  From drop down menu.

3-  CHANGE THE TAB TO OPTION

4-  Make the SCHEDULE DIRECTION FORWARD (AS SHOWN BELOW)

  

T 1-THE PRODUCTION ORDER AUTOMATICALLY COPIES IN THE PRODUCTION ORDER LINE.

11-  IN PRODUCTION ORDER LINE SEE AT FIELDS LIKE QUANTITY , REMAINING ,FINISHED, DATE.

HOW TO CONSUME THE ITEM RAW MATERIAL THAT IS ON PRODUCTION ORDER

1-  GO TO MANUFACTURING MODULE.

2-  SELECT EXECUTION -----> CONSUMPTION JOURNALS

3-  A new window appear which looks like as below

 

*  PRESS Function ----- >CALC.CONSUMTION

* A new window appears which looks like

  

1-  In PROD. ORDER tab enter the PRODUCTION ORDER NO. That you want to consume

2-  In OPTIONS tab enters the details like

*       POSTING DATE

*      Select PICKING LOCATION from arrow down

 

Ø  After filling up the detail press OK.

Ø  Now the initial consumption sheet pick the BOM against that material order NO. and it will look like.

 

Ø  CLICK on POSTING.

Ø  POST the ORDER.

Ø  NOW YOU CAN CHECK THE PRODUCTION OF THAT MATERIAL/ITEM IN RELEASED PROD. ORDER AGAINST THAT ORDER NO.  OR YOU CAN MANUALLY CHECK THE INVENTORY AGAINST THAT ITEM.

 

HOW TO CREATE A PRODUCTION ORDER FROM SALE ORDER:-

STEP 1:- IN GENRAL TAB, FIELDS ARE

1-GO TO MANUFACTURING MODULE.

2-  SELECT EXECUTION -----> RELEASED PROD ORDER

3-  SELECT GENRAL TAB LOCATED IN THE NAVISION PANE.

      4-PRESS F3 TO CREATE A NEW PRODUCTION ORDER.

 

 

  NO. :-

1 Here you can enter the ORDER number. You can use one of the following methods:

2 If you have set up a default  number series, press Enter to have the program fill in this field with the next number in the series.

3 You can also manually enter a unique ORDER number.

 SOURCE TYPE :-

·Here you can select the Sale Header from arrows down option, which contains the list of Sale order (previously created sale order). Where we want sell.

SOURCE NUMBER:-

Once you have selected the sale header as a source type from list all the relevant fields automatically took the sale order information.

Once you have selected the sale order as a source number from list all the relevant fields automatically took.