-
Getting the error while export a table as Excel file
In Data migration, I am trying to export a table as an Excel file. But it throws a below error. Microsoft Dynamics NAV ClassicThis message is for C/AL programmers: The call to member text failed. msxml6.dll returned the following message: An invalid character was found in text content. Please assist me to clear this error.…
-
NAV2009 SP1: Change Timezone for processing web-requests running as Network Service account
Has anyone found a hack / tip to change which Time Zone the NAV 2009 SP1 Web Service is executed in? In NAV 2009 R2 and newer it can be changed for each service, but I have an old server instance I would really like to change without doing a run-time upgrade. It is documented here, that this is "by design" in NAV 2009 SP1:…
-
Short/Excess Qty
Hi How we can manage Excess/Short inventory . Can we specify different Document Type or Entry Type to differentiate these Document No or Items Thanks
-
EBICS TS Channel configuration - Import bank statement
Hi, Is there a features provide the functionnality to connect directly Nav and the Bank server with the EBICS TS protocol to pull in the bank statement directly in the bank reconciliation windows ? My bank provide me a link and credential, and they say to me that I have to configure my ERP system with this credential to…
-
Control AddIn public key corrupted
Good day, Setup: NAV2018; Several AL Extension with several Control Add-In Problem: My Control add-in stops working sometimes when I deploy the new version of my extension. It shows the errror "Control add in with public key XXXX cannot be found." Investigation: I found out, that after deployment (via Publish-NavApp from…
-
Rounding
Hi all, My client got an invoice with 0.01 and it has to be 0 (because of the rounding). Is there some setup in NAV regarding this or we have to change the calculation? Thanks in advance
-
Business Central Cloud Enable Table Key
What if I want to enable "Serial No." key in Business Central? Now we are on NAV2018, I enabled this key. Because we want to sort ILE by Serial No. and quickly. How could I achieve the same, when we theoretically move to BC Cloud? As far as I understand you cannot enable existing keys in BC, right?
-
NAV 2013 R2 - Need help on report
Hi, I'm creating a payment journal report and need a help with it since i'm not very good at it. The data on gen.journal line template payment should look like this: The result should be totaled first by document, vendor, and then followed by field Ok to Pay like this : The 1st Amount column from the left is totaled by…
-
General ledger entry not pulled to the bank rec
Hi all! A few of my general ledger entries are not pulled into the bank rec, any advices?
-
Finished Production Order and incorrect Posting Dates
Hi All, I found a problem with production order in my NAV 2017. 1.I wanted to change status of production order into Finished. But it was not possible due to not correct posting period setup. Posting Period setup during changing status of the order to Finished General Ledger Setup: 01/03/19 – 31/03/19 User Setup: 28/02/19…
-
Connect NAV 2018 with CRM on-premise 2016
Dear All, We working connect NAV 2018 - CRM 2016 On-Premise. While connecting NAV 2016 with on-premise I am getting below error: Can supported NAV 2018 -CRM 2016 On Premise? Thanks for advice Mesut
-
attach links to a posted document and open it from the entries window
hello there! I have heard that with the newest CU you can open the attached links even if you attach them after posting the document. can somebody tell me how to create /recreate this. and where to look at for this functionality?
-
Inventory value zero - assembly order
I'm generating a item with inventory value zero by assembly order by I'm having a real cost (that's something I didn't want). Is this a standar use or I've missed something.
-
Remaining Qty. exists in Job Planning Line,but Job Ledger Entry and Job Plan. Line have the same Qty
Hi everyone, The NAV is 2017. There is a job with multiple job tasks and job planning lines.The job planning line type is Budget and type G/L account. As you can see in the picture the Quantity is 2 and the Quantity Posted is also 2. Through the Usage Link table and after going to the corresponding Job Ledger Entry ,the…
-
Doubt about MailItem automation NAV2015
Hi experts!! I have the following code that automatically sends an email with a Word file in the message. Now I need it not to be sent but to stay the dialog open for the user to decide whether to send it or not. I tried to comment the line "objMailItem.Send" but does not work. objMailItem:= MailApp.CreateItem(0);…
-
Adjust Report selection during Runtime Business Central AL
Hi, I look for a possibility in AL, to print a custom report when a Whse. Pick is created, whithout leaving a footprint. Right now, in Report 7318, the following code is called in the OnPostReport(): IF PrintDoc THEN BEGIN IsHandled := FALSE; OnBeforePrintPickingList(WhseActivHeader,IsHandled); IF NOT IsHandled THEN…
-
Second XML declaration line in XMLport
I have imported a XML schema and made a XMLport as an extension in AL (NAV 2018), but I need to insert a second XML declaration row and can't figure out how to do it. After the standard <?xml version="1.0" encoding="UTF-8" standalone="no"?> I need a row looking like this <?POSTNET SND="5566081716" SNDKVAL="30"…
-
Remember filter
Hi, Do this on any form with lines in AX 4.0: - Open form. - Use Ctrl-K to filter the records. - Use Ctrl-N to start creating a new record. When I press Ctrl-N, I suddently see the lines, that I filtered out using Ctrl-K. I only want to see the records, that matches my current filter. Is there a way to remember the filter…
-
AL - Closing Page does not save customization changes in page.
Hi All, when you open - for example Customer Card- and change Page Size or collapse/expand some groups, the next time you open the same page, these settings are saved and you continue where you left off... When i open a card that i have created using AL, these settings are not saved, the groups are always collapsed and i…
-
Report on Visual Basic-empty lines on table
I Create a report on visual basic and I have a table on the report with values from a table. I have several empty lines before the the data . How can I filter to skip the empty lines on the table that is used on the report?
-
Upgrade Tags in Buisness Central
Hi everyone. I am looking for any information about Upgrade Tags in Buisness Central. Does anyone know anything about this? Does he have any documentation? The only thing I found on the web is this blog: https://robberse-it-services.nl/blog/2018/11/21/using-upgrade-tags-to-facilitate-continuous-upgrade/. Every information…
-
Address and contact address formats for BA, MD, GE countries?
Hi All, Can any one please provide address and contact address format for below mentioned countries. BA-Bosnia and Herzegovina MD- Moldova GE-Georgia Example: "BR","Brazil","","","City+Post Code","First" Thanks, Mahesh
-
Making Tax Digital for multiple companies
Hi, We managed to setup OAuth2 authentication for one company. (So we got Authorisation Code and all is working fine) The problem that we have is that we have 3 more companies. If we use the same setup for other companies then we get 400 error message. Do we have to request a different Authorisation Code for every company…
-
Issue with Journal Upload in Rapidstart
Does anyone know if there is a way to populate the source code in journals when loading via Rapidstart? I have used this for many years, but have just noticed that the source code is blank in the journals posted, unless the source code is populated in the Rapidstart package? This is NAV2017 Know it can be included, but it…
-
price checker
Dear I have a price checker that will read the barcode to give the item price for the customer. I should develop a console application, but within the query what tables should I use to get the price of the item and also after the discount if there is offers. I am using Dynamics Nav 2018 windows client.
-
Procurement process addon
Hi All I am looking for procurement process addon like RFQ, Quote comparison and Conversion to PO. Please let me know if any lead available on this add on part. Regards Vinoth
-
Export to excel for Card Pages/Worksheets in Nav 2018
Hi All, I would like to know if there is a way to export the data to excel from card pages/worksheets in Nav 2018. We do have it for List Pages. For Card Pages/Worksheets Export to excel option is disabled by default. Thanks in advance.
-
default Process Flow
Hello Good day. Where can I find the default process flow of defaults modules of Navision 2018? is there any available? Microsoft release this kind of documents ? Thanks and advance.
-
Stylesheet in Javascript Control AddIn will not be applied
Hi, I have created a simply Control AddIn, based on this article. The javascript file will be applied. But not the Stylesheet. If I inspect the DOM in Webclient, the reference to the javascript file exists as espacted. The stylesheet is missing in the head-section. Does anybody knows, what I'm doing wrong? Navision is…
-
What are the results of changing these service settings (cache size, chunk size, comp. threshold)
I am curious if anyone knows exactly what can happen by changing these settings? Or even, what other factors on the server/data/etc should be taken into account with These are the settings you can change per service tier using the Dynamics NAV Administration snap-in. Data Cache Size Chunk Size Compression Threshold The…