-
Get total number of results?
Hi All, Is it possible to get the total number of results from a web service? For example, if queriying the ItemCard, the PageSize is set to 200, is there any way to find out what the max number of results will be? (e.g Total 8425 total Items). Or is it just a case of looping through until there are no more results? Andy
-
NAV 2016 Determining which Windows Groups / Active Directory Groups a User belongs to
Hi all, There are a couple of dozen posts here on MIBUSO that ask the same question in a variety of ways: "How can I see/list/determine which Windows (Active Directory) groups a user belongs to from inside NAV via C/AL code? The method that works successfully in 2009 is to use the "User SID" virtual table - this works…
-
RDLC grouping nested with iiF construction
I have a report with a table that is sorted and grouped in three different ways. I managed to get 2 ways of sorting in one table in de RDLC layout like this: Sorting/grouping: iiF(Fields!SortInt.Value = 1, Fields!MIL_ItemCategoryCode.Value,Fields!MIL_No.Value) (and de table is shown for Sortint=1 and sortint=2) Now I want…
-
Email from NAV2016 with Azure AD
Hi all, we want to send email from NAV2016. We are getting an error when sending the mail. We are using Azure Active directory. We are running NAV2016 9.0.42815. The last workstations which are not in Azure AD wont get this error and working fine. Could anyone tell me what to do? update: standalone pc does work (login…
-
Sales Tax on Purchases
I am using Navision 2016. For some purchases I need to record Use Tax but I need to have the expense recorded to a different account than the item being purchased. Here is what I have in Tax Jurisdiction: Code: TN-State Tax Account (Sales): 4663 Tax Account (Purchases): 5351 Reverse Charge (Purchases): 2301 And this is…
-
Display/count number of orders that an item appears upon
Hi all, I'd like to create a factbox for the Item Card that contains: Number of Open Orders (that this item appears on) Number of Open Invoices (that this item appears on) Number of Open Credit Memos Number of Posted Credit Memos <...you get the idea> Note this is NOT "Quantity on open orders" - this is a standard…
-
error showing item ledger entry no ....... does not exist on when running Adjust Cost - Item Entr
hi all below error showing while i run batch job of Adjust Cost - Item Entries error showing item ledger entry no ....... does not exist on when running Adjust Cost - Item Entrie s.. and saw this entry n o in ILG this entry showing blank document and only showing document type Purchase.
-
URGENT PLAIZE REPORT Detailed Vendor Ledg Entry
HI EVRY BUDY CAN HELP A WANT TO does not display the Scriptures apply and unapply in nav 2009 R2 thank yout
-
CRM Coupling for NAV 2016 to an existing installation of CRM
Puzzled here. We deployed CRM to work with NAV 2013 R2 using the Microsoft Connectors a few months ago and did have it working so there is data in CRM. We upgraded the NAV 2013 R2 to NAV 2016 . How can we couple all Customer records in NAV 2016 to their existing records in CRM? I know we can go to the Customer Card and…
-
E-Commerce
Hi, I am very new to e-commerce and NAV. Currently, the only electronic communication with the outside world our solution uses is to send e-payment data to a bank, using a flat file. So I've been tasked with trying to discover something. Basically, is it possible to have more than one e-commerce partner in the same NAV…
-
final invoice after validat a prepayment invoice customer
Hello I would like to change multiple line when a valid end customer deposit invoice, in writing the book table the system displays a line of advance VAT in the debit portion down * is in the part it calculates credit or for amounts of VAT in line vAT sales final invoice, i want the system does not calculate the vAT…
-
Problem to register a credit card NAV2016
I'm trying to enter a credit card to Navision 2016, for that I'll Customer and page "DO Payment Credit Card (827)" when I try to add the numbers on the card I get the error "Encryption key was not found". Look for the error in google and found a forum where they explain the need to create a key from the "Payment Services…
-
zetadocs Unexpected error during operation. Unexpected problem encountered while finding unique file
"Unexpected error during operation. Unexpected problem encountered while finding unique file name." error when draggng files in. Attached screenshots of error log.
-
Deferral Code with Discount
Hi All, currently I'm using Nav 2016 (CU 12 to be exact) i need to generate sales invoice with Deferral code and discount but from NAV Itself wont allow to post sales invoice if we have both deferral code and discount I blocked deferral checking in Codeunit 80 (sales post) will it any impact in the future? can someone…
-
Create vendor payments in EBICS protocol
Hi all, our customer need to generate vendor payments with the EBICS protocol. Is there a build-in functionnality with NAV? At the moment, we are on NAV 2013 R2, but we are upgrading to NAV 2016. Thank you, Elena
-
Export objects as text from SQL Azure database?
Hi all. I have been trying to export all objects from an NAV Azure SQL database as text so that I can use the file in Statical Prism. I find that the export will run for a minute or two and then just freeze. I have tried to do this from the development environment and I have also tried using the Powershell…
-
How to setup Sales tax in a W1 version of NAV
Hi, We are using NAV 2016 W1 version. I have one database with multiple companies in the database. Most of the companies we have use VAT, which is fine and setup, but two of the companies we have need to have sales tax setup. We have a company in Singapore, that is Sales Tax, and a USA company that needs Sales Tax setup. I…
-
prepayment and table g/l entry how can reverse flow
hello my friends thank you in advance to all people respond to my questions right now I worked on the parameter of the prepayment invoice sale, then the states were well have validated the only thing that incorrect accounting Scriptures I want to reverse flow and credit party when validate the final invoice thank you
-
XMLport import problem
Hi all, I hope you can help. I get the following error: https://s3.postimg.org/3unozfcoj/Sin_t_tulo.png EDIT: At the end I managed to import the file and parse it manually without xmlport. I have found some code... the only option seemed like to work
-
Sorting on Production Order lines
We have a multi-level BOM with e.g. 3 subassemblies. 001 ..002 ....004 ..003 In the production order the default structure is 001 ..002 ..003 ....004 Guess, there isn't a standard feature to make it to follow the BOM structure?
-
NAV 2016 Web client language of sign-in page
Hi all, as you may know, language/region settings for web client in nav 2016 is set on "user personalization" screen in RTC or "My settings" page in web client. so far so good. how can I change the language of login/sign in page of web client? (we are using forms authentication in web client and NAVUserPassword option in…
-
Service Order - link to PO for subcontractor cost
Hi In service order, there is a need to record subcontractor cost e.g. certain service are outsourced to external party. A PO would be sent to the subcontractor. The subcontractor will send their invoice. We want to capture such cost to be part of the service order. Tried G/L , Resources, Cost in Service Item…
-
Bank Reconciliation
Hi, I would like to reconcile multiple bank account statement entry against a single Bank account ledger entry. I'm pretty sure that this was possible in the past, however it seems that it's not working in the current version. Did anyone face this issue? Regards, Steve
-
Nav 2015 - Reports causing blocking of new sessions
Hi all, Im having an issue with Nav 2015 whereby if one user runs a report that may take some time, they will block any other user from opening up a new nav client session. For example, Person A starts running a report Person B tries to open a new Nav session, but all they will see is the blue "Microsoft Dynamics NAV" logo…
-
Production Journal
Hi, I have a multi-level production order. I want to backflush one of the subassemblies. When I go in to the production journal and drop the Flushing Method to Backflush, the Consumption Quantities and Run Times are blank. When I look at the actual components and routing for the subassembly line, I can see the consumption…
-
Report with layout export to excel, PrintArea, TitleColumns, TitleRows
Is there a way to predefine in the layout- report in NAV, the PrintArea, Print TitleColumns And TitleRows in Excel? The print to PDF fits on one page, but in Excel I get two pages. (I know, to show the header, I can use de report header section, but I get far to many rows in Excel, that is not a solution.) Thanks in…
-
Invalid object name 'XXXX.dbo.company$xxxxx'
Hi, We just ran into an interesting problem with one of our clients, on a Nav 2015 environment. In a newly created company the users received the following error message: The following SQL error was unexpected Invalid object name 'xxx.dbo.company$xxxxx' We spent some time finding the problem and would like to explain what…
-
NAV 2013 R2 Page Layout - standard function send & print Page print
We have recently changed the build in one of our customers to the 45254 build. Everything ok untill the customer started to report changes on the layout of that functionallity, from what I have understand from our location provider it seems that Microsoft changed it. Anyone have an idea of what sets that layout properties…
-
Phone client APP cursor in textbox
When opening a page in the Phone client app, NAV opens the page without positioning the cursor in the first textbox as it does in the webclient. The only way it does it , is by first touching the textbox on the screen. This quite a problem when the textbox is actually filled by a barcode scanner, we can't ask a user to…
-
Issuing a Credit for Tax
Hi, What is the best way to issue a credit memo to a customer for tax that the customer should not have been charged for? This applied to US taxes. Thanks, Steve