-
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…
-
You don’t have access to any entity in Business Central
Hi, I am testing in a sandbox with one of my co-workers MEM by Binary Stream. We have the exact same user permissions. I am the installing users and I do not receive any errors. My co-worker see the error saying that You don’t have access to any entity Any suggestion? Thank you
-
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)
-
Problem to change Expiration Date for Lot
Hello, Current situation: - Bin Manadatory for Location SILVER is turned on and all other options are turned off on Warehouse tab. This Location do not use full WMS functionality and use only Bins functionality. - Tracking Code for Item ITM1 is LOTALLEXP, i.e. Lot No. and Expiration Date need to be registered. - Then we've…
-
Regarding Danish OIOUBL
Hi, This question is for people who are familiar with the Danish OIOUBL module for issuing invoices to the public sector in Denmark. In standard NAV / BC there is a table no. 289, "Payment Methods" . The table contains payments as shown in the attachment. As it can be seen, it has FIK 71, FIK 73 and also FIK 75, entered by…
-
"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:…
-
Table "Session Event" - OnAfterInsertEvent never fired?
Hey guys, has anyone of you ever managed to subscribe successfully to the "OnAfterInsertEvent" of Table "Session Event"? I'm doing this: [EventSubscriber(ObjectType::Table, Database::"Session Event", 'OnAfterInsertEvent', '', false, false)] local procedure User_Session_Event_Inserted_Handler(var Rec: Record "Session…
-
file location in intercompany functionnality
Hello i have this problem when i want to import an xml file transaction can you please help me to fix this problem?
-
On prem BC v20 edit in excel setup
I have been trying to set this up using the AAD auth which is ws-federation and I have the AAD auth working but cannot seem to get edit in excel. Anyone got links to some step by step guides or pointers? After this I then need to look at the Power BI and guess this will also need an AAD app registration etc. Looking at…
-
NAV 2016 Combine shipments very slow
Hello, Does anybody know why combine shipments is so slow when the customer has several orders some of which have many lines ? We have a customer that has no more than 3.000 sales lines and preparing the Invoice with "Combine Shipments" may take more than 4 hours. It seems that with every order it goes slower, slower, ....…
-
BC19 Download Symbols Error
Hello Everyone, I am getting below error when trying to download symbols: My user has already below permission without Company Name: SUPER, EXTEN. MGT. - ADMIN, D365 BUS FULL ACCESS I have already uploaded latest BC19 License. 2022-03-21 21:28:55.84] Targeting server 'http://localhost', server instance 'BC190' and tenant…
-
NAV 2016 won't open "Sessions" page
Hi all, I have a new workstation, and when I try to run the "Sessions" page (ultimately to run the debugger), I get a message box that says: "You'll need a new app to open this dynamicsnav link. Look for an app in the Microsoft Store" If I start a debugger session from the Development Environment, the Sessions Page opens…
-
SetRecord And GetRecord Function
Hi Can you explain Set record and get record With examples
-
How to handle VAT for free of cost invoices - NAV 2017
How to handle VAT for free of cost sales invoices- NAV 2017 The products are given free of cost to the customer, but we have to calculate and account for the VAT amount
-
AL Compile Issue
I have the following Test-Codeunit. This small test is just for testing my unit-testing-task in Azure Devops. If I publish/package my project, no issues occur and all my apps are deployed (Main App + Test App). Used compiler on my machine: vscode\extensions\ms-dynamics-smb.al-5.0.312966\bin\alc.exe If I run my Azure Devops…
-
Change Color Company Name - Business Central
Hi all, We have a many company. We need change the backgroud colour of Company Name on the left. The users risk write data on the wrong company. Is there some solutions?
-
Prety Message TextBox on Email Editor Page
Hi! Today I came across the Page 13 "Email Editor" and I've seen the "Message" TextBox like this: My first thought was - "it's probably some controladdin, let's see how it is done, so I can copy, paste and reuse it for my own purposes". So I went straight to AlAppExtensions repository on github to see the Page 13, but I…
-
Webinar: Utilizing the new Sharepoint Connector to handle File Management in Dynamics 365 BC
Simplanova invites you to join the webinar: Utilizing the new Sharepoint Connector to handle File Management in Dynamics 365 Business Central. Webinar Date and Time: Thursday, 2nd of March, 2023, 04:00 PM CEST (Central European Summer Time). You can register now HERE. In this webinar, we will overview the capabilities and…
-
Error on role center
Hello guys, One of our customer has an error on the role center - Error: Arithmetic operation resulted in an overflow... We uninstalled all custom extension and we managed to reproduce the error. What could be the reason ? The role center ID is 9027. This error is not showing in other companies and in other roles.
-
Add new Excel sheet - Dynamics Nav 2016
I want to add multiple sheets for an Excel export functionality and after hours of searching the internet I have yet to come to a working solution. I have added 2 new functions to the Excel Buffer table 370AddNewSheet(SheetName : Text[250])
CurrentRow := 0;
CurrentCol := 0; XlWrkShtWriter :=…
-
What is Nav looking at when running MRP? This is for NAV 2013 R2
Hello! We are learning about MRP, we understand this is the calculation of material requirements based on actual demand for components and the production forecast on the component level. However, we would like to know what is "actual demand" includes? are these just production orders or sales orders as well? If it's…
-
Navision 2017 AWS signature V4
How to generate amazon signature from Navision? My code: ouputs should be: kDate = '969fbb94feb542b71ede6f87fe4d5fa29c789342b0f407474670f0c2489e0a0d' kRegion = '69daa0209cd9c5ff5c8ced464a696fd4252e981430b10e3d3fd8e2f197d7a70c' kService = 'f72cfd46f26bc4643f06a11eabb6c0ba18780c19a8da0c31ace671265e3c87fa' kSigning =…
-
Process x number of records at a time.
Hey, We have an outgoing WS call to an external system, where we send one customer at a time. Now the table is really big, and we want to send a list of customers, say 50 records per call. What is the best way to process x number of customers? can we set any filters on any fields? I tried to use counter +=1, but what if…
-
Business Central Scroll bar issue while accesssing in mobile browser
Hi All, I created a list page in Business Central 18 On-premises. when I access that page in a mobile browser, Left&Right swipe not working. But if I open any default list pages swipe is working fine. Noticed the difference between the default page Vs customized page. In customized page horizontal scroll bar is not showing…
-
find the values of an array in a json (power automate flow)
Array: [ "5", "6", "4" ] Json: "body": { "fecha_inicio": "01-01-2023", "Id_Recurso": "{00000000-0000-0000-0000-000000000000}", "lunes": "5", "martes": "6", "miercoles": "5", "jueves": "6", "viernes": "4" } I need to find my array values inside json for example 5: lunes, miercoles 6: martes, jueves 4: viernes but I don't…
-
Trigger something into another Company
How can I run a codeunit for another company without using job queue I want to approve a Purchase Invoice in another company. so we have 5 companies approver will have to go into every company and approve it I can display all approvals from all company into one list but when he approves it errors, even I use changecompany…
-
XmlDocument.root().SelectSingleNode() - or error handling in general
Hi experts, I have a class that call various classes in AX 2009. It handles all the files in an folder. I would like to catch all errors that may come from these classes, but some errors are not caught by try-catch {} For instance, if an xml file is incorrect when I read it, the call to…
-
Changing tables IDs in NAV
Hi experts, Here's the problem : I have a list of object in NAV17 wich IDs start from 2000000 I don't have permission to design or to export those object since I don't have the right licence and I can't buy one (lol). For Pages / Reports / Codeunits / XMLPorts, I changed there IDs from the development environment and I was…