-
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"…
-
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…
-
'Failure sending mail. Unable to read data from the transport connection: An existing connection was
Hi everyone I have implemented some mail sending functionality to send(Posted Sales Invoices) with custom email body, when I try to send multiple it send few of them and show a message that enables sending email If I try to debug it shows them following error. "'Failure sending mail. Unable to read data from the transport…
-
Currency Error
Hi Folks, There is no problem in cases where there is invoice and then payment, but when the payment and then the invoice are received and these two transactions are applied to each other, that is, when the application is made, there is a problem in the G/L Entry records and the realized loss or gain account line. This…
-
website certificate of mibuso.com seems to be expired
The cert of mibuso.com seems to be expiered. My WEB- Brower warns me for the expired certificate.
-
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!
-
German Language
hi, anybody can send me the German language? how do i say Lot No. in German? 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…