-
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…
-
Auto Export of Item List
Hi Experts, I need to automatically export data (Item List) from NAV 2018. I've been searching online and got a clue that I must create a codeunit for this and use a job queue, but I really don't have a background in writing script. May I know if is the right way to do it and where I sould start?. Thanks in advance.
-
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…
-
How to add date stamp field when boolean field box is checked
When boolean box ix checked, i want the current date to populate a date box next to the boolean box on the page NAV2018
-
"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…
-
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…
-
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.
-
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…
-
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…
-
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.
-
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…
-
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…
-
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.
-
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…
-
Windows Client Issue with Credential Type UserName
Changed ClientServicesCredentialType to Username. Web client works, but Windows client would complain: The ClientServicesCredentialType configuration setting cannot be parsed into a valid NavClientCredentialType Using NAV 2017. Any suggestion please. Thanks.
-
How to import data from an XML file to BC tables?
Hello everyone, I already have the data from the XML file in InStream, I need to access each node to obtain the data and insert it into a BC table. XML has several levels, in addition to being very extensive. How can I do it? I have seen a method (y2u.be/x8AOo9j-ifE), however I have not managed to access the nodes. This is…
-
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
-
BC 14 CU11 SignalR Queue and CU1 Error
Hello Everyone, Client is using Web Client for BC 14 CU11 on premise version. We are getting error of CU 1 in event viewer even though there is not reference for Codeunit 1 in any objects. Also, event viewer has "SignalR: Large Count of message in the queue" warning. I have noticed users start to have more errors when this…
-
[BC 365] The wsdl of my web service is not complete
Hi everyone, I'm having issues while trying to install web services on business central. I've developped a web service on dynamics nav 2018 and I can't post it on a BC version. I used to create my web service on the web service window, and to verify if my web service was correctly posted, i used to follow the soap link…
-
Navision 2018 CU 35
We have noticed that when printing reports from NAV 2018 on dot matrix; it actually changes the report layout to landscape. We've tried all possible items mentioned in articles mentioned. Anyone can hint us how to fix this issue.
-
help with how to create a purchase order with a shortcut dimension pre-populated in the right compan
I need to launch a page in Business central and change the company through the URL, launch the create purchase order (page 50) and have one of the required dimensions pre-populated I am thinking it would be nice to be able to launch the following URL https://mybcinstance/Live/?company=CompanyName&Page=50&dimensionParam=123…
-
DE language package for NAV 2013
Hello, Someone can help me to find the DE language package for NAV 2013 CU11 (v7.00.36.076) . I searched everywhere on the internet without result Thank you
-
Credit Memo Inventory Adjustment
When you process a Credit Memo it will automatically bring this item into stock. It has been requested to control this behavior to either continue as standard or allow for the Items to not come back into stock. Reviewing the options we have would it be best for me to let Standard Nav handle the Adjustments as standard…
-
JSON Nested Array
Using a website such as https://jsonplaceholder.typicode.com/users how would I iterate through the Address array within this json text? What would my Selecttoken path be if I wanted to retrieve the City of all available users? Thank you.
-
Planning worksheet, no join
Hey guys, maybe someone can help: Do you know how to make the planning worksheet calc function not to join supply orders for sales orders even if they have the same item no and due date? The customer wants to see a clear picture about the source of demand, it is very annoying to click order tracking on each plan line.…
-
How to replicate Sales order as now one?
Hi I try to create Sales Order Change page for the situation : When user makes sales order change they must entry data in the page (Sales Order Change) and waiting approval by team leader. For the purpose ,I replicate the Sales Order include Table (SO Line Table ID 37) / Page as new one for Sales Order Change table (SO…
-
launching a business central page with parameters filled in?
I need to launch a page in Business central and change the company through the URL, launch the create purchase order (page 50) and have one of the required dimensions pre-populated I am thinking it would be nice to be able to launch the following URL https://mybcinstance/Live/?company=CompanyName&Page=50&dimensionParam=123…