-
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.
-
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 ?
-
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?
-
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…
-
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.
-
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 {…
-
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"…
-
Can't see serial numbers at invoice screen
Hi Guys, We took the product, whose serial number we tracked, into stock. We transferred to another location. Then we want to make sales from that location. However, it does not appear among the available serial numbers in the item tracking section of the sales invoice section. When we examine it from Ledger Entry, there…
-
how to find name within a name
Hello, newbie here I have this name 'Name Name2 Name3 Surname'. From this I need to extract the surname. How is this possible. If they were two names only, I could exclude up to the first space but what if they are more?
-
Sub Page ProviderId and updting a factbox based on a temporary table
NAV2013 I have a Page, with a SubPage (ID:1000000001) and a factbox (ID:1000000022 and Provider ID:1000000001) with appropriate SubPageLink. All works. However, I need the factbox to be based on a Temporary table pulling out various fields from the factbox SubPageLink record and showing them in rows rather than columns. So…
-
Combining two role centers into a new one
Could anyone guide me on how to combine two role centers into a new one please? What I meant by that, I want to add all the pages actions and queues for those two role centers "production planner" along with the "Purchase Agent" into a new one. Thanks!
-
Records, RecordIDs, and RecordRefs OH MY!
Arg. Ok, I grew up on MS C/Side documentation examples like: Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy…
-
How to send item picture to SOAP web service?
Hi experts, I need to create a SOAP web service codeunit that gets an item number and returns the picture that is on that item in Business Central cloud. (I think there can be more that one picture, but I only want to get the first picture.) I have made the procedure below on a codeunit, but it doesn't return anything.…
-
Delete Large amount of Records
Ladies and Gents, Due to some wrong functional setup and programming, one of our clients now has a table with 2bln lines which takes upto 2tb of storage. The table data is not being used anywhere anymore.....;) I have been trying to delete these through processing reports and codeunits, with deleteall. This does not work…