How to delete ZUP file for Dynamics NAV in Windows 7?

In older Dynamics NAV versions (and obviously, working on Windows XP), I needed to delete ZUP files quite often. Now, when I think back, maybe too often… Anyway, C:\Documents and Settings\YourUsername\Application Data\ path (that’s where ZUP files were saved in Windows XP) has been rooted down into my memory for ever. However, recently I was asked how to delete the ZUP file for Dynamics NAV in Windows 7, and my default answer (Documents and Settings) did not work!

It took me a minute or two, to find where the ZUP file resides in Windows 7, and while I haven’t memorized it yet, it might be a good idea to write this down.

How to delete ZUP file in Dynamics NAV in Windows 7

Start “My Computer”. Go to C:\Users\. Find your username (in my instance, it is TomasZ) and go into that folder.
Delete ZUP file - Users
Now, do you see a folder called “AppData”? If not, don’t worry, the folder is hidden. Click ALT+T on your keyboard (this will open Tools menu) and select “Folder Options”.
Delete ZUP file - Tools Folder Options
Click on tab “View”, and find property “Hidden files and folders”. You will need to click on “Show hidden files, folders, and drives“, in order to see “AppData” folder. Click OK.
Delete ZUP file - View Tab
Result (now you can see the AppData folder)!
Delete ZUP file - AppData Folder
But the job isn’t done yet. We need to go into AppData folder, and then into Roaming folder. So, now you should be in C:\Users\USERNAME\AppData\Roaming\. You will find your ZUP files at the bottom of this folder.
Delete ZUP file - fin.zup file
Click on the fin.ZUP file and delete it. The next time you start Dynamics NAV, the program will create a new, clean fin.zup file.

Related Links

Technorati Tags: , , ,

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

Error: BACS Exported must be No in Gen. Journal Line Journal Template Name=’PAYMENT’,Journal Batch Name=’GIRO’,Line No.=’10000′.

Once in a while someone will ask me: could you reset “BACS Exported” on Payment Journal for me? When faced with this question for the first time, my first though was – but why?

And scenario is quite simple. Imagine that you are working on a payment journal, applying entries to be paid, and you export BACS file to be sent to bank. However, when exporting the file, you received some funny error message (usually, if you try to save a file in the folder, where you do not have permissions to write), and the file was not exported. So, what do you do?

If you will try to export the BACS file, you will get a message saying that there is nothing to export.
Payment Journal - Nothing to export
Which is fair enough, system knows that you already exported the BACS file and there is no need to export a duplicate. If you will try to delete the payment journal, with an idea of starting from scratch again, you will get another error message, saying that BACS Exported must be No.
Payment Journal - BACS Exported must be No
And then, if it has been a long day, Eureka! moment might hit you – let’s manually set “BACS Exported” to No and let’s export the BACS file again. But, if you will add “BACS Exported” field to the payment journal, you will see, that field is not editable.
Payment Journal - Payment Journal with BACS Exported
In fact, even if you will go to Gen. Journal Line table directly, and try to change the field “BACS Exported” to No in Object Designer, you will not be able to do that – field is not editable!
Payment Journal - BACS Exported Field Not Editable
And there is a reason for that is – when you export BACS file, BACS Ledger Entries are created. Therefore, by setting “BACS Exported” to No, you would do only half of the job required. Instead, you need to Void BACS for all lines and export file again.

How to set “BACS Exported” field to No in Payment Journal in Dynamics NAV
1. Go to Financial Management > Cash Management > Payment Journals.
2. Click Payments > Void all BACS (if you will click Payment > Void BACS, it will only void active payment journal line).
Payment Journal - Payments - Void All BACS
3. Click Payments > Export BACS again.
Payment Journal - Successfully exported

Result!

Technorati Tags: , , , ,

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

How to publish Dynamics NAV Web Services?

Today, I was asked – how do I publish Dynammics NAV web services?

That’s easy… click “Published”! – was my short answer. And only then I realized, that if you have never done this before, my short answer (even though I said almost everything you need to know), might not be that helpful.

