-
THE RAID 5 thread
I've had it, this RAID 5 thing is driving me nuts! When I went to training, the Navision trainer (someone who actually was one of THE Navision developers in the US) told us that RAID 5 was the cause of database corruption, and was a performance killer in every case, so it is bad to use this. Since then I have tried and…
-
WebServicesUseNTLMAuthentication
Hi All, Using NAV 2009 R2 facing issue in WebServices ie., Able to view the web service URL in the browser when WebServicesUseNTLMAuthentication is false in the CustomSetting config file. Attached login issue occurs in the browser when WebServicesUseNTLMAuthentication is set to True in CustomSetting config file. and also…
-
problem when adjust cost item entries
Hello 1-well I COM to launch adjustment of cost item but during the adjustment process it blocks me a message display here : WRITING BOOK ARTICLE NO SEQUENCE Do NOT EXCISTE. 2-
-
Unique Record Filtering
Hi, I need to filter the main project and show the data in excel filtering on date range, the condition is the same name must not repeat Eg: In this case the name "BEAS PROJECTS - DIRECT" comes twice, it must come once.. I tried following code: i := 1; Rec50023.RESET; Rec50023.SETRANGE("Start Date",StartDate,EndDate); IF…
-
Extracting all distinct option strong values
Hi there Has anyone ever tried to extract all option string from NAV, i.e. iterating over every option field of every table and returning the text value of these option fields in a given language? Thanks
-
Dynamics NAV 2009 R2 | OLE control or Automation server
Hi Everyone, I have an issue on posting invoices in my Dynamics NAV 2009 R2 with the Portuguese location. When I try posting an invoice in classic or RTC happens the same. My Dynamics was installed and the HOTFIX KB2496107 also. All objects are compiled. Anyone know more about this issue? Best Regards. ///*** menssage…
-
Update Bin Inventory from Adjustment Bin to Transaction Bin
After posting a transaction, the warehouse entries are updated for the Adjustment Bin in the Location. How do I create or transfer the inventory from Adjustment Bin to my transaction Bin?
-
internal error 8 in module 60
I cant find any information about this error. Anyone got a clue? We sometimes get this error but has not yet been able to reproduce it. Client 5.0 sp1 build 29729
-
Fixed Filetype Dataport issue
Hi, when i try to import txt file contains "R12000025918905708201" using fixed filetype dataport. startpos includes quote. i need to ignore the starting and ending quotes. i know that i can do this using variable type dataport, but i need to use it in fixed type dataport. pls help. thank you, shyam
-
Concat Code & Text
Hello, I tried to concat Code with Text. I have table with item categories and need to save categories (code) as text to Item table. Format: "#cat1#cat2#cat3#". My attempt:REPEAT lteCategories := lteCategories+lreItemCategories."Category Code"; lteCategories := lteCategories+'#';
UNTIL lreItemCategories.NEXT() = 0; But it…
-
Going from NAV 4.0 SP3 build 23305 with native DB to build 26565
Is there anything special that needs to be done or anything negative that will happen when going from NAV 4.0 SP3 build 23305 with native DB to build 26565 clients? I couldn't find anything anywhere that states there would be problems or updates to the native db when going directly from 23305 to 26565 build. My plan is to…
-
Open PDF and Search
We are running NAV2009 R2 platform How do you open a pdf file and search for content direct from NAV?
-
Display number of attachments (links)
Hello, Is it possible to show number of links? For example, show number of links with extension jpg or png in Item form?
-
Reverse Credit Memo
We have a Sales Order with an Item and a G/L Account Line. The total for the Order is $950. Order was posted. Customer made the payment of $935 (which was registered in NAV using Cash Receipt Journal). The remaining on the order was 15$. User accidently created a Credit Memo for $950 (instead of $15) and applied it against…
-
NAV remittance and bank account
Hi! We have a customer who want's to pay to foreign countries using the remittance (norwegian). And in order to do so, there are a lot of things to set up, Among all these things, you have to set up bank accounts in NAV. Our customer have just one bankaccount in their bank, even though they pay to different countries. And…
-
Default Role Center
How to track changes done in User Personalization Card, user can't find the source table (User Personalization 2000000073) under change log setup. Microsoft by default hard code only view-able until source table 2000000006 so we wanted to ask, what is the impact if we allow the range up till 2000000073++
-
Unable to register WinForms.tlb when installing Nav 2015 client Rollup 9 and 13
Hi, I am trying to install the Nav 2015 client on 3 of our terminals. Only everytime I get the following error: Microsoft Dynamics NAV build 41779
Foutrapport
Client
Client-onderdelen van Microsoft Dynamics NAV
Onherstelbare fout bij installatie. Kan geen typebibliotheek registreren voor bestand C:\Program Files…
-
Setting default column width in table field containing BLOB
Hi everyone, I am trying to make progress bar summary by this tutorial: https://olofsimren.com/custom-progress-bar-in-dynamics-nav-2013-r2/ , but I am stuck with default visibility for the first view of List Page. So I tried to set up default value of the field, where the progress bar is. But I got an error saying, that I…
-
Get record and check field value in one "IF" statement
Is it safe to get record and check it's field's value in one "IF" statement? For example: IF UserSetup.GET(USERID) AND (UserSetup."Main Menu ID" <> 0) THEN BEGIN //do something
END; looks like this is works fine, but IF (UserSetup."Main Menu ID" <> 0) AND UserSetup.GET(USERID) THEN BEGIN //do something
END; don't works and…
-
Scanning Invoices (TWAIN?)
Hello, I am looking for a solution to activate a scanner from Microsoft Dynamics Nav using automation. I was looking on the internet for some freeware programs that I could use and with the use of automation, scan a document and once scanned, move it to another configured location. I hope someone can help me. Thanks in…
-
controls in the subform
I am trying to to calculate a value if a column on a subform is hidden by the user. I was wondering if there is something along these lines that would work? SKUList is the subform and Inventory is the column that can be hidden by the user. IF CurrForm.SKUList.FORM.Inventory(VISIBLE) = FALSE THEN CALCFIELDS(Inventory);
-
To save a file in a folder with a different user
Hi, We are currently using Nav 5.0. We have a requirement where we need to save a file generated by NAV in a folder that is not accessible by the user (Read Only) running the report. Is there a way we can force the report to run as a different use that has access on this folder? The reason is so that the person generating…
-
Error: You cannot base a date calculation on an undefined date
Hi Friends, I got struck up in a place where got an error... [b]You cannot base a date calculation on an undefined date. Date: 0D
Formula: +1M[/b] On activating the Debugger, I found that it shows an error in a code which is given below: dtOldStart := dtStart;
CASE recServConHead."Invoice Period" OF recServConHead."Invoice…
-
New user has to re-open database and company every time
I recently added a new user to our Navision app. (NAV 5.0 SP1) and just got an email with the following: "... every time she logs out of NAV she needs to re-open the Database and Company. Usually, you open these once and they stay. I’m not sure if it’s something with her setup, computer, or NAV itself ..." I looked around…
-
Deactivate/Remove "Directed put-away and pick" in Location
With “Directed put-away and pick” flag TRUE for a Location, we can’t use Item Journal instead we use Whse. Item Journal. I’ve 2 questions. 1) I’ve done many transactions for a Location, but now I want the “Directed put-away and pick” flag to be removed (FALSE). How can I do it? What tasks I’ll have to carry out in order to…
-
IF statement to see if a column is hidden
I am trying to do an IF statement to check if the control for a column is hidden. Anyone know what I would use? For example I would have IF Quantity = Hidden THEN BEGIN... Could you do something like IF NOTFOUND(Quantity) THEN BEGIN...?
-
How to integrate Barcode in Navision
How can we get barcode information in sales order? Can anyone help me?
-
LR Retail / Compare field values in 2 different DB
hello everyone.. sorry for my english.. i need help.. im using LS Retail product, and when i loggin on POS terminal - displays "PlusPos Menu OCX not initalized".. if change DB to other (working db) - all is well.. LS Toolbox 6.4 reinstalled.. i think, that user delets any data in many "setup and init" tables... how to…
-
export images to excel
Hello experts!!! NAV 2009 SP1 I am exporting data to excel from the item table, I need to also export the product image but only exports a '*' Is it possible to export the image to excel with some function? My code is: ExcelBuf.AddColumn(Item.Picture,FALSE,'',FALSE,FALSE,FALSE,''); I know that is a blob item.picture but I…
-
import variable column count csv with xmlport
Hi there, An example of the content of the csv file below. 1.;9.;8.;16.;;13.;;38.;;;15.;3.;30.;31.;;;;;;;;;42.;92.;;;;;;;39. ###;ABCDEF;ABCDEF;DOLIXMR16, round , white, max. 35W;;32,9;AAA;50;;;STK;1/11/2015;05.02;1;;;;;;;;;290;320;;;;;;;4024163080323 The first line is a header: a number that indicates which kind of…