-
Menu Issue
I need help on how to remove ALL menu from a user at once. My company Admin is outsourced so is the Hosting, and once a new user is created, by default, ALL menus will be assigned. This gives me lots of headache as I have to manually remove over 25 menually (Menu by Menu) Please how can I remove ALL menu from a user at…
-
Display the content of an Array in a report
Hi everyone, I have a variable of type decimal which is a bidimensional array (dimensions: 50;22). I want to display the content of this array in a report. Do I have to put the actual indexes for each row (meaning do I have to put tab[1,1], tab[1,2], ....) to get the result? or is there another way to get the values…
-
multiple Journal voucher not posted if narration is blank
if multiple journal voucher lines are posted then it should check for approvement of narration for each line posted in default it only checks for first line and all the lines in voucher are posted i tried to modify in 439 code unit but not working..
-
Purchase Receipt Date
Good day! We are trying to create a receipt report per PO line. What is the specific field for the actual receipt date? Can we get it from the receipt header or line tables or from the item ledger entry table? The posting date is not the actual receipt date correct? Thank you.
-
Unused objects
Hi, Any idea how can I find the objects which are not in use I can find the tables but not idea about forms/reports/codeunits any help?? Thanks Ajay
-
Import Mails from Outlook
hello all and sorry if i placed this topic in wrong section.. and sorry for my english =) is it possible to do import mail msgs from outlook [exchange] to nav5.0+? which automation component to use? 4ex: PC_1: sending mail msg with 2 fields (in front of field maybe placed unique code (transparent color) for identify field)…
-
Default setup to link trade units
Hey I would like to know what the default setup is to link "trade units" in NAVISION With "trade unit" I mean each unit that can be ordered by your client, a definition used by GS1. (GS1: international standardization organization for supply chians that is responsable for barcodes) For instance when you're distributing…
-
With Cash Payment Voucher Link Should also be Posted
I want to post the Record Link associated with the Line in Cash Payment Voucher . How can I do So . i don't have any idea about Links i.e it should get reflected in Vendor ledger Entry when posted for vendor I think i should use HASLINK and COPYLINK FUNCTION
-
Multiple Payment Methods
Hi All, I am working on NAV 2013 R2. There is this new requirement where a single invoice can have multiple payment methods. For eg an amount of 20000 can be paid in CASH of 5000, CHEQUE of 6000 and rest via card. Can anyone share some ideas on this?? Thanks in advance.
-
Bad Sales Order
One of our clients, had a sales order was entered with the wrong bill-to. Before, it was invoiced, they unshipped the Item lines. Now, there are 2 G/L Lines that the system wont let them unship. They tried to change the bill-to because of the shipped G/L Lines, they were not able to do that. So, they ended up creating a…
-
NAV 5.0 Client crash with attachments in CU 397 Mail
Hello, for some reason the NAV client crashes sometimes and i don't get it what it could be. Most of the time everything went ok, Outlook Mail opens with the correct parameters and the attached file. But sometimes only the mail client opens correctly, but NAV crashes. Doing it again with the same record no problems. So…
-
How to pass parameters in XMLports
Hi all, Hope someone can help me out with this as it seems to be difficult to find anything about it: When you create a report you can pass on parameters deciding from which record to which record. When creating an XMLport for export of G/L entries and want to put a filter on posting date - how do you pass these parameters…
-
How to get information from Object Designer outside of NAV
Dear community, I working on new free tool and faced a problem with no idea how to deal with it. I have C# application. I need to know what object is currently selected in NAV object designer. I get handle to NAV. (IntPtr) I get handle to Object Designer. I get handle even to C/SIDE SubForm. But what to do next... :)
-
Fixed Asset Balance
Hi all, is there a way that i can see all current assets and there value in one table(that i can transfer to excel), so that i can reconcile two databases? Thanks Lisa
-
vendor/customer balance
Hi all, relatively new to the NAV world, can anyone help me with the following, I am trying to compare two databases to make sure that the vendors and customers balances match in both. Is there a way of seeing a list or similar of all vendors with balance and all customers with balance?(if poss exported to excel) :?: I am…
-
Table relation
Hi Friends, How if we want to create a new table which primary key same as other table. for example my new table, should show primary key field same as Item table. So whenever Im running my new table, it should show primary key field same as item table automatically. And other records value will get from flowfield from…
-
case statment
Hi There is a special possibility with case statement CASE TRUE OF Expression1:; //do something Expression2:; //do something ELSE //do somethingEND; Personally I think a construction like this is a bit easier to read than subsequent if or else if statements. What is your opinion? Regards Thomas
-
Check next record in view
Howdy, I'm trying to make the life of a user easier; currently, they have to set a "commodity code" for each line/record in a form. The commodity code is chosen based on the information in the description. I want to create a snippet of code that checks whether the description in the next record(s) is the same as the one…
-
License Issue
We have a client, and he just bought few user sessions a while ago. We loaded the new license file in the Live database and worked perfectly. I exported the license file from the live database and uploaded it into the development database, but the no of Licensed session did not change. It is still display the old licensed…
-
ACH for transfers between Bank Accounts
Has anyone used the ACH Electronic Funds Transfer function in the Payment Journal to transfer funds between bank accounts? I think it will work if the "To" Bank Account is setup as a Vendor with a Vendor Bank Account. But I'm curious if anyone has been successful transferring directly between bank accounts without…
-
Exchange Online (Office365) and SMTP Mail Setup NAV
Hi guys, do you have tried to configure SMTP Mail Setup for Dynamics NAV, to the Exchane Online Server? Thanks for your attention.
-
Date Table,Calendar.FIND(SearchString)
Hi friends, recently I was going through FindDate function in Codeunit 359, PeriodFormManagement. Here got a line, Found := Calendar.FIND(SearchString); and value of SearchString is '=<>' to find the record and I don't know what does it mean. Do anyone know how to use this kind of value to find 1st day of current week?…
-
VAT difference in LCY
Hello everyone, My problem is VAT differences due to the exchange rate difference between purchase invoice rate and NAV rate. For ex.: Received invoice from supplier Amount excl. VAT 100EUR Amount excl. VAT (LCY) 800SEK VAT 25EUR VAT (LCY) 200SEK Invoice rate: 8 EUR/SEK Now, NAV has different rate: 10 EUR/SEK Amount excl.…
-
How to read Database Navision with visual studio 2010?
Dear All, I have one question: Is it possible to read database navision with visual studio 2010? If possible, how to do this? please share Navision database = SQL Server 2008 Navision = 5.0 Best Regards Heru
-
OBject Cache in NAS
Please help me We use NAS for Job scheduling, and now the size of Object Cache is 64000KB. We have slowness of transaction the users cannot login sometime and so on. Advice what should be done. Can I delete Job log entries and will it help to increase the speed of transaction. Should I reduce Object cache size? as I know…
-
indexing 11 in the array is outside of the permitted range
Hi guys i have problem when i create new account in chart of account form it come to me message error as following "The indexing 11 in the array is outside of the permitted range" what i do to solve this problem and why this happen this message show to me when i make indentation to new account I have dynamic nav 2009 r2 my…
-
Exporting Header and Line records using Dataport
Dear All, I want to export Sales Inv. Header and Sales Inv. Line tables from Dynamics NAV 2009 as .txt to feed a third party application. Since I cannot indent Sales Inv. Line under Sales Inv. Header in a dataport like we do in reports, how can I go around this using dataport to export. Exported file should look like this:…
-
Reset AutoIncrement when table is Empty?
Dear all, I have developed a XMLport function and it is fine. Nevertheless, during my testing of importing, the PK ("Entry No.") was incremented into a large no. Before deploying to customer, I want to reset the Entry No. to be start from 1. Although the table is empty, the Entry No. is not being reset. I have a very…
-
dimension posting
hi experts I have made dimension mandatory in my data base . And during consumption entry I need dimension but in purchase posting purhase posting i Have to by pass it. how i will do it plz give a suggestion.
-
Alternative lookuptable ?
I give up searching this topic and ask instead. From a card, I like to be able to push F5 and choose a new record using a form that is not the default lookup form id of that table. Is this possible in classic ?