Microsoft Dynamics NAV Forum - Recent Threads

Warehouse UOM Conversion

Neville Foyn — Fri, 17 May 2013 05:16:38 GMT

How would i go about putting units of measure back together in full warehousing

The Purchase order is for Each, and it is WH received in each as that is what was on the PO, i need to put pallets away though, how would i do a put away in pallets from my receiving bin which is in units? (Or is there a better / different way of doing this?)

The PO must stay in each however the process beyond that is flexible

Anyone done something like this before?

Thanks

Nev

Explicit Deny in NAV

SvenGodz — Sun, 19 May 2013 20:49:10 GMT

Is there Explicit Deny permission in NAV as SQL permission? I see only YES and Indirect.

NAV 8

MMaisch — Sun, 19 May 2013 15:59:56 GMT

I heard that we can expect new version of NAV in end of this year. Does anyone have information about this? I am not sure and I can not believe. The last version (2013) appeared at the end of last year. This means that the new version comes after only one year.

Wrong Item Price

Aless — Sun, 19 May 2013 13:23:02 GMT

I make sales order and have problem with item prices. For most of items, everythime when I try to make sales line, I get wrong price. I always get old price, although I input new price in sales prices table.

Data Validation

Aadi — Sat, 18 May 2013 08:18:23 GMT

Hi, I have NAV and LS Retail. Now i am using TS for validating the value on POS on Head office. Is there any other feature that can be used for this to make the validation faster.

FA inventory

Aless — Sat, 18 May 2013 22:57:28 GMT

How can I make fixed assests inventory in NAV? I need to do inventory every six months.

I use NAV2009R2.

New to NAV: Regarding Outlook 32/64 -bit to integrate add-in.

JithuTC (B.Tech, MBA, MCSE) — Sat, 18 May 2013 15:48:38 GMT

Hi, I installed NAV 2013 on Windows 8 with Office 2013 on a x64 machine. I was going through the initial setup of NAV 2013.

After the CRONUS demo DB was loaded, I was doing this Walkthrough: Synchronizing Information Between Outlook and Microsoft Dynamics NAV, when I came across this prerequisite" http://msdn.microsoft.com/en-us/library/dd338966%28v=nav.70%29.aspx.

On checking this out, I noticed this prerequisite "Outlook integration requires the 32-bit version of Outlook". As my Office 2013 installation was 64-bit, I'm unable to proceed with the walkthrough. Is there any alternate way to complete the integration so that I can complete the walkthrough? Is it necessary to sync the Outlook? Am I following the right tutorial for starters to NAV 2013?

Production Order refresh

bosovik — Sat, 18 May 2013 12:58:20 GMT

One more problem.

I have problem with production order. I made new work center (A) and made new routing with only one line (work center A). A assign this routing to item and I made released production order with this item source. When I start Refresh command, I get message:

Error when calculating backward. Calendar is not available before date for work center A.

Include Inventory

bosovik — Sat, 18 May 2013 11:52:02 GMT

How Include Inventory field on Item Card work? I know that means planning will be calculate with or without inventory, but how?

Correct wrong unit cost from purchasing how

ahmed barbary — Wed, 15 May 2013 17:00:57 GMT

I have item his name iron his method cost is average i do only in it purchasing it represent in my company as spare partes i only made purchase to it(no consuming no sales no production) I have transaction to it from 01-09-12 until now like following

posting date unit cost quantity

01-09-12 200 1

01-09-12 400 1

01-11-12 300 1

0-12-12 600 1

The actual unit cost is 400 and another values is wrong what i want to do is make unit cost to this items for all unites purchasing is 400 meaning i need to correct (200,300,600) to 400 what i do to change this values

Field User ID of G/L Entries and the other entries is not correct.

Linh Linh — Wed, 13 Mar 2013 13:45:49 GMT

Dear everyone,

I encounter a strange situation about data of User ID field of G/L Entry table.

Most of record the User ID data is exactly the id of user who log in to RTC, but some remaining is wrong. I dont know where the system get these values.

