-
MediaSet in temporary records
Hi! I'm building an image gallery page. The pictures should not be stored to the database but to the server folder. I am able to implement this by importing the file to the temporary table Media or MediaSet field Rec."Picture Media".ImportFile(FilePath, ''); I notice that each time when creating the temporary records, the…
-
SetSaveStream - Document Attachment
I'm trying to add a Document Attachment record via an Unchase Connected Service to a Microsoft Dynamics NAV database in C# (Visual Studio 2019). I downloaded the XML metadata from a Dynamics NAV URL. In Visual Studio, I perform an Add / Update Unchase Connected Service and point it at the metadata file. This process…
-
Subscribe on a custom API?
Hello! I'm trying to subsribe on a custom API that was created for the customer, but I can't get it to work for some reason. For subscribing on a resource I post to this URL https://{{baseurl}}/v2.0/{{tenant}}/{{environment}}/api/v2.0/subscriptions with the body { "notificationUrl":…
-
Simple boolean question
hi, i have the follwoing question.. what does this do boolean1 := not rec.boolean2
-
Sort by two columns
On the Payment Journal, when the user clicks on "Suggest Vendor payments". I want to sort first by Description, and then each Document No. should be sorted from the lowest to the largest number as well. Just as follows I tried to SetCurrentKey(Description) but that would sort the description only.
-
how to calculate planned Receipt date for POs?
Hi, Please share the calculation behind Planned Receipt Date in purchase Order lines with requested receipt date? I think Planned Receipt Date must be same as requested Receipt date. But in my PO's , it is not coming as true. in my PO's planned receipt date is always equal to expected receipt date. Why So? Please help...…
-
why my coding some times can't locate the records?
hello I meet a issue based on the Virtual Table: file in Navision 2009,can I discuss with you? I am doing the code like: (the ImportFile is the record based on File Record) ImportFile.RESET; ImportFile.SETRANGE(Date,WORKDATE); ImportFile.SETRANGE(Path,ImportPath); ImportFile.SETRANGE("Is a file",TRUE);…
-
Which version is this?
Why do I have to select"platform": "11.0.0.0",
"application": "11.0.0.0" in VSCODE to access this installation? I thought this is BC14 ?
-
Report Based On Temp Table Not Working
Hi All I have a report based on a temporary table (TableType = Temporary) in BC SaaS v19. If I comment out the table type = temporary then all works, however temporary table does not provide nay results (empty dataset)table 60030 SalesInvoiceCreditTemp
{ Caption = 'Sales Invoice & credit Temp'; [b] TableType =…
-
Danish version of Business Central
Hi experts, I have this question for the Danish Business Central users: Jeg har en bogført købsfaktura i Business Central cloud med danske apps såsom "Payment and Reconciliation Formats (DK)". Når jeg prøver at kredittere den via knappen "Ret", får jeg fejlbeskeden "Den valgte betalingsmetode er ikke en FIK-betaling..".…
-
Calculate derogatory depreciation quarterly instead of yearly ?
Hello everyone, One of our client wants to calculate his derogatory depreciations quarterly instead of yearly, but the calculation doesn't seem to work. To be a bit more specific, i have here an example with a linear depreciation calculated over 15 years and a derogatory depreciation calculated over 10. As long as i use…
-
Reference from BC customer running > 700 users
Hi, We have a far gone prospect with ~800 users. And I'm now looking to get in contact with partners who have a customer or customers with similiar amount of users. The reason is that we would like to give our prospect references from other customers in that size that runs BC. Since Microsoft says BC is out of the question…
-
QR Code not getting Printed
Hi All, Is there any setup in LS retail to print the QR code?. I am using Nav 2013 LS retail and the QR code is not getting printed. Can you please share the standard code for PrintBitmap. Mine dont have the path option along with it. I am using PrintQRBitmap. The QR is created, saved and loaded to file but not getting…
-
Use of Bar Codes in Business Central
I will kindly want to know if bar code can be assigned to items in Business Central without any form of customisations ?
-
ModifyAll Item Costing Methods
Greetings to all of you. CASE: My customer needs to change all of his items costing method, from average to FIFO. The items have already related ledger entries which means that i am not capable of modifying the value of the costing method , within BC. Due to that , i am trying to create a codeunit which will allow me to do…
-
Is there anywhere in Navision/Business Central that makes a chart/graph/image pop out?
Is there an example anywhere in Navision or Business Central that shows a chart, graph or image have a pop out functionality so that you can see it enlarged? I would like to observe the code behaviour so I can have similar functionality
-
FTP upload + NAV2017
Hi I want to upload *.csv files to a specifik ftp folder and I have found some code, that I do not understand. Can someone help me? FTPSetup.SETRANGE("FTP Active",TRUE); IF FTPSetup.FINDSET THEN REPEAT URL := FTPSetup."FTP Server" + ' '; URL += FTPSetup."Path to Files"+'/' + 'de-int2c5-05012021.csv'; FTPRequest :=…
-
Jobs Wanted / Offered forum location?
Hello - I can't find a location or working link for the Jobs Wanted / Jobs Offered forums? Could someone please point me in the right direction? Thank you!
-
How to make a CardPart page open up in a separate page?
How can you make a cardpart page open up in a separate page when clicked on?
-
Captionclass - BC140
I want to change dynamically the label caption from a page. I found some information about this matter and verify that there are a codeunit 42 that makes the changes. But I can't edit to make the changes I want. Does anybody have information about that to share with me?
-
Event Subscription running 2 times
This issue happened for a Dynamics NAV 2017 database in SQL Server 2017 There are couple of Event Subscriptions used in this database. One of the function is, on some NAV events some notifications / emails went out. Users complained that notification emails did not went out. Opened the Event Subscriptions page, found to my…
-
Can't add components in a BOM for a finished good item. Can someone please help? thanks!
Hello! We are in the process of setting up a new company in Nav 2013. All the setup is done, we are ready to test things and we ran into this issue. I created a BOM for a finished good item but can't complete it, this means I can't enter any components because of this error message: "The Unit of Measure does not exist.…
-
How to send multiple data with API IN BC365 -OnSub
{ "customers": [ { "CusNo" :"0002", "CusName" :"02", "Cusphone" :"08123456782" } ] }
-
The input is not a valid Base-64 string as it contains a non-base 64 character, more than two paddin
Hi all, In Postman I need to use/call REST API from the version BC365 BC18 Cu2. I want to add an attachment to the GL Journal Line. All works fine until I try to upload a file. 1/ I create the record (Incoming Documents) by calling…
-
Login failed when connecting to SQL (RTC)
Hi All, We have 3 tier architecture (NAV2009 R2-RTC) Classic client working fine for all user’s. RTC working fine - in NAV SERVER (where Nav server installed) but when I am connecting through RTC in the user’s system then I faced this error-screenshot attached. Can u suggest what things I skipped or any other things…
-
Security Filters on Reports
Dear all, I am experimenting on Security filters and how those are going to work with Report Objects. The case is : 1) I have a customer table , and i have set a security filter on this tabledata because the users to see only some of the entries which are stored inside this table. 2) This table , comes as a dataitem on a…
-
Modify Exsting Report - DataItemTableView Property
In business Central (SaaS), Can we add addition filter to DataItemTableView in data item by extending report? I want to add Type::G.L Account in Report 214.
-
Can we delete Obsolete fields from sql
Hi All, I'm working on Business Central 16.0 version. I have changed the data type of a field in table extension, by making the original field as Obsolete. It didn't have any data in the table. Then I created a new field with new field ID and required data type and published the extension. I wanted to know if it is…
-
Report Layout Illegal characters in path error in NAV2016
Dear All, When I try to open the report layout by clicking Tools -> Layout from developer environment, I am getting error as follows. It is not possible to edit the layout with the report designer. Detailed description: Illegal characters in path. If anyone know how to resolve this , please let me know. Thanks in advance.…
-
LS Retail PrintBitmap
Hi experts, I need a quick help with Printing Bitmap Barcodes in LS NAV 2018. Below is code: Store.CALCFIELDS(LocationQRCode); IF Store.LocationQRCode.HASVALUE THEN BEGIN lBLOBRef.Blob := Store.LocationQRCode; QRPath := FileMgt.BLOBExport(lBLOBRef, 'QrBmpExp.bmp', FALSE); PrintBitmap(2,QRPath,1); DSTR1 :=…