-
Copy User field from posted purchase invoice line(123) to G/L Entry(17) table
Hi All I have user field on the purchase order line that carries to posted purchase invoice line. I have the same field in G/L entry table as well. What is the best event to transfer the field value from posted invoice line to G/L entry table? Thanks
-
NAV 2015 - Footer Only On Last Page (Here we go again!!!)
Apologies as this has probably been beaten to death. But I've been out of the loop for a few years and now have a "requirement" for a .(sizable) footer to be printed only on the last page of a purchase order. Searches have lead me through "impossible" to using a sub-report. The sub-report approach sounds intriguing - but…
-
Integration Management does not have a definition
Does anyone know how to resolve that the Integration Management has been deleted by Microsoft? I'm trying to update Microsoft Business Central to the latest version and I need to fix that prior to the update. I already checked Microsoft Wiki but it doesn't really help
-
Limit Quantity of Credit Memo Items against Invoice Quantity
Hi Is there way in NAV or BC to Limit Quantity of Credit Memo Items against Invoice Quantity ((less than or equal to)? The issue client reports is when an invoice returned by customer, they sometime return more items or items made by our company but NOT in the relevant invoice. Since the users do not check items one by one…
-
Fornav, Document output, BC Azure
Hi. I would like to hear about your experiences with Fornav in a BC in Azure with an output module like Document Output? I have had minimal experience with ForNAV in a BC14, and I hope you can enlighten me with some basic Pro's and Con's. I have a friend who's recommending LaserNet, but I would very much like to keep as…
-
Date format Word layout
Does anyone know how to change the date format in the Word layout? I tried to use the following command column(Posting_Date; Format("Gen. Journal Line"."Posting Date", 0, '<Day,2>/<Month,2>/<Year,4>')) But the year is showing 0022 instead of 2022.
-
Reserve a Non-Lot tracked Pick Line (and consumption) against a Purchase Item Ledger Entry
Dynamics NAV 2013 We have thousands of FIFO items that are NOT Lot tracked (and thousands more that are). These Non-Lot tracked items, when picked, now need to record the incoming goods receipt number (GRN) produced at purchase receipt i.e. the Item Ledger Entry, and subsequently apply that item ledger entry number to the…
-
Address formatting in sales invoice RDLC report
Hello, I am fairly new to programming, so it can be my questions will sound silly:) A customer requested to hide the country name from the customer address in the header if the country code = x. It is a copy of a RDLC layout for the standard sales invoice report I am working with. Any idea for a newbie like on how to do…
-
wsdl "data contract" case difference from nav2015 to nav2018
I have the same codeunit exposed as webservice in nav 2015 and in nav 2018. But the wsdl datacontract is different in first letter case of function parameters. Any idea to have the same?
-
Cloud BC - Bank account linking issue
Hi All, I have 1 customer that always got this credential issue for bank linking. after key in the company id, user id, password. and then key in the security code, it keep getting me this error even though we tried using the same companyid, userid and password to the bank. it seems all the credentials are correct. but…
-
Update 22.1.54915.0 BC
We are getting the following error upon update Error AL0433: Table 'Integration Record' is removed. Reason: This functionality will be replaced by the systemID field. I'm confused how could we replace a table with a field!!? Does anyone know how to resolve this, please?
-
Report language
I have a code unit running on scheduled JOB QUEQUE that execute a report saving PDF in a folder. Works but there is a strage problem: report language was printed in English and not in Italian that was language selected in RTC client. Why? There is a way to select different language?
-
NAV 2016 - "User Personalization"/Customizations, can they be "moved" from old to to new role center
"User Personalization"/Customizations, can they be "moved" from old to to new role center? A customer is running NAV 2016. And their user groups need to be cleaned up. Some users need to be moved to another user group, and probably have a new role center. The individual users have made their own customizations, which I…
-
Communication between Traefik Proxy and Business Central with minimum TLS Version 1.3
Hi guys, I ran into a problem while communicating with a Traefik Proxy from Business Central Sandbox (SaaS as well as OnPrem). I get the error "An error occurred while sending the request. The request was aborted: Could not create SSL/TLS secure channel.". But only if Traefik has set the minimum TLS Version to 1.3. Did…
-
How to disable notes?
Hi experts, In my Business Central cloud app, I have made an extension where my new table has notes attached to it using a factbox like this on the page: area(factboxes) { systempart(Notes; Notes) { ApplicationArea = Notes; Visible = true; } } It works fine, but I don't want the user to change the notes that are attached…
-
BC - Handling Software Sales
Was wondering how people manage software sales? For example, a business buys and sells software from 3rd parties. It does not develop it in-house. Within the Item, there is a "Type" which allows "Service" and "Non-Inventory". This to me appears to be designed for software companies which develop their own software, not…
-
Add Report Sort to sub DataItem fields
Hello Everyone, Wondering if there was any way to add a sorting field to the attached Request page? I have tried to just hard code it by changing DataItemTableView to SORTING(Entry No.) ORDER(Descending) but it does nothing to the sorting of the DataItem. This is on Report 10136 for the Item Transaction Detail Report. Any…
-
Error "The type '5056' was not defined for the function
Hi All, Would the issue be resolved wiht technical upgrade to NAV2018? and then to the BC? I have an error as I am exporting a table object. Error happens at exporting of FOB and TXT file format. Microsoft Dynamics NAV Development EnvironmentThe type '5056' was not defined for the function.OK Thank you BR Damjan
-
Group on a Code field with DataItemTableView
Hi all, I'm currently trying to print subtotals for each individual support case between the lines on the report (when one case ends and the new one starts). To achieve this, I want to group one supportcase at a time to sum the lines time values. I have tried to do this using DataItemTableView and this is what I have so…
-
Microsoft Dynamics NAV Amount needs to be rounded in G/L When posting Disposal in FA G/L Journal
we are geting this error Microsoft Dynamics NAV Amount needs to be rounded in G/L When posting Disposal in FA G/L Journal in Nav 2018. How can this be resolved?
-
CurrReport.Quit causes Error in Windows EventLog (NavControlException)
Hey guys, I recently got a evtx event log export from a customer and wondering about the reason for errors like this obviously cause by this code I'm not sure if that is somehow normal or bad coding of my developers. Does someone of you has an explanation or opinion on that? It is BC20.4 on-premises. Regards Markus
-
How to copy Notes (stored in Record Links table)
Hi everybody, I'm getting crazy with this... Example: In the RTC client I add a note to the Sales Order #100. The program write it in the Record Links table and the only way to know that my Sales Order 100 has a note is to read the field "RecordID" in the Record Links table. The Sales Header has no link field like that...…
-
Reference to the member 'name' of the variable could not be solved
Hello everyone, I'm fairly new in dinamycs nav and I run in to a problem when trying to LookUp for "No." in Purchase invoice form. Error looks like that Reference to the member Padalinio koregavimas of the variable could not be solved How to fix this problem?
-
Orphan extension - cant import company
Hi We have a client on BC 21 - 2022 release wave 2 on prem, with a UAT database and a Production database. Recently we created a new instance and forgot to disable designer, and a user added a field to a page in designer. When we noticed it, we uninstalled, unpublished, and disabled designer. We now have a situation where…
-
Upgrade from BC14 C/AL to BC Online
Hi, Currently using BC14 with C/AL changes. (non extension). Which upgrade path should I take? I was planning to use this path --> https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v21 But it seems wrong, as there are no steps here to convert from C/AL to A/L.…
-
Navision 2018 Multiple JSON file printing in single text file through codeunit.
I need to get JSON file with multiple values in a single text file through code unit . As my code I'm getting a single value in a text file as JSON . Can anyone suggest answers? I'm using Nav 2018 version as i checked google 2016 codes are available I referred 2016 code and it's work a bit but I got single value only. MY…
-
trouble with report: Too many rows
Hello! Can you help me. I created new report and run on preview. Total rows in the report 19000. I get error "Stream was too long". Why can't show 19000 rows? Nav2016
-
Upgrade NAV2009r2 to BC14
Hallo together, i facing a problem in the upgrade process to BC14. MS says, to upgrade NAV2009r2 to BC14 you need to do following steps: 2009r2 -> NAV2013 (technical) -> NAV2015 (incl. Codeupgrade) -> BC14 in step 2009r2 -> 2015 i faceing the problem that that the tenant sync throw me the error, that MS standard fields are…
-
How to remove or change app registration ID for Email Account Current User
I wanted to setup Email for the type Current User. I created an app in Azure, got everything OK (I hope), but when running the set up email wizard, I used the wrong App ID. However, it went through with the wizard, but on logging on, it ofcourse showed a message that the application with identifier "xxxx" was not found in…
-
How to have more than 4 header condition in power automate when we do approval request in BC
Hello All, By default we've 4 conditions in power automate for sales quote request approval in business central(cloud) when we request approval. How to have more than 4 conditions in header? Should it be handled through code or can it be achieved using some configurations by creating a flow from the scratch or is it not…