EX: My end user id is ACC_01 but when create a journal and post, the system insert in to USER ID field as TÀS4`ELATIN_100

Here is some strange values:

´¾̃:NAL BATCH NAME

ÄËÑE´́ÑE„ÍÑEHA_NTL

TÀS4`ELATIN_100

RECURRING FREQUENCY

APPLIES-TO ENTRY

This problem happen for all program area and all screen that has User ID (Posted Sales Invoice, Gl Register, Item Register, Customer Ledger entries...).

Some transaction need to authorize to run by setup user's permission is also difficult to use the system because sometime the permission is not recognized due to USERID wrong such as Posting Range of user when runing Post to G/L batch job.

In this situation, the solution we give to the user is close NAV and restart again.

So any advise, clue... please give us to find the solution to fix it. Many thanks to NAV community.

Number of report executed

mariyana — Fri, 17 May 2013 20:55:10 GMT

I want to make how many times is each report executed.

Is there a universal solution? I don't want customize each report.

NAV and SharePoint 2013

ryk — Fri, 08 Feb 2013 20:43:58 GMT

Can anyone address NAV 2013 SharePoint client compatibility with SharePoint 2013 (SharePoint client and web parts)? SharePoint 2013 has the 2010 mode but is it at all compatible with NAV 2013? Furthermore, are there any compatibility issues with SharePoint 2013 and NAV 2009?

Excel PowerPivot as a way to replace the Inventory Valuation report?

John Bellinger — Thu, 09 May 2013 13:22:09 GMT

NAV2009 R2 (Version US Dynamics NAV 6.0 SP1)

I built an Excel Power Pivot worksheet as a way to replace the out of the box Inventory Valuation report (I think). I’m getting results that agree to that report (in my limited testing). I’m wondering if anyone else has used this method and can share their experience. ??

I used the Value Entry table; this is what my Query looks like;

SELECT [dbo].[MYCOMPANY$Value Entry].[Item No_],

[dbo].[MYCOMPANY$Value Entry].[Location Code],

SUM (

[dbo].[MYCOMPANY$Value Entry].[Cost Amount (Actual)] +

[dbo].[MYCOMPANY$Value Entry].[Cost Amount (Expected)] ) AS [Cost Amount] ,

SUM (

[dbo].[MYCOMPANY$Value Entry].[Item Ledger Entry Quantity] ) AS [Item Ledger Entry Quantity]

FROM

[dbo].[MYCOMPANY$Value Entry]

WHERE

[dbo].[MYCOMPANY$Value Entry].[Item No_] <> '' AND

[dbo].[MYCOMPANY$Value Entry].[Posting Date] <= '01/31/2013'

GROUP BY

[dbo].[MYCOMPANY$Value Entry].[Item No_],

[dbo].[MYCOMPANY$Value Entry].[Location Code]

I related the Item and Item Category tables for descriptions and categorization (by Item Category code).

Processing is much more acceptable in PowerPivot vs. NAV, not to mention analysis reporting potential (slice/dice information and graphical presentations). Of course, this assumes I’m getting the results I expect (Inventory Valuation as of a defined date).

Any experiences would be appreciated.

Thanks.

OpenOffice instead of MS Office

Aleksandar Totovic — Fri, 17 May 2013 12:13:00 GMT

I am not sure, but I have client who doesn't use MS Office. Of course, he want to use OpenOffice integrated with NAV (I mean on commands "Send to Word/Excel"). This I have never tried to do. NAV is 2009R2 Classic.

Dynamics NAV 2013 for process manufacturing

will2power — Wed, 08 May 2013 18:19:32 GMT

We're an ink manufacturer that works with formulas and batches with very little discrete manufacturing. I have read literature that says NAV can help with Formulas and MSDS --but I haven't seen anywhere to find out how people are doing this. Looking at the demo --it seems to be more setup for discrete manufacturing. From the stuff I read, I thought it would have chemical as an option. Am I missing something?

License Information

nenada — Fri, 17 May 2013 10:48:55 GMT

Who can be explain functions on License Information Form?

For what we use Upload, Import, Export and Change?

Customer Balance on Vendor Card...

