-
SOLVED: An error occurred while sending the request. Unable to read data from the transport...
Hi, I'm trying to publish an extension from Visual Studio for BC16. It has worked many times before, but now I am getting this error: The Danish part means: "An existing connection was forcibly closed by remote host." I've tried repairing the BC installation, restarting service, restarting IIS, but I'm still getting the…
-
Sorting new field in page list
Hi, may I know how can let the new field have the sorting function in the page list? e.g. I created a new field to calculate the Balance in page list, but I can't do the sorting, I want to design same as below, when click the field will show like below one.
-
Dimension not appearing after running Calculate Depreciation for FA
Hi Friends, [Version NAV 2018]. After running Calculate Depreciation for Fixed Assets, in FA G/L Journal in the Dimensions Code column the value is not picking up from Fixed Asset's dimension and it is blank for all Fixed Assets. I might be missing something somewhere. Can anyone let me know what am I supposed to do?
-
Business Cental-How to show only Person Contact
hello guys, this code shows both Company and Person Contact. is there any idea(setrange or filter) to display only Person Contact? Thanks trigger OnLookup() var ContactBusRel: Record "Contact Business Relation"; Contact: Record Contact; begin ContactBusRel.Reset; Contact.Reset; ContactBusRel.SetRange("Link to Table",…
-
In CalcFormula of FlowField, how to filter the values on basis of some field from a setup table?
I have a solution where FlowFields are calculated on the basis of a hard coded filter, now i have moved all the hard coded values to a setup table to make the solution generic. But i am unable to filter on the basis of field from setup table. In the image below, i want to filter it like "Job Task No." =…
-
How to create sales order from web shop program?
Hi experts, A company is making a new web shop for our customer. The web shop is calling the NAV page 42 ("Sales Order") in order to create a new sales order and some lines on it. When they use Wizdler in the Google Chrome browser, it works fine. When they use their own code to call NAV, there are some "401 Unauthorized"…
-
Write only to an external database in BC 15 OnPrem
I'm trying to write (insert) to two external tables from an on premise installation. We're essentially updating shipment label information for an external process to pick up the label data. I have no need to read or modify existing records in the table, although I will need to be able to delete based on a date/time filter.…
-
Iterating over record set twice
Hi All Working on an extension where I need to swap items on Sales orders and Blanket Sales Orders (where qty shipped = 0). If I have sales order lines linked to the blanket lines, I need to do the following:* Disconnect the Sales line from the blanket * change the item on the line * Change the item on the blanket line *…
-
[Business Central] Showing Notifications on Sales Oder Processor Role center Page
Hi Community, I have a problem regarding notifications on my Business central 16 On Premises version. I am showing a notification on 'Order processor role center' page using 'OnRoleCenterOpen' EventSubscriber but what happens is when I refresh the role center page it refreshes twice and notifications appears twice but When…
-
Mass updating sales lines
Hi All Written a few small extensions and need to write one that updates all sales lines with no shipments. We frequently have to swap out items for replacements (but need to keep the old ones as we may sell later) So I need to create a codeunit to swap the item on sales lines. I've got it working except for when the sales…
-
Cannot create an instance of the following .NET Framework object:assembly TransAutomClient
Hello, I am newbie here. During my testing for a scheduler job, testing connection, i have encountered this error. Please help me.
-
Sorting on flowfields (in NAV 2017)
Typically, we can sort on any field by clicking on the column header, even flowfields. E.g. sorting on Net Change in T18 Customer works fine, as well as on Inventory in T27 Item. However, if I try sort on Net Change in T15 G/L Account I get error: "Sorting cannot be done based on the Net Change field(s) in the G/L Account…
-
how to clear listpart data?
When I'm creat a new card page it gets previous card page data. How I can remove this problem?
-
Date Formula
Hi, I have a hard time figuring out what my date formula should look like on my items. Our suppliers deliver 2 times a week (tuesday and friday) so what I would like to achieve is that the customers would get the fastest delivery date. E.g. if a customer orders on a wednesday and our suppliers have 3 weeks delivery the…
-
Read image file by webservice in AL
Hi All, I hope somebody can help. Im trying to read an image returned from a webservice, however, I´m not sure much about it. This is what I´ve used for reading xml response which is fine, since is a text that I then parse, but as image, I´ve never done before. Any ideas? thanks a lot. RequestHeaders :=…
-
Two Sales Order Workflows required
Hi, I have an issue with the workflows that have me confused and I cannot seem to find any solution for this issue. The scenario is as follows; We have 1 workflow that is setup under sales, MS-SOAPW where we have set certain criteria for this workflow. It is a custom field on our Sales Order for Gross Profit percent, and…
-
Can't "Print WHT Certificate" on page "Payment Journals"
I've tested and debug from different version, The result is still the same error, What should I do?
-
BC14 CU11 App Install Error
I am facing issue when I try to install Suretax app on BC14 CU11. I am able to install app on Cronus BC14 CU11 Database but I am getting error as shown in below snapshot when I tried to install on Customer Database. I have already generated symbol for all objects and resolved compilation error. Any help is appreciated.…
-
Business Central 17 - D365 2020 release wave 2 preview
Hi All, I'm upgrading a vertical solution to business central AL from BC 14 C/AL. Does anyone know of a preview version of BC 17, maybe on docker that I could get my hands on please? Or do I need to use BC 16 for now? Regards and Thanks Roddy
-
Can I modify the Standard report in BC 16?
Hi guys, May I ask how I can modify or add a new field in the BC 16's standard report? Thank you.
-
RDLC problem
Hello, I am creating a report in Business Central, using Microsoft SQL Server Report Builder. The report has a tablix where it iterates lines. The lines have a field called "Line category". There is a repeater and for every line I want to control if the line gets displayed or not. I therefore select a row and select the…
-
Boolean checkbox in factbox
Hey everyone, Is it possible to display a Boolean field as a checkbox in a factbox? It is not necessary to make the field editable. I just want to display the normal "Yes" and "No" as a checkbox.
-
Pass the value between pages
For example I have "Page A" and "Page B" And I have to pass the value from "Page A" to the "Page B" For this case I was created the function that takes as a parameter value(the value that I have to pass) on "Page B" In the body of this function executes next: parameter := globalVar (where globalVar - global variable of…
-
[SOLVED] Passing Data to JavaScript Addin
Hi Guys, We are starting with the Adding development and I was wondering what is the preferred way of passing a lot of data to JavaScript addin. Sure, passing single variables is simple, but what about something like an array? How about a record? Any help is appreciated. Thanks
-
User interected fields in NAV/BUSINESS CENTRAL
Hi BCExperts, I need your valuable suggestion on below query!! Is there any way to get a user modified field through code? For example, I want to prompt an error to user if he/she modify a field that is blocked for her/him. For this i have subscribed OnAfterOnDatabaseModify event from GlobalTriggerManagement codeunit. But…
-
Code coverage: time spent per object?
Hi, I´m trying to find some performance issues and as you know, it is tricky, specially when the code has a lot of bespoke and facboxes you are not aware of. Do you know if there is any tool that tells the amount of time spent in each object? This could ease the search between them. thanks.
-
Print MediaSet (or stream) on business central
Hi folks, I have a kind of weird request. My customer made me save a .pdf file on the item record. I saved it in a MediaSet data type filed. I can save/delete/download it without problem. Now he is asking me to print it. I'm working in BC16 so I can't/don't want to use temporary path or whatever. I wish to print the file…
-
Passing credentials through SOAP Header in XML to connect to NAV Web Service
Hello, Hoping someone has come accross this before, but has anyone connected to a NAV Web Service to create data in a table and passed the credentials through the SOAP Header section of the XML within the envelope? NAV Version: NAV 2017 NAV Authentication: NAVUserPassword I am using SOAPUI to Test and I can insert data…
-
How to call webservice which Require Json structure and XML as attachment using REST API .
Hi i am trying to call an API which require Param as Json file structure and xml file attachment as body .
-
I have not action "Open in Excel" on pages BC16.
We have two the same databases but in 1st database I have this action in 2nd - not. Excel version meets the system requirements of Microsoft. Permission sets include either the D365 Excel Export Action permission set or the system permission 6110.