-
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…
-
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…
-
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?
-
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…
-
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?…
-
Upgrade Record Links
I am having trouble finding help with upgrading Record Links from NAV 2015 to NAV 2018? Nay help would be appreciated. The client did not bring over all their old data, like customers and items. I have tried following Gunnar's suggestion found here: https://dynamics.is/?p=1193. I was able to get the data out and decoded…
-
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
-
customize standard C/AL report as AL
I'm trying to make a customized version of report 4 i BC ver. 14, so I've ExportToNewSyntax and Text2Al, this gives me 4 files *.al, *.rdlc and 2 xlf, I have added the al and rdlc to my vsc project, here I have added possibility for Dimension filter and corrected the RDLC path in the al file, this all went smooth, but when…
-
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…
-
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…
-
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;…
-
Set-NAVServerUser to add profile to user failing, after New-BcContainer for BC 17.0.16993.0
Hi, I am trying to add a profile (role) to a user. I have created a docker image/container using New-BcContainer and then using Set-NAVServerUser as below. However, I am getting an error. I have tried various profiles ACCOUNTANT, BOOKKEEPER etc. Regards & Thanks Roddy
-
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…
-
One Field is editable when I am in View Mode of page
Hi Friends, One field is editable when I am in View Mode of page, can anyone help how can I do it to behave like nav standards (the field is a variable)
-
Is it possible to create a RDLC layout with a picture besides the item extended text?
I would like to know if it's possible to display the image of an item besides the item extended text (see example below) in a RDLC layout?
-
Error when compiling codeunit 9010 (after upgrade from NAV2017 to BC13)
After an upgrade from NAV2017 to BC13 I get the error message below after compiling codeunit 9010, does anyone have any idea how I can fix this? (error message is in Dutch saying 'The found assembly manifest definition does not match the assembly reference')
-
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…
-
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 ...…
-
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…
-
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