So, what could have caused this?

Firstly (when dealing with permissions, I always do this first, I am not even sure why), Tools > Security > Synchronize All Logins worked without any errors.

Then, in SQL Management Studio, I have checked Server Roles for user (Database Login – USER1): sysadmin and public should be sufficient. Also, User Mapping (public and db_owner are more than sufficient!).

So, what else do you need to be able to create a new SUPER user (to assign SUPER role to existing user)? Because of above sql permissions, USER2 was created successfully, but the error message would appear when trying to add “SUPER” role.

Well… thinking down the lines of default Dynamics NAV functionality, you need to have SUPER role yourself. So, I have logged in as USER1 and checked it’s permissions. And, instantly, I’ve got he “aaahhhaaa!” moment. What’s wrong with permissions below?

That’s right! SUPER user was limited to a specific company. In order to be able to add “SUPER” role (without Company filter), you need to have “SUPER” role, without company filter. Simple!

Technorati Tags: db_owner, permissions, public, roles default functionality, Security, Server Roles, SUPER, sysadmin

For example, let’s say, that you want to use one number series, for most of your customers:

But for, other customers (specifically, customers who own factories), you would like to use another set of number series:

How would you achieve that? Well, (as in most cases with Dynamics NAV setups) this is quite easy.
1. Firstly, you need to create both number series.
2. Secondly, you need to define the first number series in setup (as per our example, that would be in Sales & Receivables Setup, Numbering tab, “Invoice Nos” field, select “CSI” No. Series).
3. Go to Administration > Application Setup > General > No. Series and find “CSI” No. Series. Click Line > Relationships.

4. In the opened form, define second number series (as per our example, that would be FSI):

And that’s it! Now, when creating sales invoices, all you need to do (after clicking F3, or Edit > New), is to drill down into “No.” field:

And you will be able to select one of the two number series: CSI or FSI:

Result!

Technorati Tags: Application Setup, default functionality, Financial Management, interview questions, No. Series

I quickly jumped into CRONUS UK database and filtered customer list setting Application Method <> Manual. The result – only 1 customer (20000 Selangorian Ltd). This would explain the reason, I’ve never seen this field – even in CRONUS there is only one example!

However, as always, Dynamics NAV help files can answer such straight-forward questions (no need to know everything, right?).

Application Method Field on Customer Card, Payments Tab
In Application Method field you can choose how the program will apply payments for this customer. To determine the application method, click the AssistButton in the field and select one of the two options:

• Manual - If you select Manual, you must manually specify in the Apply Customer Entries window which sales document a payment applies to.
• Apply to Oldest - If you select Apply to Oldest, the program will automatically apply the payment to the oldest of the customer’s open entries.

If you do not enter anything here, the application method will be Manual.

Technorati Tags: Customer, default functionality, Financial Management, interview questions, Payments

Functions > Reverse Transaction… is part of default Dynamics NAV functionality, however it cannot be used on all Customer Ledger Entries. There are a few prerequisites to use that function – Customer Ledger Entry, that we will be able to reverse:

