Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

In Credit Warnings Field in the Sales & Receivables Setup you can specify whether you want the program to give a warning about the customer’s status when you create a sales order or invoice, or not. I have seen to many times, end-users being blind to warnings (even with written instructions), just clicking OK, to get rid of the form, without actually making a decision (which needs to be made, according the the option selected in the setup).
6466490899 71196f7b6e   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

In the Credit Warnings field, you have following options:

Credit Warnings – Both Warnings

When you use this option, the program checks both the Credit Limit and the Balance Due fields on the customer’s card and gives a warning if the customer has exceeded its credit limit or if the customer has an overdue balance (check below options for more specific details).

Note: It would start with the Overdue Balance check, and then would move to Credit Limit check.

Credit Warnings – Credit Limit

When you use this option, the program compares the value in the Credit Limit (LCY) field on the customer’s card with the customer’s balance and gives a warning if the customer’s balance exceeds this amount.

For example, if we would check Credit Limit (LCY) and Balance (LCY) fields for customer:6466521129 eeb9cf071e   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

We could see, that Credit Limit is almost reached. So, the next time, we create a new sales order, we might get Credit Limit warning:
6466540939 6e099bbf32   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

Note: Credit Limit (LCY) set to 0, means that customer does not have a limit at all, therefore, a warning message would not be displayed.

Credit Warnings – Overdue Balance

When you use this option, the program checks the Balance Due field on the customer’s card and gives a warning if the customer has an overdue balance.

For example, if we would look at customer 50000. We can see, that Customer Limit is not set at all:
6466585671 7a45b813bd   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

But, if we would click on Customer > Statistics (or F9), we would see that Overdue Balance (LCY) is more than 0:
6466585917 00e7b9bab8   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

Which means, that when creating a new sales document for this customer, we would get Overdue Balance warning:
6466586241 619e2a3c72   Credit Warnings Field in The Sales & Receivables Setup Table in Dynamics NAV

Credit Warnings – No Warning

When you use this option, the program gives no warning about the customer’s status. Which means, you can create new sales documents without checking the customer credit limit, not customer overdue balance.

From business perspective, these warnings could be invaluable – each time you create a new sales document, you get an actual view of your customer’s credit standing, and based on warnings you can make instant decisions on how to proceed. However, I have seen so many times, people just ignoring these warning messages (automatically clicking Yes, without understanding the value (or the meaning) of the warning message). In this scenario, if you really do not care about the warning message, it’s better to change setup of Credit Warnings to No Warning. At least then you will be more efficient in entering new sales documents.

Technorati Tags: , , , ,

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

How to Disable Tools > Zoom Function in Dynamics NAV

We can quite easily disable ShortCutKeys in Dynamics NAV by creating hidden Menus (with keyboard shortcuts assigned to them). However, how do we disable Tools > Zoom Function in Dynamics NAV? How do we hide sensitive data from SUPER users? Of course, we could encrypt the data, so it would not make sense for a person viewing it, however there must be a way, of disabling Tools > Zoom function for SUPER users. There must be a way…

And, in fact, there is (thank you Peter for sharing this information)! Quite an ugly way (involves a little bit of coding), but it does the trick. Not only, it can disable the Tools > Zoom function, but it can also prevent SUPER user from opening the table directly in Object Designer!

How to Disable Tools > Zoom Function in Dynamics NAV
1. Go to Object Designer, and design Codeunit 1 ApplicationManagement:
6461607505 40370f6021   How to Disable Tools > Zoom Function in Dynamics NAV
Click Tools > Object Designer (or SHIFT+F12). Click on “Codeunit“. Click on Codeunit 1 ApplicationManagement and click Design.

1.1. Create a new function call DisableZoom:
6461607583 1f7982ecd2   How to Disable Tools > Zoom Function in Dynamics NAV
Here, if we will use only ERROR(”), this will disable the Tools > Zoom function for all users. However, we could incorporate more meaningful logic behind this function, with which we could allow or restrict specific users from using Tools > Zoom function.

1.2. Modify existing function CaptionClassTranslate:
6461607741 c8443c7cf0   How to Disable Tools > Zoom Function in Dynamics NAV

