Error when importing FOB file: Cannot find the object because it does not exist or you do not have permissions

There are some tasks in Dynamics NAV, where it is not sufficient to be a SUPER user, to complete them. You need more permissions added for your username on the SQL Server. For example, if you would try to upload a license file without having sufficient SQL permissions, you would get an error message: Database is invalid or cannot be accessed State ID: HY024.

Similarly, if you would try to import the FOB file which contains changes to the table structure (for example, developer added a few new fields to a table and sent you the FOB), you would get a different error message: The following SQL Server error or errors occurred when accessing the TABLE: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object “COMPANY$TABLE” because it does not exist or you do not have permissions.

Cannot find the object because it does not exist or you do not have permissions

If you get error message when importing FOB file, iy means, that you do not have sufficient SQL permissions. By default, if you are Dynamics NAV user, you would have only Public role assigned to you. However, for administrative tasks (like uploading a license file, or importing the FOB file), you need more permissions.

So, if you are trying to import the FOB and you get above error message, you will need to ask you SQL administrator to import the FOB for you, or to grant you sufficient permissions (either a sysadmin or db_owner server roles).

Related Links

Technorati Tags: , , ,

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

How to import objects (*.FOB file) to Dynamics NAV?

To import Dynamics NAV objects (*.FOB file), please follow these steps:
1. Click Tools > Object Designer (SHIFT+F12)
Import FOB File - Object Designer
2. Click File > Import (ALT + F + O)
Import FOB File - File Import
3. Select the FOB file and click Open.
Import FOB File - Open FOB File
4. Read the message, and select option, which will open Import Worksheet.
Import FOB File - Object Analysis
5. Click Replace All. Click OK.
Import FOB File - Click OK
6. You will get a confirmation message about imported objects.
Import FOB File - Confirmation
7. Click Tools > Security > Synchronize All Logins.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 3 Comments

View > Go To Definition (CTRL + F12)

What is keyboard shortcut Ctrl+F12 used for? Yes, that would be my Dynamics NAV technical interview question for you. If you spend at least a little bit time of doing development, hopefully, you are aware of function  the View > Go To Definition.

And what a time-saver it is! While working in one codeunit, you can quickly jump to any other function (regardless, whether it is in different codeunit, or table), by clicking on the function which you want to check (for example, DateNotAllowed),
View - Go To Definition - Starting Point
and then clicking View > Go To Definition (or obviously, if you love keyboard shortcuts, and you better would! just click Ctrl+F12).
View - Go To Definition - End Result

Result!

Technorati Tags: , , , ,

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

How does “Blocked” field work on Item card?

There are some things in Dynamics NAV that you take for granted. For exmaple, “Blocked” field on Item card, what does it do? Well, it should be self-explanatory, if you put a checkmark on “Blocked”, you will block the item, hence, you will not be able to use it anymore, right?

Well, yes and no. It will block the item, but only for posting.

According to Dynamics NAV help files:

When you select the Blocked check box, it does not prevent the Whse. Item Journal or warehouse activities (pick, put-away, and movement) from using the item. You can still move items in the warehouse and register adjustments in the warehouse journals.

However, blocking does prevent you from creating a sales order line. In addition, a warehouse shipment for a sales order line that was created before the item is blocked can be picked but it cannot be shipped.

So, how does “Blocked” field work on Item card in Dynamics NAV?

Blocked Field - Error Message
Firstly, when Item is blocked, you will get error message saying Blocked must be No in Item No.=’TEST-ITEM’, when trying to enter Item No. on:

  • Table 39 Purchase Line
  • Table 83 Item Journal Line
  • Table 89 BOM Journal Line
  • Table 171 Standard Sales Line
  • Table 174 Standard Purchase Line
  • Table 210 Job Journal Line
  • Table 246 Requisition Line
  • Table 753 Standard Item Journal Line
  • Table 1003 Job Planning Line
  • Table 5405 Production Order
  • Table 5741 Transfer Line
  • Table 5902 Service Line
  • Table 5997 Standard Service Line

Blocked Field - Warning Message
Secondly, when Item is blocked, the default Test Reports (for example, on purchase order, if you would click on Posting > Test Report) will display a warning message saying: Blocked must be No in Item No.=’TEST-ITEM’:

  • Report 202 Sales Document – Test
  • Report 402 Purchase Document – Test
  • Report 702 Iventory Posting – Test
  • Report 802 BOM Journal – Test
  • Report 1005 Job Journal – Test
  • Report 5812 Revaluation Posting-Test
  • Report 5915 Service Document-Test
  • Report 7302 WHse. Invt.-Regis – Test

Blocked Field - Codeunits
Finally, default Dynamics NAV posting routines, will also check if item is blocked (and, as per help files, it will stop users from posting blocked items). This will come into play, if item has been blocked after it has been added to documents/journals, stopping you from initiating posting routine.

  • Codeunit 22 Item Jnl.-Post Line
  • Codeunit 5510 Production Journal Mgt
  • Codeunit 5704 TransferOrder-Post Shipment
  • Codeunit 5705 TransferOrder-Post Receipt

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 2 Comments

