-
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…
-
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…
-
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…
-
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 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 :-…
-
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
-
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.
-
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
-
Passing field from Production Journal to ILE - Onbefore or OnAFter trigger
Hi All I want to pass a field (new field) from the production journal output line to item ledger entry table. I found a codeunit in base app(Production Journal Mgt.) where I can use one of the below integration events: OnBeforeInsertOutputJnlLine OnAfterInsertOutputJnlLine However I'm not sure whether using one is better…
-
Report Layouts Run Report action always use default layout no matter what layout is selected!
Hello friends, I have a problem with Report Layouts and Run Report action. Page : Report Layouts (9660, List) Table: Report Layout List (2000000234) BC365 SaaS, Version: W1 21.4 (Platform 21.0.52534.53435 + Application 21.4.52563.52602) Run Report action always use default layout no matter what layout is selected! Have you…
-
Performance - Flow field vs Page Field
Hi All I'm trying to show item category code on the item ledger entries page and looking at the best implementation. I could create a flow field on the table and show it on page. Or I can create a page field and use on after get record or some trigger to populate it via a procedure on the page. Which one is more performant…
-
BC16 Design craches
Hi people. I have been looking at a BC16 with CU5 installed. When I try to Design any page and adding a field it craches. In the CU list, it says that it is fixed in CU6 and also a thing in CU7. I have tried both to update the existing BC from 5 to 19 - and just Install a CU19 with demo database. Both still crashes. Anyone…
-
logo positioning on reports in BC 2022 wave 2
I dont seem to find the setup for logo position in BC 2022 Wave 2. Was it redacted? if not someone kindly guide me
-
Download automatic currencies - Base currency is CHF
Hi, We use Business Central. We setup and download automatically , on a daily basis, the rates from ECB bank for all companies that base currency is EURO. Now we have created a new company which the base currency is CHF (Swiss Franc) Is there any way I can download automatically the rates according to this currency ? Thanks
-
NAV changes the global dimension choosen on the salesline (NAV 2017 10.0.18976)
Hi, I have made a global dimension with a lot dimension values. When a chose dimension ex. 'V1958' (and some other random values) on the salesline and afterwards view dimensionvalues with Ctrl+Shift+D, NAV has changed it to 'V1008'. It does this with most of the values I enter on the salesline, but some of values it keeps…
-
Export Electronic Payments
Hello , how do I force the report (Export Electronic Payments) to be in a French or English langage Thanks
-
Where/what is ActiveControlOnOpen for BC
Is there any way of activating a specific field when opening a page? In the "good old days" we had the ActiveControlOnOpen property to make sure that a specific field was activated. But this is no longer an option. So I am wondering if anybody has solved this for BC?
-
Designing Monthwise Report
Hello Experts I have a task to design a report in which GL Entry data needs to be printed monthwise thats is from Jan to Dec, User will Input year on the request page and then Amount values will be distributed monthly from Jan to Dec based on posting Date. CODE CREW NAME JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC AAAB…
-
Role Center Customization
Hi, I thought that Table, TableData and Page permissions where the reason why a particular card part is not visible in this list. I am logged in as the same user and in configuration mode I can see the card part I require for one profile, but under another profile I cannot ? where else controls the visibility of this ?
-
New page per record
Business central version -> 21.3.51409.51575 I'm trying to create a new record per a vendor in the report. Is that doable? if so, can anyone please help me as I'm not sure how to achieve that? Please note this is a Word layout(In case it matters)
-
"The date is not valid"
Hi, I am using a Business Central version 14.5. I am running a report in the job queue. The report is a processing only report, i.e. no RDLC layout. When running in the job queue, the report fails with an error: "The date is not valid". Tragically, turning the debugger on does not reveal where the error happens. The arrow…
-
Business Central 20.2 Application Upgrade to 20.10 fails (without performing a platform upgrade)
Hello, I have an On-Premises test environment of Business Central in version: Version: W1 20.2 (Platform 20.0.41086.41354 + Application 1.0.0.0) That is 2022 Wave 1, cu 2. I am researching the way to upgrade the application to cu 10 that is released (but not perform a platform update). I have found the following guide:…