Thursday, July 23, 2015

Number Series

Number Series


The No. Series window is used to set up all the number series that is used for the company. Number series can be assigned to certain tables (such as the Customer, Vendor and Item tables), sales and purchase documents (such as quotes, shipments and posted invoices), and journal templates and batches.
You can set up a complete numbering system consisting of an unlimited number of number series for all types of basic information (except G/L accounts) and documents. You can combine this with manual numbering for specific areas or you can use manual numbering entirely.
The document numbering functionality provides a flexible way of numbering all documents, journals, batches and journal lines. Documents include, but are not limited to orders, invoices, shipments and credit memos.
In the setup table for each application area and in the journal templates, you specify which No. Series will be used for which purpose. For example, if you have set up a No. Series for customers, you would enter the code for this No. Series in the Customer Nos. field in the Sales & Receivables Setup table. Then when you create a new customer, the program will use the information associated with the code to assign the customer number.
In the No. Series window, you set up codes for each type of document.

To open the No. Series window, select Financial Management / Administration / No. Series.


First, enter a code that is meaningful or relevant for your business, and then give the code a description. The program fills in the Starting No. field and Ending No. field with the information set up in the Number Series Line table.
The Last Date Used and Last No. Used fields are filled in automatically by the program, when start using the No. Series.
In the Default Nos. field, indicate whether or not this number series will be used to assign numbers automatically. For example, if a check mark is placed on the line for the customer number series, when you create a new customer, the program will assign the next available customer number from this number series. If a check mark is not placed in this field, then click the Assist Button in the No. field on the customer card and then choose the number series in order to have the program assign a number for you.
A check mark in the Manual Nos. field indicates that you can enter numbers manually instead of using the number series. A check mark in this field has no effect for number series used in journals.
A check mark in the Date Order field indicates that numbers from this range are to be assigned chronologically. In other words, if you place a check mark here, the program will run a test at the time of posting to make sure documents and Journal lines are assigned numbers in ascending order according to the posting date.
A number series will be associated with one or more lines in the No. Series Lines table, where you set up additional information about the number series.
In the No. Series window, select a line, and then click Navigate => Lines.


This window lets you establish the numbering you want to use (including starting dates for specific ranges of numbers) and set up additional information about the number series.

The first field is the Starting Date field. Here you can enter the date from which you would like this line to apply. You use this field if you want to start a new No. Series at the beginning of a new period. You set up a number series line for each period. The program will automatically switch to the new series on the starting date. If left blank it will take effect immediately.

In the Starting No. field and Ending No. field, you define the range of numbers you will use for that particular code. These fields are alphanumeric and have a length of 20 characters to allow flexible schemes.

The contents of the Last Date Used field and Last No. Used field are generated by the program and will display the last date a number was assigned and the last number in the series that was used. The contents of these two fields are also displayed in the No. Series window.

The Warning No. field lets you choose a number from your predefined series that will return a warning when it is used. It should be used to help you when you are nearing the end of a number series.

The Increment by No. field allows you to select the size of the interval by which you would like your numbering to increase. If you use an increment rather than consecutive numbers, this would allow the future addition of numbers in that range and in between the assigned numbers. If at a later date, you want to insert one manually, you could assign if you allow for an interval between numbers rather than making them consecutive.

The Open field indicates whether or not the number series is open. A series will remain open until the last number in it is used. At that time, the program removes the check mark from this field. This field is not editable.

Sometimes, you may want to assign more than one No. Series Code to a single No. Series field. For example, if you have more than one No. Series for inventory items, you can setup a relationship between these No. Series.

The No. Series Relationships window is used to set up relationships between multiple No. Series. When you set up relationships you must associate all of the related No. Series to one No. Series code. You can then enter this code on the Numbering tab in the setup window for the appropriate application area and you will be able to choose between all the related No. Series when assigning numbers.

In the No. Series window, in the Code field, find and select a line to which you want to set relationship.

Click Series => Relationships. The No. Series Relationships window appears.
Here you can set relationship for the No. series.

Automatic Archiving

Automatic Archiving
The program can be set up to create archive versions of sales and purchase documents automatically.
For sales documents, set up automatic archiving in the Sales Receivable Setup window, which can be accessed by clicking Departments > Sales & Marketing > Administration > Sales & Receivables Setup.
Select the Archive Quotes and Orders check box for the program to save a copy of a sales quote that is being converted into an order and a sales order that is being posted.
As you have archive versions of a sales quote, you can roll it back to any of archived copies.

NOTE: For purchase documents, the program can also be set up to create archive versions automatically. For that, select the Archive Quotes and Orders check box in the Purchases & Payables Setup window.
You can view the list of document archives in history.

Best Implementation Practices
Document Archive functionality can be used, if you require to maintain Amendments in Sales and Purchase Orders.

Wednesday, July 22, 2015

What happens when a report runs

