-
FTP download azure function
I have function for uploading a file to ftp and I woud like to know the equivalent function for downloading and renaming the file. I have no experience with c# I only use this functions to post them to azure function and then consume them in BC. I would be thankful is anyone could show or guide me to have the equivalent…
-
How to get
Hello, All of the "Header" data fields in the Demand Forecast page 99000919 are global variables. I want to default the View by Period to Month and also verify the same when the page closes. How can I get that value? A. I have tried using Modify(PeriodType) to get the value from the OnAfterValidate trigger. PeriodType…
-
Web Client Signin
I've installed BC14 on two server. First with SQL and BC Server. Second one with web server component. When Login with URL https://localhost/BC140 all works great and I can login. If use https://servername/BC140 after login return on signin page. In browser address bar: https://servername/BC140/SignIn?ReturnUrl=/BC140/…
-
Problem creating middle tier
Hi, I am trying to create a new middle tier on Nav 2015 and I keep getting this error. Unable to locate the default ServerInstance. This happens if I use the admin tool or if I use the powershell command. I don't know where I would find or configure the default instance. Can anyone advise? Thanks
-
XMLport import error when Nodename ends twice
Hello mibuso-members I've got a Problem with an XML import. I get the Files from the Customers and can't change how they are. Here's an example how the XML-Files look. It all works when the "NotMandatory"-Field isn't empty (No.1). As soon it's empty (No.2), two closing </XMLSample>-Nodes appear and Navision gives an Error.…
-
Whether it is possible to use a debugger to understand from what place object are call?
For example I can view page as a developer. But I have to understand the place which page is calling from? Can I use debugger in this case?
-
RDLC: Error in fill background color of row
Hi all, When I want to fill the background of a text field in an RDLC report I get the following error on the Description field, all the other fields in the same row don't give this error and work perfectly. =IIf(RowNumber(Nothing) Mod 2, "LightGrey","White") Any thoughts?
-
Group Data in List Pag
Hi, How can i group data in a list page by item code? I have developed a Matrix page on Item ledger entry, i want to group data by Item code. How can the same be done?
-
Saving a file to Sharepoint
Hello, I would like to know the setup required to automatically save a file to SharePoint from Business Central. Please could someone direct me to any blogs which explain this well. This will be on the back of creating a .txt file via Data Exchange. We are on Business Central 16.1. Thank you.
-
API Query in BC
I want to make a custom API with items and customer discounts. So I made a query and connected the item table to the Sales Line discount table. query 50100 "Itemprice Entity" { QueryType = API; Caption = 'Itemprice API', Locked = true; APIPublisher = 'Me'; APIGroup = 'Client'; APIVersion = 'v1.0'; EntityName = 'itemprice';…
-
Business Central: How can I do automated testing of Processing Only Report ?
Hi Community, I need to do automated testing of processing only report, I need to cover the code written in OnPreDataItem and OnPostDataItem triggers ? Can anyone give me head start, i'll be very thankful. thanks
-
XMLPort In Business Central
Hi! I need to catch the URL of a file imported with the XmlPort. With the Windows client, i can get the total file name (URL+File Name) with CurrXmlPort.FileName, but with the Web client, i can only get the File Name (without the URL). I need this info to save it in a log table (with other infos like File Size, Date, Time)…
-
Loggin HTTP traffic in BC SaaS
Hi all, Is there any way to log the http traffic into a BC cloud tenant? The thing is that I have created an integration with an external service. I'm sending a job with the related tasks and planning lines to that service. Each entity creates an entry into the external Service, I know that the call via HTTP post is…
-
Views and OData webservices
Hi everyone, I created and saved a view in dynamics NAV 2017. Is it possible for an OData webservice to run with the filters from that view? I mean is it possible for the webservice to retrieve dynamically those filters? Thanks in advance :smile:
-
how to send data to webhool
Can anyone help me to synch data using webhook. I have doubt only URL. what is URL for data exchange for example customer card I have both https and http with SSL for on-promise need few steps Warm Regrads Kris
-
Extension disappearing from user menu
Hello, I'm having problems with an extension in version 2018. Sometimes it disappears from the RTC menu (it's always visible from extension management) and the only way to make it visible for the users again is to restart the service tier. It disappears from all users (both super and other types of users). Does someone…
-
Reverse Payment that already applied to Invoice
Hi all, I'm trying to reverse automatically a payment to a Vendor using these steps. Step 1) Unapply the payment from the invoice Step 2) Reverse out the transaction. Step 1 i have no problems. When i try to reverse automatically Payment of a Vendor, i'm getting this error: LOCAL InsertFromGLEntry(VAR…
-
BC Automated Testing: Code coverage page is not opening in Business central 17 on premises version ?
Hi Community, I was doing automated testing on BC 17, what I have noticed is that you cannot open code coverage page. it says 'You can only run code coverage in a sandbox environment'. Previously I was able to open code coverage page in BC 16. Can someone tell is there a workaround to open Code coverage page ? thanks
-
Is Business Central enough
We have a Customer running NAV 2016 today and we are discussing a fresh start in Business Central. One question that has come up is of Business Central is enough. In 5 years time they are planning to handle 50-100.000 sales orders a day. Any thoughts from You! who has ran large installations WorldShop be appreciated.
-
AL begin..end blocks changed colour?
Hi All, I hope every1 is safe! There is something that I´ve realised in my code, for some reason "end" blocks come as red? I experienced this I think when I copied some piece of code from classic nav but as the codeunit is very long I can´t identify if I did this now at some point. Any ideas? thanks.
-
Item charges affecting unit cost
I'm facing the following problem: when a Purchase Order with a respective item has some charges, for example transport and insurance, and i invoice the Purchase Receipt of the item and only one of the charges, the charge pending will affect my Unit Cost The cost expected of the insurance is afecting the unit cost. The…
-
Inserting records in a page build from a temp table.
Hello everyone, Quick question; Is it possible to insert a record when the page is build from a temporary table? There is now a button to create a new record which is not working and I want to know if it is possible to use this button or that it is better to just remove it.
-
Unittesting and mocking?
Hi everyone this is my first post here so please be gentle. I was recently granted the honor of my company to start getting to know the inner workings of NAV and now BC14 on-prem in order to be a better orderer for our dynamics partner. Being a C#-developer I soon became interested in getting to know how to code in C/AL…
-
Worksheet Page,. Datasource is a union, Export using XML port
Hi All Still relatively new to Nav/AL extension development. Trying to figure out how to approach this extension We have items we need to label (the labels will be generated by exporting a CSV file for LoftWare labelling app). I need to show a list of records based on a few parameters (mainly start and end date) The…
-
What/How is the link between Customer number in BC and GUID in Dynamics 365?
In a BC14 solution we have set up the synchronisation from Business Crentral to Dynamics 365 using the "Microsoft Dynamics 365 Connection Setup" The flow is goo, and the changes are flowing as they should. Now however we need to be able to receive customized comments related to Customers from Dynamics 365 back to Business…
-
Blank page between report pages in PDF format
When I try to print my report in PDF format I have next result: First page: first page of the report Second page: blank page Third page: second page of the report Forth page: blank page Fifth page: third page of the report and so on... How can I fix it?
-
Synch data from BC(Item Unit of Measure Table) to CRM(Customized Table same structure like BC table)
Hi Experts, I need to synch data from Business Central ("Item Unit of Measure" Table) to CRM (New Customized Table same structure like BC table). I used CDS setup for this but not able to synch this because of this table is not showing in Table Mapping in CDS. So, I go with AL Code level but NAV integration concept is not…
-
Delete Empty Registers
Hi, Is deleting empty registers (G/L, Item etc.) necessary? If so, why? What causes empty registers? Thanks, Rachel
-
Making a field mandatory
I want when a specific product is selected that field becomes mandatory when it`s a different product the field is not mandatory. how can I achieve this?
-
Business Central SMTP TLS version
Hi all, Does anyone know if Business Central is using TLS 1.2 for sending SMTP mails? Thanks! Jan