How to publish Dynamics NAV Web Services:
1. Click Tools > Object Designer (or SHIFT+F12), find form 810 “Web Services” and run it.
FORM810 Web Services
2. Select what you want to publish (Page or Codeunit), enter object ID, the name you want to use for web services, and click “Published”.
Publish Web Services

You can also do this from Dynamics NAV RoleTailored client. Instead of going to Object Designer, click Departments > Administration > IT Administration > General > Web Services and do the same thing.

Result!

Related Links

Technorati Tags: , , ,

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

How to find the size of the Company in Dynamics NAV?

I would like to share a quick and easy (well, maybe not the best way of doing things, but it gets results quite quickly) on how to check the size of the company in Dynamics NAV. Let’s say, you need to provide an estimate of how long data migration might take when doing Dynamics NAV upgrade. And there is one caveat – your database has 19 companies…

So, to check, where you will spend most of your data-migration time, it might be a good idea to check the size of your companies. And the last time I needed to do that, I followed these steps:

1. File > Database > Information
Company Size - File Database Information
2. Click on Tables
Company Size - Database Information
3. Select all records and click Edit > Copy (or CTRL+C)
Company Size - Database Information (Tables)
4. Open Excel and click Edit > Paste (or CTRL+V)
Company Size - Paste In Excel
5. Sort by column “Company Name” and subtotal by “Company Name”
Company Size -  Subtotal in Excel
6. This gets a total size for each company (calculated in KB – but in Excel it will be easy to change this into anything you like – MB, GB, etc)
Company Size - Size of companies

Result!

Here, we are utilizing default Dynamics NAV functionality “Database Information (Tables)” which allows us to check how effectively the database is being utilized. Each table has a set of values that tells you:

Company Name
The name of the company to which the table on the line belongs.

Table No.
The number of the table (each table in Microsoft Dynamics NAV has a unique number).

Table Name
The name of the table. This is not the name of the window that displays the table in the system, but the name that is used when you choose Tools, Object Designer. However, these names can often be the same.

No. of Records
The number of records (entries) in the table. By keeping track of how many new records have been added during a certain period, you can estimate the number of records you can expect in the next period. Combine this with the record size in the Record Size field and you can see whether you will have enough space in your database to meet your requirements.

Record Size
The average number of bytes per record in the table. This can be used as described under the Records field.

Size(KB)
The total size of the table, in kilobytes.

If you know a better (faster or geekier) way of achieving same result, please let me know! Thank you.

Technorati Tags: , , ,

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

How to add user as Warehouse Employee for Multiple Locations

It is quite easy to create a new Warehouse Employee record for a user in Dynamics NAV. You just go to Administration > Application Setup > Warehouse > Setup – Warehouse > Employees, create a new record, assign a location code and you are done. It becomes a little bit more difficult when you have more than 10 Locations, but the concept is more or less the same, right?

I have seen so many times people clicking F8 on User ID column, then F6 on Location Code, and again F8 on User ID column, F6 on Location Code, and again… when trying to create one warehouse employee record at a time for a user for multiple locations. This activity might be quite common, when you need to create test databases and new users for testing various warehouse operations. To be fair, I have done this myself (F8, Enter, F6, Enter), quite a few times, but then I was shown a faster way!

Whenever you need to create a set of warehouse employee records for the same user for multiple locations, follow these steps: Run “Warehouse Employees” form from Object Designer (who can remember these menusuite paths anyway?),
Warehouse Employee - Object Designer
find an existing user that has Locations already assigned to him, select all records and click Edit > Copy (or CTRL+C),
Warehouse Employee - Existing User
click on User ID column, and filter (F7) with new User ID (in my example, I am creating Warehouse Employee records for USER2),
Warehouse Employee - Filter on User ID
click Edit > Paste (CTRL+V),
Warehouse Employee - Edit - Paste
which adds user as Warehouse Employee for Multiple Locations.
Warehouse Employee - New User Added for Multiple Locations

It’s the bit of default Dynamics NAV functionality, that you do not really need to survive in your daily life, but then again, it will hopefully save a little bit of your precious time.

Result!

Technorati Tags: , , , , , ,

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