IMSA — Fri, 17 May 2013 08:25:25 GMT

What I need to do to have Customer Balance on Vendor Card and Vendor Balance on Customer Card? All of this I want to have because analysis. I have many customers who are also vendors.

Internal Service

Aleksandar Totovic — Mon, 06 May 2013 22:37:34 GMT

Has anyone used the Service Management module, to post maintenance its own FA? Standard service items can be used only for external service, not for internal use.

Inventory Valuation Report

Aleksandar Totovic — Thu, 16 May 2013 08:04:18 GMT

If anyone has a problem with the response for report 1001-Inventory Valuation on NAV2009R2 RTC? When I start form classic, everything is OK, but from RTC I have terrible response.

Scrap in production

lylaboso — Thu, 16 May 2013 22:24:59 GMT

I have production of metal elements. In every production order, I have the scrap output and this is my problem.

I know, in NAV exist scrap evidency, but it doesn't work as I want. I want to have inventory evidence for scrap, because I need to sell metal scrap.

I need to post scrap output per production order. I use FIFO costing method for goods and I want that scrap have 0,00 cost, because I want to all production order cost go to main goods, not to scrap.

I want only material evidency (no cost, only quantity) for scrap because I want to sell it.

Any idea?

Warehouse Shipment

IMSA — Thu, 16 May 2013 21:44:40 GMT

I try to test warehouse shipment functionality, but everytime when I try to put location code, I get only one location.

Problem is, this is wrong location.

If this is important, I use NAV2009R2 classic client.

Microsoft NAV 2013 and JAWS

kcongleton — Thu, 16 May 2013 18:51:38 GMT

Is anyone using the JAWS screen reader software with NAV 2009 or NAV 2013? How easy or hard was it to setup?

Can you get OneNote on a ListPlus Page

Dan Eckhoff — Thu, 16 May 2013 15:07:09 GMT

I don't see any ability to put the OneNote solution on a ListPlus Page. Specifically, we are looking at page 5050 Contacts Card. Is this embedded as the page type or is there a parameter that can be set?

Email logging on the Web Client

Helen Smith — Thu, 16 May 2013 15:21:08 GMT

If a salesperson is using the NAV Web Client but has an Exchange email account does the email logging work (if set up correctly)?

NAV, Traditional Chinese language support in a non-unicode database sql

Roberto Stefanetti — Sun, 12 May 2013 06:39:05 GMT

Good morning

I have a database that I would like to upgrade from NAV 5 to NAV2013, currently the collaction is 'latin general', without unicode support (it's an very old database)

A brief should enable a communication channel e-commerce platform that gives orders in Navision e-commerce, these orders using the Traditional Chinese language with their own characters (ideograms etc.).

What can I do to correctly handle these characters in Nav ? (now I can not see them in NAV)?

1) Convert the db by switching to unicode (there might be potential problems of space, performance problems etc.).

2) Leave the db as it is and create sql function (or stored procedures) or use. NET to handle the character mapping (Nav then enter the converts from ideograms)

3) Create a new unicode db and execute a data migration

There are other possibilities or advice on this subject?

I would like to implement the best solution

Thanks for support

Resources and Items in the same Journal

mariyana — Thu, 16 May 2013 13:48:02 GMT

Can I post a consumption of resources and items using the same journal?

Post invoice with services spread over several periods

Mone — Thu, 16 May 2013 13:18:08 GMT

How would I post an invoice lets say, insurance invoice received in January, covering period from January to December, without having to created reccuring journals?

Cross-selling

nenada — Thu, 16 May 2013 07:49:28 GMT

Does NAV2009 or NAV2013 have cross-selling functionality?

Web Service Dates NAV 2009 RTC

Neville Foyn — Thu, 16 May 2013 04:55:31 GMT

We have an integration in NAV 2009 RTC where the third party software creates a sales order with a web service, this sales order is a published page in NAV

The problem is that the date/time being populated by the external software does not match with what appears in NAV, although the servers are both set to the same timezone we think it has something to do with the timezone on the web service vs the timezone showing in NAV.

