-
Filtering ODataV4 with list of values
Hi, I exposed a query in Web Services (query object added below). I want to filter on multiple selected GLACC's. According to https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-filter-expressions-in-odata-uris this is possible: "In a list of values $filter=EntryNo in (610, 612, 614)…
-
Void Posted Transaction
Hi, Anyone can help me setup a centralized refund in LS Central? I want to refund on Store A a transaction sold in Store B? Thanks in advance
-
Delete data and Schema from an already unpublished app
Hello I had an app installed in my OnPrem BC20. Someone uninstalled it and unpublished it (which was ok) and now it does not show in the Extension management overview - all was ok, we were happy... now we need to copy a company from one database to another. In the new database we have installed all extensions but we do not…
-
CANNOT DELETE FIELDS FROM TABLE EXTENSIONS (Onprem)
Leaving this here for those banging their head. You cannot delete table fields from table extensions in BC23 (cu0). The workaround is to change the field to flowfilter, build, then delete the field and build again
-
How to do deep inserts into a custom API in Business Central?
Based on this question: https://forum.mibuso.com/discussion/78013/how-to-insert-multiple-rows-in-a-business-central-api-with-a-single-call I was testing and found the deep inserts. So I've decided to build a sample API page with a page part: page 60000 "Sales Order Inserts MIM API"
{ PageType = API; SourceTable = "Sales…
-
Upgrade to BC21 (OnPrem) - error when syncing TableMigration
Has anyone come across this issue below, all the tables cannot be located. I can see them in SQL. This occurs when syncing the table migration app (the empty one): - Task 14 of upgrade to BC21 Sync-NAVApp -ServerInstance $ServiceBC21 -Name "TableMigration" -Version 1.0.0.1 (this is the empty version) I then get the…
-
NAV 2016 Outlook Synchronization error with connection
Hello, I have a problem with synchronization between NAV 2016 and Outlook. When I press button Synchronize in outlook I get the error. Does anyone have any idea how to fix this? Thanks in advance!
-
BC in Remote app (AVD) focus problem: new pages windows appear minimized
Hi, We are moving an installation (BC14 on premises) from Citrix to using AVD remote desktop app. During the testing, one of the users has reported that in some screens when he opens a record (for example, if he tries to open a purchase invoice from the purchase invoice list), the new page opens in a separate window as it…
-
How to have new Source Documents(Warehouse Request) Fields flow from Sales Header?
Hi Nav noob here, and I simply am at a loss as to how the Source Documents Page/Warehouse Request Table is populating. I need to have some fields on a Sales Order appear on the Source Documents page as new custom fields but can't understand the data flow of how Codeunit 5752 (Get Source Doc. Outbound) is populating…
-
Report with barcode - export to excel error
If I export the report to excel (Send to / Microsoft Excel Document (data and layout)) then the qr code will be ugly and unusable: How could I fix this? Preview or sending to PDF/Word works just fine. Thanks
-
Upgrade error BC18 to BC23 Table Sales & Receivables Setup
I am running into an error when upgrading BC18.6 to BC23.3 when executing: Start-NAVAppDataUpgrade -ServerInstance $NewBcServerInstance -Name "Base Application" -Version $NewVersion Event log mentions an error with table ‘Sales & Receivables Setup’: 'The target table 'CLNL_BC230_TEST.dbo.COMPANYNAME$Sales & Receivables…
-
Getting Error in HTTP Post Request in NAV 2016
Hello! I am trying to make an http post request with content type = 'application/x-www-form-urlencoded' but it's giving the Bad Request error. On postman the same request is working fine. Please have a look at my code below and suggest what i am doing wrong. GetAccessToken(var AccessToken): Boolean CLEAR(ContentTxt);…
-
The call to member SuretaxserviceRequest failed. mscorlib - Nav 2009
I am currently running Microsoft Dynamics Nav 2009 v US Dyanmics 6.0 and was running (2) different RDP servers for users to access, then open Navision. After retiring ONE of those RDP servers and setting up a new RDP server with Navision installed, any time I have a user try to verify an address in Navision on the new…
-
Item where Inventory Value Zero = True, but Unit Cost has a value
So Inventory Value Zero is rightfully true, and the postings are as expected on the value entries side (zero cost being posted). I suspect that when the item was set-up, it was created with a manually defined Unit Cost. Now that ledger entries exist, I cannot change the Unit Cost. I cannot revalue the item either, as there…
-
Problem with "Word Handler"
Hello, At one of our customers, a single employee receives the following error message on his laptop when trying to create a Word document from NAV in the Version BC14 and Office 21 (sorry for the ridiculous size, but I really do NOT have the time to find out where to resize; in the MSDynamics-Forum it worked): The…
-
I can't complete the connection between the tables
HELLO! Can someone please advise on how to now link to the purchase invoice? How to complete this chain? SELECT * FROM [Training$Sales Invoice Header$437] AS sih LEFT JOIN [Training$Sales Invoice Line$437] AS sil ON sil.[Document No_] = sih.[No_] JOIN [Training$Value Entry$437] AS ve ON ve.[Document No_] = sih.[No_] AND…
-
Relationships between tables Purch_ Inv_ + Sales Inv
Please, help me. I need information on the sales invoice regarding quantity, price, etc., but in the report, I want to see the price at which the item was purchased, the currency used, and the purchase date. How can I track this or combine sales invoice and purchase invoice?
-
Hyperlink in NAV 2013 Web Client
Hi, I've searched everywhere but I can't find the solution for my problem. I want to create a PDF button that opens a specific PDF file. I have my PDF files in a specific server, the path is like: \\myserver\myfolder\myfile.pdf I'm using the Function Hyperlink and I can get the file with RTC but when I try to run the web…
-
Blob to Stream to Text Issue
Hello, When testing the following code for the first time, it successfully worked, but after a few attempts it began to give only empty blank messages. Could anyone tell me what could be the issue? Thank you. //minutes changed to hours for testing purposes FiveMinAgo := CURRENTDATETIME - (5 * 60 * 60 * 1000);…
-
Suggest Vendor Payments - skip payments that have already been exported
Hello, I'm using NAV 2016, I have a question about payment journals and the "Suggest Vendor Payments" action. When I export a payment and check "Mark as Exported" in the vendor ledger entries, the field called "Exported to Payment File" is not checked. Does anyone know if I'm going in the right direction and what exactly…
-
Calculate Depreciation Batch Job Error
I am trying to run the "calculate depreciation batch job" but getting error that " It was not possible to find a starting date in Accounting period". Note:- Accounting period is already created, FA accounting period is also created. How can I resolve this error???
-
How to insert multiple rows in a Business Central API with a single call?
I'm trying to insert a json with multiple records into Business Central via Web Services page 60000 "Sales Order Inserts MIM API"
{ PageType = API; SourceTable = "Sales Order Inserts MIM"; Caption = 'Sales Order Inserts MIM API'; EntitySetName = 'SalesOrderInserts'; EntityName = 'SalesOrderInsert'; APIPublisher =…
-
How can I reload current page with a temporary table records?
I'm in page "Assembly Orders" 902 trying to filter out some records and display only the assembly orders that the user is allowed. Basically, trying to populate a temporary table to reload the current page with the records of the temporary table: pageextension 60008 "Assembly Orders PL" extends "Assembly Orders"//902
{…
-
Reservation Entry table
Hello, please help me. There is a table called /reservation entry./ For some reason, I always see [Item Ledger Entry No_] as zero. I can't understand which table is best to join it to correctly track it to location and item? And what does positive 0 and 1 mean? Does 1 indicate the reserved quantity? And what is…
-
Connect Posted Approval Entry with G/L Registers
I have been struggling with this for a while now, Any help or suggestions would be highly appreciated. How can I connect Posted Approval Entry to G/L Registers Tables? I'm trying to add "Approver ID" to the G/L Registers page. From what I was able to find, the only field that has some sort of common information with the…
-
Error when trying to install Microsoft_System Application Test Library.app on BC22
I'm trying to get some unit tests going, so need to install the test libraries. I installed most (Any, Library Assert, Variable storage) without problems, but when trying to install System Application Test Library I get this error: The error message seems clear enough but the issue is that I have placed the dll files…
-
How to get name of database server in AL w/o dll usage?
Hi community, is there a way to determine the name of the sql database server in AL without using dlls? I need the database name which I should get from the active session, but I have no clue how to get the database server name - the active session only carries the name of the BC server. Thanks in advance and best regards…
-
Implementation and upgrade - Business central (BC)
Please connect us.
-
Finance and accounting USA
Hi, has anybody done any NAV implementation in USA. Finance and accounting in USA are totally different then in EU and UK, especially if the nature of business is construction services. I'll get my hands on standard NAV version with USA localization, but I'd really appreciate for any practical experiences. Thank you BR…
-
is it possible to modify the "Correct Dimension" functionality in BC 22
Hi All, As we know the "Correct Dimension" functionality is working only G/L entries. but one of customer wants to also change the related Customer Ledger Entry, Detail Customer Ledger Entry and Posted Invoice or Posted Credit Memo. is it possible? thanks Advance