What is Permissions Property in Dynamics NAV Object?

I have explained how to find and add permissions in Dynamics NAV, if you start getting error messages: You do not have permission to read TABLE table. However, there is another way (which is sometimes necessary for developer to use rather than for end-user) – assinging permissions directly to Object (table, form, report, dataport, xmlport, codeunit, page – every object except MenuSuite.

Basically, the license file (your fin.flf) determines the permissions that users have within Microsoft Dynamics NAV. These permissions are further filtered (restricted) by the security permissions that you grant the different users.
However, sometimes the license file only gives you indirect permission to perform operations on certain tables. If you only have indirect permission to, for example, insert data into a particular table, you cannot insert data into this table from the standard user interface. You must use a database object that has been given extra permission to insert data into the table in question.

Note
After you set the Permissions property of an object, only users with direct permission to perform all the extra operations that the object has been given can modify this object.

Do not use the Permissions property to give extra permissions to an object that you would like your users to be able to modify. These users might not have direct permission to perform these operations. This is why you should be careful when you use the Permissions property for tables and forms.

A great example could be codeunit 80 “Sales-Post”. If you would design the codeunit,
Permissions Property - Design Codeunit 80
and click View > Properties (or SHIFT+F4), find property called “Permissions”,
Permissions Property - Find a property
Click on “Value” column for “Permissions” property and drill down into Permissions (or click F6):
Permissions Property - Actual Permissions

So, as you can see, default Dynamics NAV Codeunit 80 “Sales-Post”, gives users indirect permissions to Insert/Modify/Delete Sales Line table, only to Modify Purchase Header, etc.

Technorati Tags: , , , ,

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

How to change Unit of Measure for Bin Contents record in Dynamics NAV

When trying to change status for production order from released to finished in Dynamics NAV, I have received error message saying: “The Bin Content does not exist“. After further analysis, I have found that production order had components set to be backflushed, so the first thought – we don’t have enough stock! However, the stock was there… plenty of it. Just, in the wrong (that is, different) unit of measure. And when the system was trying to backflush consumptions, it was trying to do so using “Unit of Measure” code from prod. order component lines.

After scratching my head for a minute, I decided that the quickest way of solving this issue would be to change Unit Of Measure Code for existing Bin Contents to match Unit of Measure defined on Prod. Order Component. However… I haven’t done this before…

How do you change Unit of Measure for your Bin Content in Dynamics NAV?

Go to Warehouse > Planning & Execution > Movement Worksheet and click Functions > Get Bin Content…
Change Unit of Measure - Movement Worksheet - Get Bin Content
In the request form, enter filters (your item, in this example, we will use LS-120, location, bin code, etc):
Change Unit of Measure - Movement Worksheet - Get Bin Content - Request Form
This will create a new line in Movement Worksheet with “From Bin Code” field filled in, and with blank “To Bin Code” field.
Change Unit of Measure - Movement Worksheet Line From
Enter “To Bin Code” (you can actually use “From Bin Code” field value, if the stock is in the right bin, but with the wrong Unit of Measure).
Change Unit of Measure - Movement Worksheet Line To
And click Functions > Create Movement…
Change Unit of Measure - Functions - Create Movement
This will create a new movement (take a note of the movement number):
Change Unit of Measure - Movement Created
Go to Warehouse > Goods Handling Multiple Orders > Movements and find your new Movement. You will notice that there are two lines – one to Take the stock from Bin Content and another to Place the stock back to another (or same) bin.
Change Unit of Measure - Warehouse Movement
Click Functions > Change Unit Of Measure…
Change Unit of Measure - Functions - Change Unit of Measure
In the request form, you can select any other unit of measure that is available for the item (in our example, we need boxes, so let’s select BOX). And click OK.
Change Unit of Measure - Whse. Change Unit Of Measure
This will result in Place line being changed to use new Unit Of Measure.
Change Unit of Measure - Warehouse Movement With Changed UOM
Now, if you would click Registering > Register Movement, system will create a new bin content record with new Unit of Measure (and I will be able to finish my production order with back-flush consumption).

Result!

Technorati Tags: , , ,

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