Ctrl + Alt + Delete in Remote Desktop

This tip is not really related to Dynamics NAV, however, if you are like me, you are living in multiple different Remote Desktops and working on different Dynamics NAV clients. And sometimes, you need to kill your Dynamics NAV client, so… you click Ctrl + Alt + Delete… and it is executed on your local computer instead of RDC. Annoying!

CTRL+ALT+DELETE

Annoying, if you don’t know the shortcut that would work on RDC, that is. Next time, you need to click CTRL + ALT + DELETE while working on Remote Desktop Connection, click CTRL + ALT + END instead

Result!

Technorati Tags: ,

Posted in Dynamics NAV / Navision, Tips & Tricks | Tagged , | 1 Comment

Automatic Cost Posting Field in Inventory Setup Table

What is “Automatic Cost Posting” field in Warehouse > Setup > Inventory Setup used for? What is the difference between having the “Automatic Cost Posting” field value set to “Yes” and “No“?

According to Dynamics NAV help files:

A check mark in this field indicates that the program will use the Automatic Cost Posting function. If you use this function when posting items to an item account, the program will automatically post to the inventory account, adjustment account and COGS account in the general ledger. If you use this function, however, it is still necessary to run the Adjust Cost – Item Entries (or use Automatic Cost Adjustment) and Post Inventory Cost to G/L batch jobs periodically.

If you only use Automatic Cost Posting, your inventory account will not be accurate in cases where you do not know the cost of items at the time of sale. For example, if you sometimes sell before buying.

So, what does it mean in simple user-friendly terms? Well, I think, the easiest way to explain things, is to show how they work. Let’s test two scenarios: posting purchase orders when “Automatic Cost Posting” is disabled and posting same (a copy of) purchase order when “Automatic Cost Posting” is enabled.

Posting Purchase Order when “Automatic Cost Posting” is set to No.
1. Set “Automatic Cost Posting” to No in Inventory Setup.
Automatic Cost Posting - No

2. Create a new purchase order. Click Posting > Post and select “Receive and Invoice”.
Automatic Cost Posting - No - Purchase Order

3. Go to Purchase > History > Posted Invoices and find newly posted purchase invoice and click Navigate.
Automatic Cost Posting - No - Navigate

4. Select “G/L Entries” and click Show and analyse posted G/L Entries.
Automatic Cost Posting - No - Posted GL Entries

Here, you will see that 3 G/L Entries have been created for posted purchase invoice. If you would drill down into G/L Accounts and click Account > Where Used, you could work out which G/L Accounts have been hit:

  • Debit 7110 – Purchase Account from General Posting Setup
  • Debit 5630 – Purchase VAT Account from VAT Posting Setup
  • Credit 5410 – Payables Account from Vendor Posting Setup

Posting Purchase Order when “Automatic Cost Posting” is set to Yes.
Let’s run through the same scenario with different setup option.

1. Set “Automatic Cost Posting” to Yes in Inventory Setup.
Automatic Cost Posting - Yes

2. Create a new purchase order. Click Posting > Post and select “Receive and Invoice”.
Automatic Cost Posting - Yes - Purchase Order

3. Go to Purchase > History > Posted Invoices and find newly posted purchase invoice and click Navigate.

Automatic Cost Posting - Yes - Purchase Invoice

4. Select “G/L Entries” and click Show and analyse posted G/L Entries.
Automatic Cost  Posting - Yes - GL Entries

Here, you will see that more G/L Entries have been created for the same (a copy of previous) purchase order. Same 3 G/L Entries for:

  • Debit 7110 – Purchase Account from General Posting Setup
  • Debit 5630 – Purchase VAT Account from VAT Posting Setup
  • Credit 5410 – Payables Account from Vendor Posting Setup

And additional G/L Entries for:

  • Debit 2110 – Inventory Account from Inventory Posting Setup
  • Credit 7191 – Direct Cost Applied Account from General Posting Setup

So, the difference between having “Yes” or “No” in Automatic Cost Posting field in Inventory Setup is how additional G/L Entries are posted (specifically, for Inventory Account, Direct Cost Applied Account, and COGS Account for Sales) – they will be either posted automatically (if field is set to “Yes”), or they will need to be posted manually (if field is set to “No”).

In order to post “remaining” G/L Entries for the first scenario (where only 3 G/L Entries have been created), we would need to run Financial Management > Inventory > Costing > Post > Post Inventory Cost to G/L batch job.

Technorati Tags: , , , ,

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 4 Comments

Error: The active fields in a record cannot take up more than 4000 bytes

Max Record Size 4KB

So, you started working on your modification in Dynamics NAV, and after adding a few new fields, you get hit by an error meesage: The active fields in a record cannot take up more than 4000 bytes. The active fields in the table take up to 4063 bytes. You must reduce the number or the length of the active fields. What?!

It seems (according to Dynamics NAV Application Designer’s Guide – and it’s also application to Dynamics NAV 2009 R2), that the maximum record size in Dynamics NAV is 4KB. Yup, that’s it… only 4 KB!

Related Links

Technorati Tags: , ,

Posted in Dynamics NAV / Navision, errors | Tagged , , | 1 Comment