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

Once you have created Setup Questionnaire in Dynamics NAV (and exported questions to Excel file),  you can send these questions to your customer. Customer will need to answer these questions and then the file will become the foundation for your initial set ups for the new company in Dynamics NAV.

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: , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , | Leave a comment

How to Create Setup Questionnaire in Dynamics NAV?

If you would restore a CRONUS database (with intention to check out the Setup Questionnaire which I have mentioned yesterday), you might be a little bit disappointed when you go into Administration > Application Setup > Company Setup > Setup Questionnaire – you can’t find any data!

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.
6619333923 bc4a345b3f   How to Create Setup Questionnaire in Dynamics NAV?

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.
6619334015 fd0334a998   How to Create Setup Questionnaire in Dynamics NAV?

1.3. Click OK when the import is complete.
6619334091 237eca22a7   How to Create Setup Questionnaire in Dynamics NAV?

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.
6619334687 65de9f7f73   How to Create Setup Questionnaire in Dynamics NAV?

2.2. You can click F5 to go to the list of Setup Tables.
6619334845 27b978cf13   How to Create Setup Questionnaire in Dynamics NAV?

2.3. Select the relevant area (setup table) and click OK to review questions.
6619334951 be2d0ae08c   How to Create Setup Questionnaire in Dynamics NAV?

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.
6619334321 be94c94415   How to Create Setup Questionnaire in Dynamics NAV?

3.2. Enter the File Name and click Save.
6619334543 0de75c45fb   How to Create Setup Questionnaire in Dynamics NAV?

3.3. Click OK when export process is completed.
6619334623 73f478f0c9   How to Create Setup Questionnaire in Dynamics NAV?

3.4. Open Excel file you just created and review various tabs on the spreadsheet.
6619356247 83458a7ff1   How to Create Setup Questionnaire in Dynamics NAV?

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: , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , | Leave a comment

What is Setup Questionnaire in Dynamics NAV?

If you are working for end-user company, most likely you have never seen Administration > Application Setup > Company Setup > Setup Questionnaire in Dynamics NAV (and most likely, you will never need to see it). However, if you are Dynamics NAV consultant constantly working with new implementations (or at least, if you are preparing for Dynamics NAV Financials exam), you might have encountered this tool.
6619176937 13af75b71b   What is Setup Questionnaire in Dynamics NAV?

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.
6619205315 1c0ba3c11d   What is Setup Questionnaire in Dynamics NAV?

And each questionnaire covers the same 10 setup tables, but questions may be different for various industry types.
6619205445 3c2f9eabdb   What is Setup Questionnaire in Dynamics NAV?

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: , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , | Leave a comment

Stockout Warning Field in Sales & Receivables Setup Table in Dynamics NAV

6466736439 645ba22bdf   Stockout Warning Field in Sales & Receivables Setup Table in Dynamics NAV

In Stockout Warning field you can specify whether you want the program to warn you when a sale will result in a negative inventory for an inventory item. Dynamics NAV will base its warning on a calculation that includes all posted item entries plus sales order lines that have not yet been posted.

Stockout Warning
The Stockout Warning check box, when selected, specifies that
the program warns the user when there are not enough items on
inventory to fulfill a sales order. The warning is based on a
calculation that sums quantity amounts on all posted item ledger
entries and unposted sales order lines, including reserved
quantities.

To have the program warn you that the inventory will become negative, place a check mark in the check box. However, please note that:

  • Stockout Warning does not work for “Drop Shipment” lines.
  • Stockout Warning does not check “incomming” stock from purchase orders.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | Leave a comment

Cost is Adjusted Field in Item Table

6594917005 fa976f1a5e   Cost is Adjusted Field in Item Table

Cost is Adjusted field contains a check mark if the item’s unit cost has been adusted, either automatically or manually.

By saying “automatically“, I actually refer to Warehouse > Setup > Inventory Setup, fields “Automatic Cost Posting” and “Automatic Cost Adjustment”. Depending on this setup, your item costs might get updated with every transaction posted.
6594916599 8c9c0f37d9   Cost is Adjusted Field in Item Table

And by “manually“, I refer to running the batch job Financial Manageent > Inventory > Costing > Adjust Cst – Item Entries. It is possible to run this on the Job Queue, hence automatically, however in the context of “Cost is Adjusted” field usage, even if report is executed as a Job Queue task, it is still considered as running the batch job “manually”.

Basically, if “Cost is Adjusted” has a check mark, it means that “Adjust Cost – Item Entries” has been executed recently. If “Cost is Adjusted” field does not have a check mark, it doesn’t mean, that cost for item has never been adjusted. Instead, it means, that there are some new entries, that will need to be adjusted.
6594933663 b860311d2f   Cost is Adjusted Field in Item Table

Once you execute “Adjust Cost – Item Entries”  batch job (and hopefully, you have done it without any filters), all your items should have a checkmark on “Cost is Adjusted” field.

To summarize, the field “Cost is Adjusted” can be used either by user trying to identify if costs for items have been adjusted, or by the system:

  • when running report 1004 Close Inventory Period – Test, system will check if cost has been adjusted for item and warn a user if it hasn’t been done.
  • Cost is Adjusted” field is set to No, whenever system creates a new records that affect Value Entries
  • Cost is Adjusted” field is set to Yes, when running “Adjust Cost – Item Entries” batch job.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | Leave a comment

Shipment on Invoice Field in Sales & Receivables Setup

6590051405 08367c66b9   Shipment on Invoice Field in Sales & Receivables Setup

Shipment on Invoice Field in Sales & Receivables Setup Table

If you place a check mark in this field, the program will automatically create a posted shipment, in addition to a posted invoice, when you post an invoice.
If you leave the field blank, the program will create only a posted invoice when you post.

What does it mean in simple user-friendly terms? Well, have you ever seen a posted sales shipment for manually posted invoices like:
6590084715 c175ccaf24   Shipment on Invoice Field in Sales & Receivables Setup

This sales shipment has been generated automatically, when user went to Sales & Marketing > Order Processing > Invoices, created new invoice for travel expenses, and invoiced it directly from Sales Invoice screen.

If Shipment on Invoice field is unchecked, sales invoice would still be posted, however posted sales invoice would not be generated.

Technorati Tags: , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , | Leave a comment

Writing about Dynamics NAV

6589946595 46f2e3aeb6   Writing about Dynamics NAV

It’s very easy to write about Dynamics NAV. Especially, when you breathe it (live with it, work with it, and love it) everyday. You encounter issues you have seen already. You create solutions (or optimize ones) that someone else has already created. You get asked questions that have been asked previously. You work in your own way, and you see other people working in their own way. And all of us arrive at the same destination (hint: go live), even though we might have followed different routes. There is no a good way (well, there might be) or a bad way (well, there obviously is!), but every way is a learning experience which can be shared.

On the other hand, it’s very easy to stop writing about Dynamics NAV. Even too easy (just take a holiday for a week or so). And once you stop, you find so many excuses not to start writing again. Or… to leave it for tomorrow. Or day after tomorrow. Even when your colleague (thanks, by the way!) says “it has been thirteen days now… not good… not good“, you nod in agreement and think “tomorrow!“. But there is no tomorrow. There is only next 15 minutes and what you make out of it.

My original inspiration after coming home from NAV TechDays conference in Antwerp was to write about Dynamics NAV for 365 days. Yes, that’s writing daily about Dynamics NAV. That is the only way of living up to my own proclaimed title – Dynamics NAV Enthusiast.

So, let’s see how far we can get!

Technorati Tags: , ,

Posted in Dynamics NAV / Navision | Tagged , , | Leave a comment