2. For the form, for which you want to disable Tools > Zoom function, modify underlying table:
2.1. Find which table needs to be modified:
6461607929 f56605368e   How to Disable Tools > Zoom Function in Dynamics NAV
Open form, click Tools > Designer (or CTRL + F2), click View > Properties (or SHIFT+F4), find SourceTable property.

2.2. Design table in Object Designer:
6461608073 6f2ea63c90   How to Disable Tools > Zoom Function in Dynamics NAV

2.3. Add new field of Text type (I have called it “Disable Tools > Zoom”):
6461608191 332e707e77   How to Disable Tools > Zoom Function in Dynamics NAV

2.4. Define CaptionClass as ’9999,5050′ (click View > Properties (or SHIFT+F4) and find a Property CaptionClass, enter ’99999,5050′):6461608331 dcfb8ebf78   How to Disable Tools > Zoom Function in Dynamics NAV
Here, 99999 will be CaptionArea, and 5050 will be CaptionRef in Codeunit 1. This will allow to distinguish for which table Tools > Zoom function should be disabled.

3. Run form in question again, and click Tools > Zoom.

Result! It seems, as if nothing happens when you click Tools > Zoom. In fact, the Zoom form, is being opened, but it errors because of our new function in Codeunit 1. In fact, you would get similar result (of “nothing happens”), if you would try to open table directly in Object Designer.

That’s one of the things… that is really good to know, but I doubt, I will use it in the future. Not the nicest way of modifying Dynamics NAV, is it?

Related Links

Technorati Tags: , , , , ,

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

How to disable CTRL+F8 on Dynamics NAV Form?

I have written about how to enable Tools > Zoom function in Dynamics NAV. I have also pointed out the weakness of using Tools > Zoom function (for example, when hiding passwords). However, there is a way to disable keyboard shortcut CTRL+F8 on a specific form.

How to disable CTRL+F8 on Dynamics NAV Form?
Add new MenuButton to the form (click on Toolbox button, then click on Menu Button, then click on the form, where you want to add Menu Button):
6461343371 65c9849103   How to disable CTRL+F8 on Dynamics NAV Form?

Create new Menu Item and define the ShortCutKey to Ctrl+F8 (right-click on new Menu Button, select Menu Items, create a new entry by defining Caption (Disable Zoom Function) and ShortCutKey (CTRL+F8) properties, but leaving Action and RunObject properties blank):
6461343725 0d2284f22a   How to disable CTRL+F8 on Dynamics NAV Form?

Resize Menu Button to a very small size (so, you could hide it behind one of the other existing buttons on the form)
6461343817 ed381c33f2   How to disable CTRL+F8 on Dynamics NAV Form?

Drag new Menu Button on one of existing button on the form, and click Format > Send to Back (this will position your new MenuButton under the button):
6461344081 3cbab628ce   How to disable CTRL+F8 on Dynamics NAV Form?

Now, if you would run the form again, and try to click CTRL + F8, nothing will happen. Result!

Unfortunately, user will still be able to click Tools > Zoom… (which I was hoping would not work either, but it does!) I wonder, if there is a way to disable Tools > Zoom functionality for a specific form…

Edited on 06/12/2011 21:45 (as per Peter’s request) - WARNING:
Disabling keyboard shortcut CTRL+F8 does not remove the ability to run Tools > Zoom function directly. Therefore, this wokaround should not be used for controlling security. Instead, this post should be taken as example, of how to control ShortCutKey property.

Technorati Tags: , , , , , ,

Posted in development, Dynamics NAV / Navision | Tagged , , , , , , | 5 Comments

Check G/L Account Usage Field The General Ledger Setup Table

There are a few places in Dynamics NAV, where you set them up once, and then forget. Unless,  you do a new installation, you don’t really need to go through these setup fields again. One, of these fields is Check G/L Account Usage Field in The General Ledger Setup Table.

6454553337 6958c9f722   Check G/L Account Usage Field The General Ledger Setup Table

Firstly, you need to know, that it is possible to delete G/L Accounts in Dynamics NAV. Obviously, if you have any outstanding balance, you will not be able to delete G/L Account. Instead, you will get error message saying: Balance must be 0 in G/L Account No.=’ACCOUNT’. However, if you have a balance of 0 (even if you had General Ledger Entries posted), you will be able to delete G/L Account.

