-
How to have more than 4 header condition in power automate when we do approval request in BC
Hello All, By default we've 4 conditions in power automate for sales quote request approval in business central(cloud) when we request approval. How to have more than 4 conditions in header? Should it be handled through code or can it be achieved using some configurations by creating a flow from the scratch or is it not…
-
Property Table Type
can anyone explain the property (table Type) with an example 1.Normal Type---specifies type used for Dynamics BC 365 2.CrmWhich is the integration of dynamics 365 Bc with dynamics 365 for sales 3.External Sql--- ? what it is and how it can used? can anyone explain the third type (Externalsql)
-
Printing multiple records in Report
I'm trying to print multiple records in a report by using the PipeLine "Record1|Record2|Record3". Some base reports already have that feature enabled and I can select multiple records to print but not on my custom report. I couldn't find a special code written in those base reports that is missed on mine. Does anyone know…
-
Report Standard Purchase order is showing blank while opening with report builder.
Report Standard Purchase order is showing blank while opening with report builder. so, I am requesting to you can anyone help me with this or provide me 1322 standard report to me with rdlc format only. I was using by report extension but it was showing blank.
-
Nav 2017 Opening up under another domain account
Hello all, We have a few workstations that, for whatever reason, continuously open up under a particular user's domain account as if that person were logged into the computer. I have tried virtually everything I can think of from removing them from the domain, changing the computer name and rejoining, modifying the…
-
Help me on RDL layout hidden property
***This is urgent*** My requirements are if decimal value is coming in reports i need to show blank & if not i need to print that value only by using hidden property if not possible, please suggest better code in reports. Ex : - value is 0.00 or 0 or 0.0 then 'blank Value is x (other than 0) then print x
-
Business Central - Rolecenter Part Size
Hi, Does anyone know how to force a part size in Business Central? The part is a list part with lots of columns, so is more usable as a large part. At some resolutions, BC renders it so that it's nice and wide. On other resolutions, its a very small box in the corner. Forcing a part size, or a minimum size would be helpful…
-
Where is the bottleneck?
Hi, NAV5 with file database here. a report runs for about 100 seconds on old HW with 10K HDDs and Win Server. The repotr is just doing some filters and iterations on some tables. I have upgraded to a server several generations newer with shining CPU and memory, brought in plenty of SSDs, split database in files among them…
-
Docker NAV2018 Container with Windows Authentication and database outside of the container
Hey, I do want to create a NAV2018 docker container which connects to a NAV database located outside of the container. I want to use Windows Authentication for that. I'm running following command to do that New-BcContainer ` -accept_eula ` -containerName MyTestingContainer ` -databaseServer 'some.server.somewhere' `…
-
Which Codeunit is used to insert vat entries and vat Statements?
Hi All, Can you please tell me Which Codeunit is used to insert vat entries and vat Statements? Thanks, Puthumai.
-
OnQueryClosePage - Stop the page from closing
Hi everyone, I've written some code in the OnQueryClosePage trigger of a page. IF CloseAction IN [ACTION::OK,ACTION::LookupOK] THEN BEGIN fctXXX(); Rec.NEXT; END; The code in fctXXX() is executed but the page closes anyway (whether there is a next record or not). Is there a way to prevent the page from closing if there is…
-
Can we use Item with new Expiry date once it is Expired.If Possible how this can be done.
Can we use Item with new Expiry date once it is Expired.If Possible how this can be done without changing LOT no.
-
What’s new in Dynamics 365 BC version 2023 Wave 1?
As the new version of Dynamics 365 Business Central is coming, we are organizing the webinar with Microsoft MVP for Business Applications – Stefano Demiliani, and encourage you to attend. REGISTER NOW HERE: https://us02web.zoom.us/webinar/register/5516778430764/WN_Hb4SNvTxRa-n07sh1fGGWw During the webinar, you will hear…
-
Upgrading From Server 2003, NAV Activigence Issues
Hi, Just wondering if anyone can help me and might have gone down this path We've finally got to the point that our long serving Navision NAS Server needs to be upgraded to a more modern operating system. Our ops team is targeting a minimum of Windows Server 2012, if not 2016 We are running IT IS Activigence for the…
-
CaptionML missing in BC15+ after txt2al converter
Hi together, can perhaps anyone please help me with the following question: I have to migrate a BC14 solution to a BC15+ solution, in our case BC21. We will stay OnPrem at least for 5 years or longer or ever. When converting the C/AL files with al converter (txt2al) all CaptionML propertys of all objects are lost. Only the…
-
pos tag update issue yes /No
hi everyone , please help me i have created one pos tag in ls nav using pos transaction code unit , create one function IsOffLineTransaction() : Boolean //IsofflineTransaction EXIT(REC."Offline Mode"); rec= pos transaction table offline mode= is a field created in pos transaction table type is boolean definition code :-…
-
pos tag not updating value
hi everyone , please help me i have created one pos tag in ls nav using pos transaction code unit , create one function IsOffLineTransaction() : Boolean //IsofflineTransaction EXIT(REC."Offline Mode"); rec= pos transaction table offline mode= is a field created in pos transaction table type is boolean definition code :-…
-
Is there any way to find out how many objects number are used for Pages, Tables, Reports, & etc ?
In daily practice or developing a project we are using object numbers as per mentioned in app.json. Suppose I want to know all used objects number as per object type in BC or web client, is it possible? let me know how?
-
Can anyone give me road map for api learning in Business central?
Can anyone give me road map for API learning in Business central please, treat it as urgent AND please share links too.
-
SetRange/FindFirst VS Get to find a record
Hi To find a record using the primary key we can use setrange/findfirst or Get. What are the differences between these two patterns? Does get throw an error if the primary key not found while findfirst in setrange will not error? Thanks
-
Create PDF without PDF Printer
Hallo everybody, could anyone tell me, if there anyway to create PDF Document without to install PDF-Printer? Thanks navsyst2
-
multi column filter using OR
How to perform multiple field/column filter using OR operator? For example, we want to filter Value Entry table (through Security Filter or C/AL code) to ["Global Dimension Code 1"='XXX' OR "Salesperson/Purchaser Code"='999'] Thank you in advance.
-
Field Layout Business Central
Hello, does anyone know how I can program such a field arrangement in BC20?
-
A DotNet variable has not been instantiated .Attempting to call InnerXml in codeunit request page
hi all, In sales order While editing the sales line and or pasting the sales lines i am getting the below error. I have attached the following. Can anyone of you help me out. Thanks, Rajan.
-
How to count a particular Character in a String
Hi, How can i find the Count of a character appeared in a string. For example suppose i have a string ABCDEFG@Yahoo.com,XYZ123@Yahoo.co.uk then if i want to find the Number of '@'. how can i do this using string function.
-
VALIDATION XML
I need validate XML file schema using XSD file. I'm using Business Central SaaS version and cannot use dotnet. Searching I've found this article but on SaaS not work. Someone can help me?
-
NAV17 / NAV16 SQL failure - could not find the prepared statement with handle
Hello all, more and more customers with NAV2017 and version NAV2016 get an "could not find the prepared statement with handle". Sometimes once a month, sometimes every week one time. Than you can only restart SQL Server services / NAV service to solve the problem. It starts 1 1/2 years ago with the first customer. Now we…
-
Transfer Order with Sames Transfer-from and Transfer-to Code
Hi, I know there is an error check on transfer order if Transfer-from Code is same as Transfer-to Code. Is there an downside of disable that checking? We have people take out demo equipment to client. In order to keep track of what equipment are out there, I was thinking use Transfer Order. With Same Transfer-From and To…
-
Copy-Paste marked lines with Extended Text
Hello, my customer uses offen the copy-paste function to copy selected saleslines. The problem is that, when marked an item line which has an extended text, than the marked lines are copied but also BC (V21) the extended text of the item is again inserted. It looks, that the trigger of the subform is executed. This…
-
Whether the Decimal Field is Empty or Not?
Hi All, How to check whether a decimal field is empty or not? can anyone of you help me, Thanks, Rajan