-
installation BC on prem
aktuelle BC version
-
How to Prevent Deletion Of Sales Order - Only if by end user?
I'm trying to impement an event driven validation to prevent SO deletion however it also block base app deleting sales order after invoicing. How do I exclude system deleting? The event:[EventSubscriber(ObjectType::Table, Database::"Sales Header", 'OnBeforeDeleteEvent', '', false, false)] local procedure OnBeforeDelete(var…
-
Sales Header record cannot be saved because some information on the page is not up-to-date. PostCode
Hi All I'm trying to find a way use the shipto address postcode to lookup a custom table to get the dimensions. The post code field doesnot trigger OnAfterValidate. So I use below event subscriber{ [EventSubscriber(ObjectType::Table, Database::"Sales Header", OnAfterLookupShipToPostCode, '', false, false)] local procedure…
-
Invalid user after BC upgrade (configurations not modified) [BC20 to BC24]
Hi all, i had a BC20 OnPrem envinronment with Windows Authentication that used Kerberos. I upgraded it to BC24 keeping the same configurations (also for Kerberos) but now i cannot sign in to the web client because BC tell me that my user is an invalid user. I am sure that the upgrade was succesfull because if i change the…
-
Copy Word layout in Business Central
Hi experts, In Business Central cloud, our customer has a Word layout in report 1306. Is it possible to copy this layout into a new Word file that can be used for report 1303? Hope you can help. Morten
-
I want Code Snippet for
SO , i am extending standard purchase order report and i added three columns 1.SalesorderName 2.SalesorderEmail 3.SalesorderPhoneNo. Now into these columns i want the data to be flowed from "SalesPeople/Purchaser" Base table. In purchase order card page there is an action called dimension which is linked to "Dimension set…
-
Odd SETRANGE and Boolean behavior
I came across an odd behavior with SETRANGE and booleans and I can't figure it out. I have 2 boolean filters that when run don't do anything. All records are returned. When I add the 3rd SETRANGE below (for testing) it then works as expected. I've tried using SETFILTER as well with no luck.…
-
CODEUNIT 1854 : MS - SALES FORECAST NOTIFIER
hello guys. the debugger point me to the object with error. but when I search the Said codeunit, it doesn't show me anything. I mean the Codeunit does not exist in my current database. Codeunit 1854 (please see attached Photo)
-
How do we migrate Table Extension from older extension to V23 ?
Hi All, does anyone know how to migrate from Table extension version 22 (or before) to version 23 ? Thanks.
-
Upgrade from v14 to v25 error
I'm currently trying to upgrade one of our older databases from v14 to v25 using the MS cookbook and I ended up with following error in Task 17 during the upgrade of Microsoft Base Application v25: Could not upgrade the extension 'Base Application' by 'Microsoft' from version '14.0.0.0' to '25.0.23364.25445' for tenant…
-
[BC24] Trouble with advanced Deep Insert using an API page
Hello all, I had this customer requirement to implement in BC24 OnCloud: Create a new sales order + sales lines using the same API call. This works and the response returns all the information that was created successfully (Both information about the Header and the lines). I used the REST API URL to deep insert this…
-
Changing Posting Date to Work Date during posting
hello all, Is there any setting that can overwrite the posting date to Work date at the time of posting sales invoice? issue is when sales order is shipped,(setting on sales & receivables for Default posting Date is 'No Date'), user enter the posting date but if finance user post the invoice for that Order and forget to…
-
Error while Financially Voiding a Check in BC23.1 On-premise
Recently one client of us migrated from NAV2017 to BC23.1 On-premise version. In the new System they tried to financially void a check for one of its vendor, but could not do it due to an error. The error is due to New Code and New Field in BC. In BC they have introduced a new field "Posting Group" in "Detailed Vendor…
-
Item Charge Assignment
Hi all, We all know how to do Item Charge Assignment from a purchase order/invoice. However, I have a different scenario with a customer, where the customer wish to assign charges a different way. My customer receives a statement from Customs when the items has been controlled at port. First 1 month later my customer…
-
Accounting series 4 to 5 characters
Hello, The customer accounting series currently has 4 digits, with a maximum of 9999. This range has become insufficient, and we would like to expand it to 99999. What process should I follow to modify the series so that all customers have the same numbering?
-
Enabling Item tracking line in Item Reclassification Journal
Hello Everyone, I would like to enable item tracking lines in the Item Reclassification Journal batch to track items, but I’ve noticed that the standard functionality only allows tracking for the "Item" type. If I proceed with customizing the system to allow item tracking for other types, could there be any concerns with…
-
Upgrade BC14 to BC19: Either the parameter @objname is ambiguous or the claimed @objtype (INDEX)
Hi, I'm getting "Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong" when running Sync-NAVApp as follows: - I'm upgrading a modified base app to a modified base app + extension. I've been able to track the error in the event log but as it stops and reports each table individually it is…
-
Best method to Add field validation in BC SaaS
Hi, There are 2 ways to add a validation trigger to an existing field in BC. 1) Subscriber codeunit that subscribes to the table OnAfterValidate Event 2) A TableExtension that Modifies the field OnAfterValidate trigger Which is best and what is the pros and cons of each method? All this while I have been using the…
-
Non Calendar Month Accounting Periods
Hi Guys Has anyone implemented non calendar month accounting periods like 5-4-4 or any config where start and end date does not fall month start/end? What are the gotchas and considerations? I looked at the accounting periods table and it does not have a field for the month as a unique identifier which means reporting is a…
-
Business Central Upgrade V21 to V24
Hi I need to upgrade a V21 on prem database to V24 CU2 onPrem I have around 20 extensions with various levels of dependency. I am using a PowerShell script that interrogates all the extensions which have been placed in a folder, builds a dependency tree then installs and publishes the extensions in least dependency order.…
-
Error When Publishing to a BC Docker Environment
Hi, I am encontering a strange error when trying to publish to a local Docker environment. Does anyone know what this means? Please note: * I have published other .app files, in the same way, to the same Docker, without error. * The .app file is functional. I have published it, successfully, to another Docker. Thanks in…
-
Javascript Error Handling in BC21 control addin (on prem)
Hi, (I accidentally posted this question in Dynamics CRM, maybe here is a better place to get replies.) i am developing a control addin in BC21 on prem (Version 21.0.46384.46844), which is running Javascript internally. My problem is, whenever an error occurs inside the Javascript, like a "TypeError: Cannot read properties…
-
Service Quote - How to stop system from deleting completed doc
Hi Guys I'm using the service module and when a service quote/order is fully completed , the document gets deleted from Business Central. Is there a way to customise the system so completed orders are not deleted and the order status changes to something meaningful
-
BC25 Onprem -Cannot Create Company
Hi Just installed BC25 OnPrem and Cronus Working without any issue. Went to create a new company and getting an Error like this OnPrem SQL2019 Standard Server has previous versions and running without any issues. Is this a new requirement? Added SQL Server Full-Text Search feature in SQL Server Installation and tried again…
-
Copy Company from Production 1 to Production 2 (Cloud)
Hi all.. I have 2 production environment at the same tenant Production 1 --> W1 Production 2 --> AU I want to move some of the companies from Prod1 to Prod2. how do i do that? Please advise. Thanks.
-
Doubt regarding the autoshceduler Job timing.
Dear Experts, i have auto Scheduler Job which is set to trigger and run the job every 10 minutes... Say some times if the job is triggered and start running from 12.30 pm and run continuously for 15 minutes straight, due to heavy data. Now comes my doubt, since we have set the trigger the job every 10 minutes. but job…
-
XMLPort - Flat File Import - Header + Line on one line
Hi folks, I'm trying to figure out a way to import purchase invoices from a CSV that has header information and line information on the same line, such as VendorID, VendorInvoice, InvoiceDate, Department, GL Accout, Quantity, Amount I have set up an XMLport to the point where it will create a Purchase Header record for…
-
Insert 4 dimensions how to improve code
Hi Guys I have the below code to enter shortcut dim 1 to 4:actions { addfirst(processing) { action(UpdateSalesHeaderDimensions) { Caption = 'Test Update Sales Header Dimensions'; ApplicationArea = all; trigger OnAction() var DimVal: Record "Dimension Value"; TempDimSetEntry: Record "Dimension Set Entry" temporary; DimMgt:…
-
General Journal - Test Report shows as Blank
HI , I have a problem with a general journal particular batch, Test report shows as blank. How to check this issue, kindly advise.
-
Global Variables in a Page List
Dear All, I have got a new list page on top of which I have created three global variable which are to be filled up by the user. This means it looks like an invoice but the header part is made up of global variable whilst the page part of the invoice in reality is the actual page. The issue is that when the user sets the…