-
BC17 - Creating XML Node namespace from code
Hi, I want to make an XML File from code in AL. I am using XMLDoc and its related data types. I have made a codeunit that handles almost everything what I need. I have a problem when I am setting attributes to the XmlElement. This whole thing is not working if attribute name contains ":" (colon). I know that colon means…
-
ERROUR ROUND PURCHAS INVOICE
Hello , i have a very stranger message when i posted purchase Invoice ( MSG(Amount, needs to be rounded in Gen.journal Line Journal Template Name=",Journal Batch Name=",Line No.='0') can
-
Codeunit based SOAP Webservice with XmlPort arguments
My function looks like this: customerprice(VAR Response : XMLport "Response Port";Request : XMLport "Request Port"). I have no idea on have to handle these XmlPorts in C# when creating a test program. Any ideas on how to get them from and to xmlDOMDocuments?
-
Incorrect Page refresh and User MetaData
I have an issue with a page refresh. I added to a list page that is related to table x with some fields from table y. In order to run the page with the correct data from table y, I added a line of code to page triggers OnAfterGetRecord and OnAfterGetCurrRecord: 'IF TableY.GET(Key) THEN; That works fine. However: when I add…
-
Run a report from a radio button selection
Hi All, I'm trying to create a simple form with two radio buttons. If radio button1 is selected then open Report X. If radio button2 is selected then option Report Y. Please keep in mind there are three buttons which are, OK, Cancel, Help. The Report should run once the radio button in the form is selected and the OK…
-
BC16.2 How to solve the Yellow Warning of Purchase Price
I met this problem while I was using " : Record Purchase Price" and " : CodeUnit Purch. Price Calc. Mgt.". It doesn't go wrong, but there is a yellow underscore under the Table " Purchase Price" and CodeUnit " Purch. Price Calc. Mgt." , just like the image below. And if i put my cursor on it, it will show the explanation…
-
Technical Upgrade - The file that you are importing is not based on the RDL 2010 schema.
Hi, I'm running a technical upgrade from NAV2017 database to BC14 (on premises). I've prepared the database, compiling all the objects, etc. When I finally open the NAV2017 database with the BC14 development environment, after some hours of work updating it, it shows the error: The file that you are importing is not based…
-
Output Journal Error
Dear All, I don't know why sometimes when i open output journal in NAV 2016 some routing line does not exist error popes up and my users are unable to enter their output in to the journal to solve this either i've create a new output journal batch or i've go to item table through dev environment and run item journal line…
-
An item with the same key has already been added.
During the synchronization to BC16 cu03 got this error.
-
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…
-
Dynamics NAV 2017. How to create Excel via Excel Buffer with ASCII Characters
Hello mates! I have problem with ASCII symbol transfer from Dynamics NAV to Excel, creating by C\AL using Excel Buffer. There are Table with text type field "Export Mark DataMatrix", it is a string which include ASCII symbol (Code 29, Group Separator): When I try to generate Excel by Excel Buffer I have following result:…
-
Why is permissions on TableData not set, when user is SUPER?
Hi experts, I use Business Central version 13, CU 11, build 35820 on-premise. My user has the permission set "SUPER" on all companies. No users have any user groups. I have made a button that should import lines into "Bank Account Reconciliations". When I try to do that, I get the error: "You do not have the following…
-
Simple Lot No. check
Hello, I need an idea how I could implement the following with around 15 to 20 workplaces. Every pallet to be processed has a batch sticker and when this pallet is processed, this batch should be checked or written to a table at the entrance to the production line. Now I don't want to set up 15 additional computers to do…
-
Routing by locations in regenerative planning
Our process is so that the purchases are planned and performed on one location and production - on another. Is there a standard setup to plan purchases and production this way and route the components through the transfer orders to the production location?
-
Hyphen in Json vs. API PAGE BC13
Hi, I'm trying to create a webhook to recieve events. Json looks like this: API Page like this: detail-type properties: Response from postman: If I change the - (Hyphen) to _ (Underscore) in both Json and API page, it works perfectly. Does anyone know if there is a way to use Hyphen, since this is not a Json I can control?…
-
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:…
-
Deep insert in API page problems
Hi, I'm having some trouble using API in my cloud BC. I have it working in my local docker container, but the syntax seems a bit different against my cloud BC. This path seems to work fine. https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company}}')/salesReturnOrder However, when…
-
Business Central Administration Multitenant erro
Hi all, When trying to manage a multitenant installation with te Business Central Administration tool a get the error: "Value cannot be null. Parameter name: objectToValidate" and the mmc crashes. I've reinstalled the everything but still the error occurs. Does anyone know what the problem is and how to solve it?
-
Update value in dictionary
Hi Is it possible to iterate through a dotnet Dictionary and update the value? If so could you please share with me a code example in C/AL Thanks
-
Implementing OAuth authentication using OAuth 2.0 standard features from Business Central SaaS
Hello everybody, I am currently trying to integrate a 3rd party service into Business Central SaaS and I am forced to use OAuth 2.0 authentication for that. I see there's some stuff already available through the base application, for instance table/page "OAuth 2.0 Setup" and codeunit "OAuth 2.0 Mgt.". Basically this does…
-
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…
-
Is there any way to add item in option drop down list by code
Hi All: Is there any way to add item in option drop down list by code？ I create an array and I want to bind these array items to drop down list object as option string. Is it possible to implement?
-
TestTableRelation Obsolete
As TestTableRelation is becoming obsolete, do you know what we are supposed to do instead if we don't want to test table relations? "message": "'TestTableRelation' is being deprecated in the versions: '1.0' or greater. This warning will become an error in a future release.", AL0667
-
How could I copy record to template recordref
Hi All: I try to open an temp recordref and assign value to field as the code: recRF.OPEN(18,TRUE); recRF.SETTABLE(Customer); recRF.FINDFIRST; fldRef := recRF.FIELD(3); fldRef.VALUE:='bbb'; recRF.MODIFY; recRF.CLOSE; When i use the command recRF.OPEN(18,False) , it will update the value to Customer . But if I modify…
-
NAV 2013 R2 - Prod. Order with Capacity Ledger Entry but no Output
Good morning – I wonder if you could help me with a process question – we have a Production Order which was ultimately requested to be cancelled, so we need to either delete it or change its status to Finished. The issue is, one of the subcontract purchase orders was received, so it created a Capacity Ledger Entry, but no…
-
Power BI Query Web Service
I have created a Query to export the Dimension Values for Power BI. The 'Name' column however is coming back empty with the caption "Name_FilterOnly" instead of 'Name'. Can anyone explain why this is and how to display it correctly? query 50100 "TDimensions" { //QueryType = Normal; elements { dataitem(DimensionValue;…
-
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
-
Sending Email through NAV
Hi everyone, (not quite sure this is the correct category though,) I have a custom functionality for sending emails to clients which was working as intended. The issue is that i added a bitly URL to use some web hooks and consume a web service in the html template for the emails. More specific in codeunit 400 at the line…
-
Report creation using arrays
I have created a report which shows me the data for days vertically according to the range of dates that is established in the request page. However, I would like this report to be displayed horizontally, that is, each day is a column. for example: employee code | Department | hourly wage | Day 1 | Day 2 | Day 3 | Day4 ...…
-
Testcodeunits AL: TableLocks when sugessting Reminder Lines
Hello everybody. As the title suggests, I have a problem with table locks during my small test application. I have set up a test codeunit in BC16, which should enter a customer on the reminder page (Page434, Table295) and then suggest lines by the action "Suggest Reminder Lines". This is a process that works very well when…