Error: You do not have permission to read the 0 table.

There are quite a few error messages you can get when setting up Dynamics NAV security – database is invalid or cannot be access, you do not have permissions to read the table, etc, etc. And once you have seen them, next time you will know (more or less) possible solution for it. And I thought I have seen all of them by now. However, today, I’ve seen one more error, which I have seen before, but the cause of it was different! You do not have perission to read the 0 table (SUPER user was trying to create another SUPER user and received this error message).

6893379332 4e9404a24a   Error: You do not have permission to read the 0 table.

So, what could have caused this? Continue reading

Technorati Tags: , , , , , , ,

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

How to Create Additional No. Series For the Same Document?

Just a few days ago, I have written How to Create No. Series in Dynamics NAV, and today I got one more question about No. Series. How to create an use additional No. Series for the same document type?

For example, let’s say, that you want to use one number series, for most of your customers:
6668808969 a910ecc052   How to Create Additional No. Series For the Same Document?

But for, other customers (specifically, customers who own factories), you would like to use another set of number series:
6668809233 e1c6aa003e   How to Create Additional No. Series For the Same Document?

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.
6668809537 03177839eb   How to Create Additional No. Series For the Same Document?

4. In the opened form, define second number series (as per our example, that would be FSI):
6668809647 ff9727948f   How to Create Additional No. Series For the Same Document?

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:
6668809879 0517ca4cd3   How to Create Additional No. Series For the Same Document?

And you will be able to select one of the two number series: CSI or FSI:
6668810075 7731faf644   How to Create Additional No. Series For the Same Document?

Result!
6668810247 c01765d60a   How to Create Additional No. Series For the Same Document?

Technorati Tags: , , , ,

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

Application Method Field on Customer Card, Payments Tab

Recently, I have been asked what is the use of Application Method field on Customer card, on Payments tab? Without looking at the field, my initial response was Huh? (I have never used this field before).
6636922857 765bf38064   Application Method Field on Customer Card, Payments Tab

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

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

Functions > Reverse Transaction… on Customer Ledger Entries Form in Dynamics NAV

Have you ever noticed a function called Reverse Transaction… on Customer Ledger Entries form? Have you ever needed to use it? Do you know when you can use it?6636727343 40664c1bfe   Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV

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 -
    6636834365 b76cfea88d   Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV
  • 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 - 
    6636727623 bbf99eb947   Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV
  • 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 - 
    6636727485 2b265364da   Functions > Reverse Transaction... on Customer Ledger Entries Form in Dynamics NAV

Related Links

Technorati Tags: , , , ,

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

Dimensions – Detail Report in Dynamics NAV

Default Dynamics NAV reports. You either hate them, or you love them. You either use them consistently, or you don’t even know they exist. So, let’s have a look at a one of default Dynamics NAV reports called Dimensions – Detail Report.

Financial Management > General Ledger > Reports > Dimensions – Detail
6636589391 cdfbf09755   Dimensions   Detail Report in Dynamics NAV

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:
    6636621021 f5c4e43f76   Dimensions   Detail Report in Dynamics NAV
  • 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:
6636621167 6299632377   Dimensions   Detail Report in Dynamics NAV

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

Technorati Tags: , , ,

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

How to Copy a General Posting Setup Line

It’s not something that you do everyday, however, once in a while, you do need to create a new General Posting Setup Line. Usually, I see people going into Financial Management > Setup > Posting Groups > Posting Setup, creating a new entry, defining Gen. Bus. Posting Group and Gen. Prod. Posting Group, and then copying the “Account” values from existing setup (one column at a time). Or, if person is more familiar with the system, I have seen users applying a filter on one of the field (Gen. Bus. Posting Group, or Gen. Prod. Posting Group), and then clicking on the right-arrow on the keyboard and clicking F8 (to copy a value from above entry), right-arrow and F8 again (click click click). It gets the job done, but…

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.
6630799273 4e55f9583f   How to Copy a General Posting Setup Line

2. Select new Gen. Prod. Posting Group and Gen. Bus. Posting Group combination. Click “Copy…“.
6630779841 2921760424   How to Copy a General Posting Setup Line

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).
6630780097 a0fc953867   How to Copy a General Posting Setup Line

4. Click OK and then click Yes to confirm the Copy function.
6630780323 4da2060b5f   How to Copy a General Posting Setup Line

5. Check copied values.
6630780545 c576ecb8cb   How to Copy a General Posting Setup Line

Result!

Technorati Tags: , , ,

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

How to Manually Create New No. Series in Dynamics NAV

6630328133 1879f44e52   How to Manually Create New No. Series in Dynamics NAV
No. Series is used in Dynamics NAV to set up all the number series that you will use in your company for various records (like Item, Customer, Vendor, etc.), various documents (like quotes, orders, invoices, etc.), and journals (templates, batches, lines).

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:
6630328301 269a32c6a7   How to Manually Create New No. Series in Dynamics NAV

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:
6630328451 fafd791cd7   How to Manually Create New No. Series in Dynamics NAV

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

Technorati Tags: , ,

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