-
Update Totals on Subform
I have created 2 fields by extending the Sales Line table.* Premium % (Decimal) * Premium Amount (Decimal) These two fields will be shown on the Sales Order Subform and will function like how Line Discount % works. It is just that, it will add the Premium Amount value to the Line Amount instead of how Discount % subtracts…
-
Unit Of Measure Translation
Hi, We have the German Language Pack installed and a Unit of Measure translation setup for the German Language. When running a report with the Unit of Measure field displayed with the CurrReport.LANGUAGE set as the German Language code, we still see the english 'EACH'. What other factors need to be considered for the UoM…
-
service tax apply entry error in nav16
hi friends, When ever my user trying to post an apply entry in Nav 16 india version getting this error, to remind he is trying to apply entries with service tax not GST
-
Problem with insert built-in layout for a report
I created a custom Sales Invoice and Credit Memo and they work fine, I'm able to print them without any problem, but I need to insert a Word Layout for them and as soon as I click on Accept on the page (image added) it just says there was a problem and disconnects. It's done on VS Code on the latest release wave. A…
-
MSD NAV 2015
when a customer list opens, in the header the caption for the column should be a value stored in variable. for example instead of "Name" I would like to have "Customer Name" and "Cust Name" based on condition. one of the two will be stored in the variable that has to pe in header when page opens.
-
Add new calculated field in a table taking the value from same table.
Hi Everyone, I have created one new field 'VAT Amount' in purchase line table. and i want this to update as calculated field as: VAT Amount= Amount including VAT - Amount; eg. VAT Amount=15-10=5;[field: 'Amount including VAT' and 'Amount' already is present] SO, i tried the below code in VAT Amount field ONValidate trigger…
-
Working with certificate on BC15 (Cloud)
Hi all, Did anyone work with certificates on BC15, cloud? We used X509Certificate2, X509ContentType and X509KeyStorageFlags dotnet's in previous version for working with certificates. But now I'm not able to use dotnet's anymore, and also as I saw I can't map these dotnet's with new codeunit DotNet_X509KeyStorageFlags,…
-
Control-AddIn Trigger not firing
Hi experts, Problem: I developed a ControlAddin for BC (140, WebClient, AL) which calls various Triggers of the usercontrol from Javascript viaMicrosoft.Dynamics.NAV.InvokeExtensibilityMethod('d3cControlReady', []); On my local dev machine and our demo servers this works like a charm, everything gets called as it should…
-
Tell me a way to cancel or exclude OPen PO and open Another PO while running MRP
For the demand. I have an open SO for 4 delivery dates for one purchased part. The buyer has already opened a PO with four lines on it buying the part and scheduling the delivery to coincide with the date of need. I would expect the plan to see the open PO and count it as a scheduled receipt. Instead, when I run the plan,…
-
how to record in Change Log Entry if using Transferfield ?
Hi all. i am using Cloud BC i have developed on sync button from company A to company B both companies i have turned on the Change Log Activities. but in company B it wont recorded in Change Log Entries. Scenario : i created new item in company A so i want to push this new item from Company A to Company B in company A it…
-
Run a script file in web client for Nav 2016
Hi Experts! I have create a script.bat file and I want to run in web client. It is running in RTC but in Web client i am getting following error "The operation cannot complete because it uses a feature that is not supported (.NET Framework Interoperability.)" I have written below code. Kindly help me Process :=…
-
NAV 2016 - better deadlocking monitoring
Hi, our customer wants better deadlock monitoring in NAV 2016. Does anybody offer solution, even paid one? I found only this https://www.erpsoftwareblog.com/2017/01/jeanmartinnavsolution/ but I got no response from them. Yes, I know, NAV 2017 and later offer better locking monitor btu customer does not want to upgrade.…
-
NAV Development Environment
Good morning, I have just installed the NAV 2016 demo on a local machine. I want to access the Development Environment but I get the alert "You do not have permission to run 'Design, Codeunit, Basic' System. Contact your Administrator to have your permissions changed". How do I go about to have this issue fixed?
-
Deploy ClickOnce Dynamics NAV2018
Hi Friends, NAV2018 CU06 SDK-V8.1A NETFX 4.5.1 Windows Server 2012R2I got an error message as below when try install client from ClickOnce: "System.Deployment.Application.DeploymentException (ManifestSemanticValidation) - The customHostSpecified attribute is not supported for Windows Forms applications." After…
-
Negate the value towards Item Ledger Entry
I am trying to negate the value to negative based on a condition, and no matter what method I apply to negate it, I get positive value. Here is the code; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Item Jnl.-Post Line", 'OnAfterInitItemLedgEntry', '', true, true)] procedure MyProcedure2(ItemJournalLine: Record "Item…
-
The remote server returned an error: (401) Unauthorized
Hi all, I am trying to open ODATA web service of customer card in Excel.I tried In Excel Get External Data->Data Connection Wizard Opens->Now we can add O data ,username,Password : Web services access key(i want this as password) then when i click next it gives me following error. does any one know how to do login using…
-
How to output full array by message?
I have an array of 10 elements. How to output this elements by message without hardcoding like: MESSAGE(FORMAT(ArrayNumber[1]) + ', ' + FORMAT(ArrayNumber[2]) + ', '+ FORMAT(ArrayNumber[3]) + ', '+ FORMAT(ArrayNumber[4]) + ', '+ FORMAT(ArrayNumber[5]) + ', '+ FORMAT(ArrayNumber[6]) + ', ' + FORMAT(ArrayNumber[7]) + ', '+…
-
How to link manually created sales invoices to Prepayment sale order
Dear friends I have created sale order and posted prepayment invoice with 100% payment. Later I want create sales invoices manually and link to the same sale order. Any short cut method? Warm Regards Krish
-
Unable to select Items from Itemtable, it gives error
I have records in item table, also I can run Reports but I can see error ' The Item table is empty'. Please advice Warm regards Cris
-
Creating a Word Layout Report in Microsoft Dynamics 365 Business Central MSDYN365BC
Creating Word Layout in Business Central Consist of 3 Steps 1) Creating AL File 2) XML Mapping in Word 3) Creating Layout in Word https://divyeshchittenavbc.wordpress.com/2020/01/01/creating-a-word-layout-report-in-business-central-msdyn365bc/
-
External Document No. on Sales Order Header (Nav 2018)
Hi, I would like to know how to write a simple piece of code where under sales order header there is an field called External Document No.; If for a customer A, I have already entered the external doc no. as Testing and post the order, that's fine since it is the first time entry with such a external document number. What…
-
Error While run Nav Database Object after Restore
Hello Everyone i am trying to restore database an run nav.but it givs me following errorMicrosoft Dynamics NAVCannot connect to the server because of a protocol mismatch. This can be caused by the client and server having incompatible credential settings (ClientServicesCredentialType). Contact your system administrator.OK…
-
Why can the customers license not see the extended fields?
I have created an extensions that handles some information via the Sales Line. Simplified version is one table that holds the values/options that are available table 68015 "Order Service Contract Code" field(1; "Order No."; Code[20]) field(2; "Service Code"; Code[10]) field(3; "Contract Code"; Code[10]) And an extension to…
-
Sales Order Header
Hi, Under NAV 2018 the sales order header has a field called Requested Delivery Date. When run the table in design mode the type is as Date. I am trying to bring this field into posted sales invoice header but failed to do so. I did created a new field under 50,000 series and named it as Requested Delivery Date and…
-
Is this a bug?? Insert data in another company - the change log settings from the source company ???
We have a company that gets a refresh of all customers, suppliers, items and a few other base files. Therefor we do not need to track any changes in the change log in the destination company, and they *are* switched off in the change log settings. Nevertheless we get a full set of log-entries, and I get the feeling this is…
-
Filtering page API
Hi everyone, I've published a page that is consumed from an external application. The source table of this page, is "Item". I need to aplly one filter, not to send al the items to the external aplication. The filters logic is this: IF "Item Category Code" = 'XXX' THEN SETFILTER("Product Group…
-
BC14 Web Client shows only logo and cannot start
Hello all, Just wondering if any of you came across this issue. I have installed BC14 on my laptop and the web client cannot start and only shows the BC logo. * I can open the RTC client without issues * The C:\inetpub\wwwroot\BC140\navsettings.json file is configured correctly to target the right NST * I'm using windows…
-
Colour Coding Issue - Nav 2016
I have done colour coding on a Nav 2016 page, but when exporting the data on excel, the coloured data isn't exporting, Any way out?? Thanks in Advance
-
Grouping table by a field and finding sum in Dynamics NAV 2018
I'd like to group a table by a field- employer code and then calculate the sum of a decimal field- total contribution in that group from C/AL code. Here's my table structure Employer No_ Total Contribution
PRTEMP005022 1817.64
PRTEMP005022 1782
PRTEMP005022 2049.3
PRTEMP005022 1568.16
PR0000247148 47750.62
PR0000247148…
-
Connect Visual Studio Code to Business Central on premise
I cannot download symbols from Business Central (2019 second wave). Business Central is on a server and I have Visual Studio Code on my local PC. App.json: { "id": "a31dcs4b-0ab4-4134-98ae-f3c780b5b0ad", "name": "Moes", "publisher": "Default publisher", "version": "1.0.0.0", "brief": "", "description": "",…