-
Create Sales Orders from Blanket Orders
I created a Blanket orders with different shipments date like this Sales line :10000 Item : 1000 Shipment date : 29/04/22 ; Sales line :20000 Item :1000 shipment date :12/01/22 to customer 10000. Sales line: 10000 Item: 1000 Shipment Date: 29/04/22; Sales Line: 20000 Item: 1000 Shipment Date : 10/01/22 to customer 20000.…
-
The odata.context url is invalid when trying to connect to Excel from Business Central using ODATA
The message is received when trying to connect excel to an ODATA feed. The characteristics of this issue are bizarre because all of the standard Cronus web services can be picked up with no problem. However, when creating a new Page or Query and trying to connect to Excel via ODATA, the error message complaining about the…
-
DateTime calculations
Hi, Is there any standard function that calculates the DateTime like CalcDate? I couldn't find anything useful, to be honest. For example: 18.10.2022 00:30:00 - 1 hour = 17.10.2022 23:30:00
-
Nav 2014 diameter pie chart
Hello all, I have the following problem: I have programmed 3 different pie charts in C/AL in Dynamics Nav 2014. In the display all 3 charts are shown with the correct data, but all 3 pie charts have different diameters (despite the same measured variables). Is there any way to set the pie chart diameter so that in the…
-
Can not reach BC client application based on a docker/container
Hi I have installed BC19 as a container. See below. It is working fine for to there days than the application will not start. When I use docker logs than I get this below error Do someone know why the service is not starting? or what I can do? Best Regards Javaid Sethi
-
how to change the status of output to close for a finished production order
Hi manufacturing experts, I'm learning NAV manufacturing module and noticed the status of the output still shows Open after the production order was finished. I checked a few finished production orders in demo NAV 2018, which also show open status for outputs. I'm wondering how to change the status to close so the costs…
-
XMLPort Import Sales Order / Sales Lines
Hey Guys, i'm a newbie at C/AL Coding, so i hope, you guys can help me :) I have a XML-File, which should be imported to a sales order. I already got, that i have a sales header. This Code works finde Now i have to add the sales lines to the same Sales Order. That's what i've got so far, but the error message said, that…
-
How to create New Payment Services in SaaS BC ?
Hi All, how do we create new payment service in SaaS BC other than PayPal? Similar like this app source Stripe Thanks before
-
sales invoice
flow the data g/l entry to Cust ledger entries when posting the sale invoice where should I write the code and tell me the function in code unit and tell me the code unit number also if you have any reference links poste here and if you any reference video poste it here.
-
Business Central G/L Budget Export
I have a financial year with differing period lengths, having created the budget I need to export in period order but cannot see away of exporting in Accounting Period Age Buckets ?. Thanks
-
Pick Register Error
Hi All, I am trying to create transfer order between white to silver. while doing the register pick, I have got error and attached below. so please advice me to resolve this issue. thanks, Rajan
-
Over-Supply - How do people handle these?
Hi, Was wondering how your businesses/clients handle oversupply for items which you did not order? The vendor may or may not invoice you for the items - it could be a Purchase Order typo on their system, or a genuine picking error. For example, if you've ordered 100 widgets from a Vendor, but they have sent 200 units. * Do…
-
Calling Kaizala(REST API) using RestSharp DLL
Hi, For demo purpose I am trying to call Kaizala Rest APIs (https://docs.microsoft.com/en-us/Kaizala/). I want to use RestSharp(http://restsharp.org/) DLL for this purpose. I tried with following code: Variables Client DotNet RestSharp.RestClient.'RestSharp, Version=106.0.1.0, Culture=neutral,…
-
Error while changing Phys Invt Counting Period Code value
Hi Friends, Version: 2009 In item card, Warehouse tab: I am trying to change the Phys Invt Counting Period Code from A to B and I am getting an error The date is not valid when Last Counting Period Update field contains some date value. If Last Counting Period Update is 0D, then I could able to change Phys Invt Counting…
-
CRM Integration, proxy tables, fields ids on the 10,000 range
Hi, In the context of an integration BC/CRM (BC20), we have used the altpgen tool to generate proxy tables and do the developments based on this. For example we have got the definition of the CRM account extension. We have been able to work and test deploying using Visual Studio Code. However, when we have tried to deploy…
-
Use TableFilter Field as Filter
Dear all, If I have a field which has TableFilter DataType so that user can set the filter for table by them self. How do I apply this filter value into filtering the real table ? Is it possible to do this ?
-
The runtime version '3.0' is not supported by the AL compiler
I've installed last CU04 Business Central Version. After I've installed Visual studio Code and AL extension from VSIX file included in package. When I create my first AL project an error was in problem list: "The runtime version '3.0' is not supported by the AL compiler" Whats the problem?
-
scrap weight calaculations
how to calculate the particular scrap weight of items in subform and update the header level for example in item table i craeted a scrap filed data type boolean when click true items only calculate in the line level i choose 3 items line level scrap weight so three items calculate and update the header also give me…
-
QR Code Generation and Save to Blob Field
Business Central On Prem - Latest Could some one help to create a QR code and save it to a blob or image field? Later to display it on a page as an image? In reports, they say it is easy use a 2D font. but, here want to create and save internally.
-
Find Functions in navision
What is diff b/w FindFirst & Find ('-'),and Findlast & Find('+') Give me the example and if you will have any reference give me
-
Delete a file on ftp server with use of .net
Hi Can someone tell me how to delete a file on ftp server using .net. FTPUpload (Working fine) FileRec.SETRANGE(Path,FTPSetup."Path to Files"); FileRec.SETRANGE("Is a file",TRUE); IF FileRec.FINDSET THEN REPEAT FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Server" + FTPSetup."Path on FTP Server" +…
-
Report with Images
I have a report that has a maximum of 3 pages. The report must display either 2 images or only 1 image on page 2. I added a rectangle and assigned the two images there. Only one image should be displayed on page 3. But now the images should only be displayed if there is an entry in the corresponding image path. And…
-
Restrict back dating and future date when selecting calendar date
I have a date field which the user will select from the calendar dropdown, now I want only the current date to be selected, future date and backdating should not be allowed. I am using NAV 2018.
-
Hi, I have a column in my report which is not in the dataitem/table, but I want it to filter.
Hi, I have a column/field in my report which is not in the dataitem/table but I want users to be able to filter for records in the table based on the value in my field. The values in my field are gotten onaftergetrecord. Any help?
-
how to rearrange substring within the string ..
String : played5year9Postponed1be4UAE7IPL2in6will3this8 Task : Every word has sequence no. at end of the word in string. Following these no. arrange this string as a proper sentence using string function as below : final correct string : Postponed IPL will be played in UAE this year.
-
Join the webinar: SALT Demo and Partner migration experience from Xitec
Join the demonstration of how simple C/AL code to AL conversion can be with automated Simplanova AL Tools (SALT), and hear from Xitec (NL) how they apply SALT in their add-on upgrade from C/AL to AL. During the webinar, you will also learn that SALT will be available for download on Visual Studio Code Marketplace. Register…
-
Permission to execute XML port
I'm trying to use XML port in code unit for web services. But, once I call code unit, web service returns below error even I can execute the XML port manually. I followed tutorial https://www.kauffmann.nl/2011/01/15/how-to-use-xmlports-in-web-services-1/. Why I'm getting the error and how can I fix the issue? Thank you.…
-
Prevent user triggered changes via Table Subscriber
Hi, I am trying to prevent user triggered changes to a Vendor table. Changes done indirectly is allowed e.g. Changes done via C/AL MODIFY, INSERT or DELETE statements are allowed. I am looking at the triggers for the Vendor table, but I cannot find any suitable events. The most suitable I can find is to use the…
-
Copy Document pattern
How Do I Implement the Copy Document pattern any reference plz tell me
-
report bilder
Hello, I have MS Dynamics NAV version W1 10.0, I would like you to point me to an application with which I can edit the layout of the reports. Thanks.