That’s where it might be useful to know (and use) the field Check G/L Account Usage:

Check G/L Account Usage Field The General Ledger Setup Table
A check mark in this field indicates that you want the program to protect G/L accounts that are used in setup tables from being deleted. If there is a check mark in this field and you try to delete a G/L account, the program will check if the account is used in one of the following tables:

  • Currency
  • Customer Posting Group
  • Vendor Posting Group
  • Job Posting Group
  • General Posting Setup
  • Bank Account Posting Group
  • VAT Posting Setup
  • FA Posting Group
  • Inventory Posting Setup
  • Service Contract Account Group
  • Gen. Journal Template
  • Gen. Journal Batch
  • Gen. Jnl. Allocation
  • FA Allocation

If you have a checkmark in Check G/L Account Usage field, when deleting G/L Account which has been used in setups, you will get error message: You cannot delete a G/L Account that is used in one or more setup windows.
6454622387 205b2848b1   Check G/L Account Usage Field The General Ledger Setup Table

Technorati Tags: , ,

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

Shipment/Receipt Posting Policy in Dynamics NAV

If you would go to Departments > Administration > Application Setup > Warehouse > Warehouse, and then in Tasks, click Warehouse Setup. On the right side of the General FastTab, you will notice two fields: Receipt Posting Policy and Shipment Posting Policy.
6420955135 485c8527c4   Shipment/Receipt Posting Policy in Dynamics NAV

This field [shipment/receipt posting policy] contains the policy that the program follows when it posts a warehouse shipment. There are two policies to choose from.

  1. Posting errors are not processed. - The program will post all source documents, without stopping, even if any errors occur in the posting process. You will get the message “X-source documents out of a total of Y have now been posted.” There is no possibility to see what kind of errors occurred in the posting process.
  2. Stop and show the first posting error. - The program will post source documents until the first error occurs. The posting process is cancelled upon the first error and the rest of the source documents will not be posted.

Technorati Tags: , , , ,

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

What is the functionality behind On Hold field in Vendor Ledger Entry Table?

Once in a while, you get a question about default Dynamics NAV functionality, and you think you know the answer… What is the functionality behind “On Hold” field in Vendor Ledger Entries? Sounds easy… You use this field to block vendor ledger entries from being paid when using Suggest Vendor Payments batch job in Payment Journal, right? Correct, but is there anything more to it? How do you “block” vendor ledger entries from being paid? When entries are put on hold, can you still apply payments to them in Payment Journal?

On Hold field in Vendor Ledger Entry Table
This field can be used when a vendor ledger has been invoiced and you run the Suggest Vendor Payments batch job. You can use the field to determine whether the posted vendor entry will be included in the payment suggestion. Before posting, you can fill in the field with your initials or any other code to indicate that the vendor entry should wait for approval before a payment is made.

If the field is filled in, the entry will not be included when you run the Suggest Vendor Payments batch job. The field will show that the entry is waiting for approval. If the field is empty, the entry will be included in the payment suggestion.

How to use On Hold Field in Vendor Ledger Entry Table?
You can fill in the field either directly in Vendor Ledger Entries (by clicking F2 or double clicking on the field and entering the value):

6452200769 9f4e55c321   What is the functionality behind On Hold field in Vendor Ledger Entry Table?

Or, if you know, that invoice should be put on hold prior to posting purchase document, you can fill in the field on “Invoicing” tab:
6452200553 1426e98540   What is the functionality behind On Hold field in Vendor Ledger Entry Table?

The contents of the On Hold field will get copied to Vendor Ledger Entries.
6452200711 725b6e9e41   What is the functionality behind On Hold field in Vendor Ledger Entry Table?

Can you apply payments to Vendor Ledger Entry that is On Hold?
This field is used only when running Suggest Vendor Batch Job in Payment Journal. If you are not using this batch, and you create a payment journal manually, you will be able to apply payments to vendor ledger entries that are “On Hold” without getting any warnings or error messages.

Technorati Tags: , , , ,

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