-
Matrix
How can I find the cell (column no.) that the cursor is currently in without having to click into the cell? (NAV BC)
-
How to connect to MVC application
Hello, How to connect to MVC application eg ASP.NET C# to import data from web service? From Business Central Cloud it is not possible to connect to the server due to restrictions, so I need to use an offline "bridge" to import data from the Web Service. Is there a way to do the above approach? The image above is a diagram…
-
Save report parameters as a blob
Is there a way i can save the parameters a report ran with into a log table? I have a log table with a blob field and in this field i need to store both the filters a report ran with and the options from the request page. For example, the job calculate wip report. In the log we want to know the posting date and document…
-
BC365 - Error You do not have the following permissions on Page Customer Card: Execute.\r\n\r\n
Hi having a question we want to insert a record in BC365. Authentication goes well, (with AAD registrerd application) we can make a connection but when we want to insert a record we are getting the error message "code": "Internal_ServerError", "message": "You do not have the following permissions on Page Customer Card:…
-
Lot Expiry Dates on Whse Item Journals
Hello, When items are booked in during the putaway, a lot number expiry date is applied. However we have a situation that Warehouse entries based upon Whse Item Journal lines are not carrying the expiry dates. Is this supposed to be this way, or is there missing setup to carry these dates? Thanks
-
NAV 2013 R2 with Azure AD authentication
I'm trying to configure app registration from Azure AD for NAV 2013 R2 using Access Control Service (ACS) credential. the web client is working well and can login using azure AD account, but the windows client having some error as below: Understand NAV Windows client does not fully support Windows Azure AD and we can only…
-
Required AD Functional Level for BC17
Hi, Setting up BC17 in a proper 3 tier environment. Service account has been provisioned and configured according to this. However, can still only access the web client from the web server. From other domain attached machines: The AD functional level is currently on 2008, will this suffice or what is the minimum…
-
SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL
Has anyone found where the new system fields are actually stored in SQL?
-
Task Scheduler: How to pass parameters to OnRun Codeunit
Hello there, the TaskScheduler.Createtask Function has the optional parameter of RecordId. How can I "access" the value of the specified RecordId when the task is executed? Is there some kind of parameter that's getting passed to the OnRun Trigger of the Codeunit that gets executed? There's almost zero documentation to the…
-
B365 Excel Buffer Autofit, BorderAround and GiveUserControl no longer exist in the Excel Buffer
We are recently upgrading a client to Microsoft Dynamics 365 Business Central from NAV 2013. The following functions no longer reside in the Excel Buffer table and I am wondering how these functionalities are being done in Microsoft Dynamics 365 Business Central. Any help would be appreicated. • ExcelBuf.AutoFit •…
-
Cannot login to Business Central mobile app after first login
Hi, When I restart IIS, I can login to BC mobile client in first attempt. But when I close app and try to connect again, app cannot connect to the server. This is valid for all users. First login is ok but further attempts always fail unless I restart IIS. Authentication is windows and certificate is from a trusted…
-
AL Code error AL0999: Internal error: System.AggregateException
Hi all, I'm working on some code merge pdf files (using the old code in C/AL ) on business central using AL Code. I got an error while compiling: and this is my code: Many thanks for your help!!!!
-
How to sort a report using a column on Dynamics NAV web client?
I can sort a report by a column in the desktop print preview by following the below tutorial. But can't sort in the web client. Is there some way to do so? Tutorial:- https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-interactive-sort-to-a-table-or-matrix-report-builder-and-ssrs?view=sql-server-2017
-
Payment Reconciliation Journal not Mapping the correct Text to relevant Sub-ledger Account
Hi All, Please may you kindly assist, The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account. When the CSV file (Bank Statement is uploaded) the transactions are populated. But only the G/L Accounts Map the text to the relevant account. All Sub-ledger accounts, Vendor and Customer are…
-
Outlook Add-In: Web Client Stored Credentials
I have a client I was help testing out the Outlook Add-in, by which I mean Contact Insights and the Document Links (not the Outlook Add-in for Sync -- can we get better naming?). We set it up with NavUserPassword logins, and when we logged in, it worked OK. Now he's changed his Nav password, but the stored credentials…
-
Federation Service endpoint login failed - BC16 to BC17 upgrade on Start-NAVAppDataUpgrade
Busy upgrading an environment to BC 17.1, and I'm at Task 8, step 1 - running data upgrade on System App and Base App. However, it basically just hangs - zero errors thrown in console. Zero app server CPU activity and nothing happening on sql server either. In the Event log, this immediately pops up:The Federation Service…
-
design pattern help - how to create a record from another system?
I'm trying to make creating a purchase order for our users easier and want to be able to create PO from another system with the Dimension 1 shortcut we have setup pre-filled Ideally I'd like to create a page that I'd like to like this https://MyIntstance/Live/?page=50&dc=0&mode=create&company=12345&Dimension1=abc What I'm…
-
OData Query values come back as "Error"
Hello, We have exposed page 1007 Job Planning Lines as a web Service and attempted to connect via 0Data. However you will see we receive "Error" in a lot of the columns. We have SUPER permissions on the user. Does anyone know why this may happen? Thank you.
-
"Wrong" encoding in webservice when asking for json
For a webservice in NAV2018 I have regular listpage showing all the customers that has been exposed as a webservice. When getting the data in an xml file everything looks as it should, but if when asking for the data in JSON all of the special characters æøå seem to use unicode. ie København transform into K\u00f8benhavn…
-
Inventory Valuation qty 0 but have value
Hello all, I have inventory valuation qty is 0 but have value. I already adjust cost item entries but it seems not success. anyone can help? Thanks.
-
Best practice for upgrading to NAV 2013 to nav 2018 with Mergetool (Code and database)
Hello, Previously when I have been doing upgrades it has always been best practice to import both the old standard version, the old custom version and the new standard version into the same client, so that the text files you exported would have the exact same "layout". But since we can no longer import old versions of…
-
Please help to fix issue Navision 2018 Metadata is not sync for table ID
Please help to fix issue or advice how to resolve this error. Metadata is not sync for table ID 472. Please try again later or contact your administrator. Page Job Queue Entries must closed.
-
Error Metadata is not sync for table ID 472. Please try again later or contact your administrator.
Please help me advice to how to fix this error. Metadata is not sync for table ID 472. Please try again later or contact your administrator. Page Job Queue Entries must closed.
-
How to bypass Excel security alert on Hypelink to NAV 2013 DynamicsNAV://
Hi all We have an excel document which has a hyperlink in it to launch a page in NAV 2013. This works a treat, however whenever clicked Excel throws a security alert warning of a virus. I can't work out how to make the DynamicsNAV:// protocol be trusted - same as a https:// in internet security trusted sites. Thank in…
-
NAV 2016 - SMTP Error
Dear All, I am using NAV 2016 CU 61, recently i have issue with SMTP mail setup, attached error message, please someone help me to resolve this issue. Note : we are using office365 for mail. it was working smtp mail setup past 1 year, suddently attahced error coming from yesterday. Regards, Muthu
-
The Dimension Value Does not exist. while running Physical Inventory Journal
I'm working on Physical Inventory Journal follow these step 1. go to Calculate Inventory, put information on 2. run the report and there is an error I have no clue what is the relation between Phys. Inventory Journal and Dimension ( Department for my case) It was working before though,How can I fix this? Thank you so much
-
Divide by Zero Exception when Adjusting Exchange Rates
Hi, we use Dynamics BC for international consolidation. Our Indian Office's financial data I just import from Quickbooks (Import every booking at the end of the month). I use USD as the additional currency as it simplifies reporting via PowerBI. When I want to Adjust Exchange Rates I get a divide by zero exception. When I…
-
Converting from Option to Enum in Business Central
Hello All! i have a problem and i'm not certain that i can get around it. I know that when the Option Type fields in Business Central were, well, still Option fields that we could not extend those options with additional values. That being said, we could still rename the captions. Now that everything is an Enum for the…
-
Uploading file in WebClient
Hi! I am developing some functionalities in BC17 for Cloud. I am currently working on a report which is going to open an excel file and analyse its rows. Done this before in C/SIDE versions. The problem is when I want to use UploadIntoStream function. The function takes: FromFolder and FromFile parameters but as Microsoft…
-
Work description field not visible on sales order page in Business Central
Hi experts, When our customer uses his Business Central Cloud (production), the field "Work description" on the sales order page, is not visible. There are no extensions or personal changes to that page. When he try to make personal changes to the page (add/remove fields etc.) the field "Work description" is NOT on the…