• must not be reversed already.
  If you are trying to reverse Customer Ledger Entry that has been reversed already (or that has been created because of using Function > Reverse Transaction, you will get error message - You cannot reverse Cust. Ledger Entry No. because the entry has already been involved in a reversal -
  
• must not be applied (note: you can unapply entries though, prior to reversing them)
  If you are trying to reverse Customer Ledger Entry, that has been applied, you will get error message saying - You cannot reverse Cust. Ledger Entry No. because the entry is either applied to an entry or has been changed by a batch job - 
  
• must be posted from a journal (that is, Journal Batch Name must be filled in).
  If you are trying to reverse Customer Ledger Entry that does not have Journal Batch Name filled in, you will get error message saying – You can only reverse entries that were posted from a journal - 
  

Related Links

• You cannot reverse Vendor Ledger Entry No. 3204 because the entry is either applied to an entry or has been changed by a batch job.

Technorati Tags: Customer Ledger Entries, default functionality, errors, functions, Reverse Transaction

Financial Management > General Ledger > Reports > Dimensions – Detail

Dimension – Detail Report displays a detailed classification of how dimensions have been used on entries over a selected period. The entries shown in the report are linked to a particular analysis view. Therefore, only entries with dimensions or dimension combinations that are included in the analysis view you have selected will be included in the report.

The report can be used to investigate which activities use which dimensions, and how individual dimensions are combined with other dimensions on specific entries. For a less detailed analysis of dimensions, you should use the Dimensions – Total report.

You can define what is included in the report by filling in the fields on the Option tab as follows:

• Analysis View Code: Here you can enter the code for the analysis view you want the report to be based on. To select among the analysis view codes you have set up in the Analysis View table, click the AssistButton in the right of the field.
• Include Dimensions: Here you can enter the dimensions that you want to include in the report. You can only select dimensions included in the analysis view that you select in the Analysis View Code field. To see the dimensions that are available, click the AssistButton in the right of the field. To include dimensions, define Levels you would like to analyse:
  
• Date Filter: In this field, you can set a filter to filter entries by date. You can enter a particular date or a time interval.
• Print Empty Lines: Place a check mark in the field if you do not want the report to include dimensions and dimension values that have a balance of zero.
• Show Amounts in Add. Reporting Currency: Place a check mark in the field if you want the amounts on the report to be shown in the additional reporting currency.

By running same report (with different dimension levels selected), you might get different outputs:

But, generally, Dimensions – Detail report should allow you to analyse how dimensions are being used for your general ledger postings.

Technorati Tags: default functionality, default reports, Dimensions, reports

Instead, you could save lots of time (and ensure that you do not make any errors by copying values) by using default Copy – General Posting Setup Batch Job. According to Dynamics NAV help files:

With this batch job you can copy a record with selected fields or all fields from the general posting setup to a new record. Before you start to copy you have to create the new record.

How to Copy a General Posting Setup Line
1. Go to Financial Management > Setup > Posting Group > Posting Setup.

2. Select new Gen. Prod. Posting Group and Gen. Bus. Posting Group combination. Click “Copy…“.

3. And on the request form, select a combination of “Gen. Bus. Posting Group” and “Gen. Prod. Posting Group” from which you want to copy the details (you can copy either all fields, or select only some of them).

4. Click OK and then click Yes to confirm the Copy function.

5. Check copied values.

Result!

Technorati Tags: Application Setup, default functionality, Gen. Bus. Posting Group, Gen. Prod. Posting Group

How to Manually Create New No. Series in Dynamics NAV
1. Go to Administration > Application Setup > General > No. Series
2. Create a new record, by defining fields:

Code – In the Code field, type a unique identifier for this number series.
Description – In the Description field, type a short description of the number series.
Default Nos. – Place a check mark in the Default Nos. check box if this number series uses automatic numbering. If the Default Nos. field is unchecked, users must manually look up from the No. field and select from number series.
Manual Nos. – Place a check mak in the Manual Nos. check box if this number series allows manual numbering instead of always using automatic numbering.
Date Order – Place a checkark in the Date Order check box, if the numbers from this range are assigned chronologically.

You might have noticed more fields on No. Series records ,which you cannot update. These are automaticaly updated in the No. Series after No. Series Line information is entered:
Starting No. -
Ending No. -
Last Date Used -
Last No. Used -

3. Click on button Series > Lines and define fields:

Starting Date – Enter the date when this number series can be used.
Starting No. – Enter the first number in the series
Ending No. – Enter the last number in the series
Warning No. – Enter the number which, once reached, will generate a warning that number series is coming to an end.
Increment-by No. – Enter the size of the interval the numbering should increase.

Last Date Used – Field is updated automatically when the number series is used and shows the last date that was No. Series was used.
Last No. Used – Field is updated automatically when number series is used and shows the last umber in the series used
Open – This field is non-editable and is unchecked automatically when the last number in the number series is used

4. Assign numbers series on your Setup tables (for example, on “Sales & Receivables” setup, Numbering tab, you can define “Customer Nos” – number series for customers).

Note: When creating new No. Series I tend to use a lenght of 10 characters for Starting No. and Ending No. (even though, you are allowed to use up to 20 characters). However, I go for 10 characters only, because then it fits nicely in default Dynamics NAV form fields.

Related Links

• Tip #21 – Implementing No. Series
• Dynamics NAV Tour: No. Series

Technorati Tags: Application Setup, default functionality, No. Series

How to Import Setup Questionnaire Answers to a New Company in Dynamics NAV?

1. Complete the Setup Questionnaire with the Customer.
The idea behing the Setup Questionnaire is to enable your customer to fill in the details themselves. All you need to do is to export setup questionnaire to Excel file and send that file to customer.Then, after filling the details, customer would send back the file to consultant (to apply setups on a new company).

2. Create a new company.
While your customer is trying to answer all the questions from Setup Questionnaire, you can proceed with creating a new company.
2.1. Click File > Company > New.
2.2. Enter Company Name and click OK.
2.3. Select Company Type field in the Company Setup Window and click OK.
2.4. Once the company has been successfully created, click OK.

3. Import the setup questionnaire.
 3.1. In Dynamics NAV click Administration > Application Setup > Company Setup > Setup Questionnaire, then click Questionnaire > Import from Excel.
3.2. Select the file (that customer has sent to you) and click Open.
3.3. Once the quetionnaire has been successfully imported click OK.

4. Validate the setup questionnaire.
As a consultant, you still need to manually review the data, to ensrue that the fields have been entered in the correct Dynamics NAV format (for example, to check that strings are not entered into date fields, etc).
4.1. Click Questionnaire > Show Questions.
4.2. For each question, review the value in Answer column (checking the value in Answer Option column and the value in Answer column).
4.3. You can click Tools > Zoom to get more specific field information.

5. Apply answers from the setup questionnaire.
If you have skipped step number 4, go back. The Apply Answers process does not validated the format of the answer in the questionnaire! Once, you have validated data on all Setup questions, you can either apply answers for whole Setup Questionnaire:
5.1. Click Questionnaire > Apply Answers.

Or, you can do it for one setup at a time:
5.1. Click Questionnaire > Show Question.
5.2. Click F5 to open a list of Setup Tables. Click on a table name, and click OK.
5.3. For each Setup Table in Question Are window click Question > Apply Answers.

Technorati Tags: Application Setup, default functionality, New Company, Setup Questionnaire

That is because you need to create (or initiliaze) Setup Questionnaire in the first place.

How to Create Setup Questionnaire in Dynamics NAV?
1. Select a company setup (industry-specific) XML file.
1.1. In Dynamics NAV, click Tools > Object Designer. Click Form and find form ID 8622 Company Setup. Click Run.

1.2. Look up in the Company Type field and select the Industry Type. Click OK to confirm. Then click OK in Company Setup window.

1.3. Click OK when the import is complete.

Note: During the import process, by default 67 tables are populated with industry-specific data.

2. Review Setup Questionnaire Questions.
2.1. Go to Administration > Application Setup > Company Setup > Setup Questionnaire and click Questionnaire > Show Questions.

2.2. You can click F5 to go to the list of Setup Tables.

2.3. Select the relevant area (setup table) and click OK to review questions.

Note: You can add new questions, or change default questions to match customizations on your database.

3. Export Setup Questionnaire to a file (usually, Excel).
3.1. Go to Go to Administration > Application Setup > Company Setup > Setup Questionnaire and click Questionnaire > Export to Excel.

3.2. Enter the File Name and click Save.

3.3. Click OK when export process is completed.

3.4. Open Excel file you just created and review various tabs on the spreadsheet.

Note: You shouldn’t change questions on the file directly. If you notice, that a question needs to be changed, do that in Dynamics NAV and export Setup Questionnaire again.

Technorati Tags: Application Setup, default functionality, interview questions, Setup Questionnaire

To say it in one sentence (as per Microsoft training materials):

The setup questionnaire help reduce the implementation workload by streamlining the task of setting up the new system.

But what does this mean for normal Dynamics NAV users? Well, instead of talking in Dynamics NAV jargon (and instead of having deep knowledge of Dynamics NAV), end-users can answer a set of simple questions, and in doing so, newly implemented Dynamics NAV system will be set up.

There is one questionnaire for each (default Dynamics NAV) industry segment.

And each questionnaire covers the same 10 setup tables, but questions may be different for various industry types.

The setup questionnaire is generated in Dynamics NAV by a consultant (in Excel or XML format), and then it is up to a user to answer the question (to setup their system). Once user has finished, the questionnaire file is imported to Dynamics NAV, and (after a few hours) job’s done – the system is set up without the user even connecting to Dynamics NAV database!

And the best thing about Setup Questionnaire in Dynamics NAV – it is not limited to the predefined number of tables (or questions). Therefore, if you are working with addons (or bigger customizations), you can create your own Setup Questionnaire.

Technorati Tags: default functionality, RIM Toolkit, Setup Questionnaire