-
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…
-
Activity Section
@Luc_VanDyck @kriki Is the Activity section (Leader Board) updating or not used anymore?
-
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?…
-
Item Cost included in Standard Cost of Production BoM but not respective Production Order
Afternoon all, We're currently working Navision Classic 2009, Manufacturing environment. Struggling at the moment to keep on top of items that are more suited to being on KANBAN as opposed to automatically adjusted inventory stock. We need to have these items on the Production BoMs such that the respective costs are pulled…
-
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.
-
Renumbering objects
Hi all, I would like to re-number objects in a database. What do I use to make it? I've tables with a lot of data (it's not clear database) and I'd like to re-number and open form and no have in the sourcetable = TableXXXXX (and I no open the form). Is it possible? Thank you. Regards
-
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…
-
Object reference not set to an instance of an object.
Hi everybody, i'm facing the following error while publishing an app in VS Code: The request for path /***/dev/apps?SchemaUpdateMode=forcesync&DependencyPublishingOption=default failed with code UnprocessableEntity. Reason: Object reference not set to an instance of an object. The error comes up when i use Enum variable,…
-
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…
-
Error in page filters, only a user of 200
Hello everyone. First excuse my english. I use Dynamics NAV2018 CU4. I have a user with problems on a page, it does not recognize the filters. I have 200 users and it only happens to him on his computer. If him test on another computer works correctly. I have deleted C:\Users\xxx\AppData\Roaming\Microsoft\Microsoft…
-
SQL Database size
I'm wondering if there is a limit to the size of the NAV database. We're at 2.6TB with a single company. Our largest table is the Sales Invoice Line table that is 490GB in size. Our G/L Entry table is 400GB. Normally, I wouldn't ask but our users have been complaining about performance issues over the last few weeks and I…
-
Cant download Symbol from C/AL in AL
Hi All.. I want to upgrade from NAV 2018 to BC On Prem 14 So now in BC on Prem 14 I want to use these tables from NAV 2018. but after generatesymbol, sync , restart... after i download symbol in VS Code, it still cannot find this object from CAL i already follow all these steps from here…
-
How can I see the price of a lot?
I'm checking the item ledger entries and I see the lot number: But where can I see the price of that lot? For example the first line, a Purchase for lot no. 1234-3 where can I check the cost of that purcharsed lot? Also for sales the sales price... for posted assembly it also should have a price Where can I check it?…
-
Why did Microsoft not redesign AL as a programming language when switching to Business Central?
Hi there, When Microsoft decided to change the old platform of NAV to Business Central and change the programming language that is used to develop functionality inside of Business Central. Why did they not make AL an full fledged OOP language to support a more mordern way of developing solutions for Business Central?
-
Can not run BC19 after a successful upgrade
Hi, I'm unable to run BC19 after a successful upgrade from NAV2017. I'm getting errors in the event log. Please see the summary of event log and detailed event log below: - Summary of event log WARNING Event Log 1 Message The required nav app to be injected was not published in the app db:…
-
Business central AL using Rendering for report layout
Hi Mibuso's, I'm using the new rendering possibilities in BC for the layout, but, I cannot select them through code. If I create a selection in a MenuItem, how to select the desired layout as it's in a [Report Layout List] Table and not as a custom layout in [Report Layout Selection] Thankx a lot for you help BR, Chris
-
How to Put a Exported XML file from Xmlport to Azure Blob Container in BC 365 AL
Hello Everyone, I wanted to achieve a task in which i am using an xmlport to export a xml file and trying to put that file into Azure Blob Storage Containers. Written the code something like this.This code is just placing a blank file on Azure, not my Exported Xml file which is in Outstream (OutStr). Please help with the…
-
Can you change option value based on a condition?
Is it possible to do the following? Lets say there are two dropdown options which I will call A and B. Based on the user selection in dropdown A, the options adjust for dropdown B. For example, dropdown A has 2 options: vehicle and colour. User selects vehicle for dropdown A. Now dropdown B has options: one, two, three,…
-
[Solved] Upgrade BC20.2 to BC21.0 - Extension compilation error on Microsoft_Base Application.app
Hi, I'm converting a BC20.2-database to BC21.0 (OnPrem). I'm stuck at the step where I am supposed to publish the new Base App. It raises compilation errors in three codeunits: Does anyone know how to fix this? Best regards, Roel