-
How this work
Microsoft Dynamics 365 Business Central Version 14.0.40464 Cu 90 - "Purch.-Post" has code ItemApplnEntry.SETRANGE("Outbound Item Entry No.",TransRcptLine."Item Rcpt. Entry No."); ItemApplnEntry.SETFILTER("Item Ledger Entry No.",'<>%1',TransRcptLine."Item Rcpt. Entry No."); ItemApplnEntry.SETRANGE("Cost Application",TRUE);…
-
Testcodeunits: Strange behavior when executing an action through invoke
As you can already see from the title, I noticed a strange behavior when executing page actions on a testpage through invoke(). I am working on BC16. I created a "Sales Header" in my codeunit and added a few "Sales line"'s. Then I wanted to load the page by a TestPage object and click the action "Post." Here is the code:…
-
Dynamics NAV 2018/BC Default Instance Removal
Isn't there a way to remove the default instance completely from NAV 2018 or BC ? This got has got installed when we first installed both. Googled and looks like this cannot be removed. But, we have one installation where we do not see "DynamicsNAV110". It was either removed by someone or we had setup the proper name when…
-
Validation of several fields
Hi experts, I use a Business Central wave 2 - fall 2020 on-premise. I have made a table extension for "Purchase Line" and a page extension for "Purchase Order Subform". I have added a few new fields in those two. I need to add some validation that depend on what item the user enter into the "No." field. So if the user…
-
Business Central: CurrPage.Update from codeunit - or get Line No. from subpages missing CurrPage.Upd
Hello Gurus. I am currently working on a solution, where a page pops up, after entering item no. on a subpage. On the popup page, it is possible to enter some quantity and new lines are inserted below the first line. I have made a codeunit, with an event to the subpage on the salesdocuments (quote, order, invoice, cr.memo,…
-
PDF Viewer
Hello. I'm looking for a way to show PDF in the RTC Nav. Probably inside an Addin. The goal is to have a preview in a factbox. Have you any ideas? Thanks
-
How to save file to user desktop insted of TEMPORARYPATH.
Hi All, we have issue with users that they are not saving the files/documents immediately after generating. For example: User generates "Inventory Valuation Report" into excel and just open the file instead of saving file. After some time they will shutdown the system and next day or some days later they will ask us for…
-
Enum filter in Query API
Hi In BC V16 I have created an API Query and published as a web service. The query has a filter which filters an enum field in the underlying table. I will be consuming the oData V4 URL. When I test in Postman the filter is ignored. Does anyone know how I should implement the filter? Thanks
-
Error: Business Central on-premises must be on the same major version as the online instance
During Cloud migration from BC17, after connecting Microsoft Integration Runtime.
-
GETURL
Hey, guys. I am using Web client and it works well. I want to generate a URL for every Purchase Order. There is a GETURL function, but the problem is that for some reason the result of this function has 3 problems: 1. It has the 'http', not the 'https' prefix (why?); 2. It has 48900 port number and I have no idea where it…
-
Production order scheduling order
Hi team, We noticed that when we would Refresh the PRD, the Backflush would schedule EVERY item to end at the Due date and flow backwards even if they go through the same work center (see two lines below). However our Work Center Capacity is currently set at 1, which to me would mean that it would only be able to process…
-
NavContainerHelper modifying customsettings.config
Hi all, I want to override the web services authentication method in a service tier. I know the command that should be placed in CustomSettings.config: <add key="WebServicesUseNTLMAuthentication" value="true"></add> However, our development environment is Docker, and the containers are built using NavContainerhelper. Does…
-
Changes in VS code not reflected in BCOnline
Hi, I am using a trial BCOnline. But for all intents and purposes, this should be similar to BC Online Production environments. I have successfully connected to the BCOnline using VSCode, and successfully downloaded symbols. When I try to run the HelloWorld.al, it does not get published to BCOnline. When I do the same…
-
Navision 2017 AWS signature V4
How to generate amazon signature from Navision? My code: ouputs should be: kDate = '969fbb94feb542b71ede6f87fe4d5fa29c789342b0f407474670f0c2489e0a0d' kRegion = '69daa0209cd9c5ff5c8ced464a696fd4252e981430b10e3d3fd8e2f197d7a70c' kService = 'f72cfd46f26bc4643f06a11eabb6c0ba18780c19a8da0c31ace671265e3c87fa' kSigning =…
-
BC16 webservices / API DeepInsert
Hi, I'm working on a webservice / api which will is running on a BC16 OnPrem environment. It has been working out great so far, but I experience a lot of issues, when trying to insert data with header and lines. I have created my example code on https://github.com/kefdk/bc16-api (yes, I have been reading on this blog-post:…
-
Add a Base64 encoded PDF as an attachment to a Sales Order in BC
Hi, I receive a Base64 encoded PDF through a webservice in BC16. I managed to deencode the PDF. My question is what the best way is to attach the PDF to a Sales Order? From the Sales Order I want to be able to open the PDF.
-
Purchase Tax on Expenses / Costs
Hello! I want to thank many who take their time to support many. On this occasion I would like to ask you for support in which you illustrate where I can go to do this. On this occasion, I would like the amount of the tax to be in their respective accounts. That means that the first line would have 517.50; and the second…
-
Can we capture mobile device ID in Dynamics 365 BC
Hi All, We are using MS Dynamics 365 business central on premises. User is accessing application from mobile. Can we capture his mobile device ID? If any user fill the data through mobile we have to capture his mobile device ID also. Please help how can we capture this? Thanks in advance. Regards, Kishore
-
Use variables in flowfield calcformula
Hello new here and new to AL. I was wondering. I have 3 fields in a table: field(1; Code; Code[20]) { Caption = 'Code'; DataClassification = ToBeClassified; TableRelation = if ("Status Object" = const(Customer)) Customer else if ("Status Object" = const(Item)) Item else if ("Status Object" = const(Vendor)) Vendor; }…
-
Access Microsoft Dynamics NAV 2016 SOAP Web Services via Azure Application Gateway
Hi, I have a client with a NAV 2016 Server instance hosted on an Azure VM. I have configured a SOAP webservice that should be accessed externally, via an Azure Application Gateway. I am able to access the WSDL page for this SOAP webservice over the internet. The problem is that when I try accessing any of the functions…
-
How do i correct Invemtory valuation report that shows item with 0 quantity but value
Good day everyone, I currently work as an ERP Analyst and we use NAV 2017.Recently, when we run our inventory valuation report, we discovered there are some items that have 0 quantity but with value Please note: 1.Our Average Cost Calc Type in Inventory Setup is set to Item. 2.When we run the inventory valuation, we run…
-
Codeunit 131007
Hi All, Where can I find Codeunit 131007 “Library - Report Dataset”. I can't add it as a variable in my extension?
-
Purchase Invoice Extra unfilled line error while posting
I'm getting this error when i post only the filled purchase lines in the invoice. The lines from 100000-150000 are filled correctly.But when I post its showing:- No. must have a value in Purchase Line: Document Type=Invoice, Document No.=EXP/CMUM/20-21/00161, Line No.=160000.It cannot be zero or empty. Although, line No.…
-
Business Central on Cloud (SaaS) - Export company from Production and Import company to Sandbox
I will appreciate if someone can help with explanation how to export specific company from Production environment on Cloud, and then import the same company into Sandbox on Cloud. Or, what is the "new way" to do that when client must test new development on Sandbox (development environment) with more/less real data from…
-
NAV Upgrade Tool-Set
Hi NAV community. I would like to bring your attention to the tool-set designed and was used for internal use in NAV upgrade projects. It was successfully used and adjusted in 200+ NAV Upgrades from Classic to RTC and BC. Since the fact, that our company SWP was acquired by bigger MS partner, the tools are not used…
-
Data migrate?
Hello BC experts, I have a quick question regarding data migration. We have an app/extension based on BC al programming in 14m range ISV range. Now we have developed same app in a PTE range which is 90k series. Now, we want to move all the data from 14m objects to 90k objects. Is there any tool or code that can help us to…
-
How to Export To OLD Syntax
Hi, I'm a developer currently working with some installations of Business Central 14 OnPremise. Despite the transition to the development in AL, I still need to make some customization the old way with C/AL and development environment and therefore I still need to merge object in txt. When I export the txt object from some…
-
React.js to NAV17
How can you connect to Navision 2017 from React.js or React Native. I want to both create data and read data. Say I want to create my own Navision client with React. Is there an example of this? Thank you very much stony
-
Converting Data from NAV 2009 R2 to NAV 2013 R2
Help: I converted the data (tables only) from NAV 2009 R2 to NAV 2013, according to the upgrade toolkit of Nov 22/2013. This worked fine with the "short version without installing NAV 2013. After this I attached the database to NAV 2013 R2. When I am trying to open this database in the NAV 2103 development environment with…
-
is it passible to validate field value through Navision web service before insert or update
Hi All: Navision provide web service that you could call it for insert , update ... etc. The filed value will be validated when you call web service Create / Update function. But I just want to validate field value before call Create / Update function for checking filed value legally . Is it passible to validate field…