-
How to read a string in XML with CDATA
Hello to everybody, my question is simple: i need to read the CDATA string into dataOra node ... <?xml version="1.0" encoding="UTF-8"?> -<lettera> <type>L1/L2</tipo> -<dataOra><![CDATA[Verona, li 21/10/2014]]></dataOra> </lettera> I created a codeunit exposed, with a method with a input parameter, a bigtext variable by…
-
Hello everyone, I am getting this error kindly assist.
You do not have the following permissions on TableData Published on al extensions when I try to publish, My work is onprem.
-
closing income statement error
Doing the closing income statement in Navision Version 4, I´m getting following error, posting date is not within your range of allowed posting dates in Gen. Journal Line Journal Template Name General, Journal Batch name General line no 1000 Working date is on 12/31/2021
-
Error While Compiling a table
After cumulative upgrade, I am trying to compile the objects and I found the following error. The following SQL error was unexpected: Cannot find the object " NAVDBName.dbo.CompanyName$TableName" because it does not exist or you do not have permissions. Please help regarding this.
-
BC 18.7 - NavBaseException constructor was used without privacy classification
Hi all.. i am using bc on prem version 18.7 w1 after i restore the database from server, i got this error message any idea ?
-
Trying to read an Image from SQL
I have developed a third party integration that pushes data out to SQL staging tables and pulls data from staging tables. One of the tables I am trying to read from contains a Customer Signature. It is stored as an Image Datatype within SQL and seems to be identical to the way Navision stores BLOB files within Sql. The…
-
NAV default rounding
Hi All, Hope someone can help. it looks like NAV saves the decimal data as follows: but then it's shown as: This is a bespoke table, no decimal places or any rounding defined in the table or page. I suppose this has to do with some NAV's general setup. I ended doing some formatting like:format(Pricing."UK C. Sell Price…
-
NAV 2016 warehouse management put-away unit of measure
We purchase items in eaches, we sell in master cases (1200 each). We have a purchase receipt with 15800 eaches. The put-away uom converts this to 13.16667 Cases. We want the put-away to be 13 master cases and 200 each to avoid having partial cases. Is this possible?
-
Adding Charges Automatically to Sales Order line when a button is pressed using Codeunit
Hi Experts, I need to add three item charges line by setting the values automatically on sales order lines using page action or buttons on the sales order page. The values should populate automatically based on the line item added. Can some one help me with codeunit and page actions. Thanks in advance.
-
Date format in BC 365
Something happens and date format in service tier changed and filtering date in code running on server has wrong results or can not find existing data by date filtering. This situation started sometime from 17th january. Service is running under Network Service account. What can be the reason? How to solve?
-
How to configure VAT Sales Ledger
Hi everyone, I need to open the VAT Sales Ledger page in Business Central. It seems that I need to do additional configuration because, at the moment, such a page is not available. Could you please guide me on how to access this page? Thank you! Best regards
-
Creating Multiple Local BC Docker Sandboxes
Hi, I am trying to understand how to create multiple local BC Sandboxes in Docker for different customers. Each customer has a different codebase, so I believe that Tennating does not apply. I am using the PowerShell Extension New-NavBCContainer that's within the .ps1 script "CreateBCSandbox" that you can download from the…
-
Navision Table Lock Issue
When users are trying to delete Items from Planning worksheet then Reservation table is getting lock. Is there any way to stop this locking issue? Please suggest.
-
MeadiaSet to BLOB BC17
Hello I am trying to convet the Picture field on Item tabel whish is of MeadiaSet data type to BLOB (costum field i have added on Item Table). i have tried the below link Code with no luck, i cannot se the link between picture field on Item tabel , MeadiaSet, and the Meadia system tabels. The code in the the below linke…
-
Technical Guidelines: Code Analysis Tools (CodeCop, UICop, AppSourceCop, PerTenantExtensionCop)
I would like to share a useful blog post for developers about Code Analysis tools: CodeCop, UICop, AppSourceCop, PerTenantExtensionCop. You will find here some tips on how to make your solution more readable and clean as well as some tricks on how to modify some rules, make them more or less important, and in such a way…
-
WebHook for BC Onpremise
Hi all... I have question about webhook. I am using BC on premise version 18. and integrate to 1 of e-commerce. the scenario is if any changes / update from customer in this e-commerce, it will update to BC Customer master. any advise how do we use this webhook from BC? Thanks.
-
Drilldown to another company
Hi All, I am using BC SaaS. I have created new page that show total sales for all companies. let's say I have company A,B,C so it will be something like Name Total Sales Company A $1000 Company B $2000 Company C $4000 then user open company A. what i am looking for is when user click $2000 (which is for company B) then it…
-
How to apply entries between 2 GL accounts on the CoA
Hello, I am currently on a Business Central version 19.1 w1. I want to know if its possible to apply entry between two GL accounts. I am unable to spot this functionality. Is there a limitation? I have seen that this is available on the French and Belgium localisation. Can you please help? Thanks
-
Navision Table Lock Issue
When users are trying to delete Items from Planning worksheet then Reservation table is getting lock. Is there any way to stop this locking issue? Please suggest.
-
Simplanova Objects Usage Log Tool
Simplanova Objects Usage Log Tool Upgrading your customers’ solutions from Dynamics NAV to Business Central starts with analysis and defining the project scope. Simplanova knows that this process takes time and discussion with the customer, which is usually non-billable hours so, to make this process easier and based on…
-
Date Compression for Job Ledger Entry ?
On NAV 2017 (16585) , I can see that there are date compression options for several ledger entry types ( including Cust. Ledg. Entry , Vend. Ledg, Entry, Gen. Ledg, Entry .Bank Ledg. Entry. etc) . However I couldn't find a way to date compress Job Ledger Entry records. ( also searched on Google ) . Do you know a way to do…
-
Webservice can not return response when calling from CRM
Hi All, We are using BC 16 Onprem and published a soap webservice which is consumed in CRM to push sales order data. sometimes it does not return response from BC to CRM in few cases and prompt below error in CRM. have anyone faced this issue before?
-
BC14 - NavMetadataNotFoundException in Event viewer when starting BC Service
I have completed a technical upgrade from NAV 2016 to BC14 - all is seamingly ok - but when I go to the Event viewer there are some errors that appear every time I start the BC Service - the Page ID's that are mentioned are not in the Database - not in BC and not in the old NAV 2016 database. Message…
-
BC14 config file resets itself ???
Does anyone know how to prevent these observed behaviors upon server reboot??? 1. BC14 service A copies config settings from BC service B and will not start because the ports (and everything else) are the same. 2. BC14 service resets to Demo database even though this is not installed. These are probably the same issue.
-
NAV 2017 Page webservice error "401 - Not authorized"
Attempt to consume page webservice via code: Customers_Service customersservice = new Customers_Service { UseDefaultCredentials = false, Credentials = new NetworkCredential("xxx", "*****", "domain") }; List<Customers_Filter> customersfilterarray = new List<Customers_Filter>(); Customers_Filter f1 = new Customers_Filter {…
-
updating, code changes in NAV2016 after "Enhancement Plan" expired
Hi, We have NAV 2016. We've been paying (the 16%) for the "Enhancement Plan" for a few years, during which our partner has applied only 1 CU update (MAY 2017). We want to stop paying $16k a year for this "enhancement plan". Questions: 1) Our partner is telling us that in order to update to the latest CU update, we must…
-
Add Cash Flow Chart to NAV Client
I'm trying to add the Cash Flow Chart that is available already in the Accounting Manager Profile to the Staff Accounting Profile When I went to the Staff Accountant Profile -> Customize ->Customize this page, and I added the chart in there, for some reason the chart keeps loading as the screenshot below and it doesn't…
-
How to get the value entered in the Request page
I'm trying to set a range between a date field of 0D till the date entered in the Request Page Can anyone help me with how to get the value of the date entered by the user? Also, I want to make the "Created Date" field mandatory. My code so far, when I hard-coded the date, the report runs perfectly fine, but I don't want…
-
Export file from Cloud BC to Sharepoint Online
Hi All, any idea how to export file from Cloud BC to Sharepoint online? Thanks.
-
Why I cannot find "To" and "Notity" in Notes
Hi everyone, I am working on Dynamics 365 BC14 and using web client. While I opening Sales Order then click on Notes button. I cannot find "To" and "Notify" in Notes . But I check in Windows Client, they occur as normal. How can I do if I would like to display "To" and "Notify" in Notes? "To" and "Notify" disappear "To"…