-
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…
-
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…
-
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?…
-
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?
-
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;…
-
CONSTRUCTION INDUSTRY SCHEME (CIS) IN BUSINESS CENTRAL?
Hello, can anyone help, I am looking for a way to deal with the new government CONSTRUCTION INDUSTRY SCHEME in the latest version of Business Central. Is there anything setup in BC to deal with this, as I cannot find anything? I have seen that Finance & Operations have this functionality. Thank you!
-
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
-
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…
-
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')
-
Licensing question
Hi, I'm a freelancer developer and would like to extend my abilities with programming for Dynamics. As I understood it has very diversified licensing system. Visual Studio Enterprise Annual subscription offers to download all kinds of Dynamics software. However I'm not sure if it also offers a development license for it. I…
-
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…
-
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
-
Production order scheduling order
Hi team, We noticed that when we would Refresh the PRD, the Backflush would schedule EVERY item to end at the Due date and flow backwards even if they go through the same work center (see two lines below). However our Work Center Capacity is currently set at 1, which to me would mean that it would only be able to process…
-
Purchase Tax on Expenses / Costs
Hello! I want to thank many who take their time to support many. On this occasion I would like to ask you for support in which you illustrate where I can go to do this. On this occasion, I would like the amount of the tax to be in their respective accounts. That means that the first line would have 517.50; and the second…
-
Data migrate?
Hello BC experts, I have a quick question regarding data migration. We have an app/extension based on BC al programming in 14m range ISV range. Now we have developed same app in a PTE range which is 90k series. Now, we want to move all the data from 14m objects to 90k objects. Is there any tool or code that can help us to…
-
Converting Data from NAV 2009 R2 to NAV 2013 R2
Help: I converted the data (tables only) from NAV 2009 R2 to NAV 2013, according to the upgrade toolkit of Nov 22/2013. This worked fine with the "short version without installing NAV 2013. After this I attached the database to NAV 2013 R2. When I am trying to open this database in the NAV 2103 development environment with…
-
Hi All! I want execute parametrized sql text query in Nav2009
I use microsoft ado library 2.8. Question in how can i pass the parameter to the sql text query? SELECT [Project No_] FROM WHERE [CM FIO] = @UserVariable IF I compile SELECT [Project No_] FROM WHERE [CM FIO] = 'Kanye West' it works, but i want make this with parameter @UserVariable. My function where i am trying to pass…
-
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/…
-
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?
-
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)…