When a Report Runs,
When you initiate the report run, the OnInitReport trigger is called. This trigger performs any processing that is necessary before the report is run. It can also stop the report. If the OnInitReport does not end the processing of the report, the request form for the report is run, if it is defined. Here, you select the options that you want for this report. You can also decide to cancel the report run. If you decide to continue, the OnPreReport trigger is called. At this point, no data has yet been processed. When the OnPreReport trigger has been executed, the first data item is processed provided that the processing of the report was not ended in the OnPreReport trigger.
When the first data item has been processed, the next data item, if there is any, is processed in the same way. When there are no more data items, the OnPostReport trigger is called to do any necessary post processing, for example, removing temporary files.
How a Data Item is Processed
Before the first record is retrieved, the OnPreDataItem trigger is called, and after the last record has been processed, the OnPostDataItem trigger is called.
Between these two triggers, the data item records are processed. Processing a record means executing the record triggers and outputting sections. C/SIDE also determines whether the current record should cause the outputting of a special section, such as a header, footer, group header or group footer.
If there is an indented data item, a data item run is initiated for this data item (data items can be nested 10 levels deep).
When there are no more records to be processed in a data item, control returns to the point from which processing was initiated. For an indented data item, this means the next record of the data item on the next highest level. If the data item is already on the highest level indentation is zero control returns to the report.

issue while upgrading Navision 2013 to Navision 2015

We faced an issue while upgrading Navision 2013 to Navision 2015 with one of our client.
The issue with the fields Amount and Amount (LCY) in the Vendor Ledger Entry and Customer Ledger Entry and its value is not get updated after the upgrade process.
Hence, Issue reflects in the Customer Detailed Trail balance and Vendor Detailed Trail Balance Reports.    
Reason
In 2015, Microsoft includes a Boolean field named as Ledger Entry Amount in both Detailed Vendor Ledger Entry and Detailed Customer Ledger Entry and this field gets updated on every new record entry on both the tables except the record with the "Entry Type" as Application or Appln. Rounding. 
The flow field filters of the fields Amount and Amount (LCY) is based on the above Ledger Entry amount field in Navision 2015 (But not in Navision 2013, 2013 R2). So there is no way to update the values for the fields Amount and Amount (LCY) for the records which has upgraded from Navision 2013.              
Solution
To update the values for the field Ledger Entry Amount in both the tables, we should write a processing only report with the Data items as Detailed Customer Ledger Entry and Detailed Vender Ledger Entry with the Data Item filter as "Entry Type" with values
Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'|Correction of Remaining Amount.
Please aware of the above issue while upgrading lower versions of Navision into Navision 2015.
There is one more issue regarding the same on the Report 595 in Navision 2015 , but i hope it gets fixed in the Cumulative updates of Navision 2015.


Article Source: JayaMurugan.P, Technical Consultant, CETAS Information Technology, Chennai

How to Open the RoleTailored Client in Configuration Mode

To configure a profile, you must open the RoleTailored client in configuration mode. 

When you open the Role Tailored client in configuration mode, you can make changes to a Role Center. These changes then become part of the Role Tailored client for users assigned to the profile associated with the Role Center.

To open the Role Tailored client in configuration mode, follow the below steps:


Step 1: Open command prompt

Step 2: Navigate to the root folder of the Role Tailored client.

Example: CD C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client

Step 3: Type the following command.

Microsoft.Dynamics.Nav.Client.exe -configure -profile:profile-id

Example:

Microsoft.Dynamics.Nav.Client.exe -configure -profile:"Accounting Manager"

 


 

 

Sunday, July 19, 2015

Pages that needs to be configured in order to configure a new company

You need to configure the below pages in order to configure a new company
Steps for setting up a new company
  1. Create new company
  2. Company information
  3. Accounting periods
  4. No. Series
  5. Chart of accounts
  6. Dimensions
  7. G/L Setup
  8. Sales & receivables setup
  9. Purchases & payables setup
  10. Inventory setup
  11. Customer posting group
  12. Bank posting group
  13. Vendor posting group
  14. Inventory posting group
  15. Gen. bus. Posting group
  16. Gen. prod. posting group
  17. Location
  18. Gen posting setup
  19. Inventory posting setup
  20. VAT posting setup
  21. Currency
  22. Vendor
  23. Customer
  24. Item

Friday, July 17, 2015

Summation of a field in report with groups:

Summation of a field in report with groups:
write code in Report Properties:
Shared Total as Decimal

Public Function SetTotal(ByVal Value as Decimal)
Total+=Value
End Function

Public Function GetTotal
Return Total
End Function
And then call GetTotal Function in respective table box(in report) where you want to get the Total
Code.GetTotal
And then in report , data for which you need total to be calculated. In that text box, call SetTotal function

=Fields!BudValue.Value+Code.SetTotal(Fields!BudValue.Value)