Anyone have the theory behind how the dates/times work with webservices?

Thanks

Navision in Singapore

Vonn — Thu, 16 May 2013 09:23:05 GMT

Hi,

Our server and Navision software is located near Boston in USA.

We are interested to transfer it to Singapore and possibility engage someone in Singapore as a consultant to maintain it.

Please advise if you provide such service and the fee that you charge?

Thanks.

Best Regards,

Vonn Wong (Ms)

HP: +65 96387191

RTC NAV 2009 with Citrix / Design

Marhune — Tue, 14 May 2013 15:06:57 GMT

if i start the RTC with a Citrix Receiver the design turns to very unadorned. Obviously it comes from the also unadorned design theme from MS Server 2008, where the Client is installed. All tables are blank. Is there an opportunity to fix it?

New to NAV

JithuTC (B.Tech, MBA, MCSE) — Mon, 13 May 2013 20:23:29 GMT

Hi, I'm new to MS Dynamics NAV. Could someone please provide me info on where to start, like, from where I can download a demo of the software & a specific beginner's tutorial guide?

Kitting and Disassembly

rschaefer — Mon, 13 May 2013 19:57:24 GMT

Maybe I'm doing this incorrectly. If I have a return for an item has a kit bom, is there an extra step that I have to take in order for the components of the kit to be returned as well? As of right now, the main item goes back into inventory, the components do not.

Thanks in advance for your help.

Implementing NAV 2009 SSL Web Services for Three Tiers on Three Computers

Mohamad El-Sadek — Wed, 15 May 2013 13:59:23 GMT

Hi all,

OK, so this might be the mother of all complex NAV 2009 deployments, but this is the NAV community, so I hope you can give me some answers.

Our client requires implementing SSL web services for their NAV 2009 implementation. I have already set them up for Three tiers on Three computers (as per their request), and I also successfully configured basic non-SSL web services, and they both work beautifully. I can access my webservices from the Dynamics NAV Server PC, from within the domain, and from outside the domain. I've setup the SPNs and everything WAS just humming and singing along nicely.

Now...they want us to configure the webservices to use SSL. So, I went through the following steps, as per all the MSDN documentation I could find:

1) Get the SSL certificate

2) Save it to the local Computer store

3) Fetch the certificate thumbprint

4) Use "netsh http" to register url acls - httpcfg was garbage...I continued to get the return code 183.

5) I changed the CustomSettings.config to enable SSL webservices

6) Restarted BOTH Dynamics NAV service and Web Services service

And now...I get an HTTP 500 Internal Error when I try to access the webservices from Internet Explorer. I changed the IE settings so I no longer see friendly error messages, and I found out that it was a NavPasswordException error. It turns out with SSL, My SQL Server is no longer accepting my login credentials, EVEN THOUGH THEY ARE EXACTLY THE SAME AS BEFORE SSL.

Now I got the same error message before when trying to run web services without SSL, and I was able to solve this by adding the SPNs and removing any duplicates that were found. And although it did work without SSL, now with SSL and even after adding the SPNs it is not working.

What I am missing here? Please help me out. I'll wait for your feedback.

Regards,

Item tracking line

sanjaypandey20@live.com — Wed, 15 May 2013 12:45:59 GMT

I need to insert lot no. in warehouse shipment line, but this field is disable, what wrong in setup, I already mentioned item tracking code in item master card.

NAV 2013 for Stationery Manufacturing

Venkatanarayanan Ramamoorthy — Sun, 07 Apr 2013 08:34:01 GMT

We have a prospect who is into Stationery Manufacturing (Diaries, Note books, Organizers etc). I would like to know how much NAV 2013 will fit in this industry? Has any one implemented NAV 2013 for this industry and what are the challenges? Just to know whether the standard MFG module will fit in this process or a huge customization?

Any inputs will be appreciated

Item Revaluation Journal - possible Bug?

Jens Glathe — Tue, 14 May 2013 15:42:06 GMT

Hi there,

I'm just checking the item revaluation for our year's end closing and I came across a possible bug. It concerns the entries allowed for revaluation. As it is now coded in R5899 "Calculate Inventory Value", not all item ledger entries are considered for the inventory value at date.

