-
Export XML lines without header
Hi!, I'm using an XMLPort to generate an XML but I need generate an XML like this: (repeating error without header): <Response> <Errors> <Line Number=1> <Comment>comment</Comment> <Error>Error x</Error> <Error>Error y</Error> <Error>Error z</Error> </Linea> <Line Number=2> <Comment>comment</Comment> <Error>Error x</Error>…
-
How can I automate republishing?
As it currently stands, BC requires all apps with dependencies to another app to be unpublished before it's possible to update it, making us either have to unpublish multiple apps manually or unpublishing and publishing every custom extension through a hardcoded sequence of PS-commands. I find this very tedious and…
-
NAV 2016 TextEncoding problem
Hello, I have a problem with TextEncoding. In general, what I am doing is:TempBlob.INIT;
TempBlob.Blob.CREATEOUTSTREAM(OutStream);
OutStream.WRITETEXT(SomeTextVariable);
TempBlob.ReadAsText('', TEXTENCODING::UTF8)) Where SomeTextVariable = 'xńx'. As you can assume 'ń' is making me some kind of trouble. Sometimes (but not…
-
A how-to question
Hi everyone, I wonder if it’s possible to make a phone call using URL? If so, how can I do that? Thanks in advance.
-
Dataverse Integration Sales -> Business Central
Hello to All, I have setup the integration between D365 Sales and Business Central successfully. Creation and updates of accounts is working fine between the two systems however when i deactivate an account in D365 Sales this does not update the Customer in Business Central. I am using the OOTB functionality. I was just…
-
Testing ListPages
Hi, Is there any way to invoke the "New" Action on a Testpage based off of a ListPage (e.g. CustomerList), in a way that the CardPage opens with the new Record? TestPage.New only "puts the cursor in a row" - which does nothing in a Page that is not editable.TestPage.OpenNew does nothing in a ListPage as far as i figured it…
-
Item Unit Cost
Hi, In an average unit cost codebase .. is the "unit Cost" on an item record inclusive of "indirect cost %" or is this only considered when entered on a purchase line ? And is this ever considered when entered on a sales line ? MY current testing suggests no to both but im curious as to why, if it is so..
-
Reservation Entry
Reservation entry not getting update when changes in sales line.
-
How to Import XML File to BC
Hi All.. how to import xml file to BC? I am not familiar with XML port? should we use XML Port? or use standard code? anyone can share? here is the sample file.<supplier operation="add" id="V-000001" exportTime="2021-07-16T18:03:04">
<alias>VENDOR ABC</alias>
<company>Vendor ABC</company>
<addUser id="1">dcs…
-
Activating "SN Warehouse Tracking" afterwards
Hi all, this has been asked before, but with no real answer. We have just one Item Tracking Code with "SN Specific Tracking", "SN Purchase Tracking", "SN Transfer Tracking" and "SN Sales Tracking" enabled assigned to many items. No we want to use bins for some locations, and in order to create Warehouse Entries with the…
-
Sorting cannot be done based on following FlowFields, you must set the security filtering mode to ‘F
Hi, Need help I logged into development environment and changed the property of the flowfield from validated to filtered but the error still persists
-
OK button in BC
Hello, I have an issue when running a page using runmodal = lookupok The source of the page is a temporary table And when this table is empty the OK button is disabled Is there any way to enable it?
-
FILTERGROUP Sales Order by Location
I'm having a filter problem on the Sales Order list and the Employee warehouse table. I want to set filters the Location codes on the Sales Order (sales header) according to the location codes of the user when opening the Sales Order List page. (The Sales Order list only shows the location codes by the warehouse employee…
-
Key field in Webservice
Page 201 "Job Journal" is published as a webservice, when i read multiple lines from the job journal through post request from Postman i get all the data plus a field "Key". I am not sure where that "Key" is coming from and how is its value populated. I want to store this key to a custom field in Job Journal Line table,…
-
xxx is inaccessible due to its protection level AL(AL0161
Hi, We are in the process of migrating our C\AL application towards AL. One of the issues we need to deal with is that in some page extensions we would like to access the value of a global variable in the base page. However this is impossible, getting the message "xxx is inaccessible due to its protection level AL(AL0161)"…
-
NAV Mobile App cannot connect to the server on Tablet
Hello Good day, Masters. I have a problem using NAV Mobile app, it says Cannot connect to the server. 1. I didn't use HTTPS, only HTTP. didn't use any signed or self signed cert. all I did is that I install normal configuration and that includes web and just forwarded the port. 2. Outside network, Web and Phone client…
-
Import flat file to create invoices in BC
Hi Guys I have looked at below NAV thread to get ideas on how to import a flat file and create invoices to BC https://forum.mibuso.com/discussion/52828/xmlport-flat-file-import-header-line-on-one-line So my file is imported to a staging table and external number is used as unique key since auto numbering of invoices Ext_No…
-
Error msg "You cannot reverse Cust. Ledger Entry..."
I try to reverse Customer ledger entries and get an error message "You cannot reverse Cust. Ledger Entry No. 871 because the entry has an associated Realized Gain/Loss entry". How to solve this issue? Is there any way to reverse the payment if it is in foreign currency?
-
how to check if record already used
hi, urgent help, please how can i check if record from one table has already been used, i.e. im filtering table x by vendor no, then i use this vendor no in my table. how can i check if its already there
-
Hello during the installation of BC 14 I have the following error message
Hello during the installation of BC 14 I have the following error message:
-
all page long fields
hello, how can I make the fields on the page long from one end to the other
-
Temporary tables outside of license range
Has there been a change in the last 12 months for how these are handled? A BC14 license from Jun 2020 allows me to use tables outside of my license range so long as they are Temporary = yes. But when I try do design the same object using a license from July 2021, I get: "You do not have access to read the 'XXXX' table.…
-
Barcodes in Business Central
Good morning. We have a customer, with Business Central, who has in a list of orders a field created to save the text of a barcode for each product. How should I do to read the barcode and enter the text read in that field created from a tablet? Best regards!
-
Business Central: Payments in international currency
Good morning! I am a developer for a Spanish Microsoft partner company and I have a question: How could I export a payment file with international currency? It would have to be a file similar to SEPA, but as I mentioned, it has to be in international currency. Best regards!
-
SSRS: How can i format decimal number without rounding ?
In ssrs, how can i format 1.52467 to 1.5246 without rounding up ?
-
Bank balances
hi! how do you do bank rec on a new implementation
-
Test codeunit failed after Modify
Hello. I have a problem with testing. In a test codeunit I am inserting a record to a table. In application, which is being tested, I have a subscriber to OnAfterInsertEvent, which is modifying a record if some particular conditions are satisfied. Debugger stops on "Modify();" line and after that all I can see is…
-
NAV Server/NAV Web Services and SQL: fail
I have this installation: NAV Server 2009R2 with service account to start NAV Server and NAV Web Services (domain\navadmin). The SQL server is on another server with a login account (domain\sqladmin). I have registered these SPNs setspn -A DynamicsNAV/servernav.domain.local: 7046 DOMAIN\navadmin setspn -A…
-
Using BC on a mobile browser without being asked about the app
I have to set up a Business Central client on multiple Android devices using the Ivanti Velocity Browser. It works fine, but every time the session is started there is a page asking the user if they want to download the dedicated mobile app instead. I already tried using a direct link to a page to see if it would…
-
Single Sign On Authentication, Sign In screen error: an error has occurred
Hi, We have an installation of NAV2009R2 (CU22). We have a NAV Service configured to use Single Sign On (authentication type "AccessControlService"). It works fine for most users, but for one particular user, we receive an error (attached): An error occurred in the script on this page Error: Script error:…