-
how to Remove 00/100 in Standard Check, If the Amount Has No. Value
Hi Guys, I have a question regarding the Dynamics NAV Standard Check, I'm Having trouble formatting the Amount in words Part of the check, since the requirement is to remove the 0/100 if the amount in payment journal Lines, has no decimal value to be exact. if the amount is 1000.00 the amount in words should be -ONE…
-
Does anyone have Navision 4.0 Hotfix 891518
The hotfix was originally posted here http://support.microsoft.com/?kbid=891518 It may also be known as Navision 4.0 Hotfix 4 But It is no longer available. It is no longer available on https://mbs.microsoft.com Our solutions provider does not have it; nor does microsoft. If anyone has the original hotfix archive /…
-
Depreciation not accounted
I have some fixed assets not depreciated since September 2018. Acquired this on 8th Sep 2018. Run the calculate depreciation for the asset. But it has not depreciated for the Sep 2018. I need help
-
POS Item Lines
Hi In LS Retail Pos Screen Item lines come from which table & which function or CodeUnit is used. Thanks
-
How to show more than one VAT type on sales invoice print
Hi everybody, I got stuck while creating new report which will use for sales invoices print. I'm doing it via word layout, and i do not know how to map VAT amount field after creating it into NAV development. Imagine if you have two different VAT types with for example 3,7 and 7,7 % on few lines in same document. What I…
-
branch code missing
branch code missing in some of the g/l entries.
-
Inventory Valuation
Hi I have Item say Xyz with docNo = R0001 say value 100 , Qty 5 . It is issued against 2 document No's say I01 & I02 In I01 Qty = 4 Value should be 80 . Applied Entry R0001 In I02 Qty = 1 Value should be 100 . Applied Entry R0001 Is 80 & 100 value is stored in any table against that invoices or is calculated runtime. Thanks
-
Got SQL error while Logging into NAV 2009 classic?
Hi All, Login is existed for this user but still facing this error while logging into NAV. " the following sql error or errors occurred. 15161,"42000" [microsoft ODBC SQL Server driver][SQl server] cannot set application role." Please suggest me some solution to overcome this issue. Thanks in advance, Jacob A.
-
Extra license for test database
Do we need extra license for the test database that will be installed in users' pc?
-
Delete Invoice Sales Orders and Purchase Orders
Hi, Is it safe to run Delete Invoiced Sales Orders and Delete Invoiced Purchase Orders without any filters? I'm looking for thoughts and experiences with this. Thanks, Steve
-
Report Design Nav 2009 R2
Hi, I am new to CSIDE and C/Al. I am using Nav 2009 R2. I would like to design a report based on the following SQL Query. Please guide. select [Item Category Code], sum(B.[Invoiced Quantity]) as Qty, sum([Cost Posted to G_L]) as Value from [CRONUS International Ltd_$Item] A inner join [CRONUS International Ltd_$Value…
-
Disposal Date must be the last date for Fixed Asset Error
Hi All, I received the following error message when I tried to dispose of a Fixed Asset in a NAV 2009 R2 client: 'Disposal Date must be the last date for Fixed Asset No. = XX in Depreciation Book Code = YY' This message appeared when I was posting a FA G/L Journal (FA Posting Type of Disposal). The fixed asset was migrated…
-
NAS shell commands
Hi all, Hope som1 can help, I´m getting mad. IF GUIALLOWED THEN SHELL(T50161."PH Files Path"+'RequestToken.bat') ELSE BEGIN //SHELL(CONSTRequestToken); CREATE(WshShell); WshShell.Run(T50161."PH Files Path"+'RequestToken.bat'); CLEAR(WshShell); END; I know that for shell you have to use text constant so, I did that…
-
statement
.
-
Insert the Comments into next row automatically.
Hi All, I want to import Business record comments for the customer. Here the length of the Comment field is 80. So I am not able to insert more than that. My Requirement is: If the length exceeds(more than 80), the comments are automatically inserted into the next row. Please suggest me some c\al code. Thanks in advance,…
-
Call report by passing Parameter
Hi I have below code and i want if Amt[2] > 0 then report is called by passing Item No Item - OnAfterGetRecord() FOR i := 1 TO 10 DO BEGIN ILE.RESET; Amt := 0; Qty := 0; End; ILE[2].SETCURRENTKEY("Item No.","Entry Type","Posting Date","Location Code"); ILE[2].SETRANGE("Posting Date",StDt,EndDt); IF ILE[2].FINDFIRST THEN…
-
MakeSingleLevelAdjmt function in CodeUnit 5895
Hi How below function works LOCAL MakeSingleLevelAdjmt(VAR TheItem : Record Item) Thanks
-
Adjust Cost Item Entries
Hi I ran Adjust Cost Item Entries on a particular Item Manually but it didn't corrected it's value. In this item it does not go in With Item Do condition in Codeunit 5895 function . Item in which it is corrected that goes in this below function With Item Do condition LOCAL MakeSingleLevelAdjmt(VAR TheItem : Record Item)…
-
How to Create multiple sheets in excel?
Hi all, I want to create multiple sheets in Excel. So i am writing the code as follows. ExcelBuf.CreateBook; ExcelBuf.CreateSheet(Text002,Text001,COMPANYNAME,USERID); ExcelBuf.GiveUserControl; ExcelBuf.CreateSheet('TestSheetCreated',Text001,COMPANYNAME,USERID); When I run the printtoexcelo, I am having three tabs one with…
-
Location wise Inventory valuation
I need to have a report that shows Inventory valuation for a particular date in location wise. Please help me....
-
Show sales invoice using the sales credit memo
I want a list that shows sales invoice numbers that were returned. This should include relevant sales invoice and the relevant sales credit memo. Is there a method to get those data without customize
-
Item Tracking by Location
I have been able to make this work by adding a boolean field to the Location card and adding the following code into Codeunit 22. In the SetupSplitJnlLine(VAR ItemJnlLine2 : Record "Item Journal Line";VAR PostItemJnlLine : Boolean) Function. Before:DisableItemTracking := NOT ItemJnlLine2.ItemPosting;ItemTrackingCode.Code…
-
FINDFIRST and FIND('-') freeze for minutes on the same records while FINDSET(FALSE) finishes in1sec
So at first i was using find('-') because total records vary from under 10 to 600.000... i dont modify the database , just counting and categorizing them. 1 example had 150 records total and the transaction would freeze for minutes on the exact same two or three records when run for the first time a day ( every following…
-
How do i pass a variable from a Report to a Form?
Hi, so i have a Form that calls a Report in an OnPush()-Trigger. After the Report is run, i want to pass two Integers back to the Form. Is there any way to do it? Since apparently all variables are cleared after Report.RUN is executed i cant follow up with get functions in the Report. I also tried it the other way around…
-
Is it possible to access a variable inside a report from a form via get-function?
Hi so i try to run a report after clicking a button in my form and afterwards update some formfields with variables stored in the report. Is that possible? Even though i declared the report as global variable in my form it says variable not found when i try to use the get-function.
-
Zetadocs Report Settings
I created a report for my client and they have several companies in their NAV and this report works only in one company. when they click print-preview they get this error below. What might be the problem? Where should I look at it? I already looked at report selection and zetadocs report mapping. No zetadocs report…
-
Calculate Forecast Based On BOM and Materials Stock
Hello, Is there any method In Navision on how to calculate Forecast for a product based on its BOM and Materials Stock. For example : I Have An Article Called 'Table'. It's BOM Is As Follows : 2KG Of Wood. 12 Pins. 1KG Of Yellow Paint. I Have In Stock : 200 KG Of Wood. 400 Pins. 50 KG Of Yellow Paint. As A Result : I can…
-
Microsoft Dynamics NAV 2009 SP1, Email attachment
When I send an email I want my purchase quote goes to the email body, currently it goes as html attachment. When I go to purchase order it works just fine. I did compare these two objects and looked very similar, do you know where I should look? I click Print then preview>>>file>>>send >>>Report by Email I see the quote in…
-
How to upgrade the SQL server running the current NAV.
Hi All, Nav 2009R2 is running with SQL 2008R2. Now we are going to upgrade from SQL 2008R2 to SQL 2014. Can you please assist me with the below questions So, 1) How to upgrade the SQL server running the current NAV? 2)Could this be an in-place upgrade or would a full back up and restore on a fresh install be needed? Thanks…
-
How to take values from Item Template Card
Hi everyone. I would like to take values from Item Template Card so that I don't have to assign them that way: Items.VALIDATE(Description,Processor) but something like that Items.VALIDATE(Desciption,[Value from field "Processor" from Item Template Card named Processors]. Do you have any tips for me? Thanks in advance