-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Event subscriber skip missing permission true, false when to use
Hi All I have used below true or false and not sure what everyone else is using as a default and if there are hidden issues: [EventSubscriber(ObjectType::Table, Database::"Purchase Line", 'OnAfterCalcLineAmount', '', false, false)] Can someone give some real world insights?
-
Pass Document Attachment from Company A to Company B
Hi All, I am using cloud BC. any idea how to pass Document attachment from Company A to Company B? so I have Posted Purchase in Company A, i want to pass all these records to Unposted Purchase Invoice in Company B. Purchase Header and Purchase Line no problem. the thing is how about Document Attachment. My Code :…
-
AL code for reporting Lot by BIN
Hi All I know both Lot and Bin fields are recorded in warehouse entry table. However if the Item Tracking Code does not have "warehouse tracking" enabled and transacted (after which you cannot enable). Is there a way from AL to create a report? The system still validates LOT and BIN when trying to create transactions so…
-
JSON Management, nested JObjects
Dear everyone, i have a problem to loop through nested JObjects within the Json Management { "entries": { "10000": { "product": "A", "pricePerUnit": 5.68, }, "20000": { "product": "B", "pricePerUnit": 5.83, }, "30000": { "product": "A", "pricePerUnit": 5.53, } }, "currency": "EUR" } At the moment we used the following code…
-
how to check nested json is exits/not?
hi all , how do we check nested json exist or not exist? this one is not nested is ok.IF JsonObject.Contains('item') = false THEN
.....................
else
...................... but how about if we want to check fractionAmount? [ { "id": "630", "item": "Item001", "affectedAmounts": { "fractionAmount": 0 } "fees": [] }
]…
-
Upgrade from BC14 to BC20
Hi All, I'm upgrading from BC14 to BC20. At the very end step where we run the upgrade command for Base Application for example: Start-NAVAppDataUpgrade -ServerInstance BC200 -Name "Base Application" -Version 20.0.37253.38230 I'm getting an error at this step: Could not upgrade the extension 'Base Application' by…
-
XMLport import XML doesnt work when xmlns attribute within XML root in BC
When using Xmlport.Run, i am getting "The Attribute is unexpected." XML sample:<?xml version="1.0" encoding="UTF-8"?>
<Order xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="urn:oasis:names:specification:ubl:schema:xsd:Order-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"…
-
How to move cursor to the new line in BC
I need to move the cursor to the new line when I validate some field or after inserting.
-
How to find out the date based on day, weekno of month ,month and year
hi all, I have got a new requirement that I need to fetch the date based on the day, week Number of Month, month and year. example: Day=Tuesday, week Number of month=4, month=Jan, year=2023. For the above, the date should be 1/24/2023. like the above, I need to find out the date. can anyone tell me the logic behind it?…
-
Hi All, how to send report as attachment while posting sales order in business central and navision
Hi All, how to send report as attachment while posting sales order in business central and navision? I need to send the mail with invoice attachment while posting sales order. if anyone knows please help me.
-
Custom Workflow Approval process question
I'm not sure if this is possible, and if so, the best way to approach this. I have a request to * Add two custom amount fields to the purchase header table. * Add a amount tolerance field to the User Setup Table. * Create a new tolerance approval table, to allow an approver to approve multiple specific users. When a…
-
List type pages not showing data on phone client running on Chrome browser
I have running phohe client (http://IP:Port/Service/Webclient/phone.aspx) on Chrome browser on Zebra scanner. Some List type pages (List, ListPlus, ListPart) don't show data - only light gray lines. After tapping on gray lines client shows detail with the appropriate data. Some list pages show data without problem. Tested…
-
Error when posting Sales Order, if not CodeUnit.Run(), BC Cloud.
Hi experts! I'm getting this generic error message when trying to post a Sales Order through the option "Ship and Invoice". Posting by klicking "Ship" and then "Invoice" works without any problems. The problem started after I added the condition "if not CodeUnit.Run() then...." and running the CodeUnit without conditions…
-
Determine the page that begun the call stack
Hi, I have code that stops users re-opening some sales orders. But If a user is posting the warehouse shipment then std NAV re-opens the Sales order to set the posting date. Can I determine the page that begun the call stack ? I.e. if I determine the page the user was on was a warehouse shipment then I can determine in…
-
SQL error when Adjust Cost runs.
We're getting the following error just after Adjust Cost runs. We have as NAS job running Adjust Cost and the job will fail. The error is very random. It hasn't happened for 3 months and then happened 3 times in 4 days. The following SQL error was unexpected. Execution Timeout Expired. According to our DBA this is a SQL…
-
Having a Posting Problem with too many Direct Cost entries in Business Central SaaS
Dear all, I have a customer I’m setting up, and for some reason, the way I set up their system, I’m getting too many Direct Cost transactions posting to the G/L. You can see in the attachment that I’m getting 2 Direct Cost (in-and-out) that don’t need to be there: I have Direct Cost posting turned on, but in Cronus it’s…