-
Query bug in Business Central?
Good morning, I encounter some weird behaviour in Business Central (140,cu2,on prem,C/AL). When I create a new simple query with 1 dataitem (Record Link) and 1 column (URL1), I get the following error when I try to save/compile: I know the length of URL1 in Record Link table has been stretched to 2048. According to the…
-
The value of the Decimal parameter is outside of the permitted range
Hi All, I'm getting this error when trying to export a decimal field with the value shown in the error below. This is in NAV 2016 However in NAV 2009 I don't get this error. Has the maximum size of the decimal number allowed changed? Regards Albert
-
Xamarin Webservice Soap NAV17
Hi, I would like to create a Xamarin app for Android and IOS that communicates with Navision 2017. As far as I'm informed I can do that with NAV17 only about Soap (need Pages and Codeunit). Perhaps someone has an example of how I can make this web service connection for both platforms. Thank you very much stony
-
Residual Account account getting impact with 0 value
Hi Experts, we have done the setup for additional currency reporting in NAV-2016 with USD. to execute this, in currency master Residual A/c. While doing any kind of transaction this GL (Residual Account) is getting the effect with "0" value. due to this, my in general ledger entries volume is getting an increase. please…
-
Error while posting Purchase Order
Hi, I am trying to post a purchase order in Dynamics 365 Business Central (On-Premise). That order has items which are already received but not invoiced yet, hence when I try to invoice that order. I get the following error. "The changes to the Purchase Line record cannot be saved because some information on the page is…
-
Consolidated Trial Balance New 2013
hi, am facing problem with consolidated trial balance new in 2013. Till last month i was able to get data in this report. Now suddenly this report is coming blank. Kindly help me to resolve the same.
-
Read XML File for Cloud BC
Hi All, can share how to read xml file for cloud bc? Thanks.<?xml version="1.0" encoding="UTF-8"?>
<Invoice xmlns="urn:oasis:names:specification:ubl:schema:xsd:Invoice-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"…
-
Setup Internet access to Business Central Web Client and App
Hello everyone, I am attempting to setup a client's Business Central (BC14) for Internet access via the Web Client and the App. I find the documentation and resources for this quite sparse so I was wondering if any of you could point me in the right direction? I am looking to create a complete setup including:* Setup of…
-
Getting error Dynamics 365 integration
Hi I am getting error while setting up Dynamics 365 connection setup. I have entered Domain user id and password and authentication type AD "The connection setup cannot be validated. Verify the settings and try again. Detailed error description: Organization cannot be null or empty. Parameter name: Organization Name" warm…
-
SOAP Codeunit Function with Container
I have trouble calling a simple test function via SOAP. My function:codeunit 70005 TestWS
{ [ServiceEnabled] procedure add(a: Integer; var b: Integer); begin b := a + b; end;
} (I also tried this in C/AL (Windows AND NavUserPassword Auth + "ServicesUseNTLMAuthentication = true" ) My container is a…
-
Business Central OnPremise Viewer licences (Type Team Member) Problem high costs
Hello together, perhaps could you please help me with the following problem: A potentiell customer will need, besides about 10 "Full User", about 300 Viewer licences (Limited, Read Only) for Business Central OnPremise. The most of the Viewer Users look perhaps once or twice per month for a short time into the application.…
-
NAV 2016 installation on Docker
hi all, i want to install nav 2016cu 23 IN on docker when i try to pull image it gives me error as Error response from daemon: pull access denied for microsoft/dynammics-nav, repository does not exist or may require 'docker login': denied: requested access to the resource is denied while it pull all other nav cu23 with…
-
Setting Array Values in Dynamics NAV 2018
I built a class library application-dll in C# with the class definition below:namespace Microsoft.Dynamics.NAV.NAVInteropHelper
{ public class WrapDecimalConvert { public static Type GetTypeofDouble() { return typeof(decimal); } }
} I added the dll to the application, declared the following variable in my globals Name…
-
Job Queue Stuck after post batch
Hi all, I am using cloud BC after I tried post sales invoice using post batch, with some errors then there are these Job Queue Stuck. how to prevent this? i tested with same scenario in bc on premise, there is no error message like this. is there any setup? (p.s : i didnt tick background posting in Sales & receivable setup)
-
Web client how to browse a file
In NAV client it is possible to browse the local computer and make a link to a file In Browser this is not possible. This does not really make sense. How is user supposed select file?
-
Business Central multiple production instances
Dear all, since wave 2 it is possible to have multiple production instances for one tenant. I have a scenario coming up where a customer wants to use BC in different countries (for different subsidiaries of the mother company) . What would be the best approach? Creating a new production instance per country or working with…
-
Dynamics 365 sales connection
Hi I have Dynamics 365 BC and CE both on premise only. Still I did not buy SSL Hi Necdet, I am working on on-premise installation of both BC and CE. Still I did not get SSL certificate , so I am using http protocol only. I am getting the following error. please help warm Regards Kris
-
Inventory valuation report with detail transaction
Hello everyone, As I know the Inventory Valuation (R1001) show data per item. However, I need the report like inventory valuation report but show detail transaction also. There is any standard report that serve my requirement? Thank you.
-
Bundle Items in Sales Order
Hi Friends Need an advice. We are on NAV 2018 and recently upgraded from 2009 R2. We have a new requirement to limit selected items' sale as individual items. Usually they come in pair but SKU is different (different code/costing etc). We must sell both at the same quantity or nothing. So, need a way to suggest the other…
-
Can filter the dataitem just load specific value in report
Hi Guys, I have a NAV report as below: - Dataitem is a table has more records many types: 1, 2, 3... - Need to create a report just load the type = 1 when openting the report. Note: Do not allow using the Request page. Could I do it with dataitem not use the request page? Please give me some advices. Thanks,
-
Assign a value from Gen Business Posting Group Table.
I have got Gen Bus. Posting Group field showing on the subform of Sales Order. This Subform is also showing Location Code for the Line. I am attempting to write a logic as such that if the User selects Location Code as DROPSHIP, the Gen Bus. Posting Group should be LOCAL-DROPSHIP. LOCAL-DROPSHIP is a record in the Gen.…
-
Technical Upgrade to BC15 possible with BC13 Objects?
Hello, one of our customers had the brilliant Idea, that they want to do a technical upgrade to BC15. And while they have a BC14.5 Client, the objects in the database are actually BC13! Is it actually possible to do a technical upgrade with that constellation? I'm beginning to believe not since while trying it, I'm…
-
Consuming web API from C/AL
Found very helpful post and figure out the basic steps, thank you for you attention :) https://www.kauffmann.nl/2015/11/26/web-services-examples-part-1-the-basic-pattern/
-
Move a table from an extension to an other
Hi everyone (excuse me for my bad english), Someone told me that he cannot move a table created in an extension to an other because GUID of the extension was directly save into the parameters of the table I'd not the chance to test it by myself already, but I wonder if someone here has have to do that in the past and if he…
-
Error during Processing-Only Report trough Table Lock
Hi, we use in a processing-only report the item table as data-item. we iterate over the results and write some data in other tables. from item table we read only. there are no write actions for the item table. some time the report failed, because of a table lock of the item table. why happens this error? the report reads…
-
Change Bank Reconciliation Criteria for matching.
HI Guys, I just want to ask a question if it is possible to break the criteria for automatic matching in Bank Account Reconciliation module in Dynamics NAV 2018 (specifically)? because the client have a set of requirements that doesn't fit the Bank Account Reconciliation, but they do insist to use it based on their…
-
XMLPort in DBC on Premise
Hi folks - I created a XMLPort in AL to import gen. journal lines. I complied and created the package without any errors. Now when I go to Web client and try to search my XMLport I cannot find the object. Does anyone know how to search the XMLport. Many thanks for your help. Thanks RJ.
-
Ask for options before open a page
Hi! I have a page that makes a lot of calculations, so I would like to ask the user for the start and end date before open the page. Something similar to the Request Page of the reports, but to run a page, not a report. Some idea? Some similar behaviour in standar NAV? I'm using NAV 2013 Lot of thanks
-
CreateBookAndOpenExcel function in DBC 365
Hi Folks - The function CreateBookAndOpenExcel is not supported in Extension development. Does anyone know any alternative solution for this issue. Many Thanks for your help. local procedure CreateExcelbook(); begin ExcelBuf.CreateBookAndOpenExcel('',Text012,'',COMPANYNAME,USERID); ERROR(''); end; ERROR The type or method…
-
Export to Excel - Business central 365 Wave 2
Hi folks - I have a processing only report with 2 data items and a procedure Makedatabody. I get the errors that Sales shipment header and Sales shipment line does not exist. Can anyone please let me know how do i refer to a field in 365 BC. Many..Many thanks for your help. Sales shipment header Sales Shipment Line…