-
How to encrypt customer table data in Dynamics NAV or SQL Server?
I want to encrypt customer table data in Dynamics NAV or SQL Server? Personal info such as email, phone, SSN, credit card info is sensitive and can be stolen from DB, so looking for a solution to encrypt it. Strong encryption such as AES 256 will be better. I will appreciate if someone can make suggestions, we want to…
-
Validate field from external system
Hi, I wonder if it's possible to validate field from outside Navision. In my application (C#) you create sales order and send it to Navision database. Is there any way to write item no to Sales Line table and then validate this field (use Navision code) to fill other fields automatically :?:
-
how to link username with dimension in dynamic nav
hi i wat to link or make relation between the user and the dimension how i can made this task
-
QR CODE
how to add qr code to report (invoice,ticket,shippment) ,on classic client dynamics nav 2009 R2
-
Report 12117
I have to modify the report 12117 Customer Bill List because it doesn't work for the italian version. Can anyone give me the .fob of a working customer bill list that uses the table Detailed Cust. Ledg. Entry? It would be great because I don't know how to correct the existing code/layout. Thank you!
-
How do i break a component asset to sub-component assets
I understand that Navision has got only two levels when it comes to breaking down assets, there is main asset and component asset. But now i need to break my component asset into sub components as well and so on, so that one asset(e.g a Plant) can have many components(e.g generator) and the components can have their sub…
-
There is no "External Document No." in Payment Journal after click "Suggest Vendor Payments"
Hello, In Payment Journal, after I click "Suggest Vendor Payments", there is no "External Document No.". I checked on Vendor Entry, there is a value in "External Document No." already in the same document no. How can l populate it automatically like other fields? Thank you for your help :)
-
Execute permission was denied on object
Hi All, Am getting below error please help.
-
My user is getting error message 'This order must be a complete shipment' when posting sales order
My user is getting error message 'This order must be a complete shipment' when posting sales order that is set for 100% prepayments. Apparently the order was created sometime back and had a prepayment invoice posted. the items were never collected and a prepayment cr memo was posted. Later the users retrieved same order…
-
How do i change the MaxIteration Property in code in a report if a condition is fullfilled
i am designing a report that shows customer comments, i have a request form for which the user can choose to see only the latest comment. how do i achieve that using maxiteration, or is there another way. thank you
-
Does Nav Dynamic retail work well when using Zero client?
i would like to switch from Desktop PCs to zero clients machines on both Nav2016 and 2009, so i want to know is my Point of sale system will work the same as before, and if the number of users limitation still applies. Thank you
-
How Can I attache Approver ID in report "Posted Sales Shipment"?
Hi users, Follow that issue, How can I get through this? I had checked, there are 3 tables which relate to each others. As I see is 1. At Table : Sales Shipment Header >> field "Order No." which store Sales Order No. 2. Then I think l have to make a relation between (1) with Table : Sales Header Archive >> field "No."…
-
Why integer report skips first record
Helo, I'm not a developer but an administrator, so i hope this isn't a totaly dumb question :) I made a report with 2 Integer data items. In the first dataitem i filled a temporary table with data. With the second line i wanted to print out that temporary table. In OnPreDataItem i added a range, so it wouldn't loop…
-
Calc. Standard Cost
Hi, We are using Standard Costing. My client will be adding new Production BOMs to the system quite often. Since the new items would not have any inventory on hand, do we still need to run the Standard Cost Worksheet to rollup the standard cost? Or, would it be ok to use the Calc. Standard Cost from the item card? I know…
-
what i need to setup a nav
hi i have had a company and my aim to setup a nav (for exampl i have x company ) and i want to set up nav system to company what i need setup(item, customer , vendor, opening balance, ......) what else???
-
Issue with CHANGECOMPANY
Hi, There is a scenario we want to export vendor master using XML port for all the company. For this i have written the codeunit and used the CHANGECOMPANY function to export the data for all the company. Code which i have written is : recCompany.FIND('-'); REPEAT CLEAR(recFile); CLEAR(recSetup); CLEAR(recVendor);…
-
2009 R2 NAV Locks up/Crashes During REPORT.RUN
Hi, Folks! I am at my wit's end... I have a piece of code that is running under 2009 R2 Classic (now Build 6.00.34105). It is designed to ultimately run under the NAS; but during Development/Debugging, I have found that it is far easier to "fake" a NAS by simply running the Codeunit that the NAS would be running, but…
-
Problem with Polish letters on RTC
Hallo Everybody. It was the problem in NAV 2009 that caused erasing of field content when using Polish local characters. The problem was solved by the update, but it induced the other problem. Now on pages (on field captions) there are no Polish letters like "ś" or "ł", even though they are present on Classic Client. Does…
-
Import/Export all NAV objects in txt by code
I would like to know if is possible to import or export all NAV objects in .txt by code. Someone could help me? Thanks!
-
Apply Posted AR Payment - Nav 2009 R2 Classic
How do you apply a posted payment to an open invoice? For example, we received a payment and it was posted to a general g/l account without being applied to a customer or invoice. Once the batch was posted we realized the company that sent the check was invoiced. So now I have to apply that payment to the open invoice.
-
Bank Reconciliation in foreign currency
Hi, I am trying to reconcile my USD bank in my CAD company. To have my ledger match my subledger, I am posting the following: April 1, 2009 at FX:1.26 Account TYpe = Bank USD Amount = 1000$ Bal Account = GL Account of my Bank USD (so its a wash to my GL but increases my subledger so they are now equal). On April 30, I am…
-
Which trigger should l put Security Filter Modes on?
Hello everyone, l'd like to set Security Filter Mode on NAV like SETPERMISSIONFILTER or SECURITYFILTER . Which trigger should l put them on? Thank you :)
-
credit memo issue
Hi guys, when i created a credit memo> functions> get return receipt line i keep getting the error message: " 'Get Return Receipt Lines' cannot close because the system is currently working. " follow by : "The program cannot find this purchase line", anyone ever encounter this? what could be the possible caused?
-
Filter
I have to filter a table with the Vehicle Number that is repeated more than once... How can I do it? Thanks!
-
NAV shows that I cannot access records that are outside of this filter
Hello, I would like Manager Roll to show only their department. For example, if Mr.A is in T department, NAV should show only document for "T" department (Order, Quote and so on). So I went to 'Security Filter' in "Permission Set", and added filter "Department = T" . Then I tried creating SQ and sent to manager. After…
-
Failing to reset variable for group totals for each FA subclass.
The problem I am facing is that the variable FASubclasstot is not resetting after the FA Subclass changes. It keeps accumulating from the prior class and its now acting as a running total.Help me how do I use the ONPRE DATA ITEM, ON AFTER GET Record and ON POST DATA ON PREDATA ITEM - I put this code**********************…
-
Prepayment
MESSAGE ERROR IT IS PREPMNT AMT TO DEDUCT CANNOT BE MORE THAN XXXXXXX IN SALES LINES DOCUMENT TYPE = ORDER ...... I HAVE AN PREPAYMENT INVOICE IN A LINE IS I WANT ONLY ONE PART OF THIS INVOICE TO POSTE IN FINAL INVOICE ,THE SYSTEM BLOCKS AND DISPLAYES THIS ERROR MESSAGE,PLEASE HELP IT IS URGENT THANK YOU
-
Count table's records which have the same description while writing a report
I'm writing a report and I have to count how many records with the same description are contained in the table of origin because I want to filter the records with a description that is repeated more than once, and ignore those record with a description that is unique. How can I do it?
-
Inserting a Sales lines from Item List
I have created a menu button, which consists of a sales list form. What I wanted to do is, that when I double-click any item in the sales list, then that particular item must be added into the sales Line of that particular order. Any insight on how to do would be helpful. Thank you.
-
Purchase (LCY) value is showing in negative .
Hi All, I have created on purchase order with foreign currency code – USD. PO Value in USD – 1000 .When I click on the statistics (F9) system shows the PO value – 1000 and Purchase (LCY) value - (-50000) . Purchase (LCY) value is showing in negative . Could you share what is the issue ? :-k