-
Automated Testing with OnPrem BC13 (without containers)
Hi All We are starting to do some of our own extension development. We are using v13 on prem BUT it has a major add-in and most of our extensions will use data from this add-in. Can I use the automated testing tools without containers? Or is there way to containerize our on-prem dev environment. (I'm guessing the…
-
Install extension error: 'Newer version exists', but I can't see it
I am trying to install an extension on a development database, when I get the error "Cannot install the extension {name} by {company} {version} because a newer version was already installed." I uninstalled / unpublished the versions I found with Get-NAVAppInfo (non was higher than what I was installing). I tried to both…
-
Sales Document with Wordlayout and various tables
I hope, somebody here can help me :) I want to design a sales document with a word layout. The most of all works fine, but I have a problem to print 2 tables which are in a relation Example Sales Line 1 - Additional Line 1 - Additional Line 2 Sales Line 2 - Additional Line 1 Is this possible to do in word? I don't found a…
-
Copy posted invoice to Sales Invoice Diffrent Debitor with dynamics BC on Prem
Hello I wander how to code (subscribe to over write) the Copy posted invoice to a Sales Invoice from different debtor without recalculating the linces, the description field should not be overwritten by the default value. incloude header = false Thank you Rgs. Firas
-
Business Central Internals: Package ID, Extensions
Hi, I am just getting into Business Central and created some extensions. I wanted to check how the metadata was stored in SQL Server and this led to some (probably basic) questions. I hope you can help me out: My extension has some ID and it can be queried in the Nav App table. This table has primary key Package ID. So why…
-
Can Dynamics BC work on Google Chrome OS ?
A customer asks me if it is possible to use Dynamics BC 14 on Chrome OS. do you have any information about this? Thank you for your help
-
Update Item tracking Lines from Purchase Order
Hey, We have added some custom fields on purchase line table, and would like to transfer the values to item tracking lines table. the field name,id,type and lenght are the same on both tables. But, the value is always empty on item tracking lines table. I found out that. item tracking lines is actually a temporary table,…
-
How to change the font color in Business Central?
Hello everyone, Is it possible to change the color of the font, as shown in the image? In this example the font color changed because the invoice expired. How can I change the font color to yellow five days before the document expires?
-
How to pay a vendor in EUR from a GBP bank account
Hi All, Simple question, and it seems like this is not possible in Dynamics NAV or 365. We have a bank account with currency code set to GBP, as it is a GBP bank account. Anyhow from this GBP account we paid a vendor in EUR, so how do we account for this in Dynamics 365. When I insert an entry on the payment journal I…
-
Experience with local standard functions in AL
Hello everybody, in AL we have the problem that a local table-function cannot be accessed from a TableExtension and therefore standard functions can often no longer be used. I find this particularly annoying because* Standard functions increasingly include event publishers, so duplicating into the TableExtension is…
-
Experience with workarounds for mixed keys
Hello everybody, in AL there is the problem that you can only create keys in TableExtensions with fields from the TableExtension itself. It is therefore not possible to use fields from the original table in a new key of the TableExtension, e.g. in a new key of a TableExtension that extends the table Item, you cannot use…
-
Experiences with Workarounds for Mixed Keys
Hello everybody, in AL there is the problem that you can only create keys in TableExtensions with fields from the TableExtension itself. It is therefore not possible to use fields from the original table in a new key of the TableExtension, e.g. in a new key of a TableExtension that extends the Table Item, you cannot use…
-
Get the Number of the day eg 150
Hi, How in Business Central code can I get the current day in it's number equivalent. So for example 1st February is the 32nd out of 365. Thank you.
-
VSC: Collapse functions?
Hi All, Hope some1 can help. is there any way you can collapse the code in visual studio code, so you can see the functions at one glance? When you have a Codeunit with lots of functions sometimes is hard to list all of them, so this could be helpful. Thanks.
-
Cannot publish extension in VS Code on BC13's Migrated Database from NAV 2017
Hi everybody, I'm Raymond and I've encountered issues after data upgrade from NAV 2017. My migrated DB on Business Central 13 works (I can access NAV Client and Web Client), but I can't publish a new AL extension. VS Code gives this error: "Could not publish the package to the server. See Visual Studio Code debug console…
-
Dimension Value ID must have a value in Dimension Set Entry
Hi, "Dimension Value ID must have a value in Dimension Set Entry: Dimension Set ID=0, Dimension Code=ITEMS. It cannot be zero or empty." This is the error I get when executing 2015 Step 2 from the UpgradeToolkit and I can't fix it because Debug doesn't work for the new codeunit type: Upgrade Any ideas to fix it? Thanks in…
-
Business Central build numbers
With Dynamics NAV, things were easy: if you downloaded a cumulative update, buildnr of platform and application were the same. If you would download NAV 2018, it would be build 11.0.41920.0, for example. That changed with Business Central, in which the platform-and application buildnumbers are different. This was well…
-
Error in USPS (Address validation API)
Hi, I implement a function in VSCode to use USPS API to check customers address. But I have this error Someone can help me ?
-
Prepayments:I deleted 2 pre-payment invoices and now cannot change anything in the original order
I am trying to understand the functionality. I am stuck with this. I am on the demo version of NAV 2013 R2 * Create new order, 100% prepayment on header * Enter one item line (bicycle), qty=1, create a prepayment invoice for 4000. * Re-open the sales order * Update qty to 2, create a second prepayment invoice (another 4K)…
-
Object changes not reflected on Client
Hi, One of our clients, running on Nav 2009R2, has an issue with object caching on the RTC: the MetadataProviderCacheSize has been set to zero, however if there is a change in any object, they need to restart the service to have it working. Does anyone has a clue why this is happening. This problem is on their development…
-
Sending multiple attachments in BC
Hi everyone, From a posted sales invoice, I need to send to the customer another report, apart from the invoice itself. In the sales report selection page, I added another report as attachment. I receive both documents, but in different mails. is it possible to send all the selected report into the same e-mail? Thank you…
-
REPORTFORMAT::Html crashes Windows Client
I just installed a new BC 13.18 and have run into a weird problem. When I try to email the statement on a customer the client crashes with only an ArgumentOutofRange error in the event viewer. I have debugged it down into cu 8800 where we try to create a HTML file using REPORT.SAVEAS that crashes the system. I have made a…
-
LS Nav 2016 Web Request
Hi Expert, Has anyone tried to create a new Web Request that you can use it successfully in the POS? I tried creating a new Web Request, but whenever I use it and send request, it's always throwing an error. Root element is missing. The web request that I created is I copied it with MM_CONTACT_BLOCK. Has anyone encountered…
-
Display Object virtual table on Page for BC
Hello I am traying to disply the content of the "Object" vertual table on a page (table number 2000000001) we are using business central 15 wave 2 on Prem. It would be nice if i can get an answer here. Thank you Best Regards. Firas My page looks like page 51160 Vtable { Caption = 'VTable'; PageType = List; ApplicationArea…
-
OnPremise region selection, show wrong decimal separator (comma instead of point)
Hi, I've a BC16.1 onPrem installation. Where can I change the regional settings to have a DOT instead of a COMMA in my decimal separator? It looks like this is managed on the serverside (NST or IIS) - unfortunately, Microsoft decided to have a , for the swiss-French region- I changed it on the server but maybe only for my…
-
BC13 - Copy company
Morning, Is anybody familiar with the error message: tenant numeric id must be set Im trying to copy a company in BC. But when i try to do that the client closes with above error. In the past the database was part of multitenancy, but migrated back to single tenant. I cannot find a solution for this
-
Can we post Transfer Orders in Job Queue just like sales and purchase orders.
Hi, One of my client is facing locking error when posting of Documents so I've implemented posting of sales and purchase documents in job queue using background posting functionality present in "Sales & Receivable Setup and Purchase & Payable setup", but to post the transfer orders in the same way i cannot find the setup.…
-
Printing Check Infinite Loop Error
When I am printing Check from Payment journal. The report run for infinite loops and gave close program error. What could be possible reason for the infinite loop of report?
-
NAV 2017 - Prevent NAV from converting a backslash to a CRLF
Hi everybody, Is somwbody knows how to prevent NAV from converting a backslash to a CRLF ? I created a we service that return a JSON as a text and I apply a Json.Encode(myJsonText) to escape all the special characters. The problem is that the Json escape the special characters by adding a backslash and in place of return…
-
How do I change/overwrite the Danish OIOUBL extension?
I'm working on Business Central version 13.11 (13.0.35820.0) on-premise. Most of the code is C/SIDE but some is in extensions. I need to make some changes to the Danish OIOUBL extension that exports an XML file. I have the code from Microsoft, but when I try to build a package i Visual Studio Code, I get a lot of errors…