-
Invoice Number to be filled in on Report Requestpage textfield
I need to get information from the customertable based on the Invoicenumber (invoiceHeader.No.) The problem is that is is first initialized when the report is running and The invoice report is called with the invoice record (standard). How do i Get that ?
-
Report group expression on 1 item no
I want to add an extra Group by expression in my report by item number. This group by must only be done with 1 item number. So if item number = 92070 then group and otherwise not. I tried this by putting this code in the GroupExpression but it doesn't work. =iif(Fields!No_SalesInvLine.Value = '92070') In what (good) way…
-
Fail to run bat file for ftp upload
Hi Expert, I have 2 machines, both running NAV 2009 SP1, classic client with same version, and pointing to same database. There is a NAV report created for generating a bat file which pointing to another ftp script file. Machine A Machine B Manually run report in NAV OK Fail Manually run the NAV created bat file in window…
-
The SELECT permission was denied on the object 'Object Metadata', database 'NRANAVDB', schema 'dbo'.
I recently install a new instance of Dynamics NAV 2016 and copied the database from the old server to the new server. The servers have different names. I logged on to the SSMS of the new server and updated "[NRANAVDB].[dbo].[Server Instance]" table [Server Computer Name] to that of the new server. After doing that I…
-
Database Key Groups (Item Tracking)
In NAV, there was a feature known as "Database Key Groups". This was used to group keys across multiple tables, allowing them to be enabled\disabled together. An example if a customer using Item Tracking. The keys to support item tracking and not enabled in the base product. The appropriate key group would be enabled if…
-
CRM 2013 and Exchange 2016
Hello everybody, I'm new here and in the CRM's World. I had to connect the CRM 2013 to Exchange 2016, i follow this tips : https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/mt622062(v=crm.8) But i still the "in progress" status, not failed or wish i'll prefer the success status.…
-
Double validation if same value entered
Hello, I have very specific problem which I cannot find any information on. I am working on Microsoft Dynamics NAV 2017. I have created custom Page, where I use variables on fields. These fields have custom ControlAddIns (to change color or sizes of the fields). I have the case where I have to validate same value two times…
-
PO with UK VAT, EU VAT and ROW VAT all in one consolidated invoice from popular parcel service.
Customer ships all over the world and at some point in the past we've modded the Purchase Order and Purchase Invoice Subform pages to allow line level access to the VAT Business Posting Groups. So, when the delivery company sends in their consolidated invoice, they can setup an Invoice that matches what they were sent.…
-
Upgrade from NAV 2017 to BC. NA version to CA or US?
Hello One of my client is upgrading from 2017 NA to BC and they have companies in US and Canada. Since they have split the databases, which version will they be upgrading? Has MS released a document on this?
-
Manufacturing Policy - Make-to-Stock subassembly
Hi, we are struggeling to set up the following scenario and are hoping for some helpful insights. We have a manufacturing item A001 that contains subassemblies B001, B002 and B003. We want to produce B001 and B002 together with item A001. Therefor we set Manufacturing Policy on all 3 items to "Make-to-Order". B003 should…
-
How to check Where-Used List from Other company?
Hi all, how do I check Where-Used List from other entity (Same database) I just need to know how many records from this Where-used List. I created my own function to get this counted Where-Used List. but it only detect in own company. from company A want to check how many records in company B (For the same GL Account) it…
-
Calculated Field for Cust Aging
I want to add some new fields to display the 30 Day, 60 Day and 90 Day aging customer balance on the customer list page, instead of having to run a report each time, can anyone help me with how to achieve this?
-
Setting up a Control AddIn as a DotNet Variable in a codeunit, is it possible?
I am testing the TinyMCEEditor Control AddIn (https://github.com/navaddins/TinyMCEEditor-AL) and I have done some modifications, so that I can have several configuration settings (i.e. Inside NAV Mail Client Page should be differently set up as a Requestpage of different reports, etc.). I am trying to make it as easy as…
-
Regarding sales order post/cust.ledger entry
Hi, I want to create two fields in sales header and sales line and i need to transfer it to customer ledger entry can anyone help me the flow of table in microsoft dynamics. please suggest how the data is transferred from sales header and sales line to customer ledger entry table by codeunit.
-
Time limit for permission recorder?
Hello everyone. I'm close to starting to define clear and concise permission sets in our NAV 2015 install. Up until now the company hasn't placed any emphasis on tracking/controlling the necessary permissions so i'm basically starting from scratch. I would like to use the recorder to capture the necessary permissions of a…
-
Customer/Vendor Invoice Load
Hi all, what is the best way to load open customer/vendor invoices into the system prior to Go-Live?
-
Cannot create an instance of the following .NET...Microsoft.Office.Interop.Excel Version=15.0.0.0
I have to use an excel file as a template, compile it and return it to the user. With previous versions (BC14) I took advantage of "Microsoft.Office.Interop.Excel.dll". With the BC 17 version, running the same report, I get this error: "Cannot create an instance of the following .NET Framework object: assembly…
-
'Record' Entry No. '1000' does not exist.
Hi I'm trying to get Entry No. (The only Primary Key) in a table and divide each one of them by 10 due to a memory issue as Entry No. reached the limit of 32 bits I created a report and I wrote the following code as the screenshot below The first record is 10000 so by dividing it by 10 it should be 1000. But when I'm…
-
Append Body with MailMessage - Body longer than 1024 characters
We are using NAVISION 2009 R2. Our partner have modified the way NAV sends SMTP emails, thus we are now sending mail via a new CodeUnit using the DotNet variable MailMessage: 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.Mail.MailMessage In this CU, our partner created a AppendBody…
-
Sales Invoice Report
Hello How can do to sorting By Id Dimensi code value using RDL report sales invoice , it's means to replease Item with ID dimension Value and grouping all sales invoice line between the same value to 1 line and qutantity must be calculated it . thank you
-
How do I get the Control Add-in Drag and Drop to work ?
I have the MS Dynamics 365 BC running on the server and the drag and drop feature isn't showing or working (shown on attached imaged) but on having the same company run on the local machine win 10 the feature is available and works. Anyone know how I can get this to work?
-
BC14 CU16 Web Client Stops Working
Client is using BC14 CU16 Platform CU11 Application. Web Client stops working with error (picture 1) and event viewer is recorded as picture 2. Any help or suggestion is appriciated.
-
OCR error when modify Vendor, how to fix this ?
Does anyone know how to fix this error? I have commented on all codes in a trigger OnModify of Vendor table but still got this error.
-
IIF instead of IF on standard RDLC reports
Hi, does anyone know if there is a reason why IIF expression is used instead of IF expression on standard RDLC reports? E.g.: The difference between these two is that "IIF is a function and evaluates all of its arguments prior to returning a value, while IF is an operator that executes like a short-circuiting conditional,…
-
Date in Json array
Hi, Can anyone give me some advice regarding Google Chats Calendar Charts. In this connection you must have a Json array with the date and a number value like this: [new Date (2012, 3, 13), 37032] How to make this Json array element? Thank in advance PRLI
-
LinkedObjecs in BC14
We are in the process of upgrading NAV2009 to on-prem BC14 and we came across a problem with LinkedObject tables. We have a number of such tables that we use to read data from other databases. Although the table property LinkedInTtransation is set to No, when we run the table in BC we get an error that "....linked server…
-
Automated Testing for BC365
Hello :) Good day. Is there any applications for automated testing for BC365 ? and where can I get it too? thanks and God Bless :) Regards, Jhan
-
is it possible, TCS in Sales Journal in Dynamics NAV 2016 IN ?
Hi friends, I have a problem in NAV. I am calculating TCS in Sales invoice, it is correct. But when I go to Sales Journal then we can not select any TCS nature of Collection even we create nod/noc lines for customer. Thanks in advance
-
Error asigning value to HttpHeaders
Hy all folks. I need to assign these headers to an httprequest: xlHttpHeaders.Add('x-amz-access-token',…
-
in case "if Page.Runmodal(...) = Action::Lookup then" doesn't show an ok-button
It is caused if you run a page from the launch.json. If you then run another object that uses the above code, it will never show the OK-button. If you then CLOSE the page that was opened on publish and reopen it again in the session, then the OK-button will appear It seems that launch.json runs a page as RUNMODAL which…