When calculated by item, the item ledger entries are traversed and written into a buffer:

InsertValJnlBuffer(
ItemLedgEntry."Item No.",ItemLedgEntry."Variant Code",
ItemLedgEntry."Location Code",RemQty,
ItemLedgEntry.CalculateRemInventoryValue(ItemLedgEntry."Entry No.",ItemLedgEntry.Quantity,RemQty,
IncludeExpectedCost AND NOT ItemLedgEntry."Completely Invoiced",PostingDate));

Function IncludeEntryInCalc(ItemLedgEntry : Record "Item Ledger Entry";PostingDate : Date;IncludeExpectedCost : Boolean) : Boolean
WITH ItemLedgEntry DO BEGIN
IF IncludeExpectedCost THEN
EXIT("Posting Date" IN [0D..PostingDate]);
EXIT("Completely Invoiced" AND ("Last Invoice Date" IN [0D..PostingDate]));
END;

And the function in Item Ledger Entry:

CalculateRemQuantity(ItemLedgEntryNo : Integer;PostingDate : Date) : Decimal
ItemApplnEntry.SETCURRENTKEY("Inbound Item Entry No.");
ItemApplnEntry.SETRANGE("Inbound Item Entry No.",ItemLedgEntryNo);
RemQty := 0;
IF ItemApplnEntry.FINDSET THEN
REPEAT
IF ItemApplnEntry."Posting Date" <= PostingDate THEN
RemQty += ItemApplnEntry.Quantity;
UNTIL ItemApplnEntry.NEXT = 0;
EXIT(RemQty);

Basically, what you can see is that the remaining quantity of the item ledger entry is calculated at valuation date by traversing the item application entries, regardless of the "open" flag of the item ledger entry. But it is not handled this way when the completely invoiced state is checked, or the last invoicing date. But these are also time-dependent. This leads to some questions:

The quantity to be revalued differs from the physical inventory of this date. But why? Because you have entries not completely invoiced (what about partially invoiced?), so you can't touch them.
If an item ledger entry gets completely invoiced at a later date and you want to revaluate at an earlier date (year's end closing), you can't do this. I have not understood why, since it's a valuation at date. Adjust Cost Item Entries would take care of subsequent invoices and adjust the changed cost accordingly.

It is pretty difficult to allocate a global revaluation to the items this way, since your base for the revaluation doesn't match with the physical inventory. and it prompts questions from auditors.

Can anybody shed some light on this? Thanks in advance.

with best regards

Warehouse Management Whitepaper

Neville Foyn — Tue, 14 May 2013 06:38:40 GMT

Anyone know if there is a warehouse management whitepaper for NAV 2009, i have the v5 & 2013 papers but will be doing an implementation of 2009 soon so would like to read through that was well if it exists

Cheers

Nev

Change Log

nenada — Tue, 14 May 2013 05:54:32 GMT

I use NAV2009R2. I have many mistakes by users, because they often change the settings. I want to activate Change Log in few tables, but I am afraid about log size. Where I can follow log size?

MS Dynamics Nav - e-commerce website

TElliott — Mon, 12 Jul 2010 09:27:53 GMT

Hi There, I apologise if this has been asked before but so far been unable to find anything on-line... Our client uses MS Dynamics Nav as their ERP system and they want to develop 2-3 e-commerce websites which need to integrate order details within MS Nav. The site would need to update MS Nav data, such as stock levels, and read data from MS Nav. We want to create the e-commerce websites in PHP and MySQL with payment processing (either external or on-site). My questions are: 1) Is this actually possible? Can we develop the e-commerce site in PHP first and then integrate MS Nav once the whole site and e-commerce is up and running? 2) If it is possible, how would I start implementing the integration? I can't find any on-line resources\help on this so if anyone could point me in the right direction... 3) Any other advice - tips, things to avoid etc will be appreciated! Many thanks, Tom

Fixed Asset -> Declining Balance 1

nv3rma — Sun, 12 May 2013 02:14:10 GMT

