Sunday, October 5, 2014

Dynamics NAV 2015 has been released.












Download :https://mbs.microsoft.com/partnersource/global/support/support-news/msdnav2015download




Sunday, May 4, 2014

Sales reports in Dynamics NAV 2013 R2-----> 3. Customer order details

3. Customer order details
Path: Cronus Sri lanka-->Departments-->Sales & Marketing-->Order Processing

  • Customer order detail report can use to view system entered sales order details. Specially what are the order which you have partially delivered & pending quantities. 
  • In report option there is a filed "shipment date" which you can use to filter the report to view earliest pending shipments. Ex: if you want to see shipments after 28-Feb-2014 
  • Shipment date: >28-02-2014 & Preview.
  • This report also can take out to Excel for further analysis. For that just press Export to excel button. 

Saturday, May 3, 2014

Sales reports in Dynamics NAV 2013 R2 -----> 2. Aged account receivable

 Path :-Cronus Sri lanka --> Departments-->Financial Management-->Receivables

  • Aged account receivables report is one of the important report to analysis debtor master

  • Report options
    • Aged as of :- Enter the date that you want the aging calculated for.
    • Aging by :- Select whether the aging will be calculated from the due date, posting date or document date.
    • Period length :- Specify the length of each period (Three periods will be shown as columns in the report), example, enter "1M" for one month.
    • Print Amounts in LCY: If you tick this check box, report will be shown figures using LCY (Local currency). If not figures can view each currency &customer wise.
    • Print details : If tick this check box, Report can view detail level, 
    • Heading Type: Select whether the column heading for the three periods will indicate a date interval or the number of days overdue
    • Print to Excel: Place a check mark in the check box if you want to export the data to an Excel spreadsheet for further analysis or formatting before printing.
This report will operate as follows :-  Once you enter the report parameters,
  • Balance column will show customer wise total balance (Total remaining amount in Customer ledger entry)
  • Customer list will be lines in the report. 
  • Four columns arethere according to period length (ex 1M)
  • According to the aged as of date & period length columns will prepare.
  • Assume we have data (customer ledger entry details) up to 01-May-2014.  Aged as of 28-Feb-2014 , period length 1M  & Aging by posting date
    • Balance column will show customer balance as 01-May-2014
    • First column will be (28-feb to 01-feb) , System consider customer ledger entry table & get the total of remaining amount column of that period. it shows each customer wise.

Monday, April 21, 2014

Sales reports in Dynamics NAV 2013 R2-----> 1.Customer List

1. Customer List
Path : CRONUS International Ltd.-->Departments-->Sales & Marketing-->Reports and Analysis or Search (Ctrl + F3) Customer list.


  • Here you can select the particular customer or customer group
  • The report will show you customer list in your company. you can save this report as excel , PDF,or Word by right clicking on the report.