-
How to copy Notes (stored in Record Links table)
Hi everybody, I'm getting crazy with this... Example: In the RTC client I add a note to the Sales Order #100. The program write it in the Record Links table and the only way to know that my Sales Order 100 has a note is to read the field "RecordID" in the Record Links table. The Sales Header has no link field like that...…
-
Reference to the member 'name' of the variable could not be solved
Hello everyone, I'm fairly new in dinamycs nav and I run in to a problem when trying to LookUp for "No." in Purchase invoice form. Error looks like that Reference to the member Padalinio koregavimas of the variable could not be solved How to fix this problem?
-
Orphan extension - cant import company
Hi We have a client on BC 21 - 2022 release wave 2 on prem, with a UAT database and a Production database. Recently we created a new instance and forgot to disable designer, and a user added a field to a page in designer. When we noticed it, we uninstalled, unpublished, and disabled designer. We now have a situation where…
-
Upgrade from BC14 C/AL to BC Online
Hi, Currently using BC14 with C/AL changes. (non extension). Which upgrade path should I take? I was planning to use this path --> https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v21 But it seems wrong, as there are no steps here to convert from C/AL to A/L.…
-
Cannot delete users in Business Central 21.3
I am having trouble deleting some users in our environment. I get the error message that The user "X" cannot be deleted because the user has been logged on to the system. To deactivate a user, set the user's state to Disabled. I have found that the solution to this, is to delete user settings, sessions setup etc. All that…
-
RAID10 configuration for 6 drives
Following on this thread. I've opened a new one. http://www.mibuso.com/forum/viewtopic.php?p=127281 My Basic question is how can you have RAID 10 configuration with 6 drives. Thank you.
-
Write Adjust Cost routine as a SQL Query?
Is it possible to write adjust cost routine as a SQL query? Adjust cost routine takes about 2 to 2.5 hours to run. We run it nightly at 1 AM. It causes tons of locks/blocks. The client that I work for, runs 24X7. I was wondering, if is it possible to convert the adjust cost report to a SQL query. Has anyone been able to do…
-
How to change page numbers in word layout
I developed a word layout. it contains 10 pages , in report it is showing 1/10 on each page. but i want show in report as 1/10,2/10,3/10 like that. Simple words i want increase page number in word layout. How can i do it. Please help.
-
Object EFT's are standard object for 2019, 2020 and 2021 cloud version?
Hi There, Please validate if object EFT's are standard object for 2019, 2020 and 2021 cloud version? because we want to move this in the cloud. Thank you for the response.
-
Navision 2018 Multiple JSON file printing in single text file through codeunit.
I need to get JSON file with multiple values in a single text file through code unit . As my code I'm getting a single value in a text file as JSON . Can anyone suggest answers? I'm using Nav 2018 version as i checked google 2016 codes are available I referred 2016 code and it's work a bit but I got single value only. MY…
-
trouble with report: Too many rows
Hello! Can you help me. I created new report and run on preview. Total rows in the report 19000. I get error "Stream was too long". Why can't show 19000 rows? Nav2016
-
Upgrade NAV2009r2 to BC14
Hallo together, i facing a problem in the upgrade process to BC14. MS says, to upgrade NAV2009r2 to BC14 you need to do following steps: 2009r2 -> NAV2013 (technical) -> NAV2015 (incl. Codeupgrade) -> BC14 in step 2009r2 -> 2015 i faceing the problem that that the tenant sync throw me the error, that MS standard fields are…
-
How to remove or change app registration ID for Email Account Current User
I wanted to setup Email for the type Current User. I created an app in Azure, got everything OK (I hope), but when running the set up email wizard, I used the wrong App ID. However, it went through with the wizard, but on logging on, it ofcourse showed a message that the application with identifier "xxxx" was not found in…
-
how to set up Tax bus. posting groups and Tax prod posting groups on G/L Account card
Hi I'm wondering if user needs to set up the Tax bus. posting groups and Tax prod posting groups on G/L Account card. It seems those fields are VAT related but I'm not sure. If user posts a purchase on a GL account using sales order, the tax could be calculated using the vendors' business group and tax area setup. But what…
-
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 :-…