I created an Fixed Asset with the following book value ($1500), depreciation method is declining balance 1, with declining balance % = 4. However, in the first year, the calculated deprecation should be 50% of the book value ($750) and afterwards, it should depreciate be 4% every year.

How can I set this up.

Internal goods consumption and planning

mariyana — Mon, 13 May 2013 15:16:10 GMT

I post goods for internal consumption through Item Journals (Negative Adjmt.) and this is OK.

I have problem when I want to buy something for internal consumption. When I put desired Iten No. and Quantity, they are not reflected in Requisition Worksheets, I have small nventory for such goods and this is very often event. We have to write this items on paper. How to automate this process in NAV? Where I can put planned consumption goods (not in budget) so as to affect to item availability.

NAV 2009 - alternate base unit of measure?

Ernie Zeitz — Thu, 04 Apr 2013 21:05:28 GMT

I have a requirement to store exactly the same product in two units of measure (bag, and pallet). The scenario is that I will need to Manufacture some in 'bag' quantities and more in 'pallet' quantities (a pallet is 12 bags).

I would like to keep the same Item number and they will be stored in the same Location, ultimately I need to be able to look at inventory and determine that I have 24 pallets and 15 bags (24 X 12 + 15 = 303 bags).

Simple is best - any suggestions?

Dimension reposting

IMSA — Mon, 13 May 2013 12:56:45 GMT

During the posting specific entries I don't know exactly dimension and I post everything on one common dimension per one account. After that, on the end of months I post correction and repost to proper dimensions. I made estimate about percentage; percentage is not the same every month. This is a lot of work. Is there an utomatic?

I use NAV2009R2 classic.

NAV2009 to NAV2013

IMSA — Mon, 13 May 2013 12:53:54 GMT

I have NAV2009R2 and I want to upgrade license to NAV2013. I currently use Business Ready AM license and I have Basic Supply Planning, Demand Forecasting and Machine Centers added granules. I heard that if I migrate license I will get all NAV modules.

I am specialy interesting in Warehouse Management Systems and Service Management. Is this true?

Global Dimension 1 & 2 on G/L Account (Table15) - NAV2009

Michel Stoelman — Mon, 13 May 2013 08:28:20 GMT

Hi,

At the moment posting are made on global dimension 1 & 2 on the G/L entry table (table17) and I'm able to get the data I need by extracting this table. However because it's on the G/L entry level I get over a Million lines for one month so a multible month extract to excel is not possible.

I noticed on Table 15 (G/L Account) the Global dimensions 1 & 2 are also present, I would expect this table to show me the total of each dimension value for the period but is completly blank?

Could someone please help me how I should treat this so I can just extract table 17 and just have the totale per GL Account and Dimension value for the given perion

Thanks

Michel

Unapplying entry from a card in ARC

Iacovos Kakathimis — Mon, 06 Sep 2010 06:46:02 GMT

Hi people

There is a bug when you unapply an entry in a card (vendor or customer) which is in additional reporting currency (ARC). In the initial application entry the LCY is adjusted and the ARC remains zero. However, if you decide to unapply this entry Navision calculates an ARC amount when it shouldn't. That's because the ARC is the Customer/Vendor currency and applications of payments to invoices to not affect their currency.

Using NAV 5.1

http://www.mibuso.com/forum/viewtopic.php?f=23&t=43185

Thanks in advance!

NAV09 R2 Client very slow loading

Kareem — Tue, 16 Apr 2013 07:38:40 GMT

Hi, Nav2009 R2 + LS Retail 6.4, client takes too much time to load. If network is disabled it loads normally and fast. No polices running on domain. Anyone can advice?

MS Word Automation Numered List

Fausto Serrata — Wed, 08 May 2013 16:13:58 GMT

Hi.

I want to program, from Dynamics Navision 2009 C/Side code, a function that generates in Word a numered list as show below.

Textx
Textx
textxx
text
text

I know how to create, save and open the document. Also know how to insert text, tabs, and other things. But I could not manage to insert a numered list.

That's my problem.

Any Idea.