-
How to Export To OLD Syntax
Hi, I'm a developer currently working with some installations of Business Central 14 OnPremise. Despite the transition to the development in AL, I still need to make some customization the old way with C/AL and development environment and therefore I still need to merge object in txt. When I export the txt object from some…
-
get all values of field in table for writing in the variable of array
May be somebody knows how to get all values (there are 10) of field in table to writing they in var of array: Int [10]?
-
Creating an outsream and in stream of XML data..
Hii all experts I am facing an issue and need your valuable suggestions, Problem --> 1)NAV System XML File/data outstream> 2)System 2(Reads the data processes it) | | 4) <--NAV reads the data and stores it <3)XML Stream data back to nav< Most of the experts must have done this.. just seeking the idea... is it feasible if…
-
How do you avoid the missing description error when Omit Default Description is ticked?
We are using Nav 2017. I have C/AL code to calculate intercompany and do various other things. Code Snippet GenJnlLine.INIT; EVALUATE(GenJnlLine."Posting Date", GetFieldStr('PostingDate')); GenJnlLine."Journal Template Name" :='GENERAL'; GenJnlLine."Journal Batch Name" := 'INTERCO'; GenJnlLine."Posting No. Series" :=…
-
Comparing two record variables
I don't know if it's risky, or if it's a known habit of you guys, but sometimes i want to compare two record varibales and see if they're the same (i mean, through code). i also noticed that FORMAT function works with record variables. Is there something wrong (or is there a better way to do it) in doing this?IF…
-
Performance issues in generating electronic accounting with high transaction volume
Hello everyone, We have a client with 40,000 transactions, and when generating electronic accounting, it takes a long time. The last one I generated took 9 hours. However, the client says it doesn't generate anything. Microsoft replied that this delay is due to the transaction volume, but my boss's boss insists it should…
-
Excel Buffer with extended formatting
Hello all, I would like to share a solution that allows to export data to excel via "Excel Buffer" with extended formatting: alignment, cell borders and etc. You can find source code with code samples on GitHub: It doesn't require any additional components, it uses only OpenXML components for extended formatting. This…
-
[Solved] SMTP Mail and TLS
Hello, One of our customers wants to switch his email delivery to Exchange Online. However, when sending the test email in the SMTP setup, he received the following message: "The mail system returned the following error: "Error sending mail. Authentication failed because the other party closed the transport stream." After…
-
New sales Price Experience - handle fall-back prices
Hi We are trying to implement the New Sales Price Experience but have experienced a bit of a let-down. We have a price list with two lines - they are exactly alike except one has a Work type code = Posting and the other one has a blank Work type code. I would expect the functionality to get the first price, if the Work…
-
how to send HTML multipart form
I need to send a multipart form data, from NAV2017 The form is very easy... <FORM action="https://cot.test.arba.gov.ar/TransporteBienes/SeguridadCliente/presentarRemitos.do" enctype="multipart/form-data" method="POST" name="form"> <P><LABEL for="user">User: </LABEL> <input type="text" name="user" value="" /><BR/> <LABEL…
-
Sales order report print issue.
Hi Everyone, I have created a sales order report, in which I have used Tablix in the body part. I need a divider between the fields up to the footer, whether the data is 1 line or body is empty or 10 lines are there. I have attached two images: in the first image, I have shown my issue, and in the second image, I have…
-
Avoid using email scenario in BC22?
I'm trying to set up some automatic email sending in BC. I set all the parameters for the "Email item" record I am using, such as the from address and the from name, from a setup table. But when I use the EmailItem.Send procedure to actually send it, it insist on using email scenarios, ignoring any parameters set in the…
-
Business central onprem AL custom approval workflow
I have a custom approval workflow that archive step instances before approval process is completed, what could be the issue? is there something I missed on my code?
-
Upgrade BC230 to BC240 (On Prem): Error when running Start-NavDataUpgrade on Base Application
hi there, I'm currently upgrading an on-prem BC230 to on-prem BC240. When I run StartNavDataUpgrade, I get the following error: "Could not upgrade the extension 'Base Application' by 'Microsoft' from version '23.0.12034.12841' to '24.0.16410.18056' for tenant 'default' and company '' due to the following error: 'You tried…
-
Data Exchange Definition Export
Hi Community :) I am trying to export Banking data using the Data Exchange Definitions and sending to a flat file. I have got it working using a repeatable line (multiple payment lines) Line Record, Field 1,Field 2,Field 3,Field 4,Field 5 Line Record, Field 1,Field 2,Field 3,Field 4,Field 5 Line Record, Field 1,Field…
-
What license is required for BC SaaS integration with PowerApps to modify Service Header record?
Hello, My colleague has integrated an application in Power Apps with Business Central to pull data from the Service Header table successfully. With this done, I want to update a record in the same table by changing the value in a single field. This field is a custom field. When I run the Power Automate flow to do this, I…
-
Weeknumber in date picker
Have searched forum but have not found this. Is there a way to show week numbers in the date picker in classic client?
-
Flow the custom data
I created some custom fields so I want to flow the data from general journal to GST (Goods and Services Tax) ledger entries in the Indian localization involves customizing the relevant CodeUnit I am not unable to find any event so can you help me out of this i am working on BC23 now
-
Blob to Stream to Text NAV 2013 r2
Hello, Issue is that in the following codeunit when creating subsequent notes only the 1st one successfully sends "Note" content. This isn't an issue in NAV 2017 for some reason, but is a problem in NAV 2013 r2. I Checked in Debugger, on first iteration NoteText = "test1", On second iteration NoteText is empty. what could…
-
In Business Central v.24 Webservies do not work
In my Business Central 24.0 i added a new Webservices with page 46 (Sales Order Subform) and i do not have access to the data via the OData4 URL. I´ve tried it with Postman, and added a valid OAuth2 Bearer token, but my Response is always "404 Not Found". It worked in BusinessCentral 23.x Thanks for your help
-
How to free space from the Tenant Media table?
Hi, I have 20GB of information from the Tenant Media table, I need help on how to free up space on that table. I deleted the images of all the products from the Items table and they are still visible in that table, there are even images that had been removed a long time ago. I am using Dynamics NAV 2018.
-
BC22 - Remove Single Quotes from Filter Totals By
Hi all, I am trying to find a way, without much success, to remove the leading and trailing single quotes that somehow get included when passing a custom field of Type Text in the Item Journal Line, e.g LOT0000067|LOT0000069..LOT0000071 (without single quotes), to the Filter Totals By field called "Lot No. Filter" in the…
-
How to free space from the Tenant Media table?
Hi, I have 20GB of information from the Tenant Media table, I need help on how to free up space on that table. I deleted the images of all the products from the Items table and they are still visible in that table, there are even images that had been removed a long time ago. I am using Dynamics NAV 2018.
-
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!