-
Reorder level
Hi all I am on Nav 2009 R2 classic client not RTC. My questions: 1) how to i setup reorder level for Items. When any item inventory drops to the specified quantity the same should be positioned for reorder. 2) i do not see "Reordering Policy" in item card, planning menu. please help. thanks satish
-
How do I setup decimal places for the field 'Line Discount amount' to round down.
How do I setup decimal places for the field 'Line Discount amount' to round down. For example for an item which costs 3.10. A 15% discount gives 0.465 as the line discount amount. That figure in my company is giving 0.47 as the line discount amount. I want it to give 0.46 or at least to remain as 0.465. Please assist I…
-
How to open the Jobqueue report as a PDF?
I have created the Nas and Jobqueue.I also downloaded the BullZip pdf software.But,I don't know exactly where I put the code(the report itself or Code Unit) for the Jobqueue report to Pdf conversion.Guide me please,, Thanks in advance.
-
Report by Email Sending Blank Body
NAV 4.0 (6.00) Office 16 Exchange 365 Windows 7 When using inbuilt function File > Send > Report By Email in the spec above the email is generated with the report rendered in body however, when emailed the body is blank. Currently working around this by saving the email after generated and then sending which retains the…
-
Transaction cannot be completed because it will cause inconsistencies
Hi Mates, I hope you all right. perhaps somebody can help me with this: https://community.dynamics.com/nav/b/tharangacnavblog/archive/2014/10/23/error-the-transaction-cannot-be-completed-because-it-will-cause-inconsistencies-nav-2009-sp-01-nav-2009-r2 I followed the steps above but the entries it is telling me to unapply…
-
How to create a Job queue Report in Event viewer?
I have installed the NAS in Nav 2009.the Nas is also running properly.Now how can i get the Jobqueue report in Event viewer? Guide me guys,,,
-
Query
Hi How to get a list of Items which have stock as on 31.03.2015 and after that it has been Sales directly not transferred to any Location after 31.03.2015. Thanks
-
NAV LS Retail Promotions
Hi All, I want to setup some type of promotions in the Nav LS retail POS. But after a big research I am not sure if this type of promotion That I want is possible to execute, what looks weird for any POS system I think is Possible. The promotion That I want To setup is I Have Product A and Product B and My promotion…
-
How can i check whether the NAS is properly Running or not?
I have installed the Nav application services (NAS) in NAV 2009 then I don't know how to check the running status of NAS.please guide me.
-
To create a report for last sold item with the posting date
Hi all, I create a report to print a customer last sold an item with posting date.But I am facing some issues. Here I am able to print the items based on posting date but all the items are shown here.Moreover, I want to display only last posting date but it is showing all the posting dates. Please advice. Thanks in Advance…
-
Deemed Credit
Hi How to calculate deemed credit in case of Transfers Thanks
-
Filter Subform2 By data in Subform1
Hi there, I need to add 2 subform into a main form. I then need to filter one of them with data stored in another subform (Something like subform link). Is there any chance to do that? I'm not able to do it. Many thanks.
-
Convert a string to an Integer
Is there a way to convert a string to an Integer in Navision
-
unknown language was selected '16393'
OS : Windows Vista Navision : Version 5 Whenever the user opens up navision he get's the following error message unknown language was selected '16393'.
-
Linked Server and Navision
Our customer has an external SQL server on which they want to make a lookup into a table. First of all I know (and it is working) that a view can be created on the Navision SQL server and I can access this view from the Object Designer (table). I have also managed to setup a Linked server and retrieve data from the linked…
-
Modulo on a big number
Hi, I need to perform a modulo operation on a very big number (30 digits, could even be all 9's), is it even possible to do that in Navision? If so, how would i do that? It would be a simple VARIABLE MOD 97 operation. Also, the 'number' is stored in a Text variable, since obviously integer can't hold a number of this…
-
Time in HH:MM:SS format
Greetings, How can we convert TIME into HH:MM:SS format. I mean if the Time is 5:45:23 AM then it should come as 05:45:23 and if the TIME is 5:45:23 PM then it should come as 17:45:23. Using DELCHAR i am able to delete AM and PM from TIME but how to add extra 0 if any of the hour/min/seconds are in Single Digit. We can…
-
Customer login using temporary password in MS Dynamics Nav
We have currently generated a temporary password using our customer login API, but we are not able to login to the system with this password. Please find the API details from below. <element name="GenTempPassw"> <complexType> <sequence> <element name="pCust" type="string" maxOccurs="1" minOccurs="1"/> </sequence>…
-
Integrate WooCommerce webshop
How to Integrate WooCommerce webshop with Microsoft Navision?
-
XML Automation in NAV 5.0 error message coming while Sending through Outstream.
Hello Coders, I have been trying the below Request and Response through the XML Automation in NAV 5.0 version but I am getting the following error. Microsoft Dynamics NAVThis message is for C/AL programmers: The call to member send failed. msxml3.dll returned the following message: A connection with the server could not be…
-
Block location in Item by Location
Hello all How do i block unwanted locations being visible in items by location matrix. thank you satish
-
Is possible to detect the open of an object
I would like to know if is possible to detect when you open an object in desing mode from object designer. thanks.
-
User Permission to Only Forms nav2009
Hello, Through Navigation Panel we can assigned users to module. Is it possible to assign users to individual forms only example: in Finance -> receivables -> Customer I want to assigner user to Customer form. Please advise. Thanks
-
Array Showing wrong Data
Hi I have below code . In array Qty[1] it is showing 0 whereas in OQty it is showing correct value ILE is Item Ledger Entry with DataType Record. ILE[1].SETRANGE("Posting Date",0D,CALCDATE('-1D',StDt)); IF ILE[1].FINDFIRST THEN REPEAT ILE[1].CALCFIELDS("Cost Amount (Expected)","Cost Amount (Actual)"); Qty[1] +=…
-
Nav - Complete setup of Version RU 3.60.03 is needed for one of client.
Hi All, I have one client who is on Version RU 2.60.03 They are planning to migrate from currentnt citrix platform to a new citrxi platform. For the same I need setup of above version. If Some-one can provide any idea for the or provide the dump, i will be thankful. Regards, Malaya.
-
Group rows in Classic report - report 206
Hello experts. I am not used to working with classic reports, I always worked with RDLC. I have lines like this in report: Description Description 1 EUR 574,11 Description 2 EUR 121,12 Description 3 EUR 241,23 Which are all with the same "No." on Sales Invoice Line. I want to show only one row with summed amounts for one…
-
Posted Purchase Receipt with No ILE or VE?
I searched the forum and found only questions regarding Undo receipt and adjust cost. here's my observation. I have a Purchase Order that will not post. I get the error message: Microsoft Dynamics NAVItem Ledger Entry Entry No. '0' does not exist. OK When i activate debugger, i find that the code stops in Codeunit 22 on a…
-
Customer Cross Reference
We're new on NAV and trying to figure out the customer cross reference. An old thread on here seems to contradict what this pop-up says, but it also doesn't seem to work the way the pop-up depicts. According to this pop-up, NAV should replace the internal item number with the customer cross reference number. So far I'm not…
-
User unable to log in - No Error
SQL 2008 NAV 5 Security Model = Standard Created a new windows user, with ALL role and additional required roles. Synched All Logins Database just doesn't open - no errors. Did the same with a new database login. Created the login in SQL Created it in NAV Synched Confirmed that user was created in DB Database doesn't open.…
-
Excel Buffer Error Library not Registered.
Hi All, I have a problem when running report using excel buffer, there is an error like this. All report that using excel buffer are show that error, but not if i use rapidstart or else. Currently I'm using Ms. Office Professional Plus 2013 unlicensed. I have tried to downgrade to Office 2007 but still error. Also tried to…