-
How to Setup Payment Service Connection
hi, How can i setup Payment Services connection setup, if i am using Payment method code in Sales invoice, the Demo database 2016 IN is asking for the setup. If I have checked yes in Run in Test mode and Generated->Downloaded ->Uploaded the Key. But, when i click on Sign up Now, dynamics link page open that i always in non…
-
How to add Chart in Role Centre Page
Hi ... is there any way to create a custom generic chart and add that to any roll canter page in new BC? Previously in NAV desktop application by add new chart part and then customize that part and selecting the required chart from generic chart list. I could not find this option in Business Central web version. I can…
-
Permissions Dialog for Interacting with External Functionality
Hi, The first time you Send to Excel, or send an email via outlook from Microsoft Dynamics 2016, you get a one time dialog informing you that you are about to interact with external functionality. The dialog asks you is if you want to not allow it, to allow it once, or to allow it always for that external functionality. I…
-
NAV 2015 Bug? TableRelation and Enabled with condition
Recently I encountered a reproducable NAV 2015 client crash that took me a while to understand. Table "A" contains a field "Ref B"(Code 20) that is used to reference Table "B". Therefore the Field "Ref B" has its property TableRelation to "Table B"."PK Field". Page "Card A" uses table "A" as SourceTable. An action "Show…
-
Import Picture in BC 18.0 (Cloud Environment)
Hi all experts, I would like to ask about the import picture's coding. In BC 18.0 (Cloud), it is no longer support FileManagement.UploadFile() function. If in the cloud environment, I want to select a picture from my computer, what should I do? Thanks. bestian
-
multiple expiration dates error after reclass. journal
I've found several hotfixes related to error: "There are multiple expiration dates registered for lot XXXX". However they don't seem to work with this particular situation when I use a Reclassification Journal. The case is: - I create a new product with required batch number and expiration date. - I purchase this product…
-
where is bank sort code and account no
hi, im using nav 13 but cant see sort code and account no? i have them in my old nav? why are they not there? i am using GB verison
-
BACS - how to chnage the exported file format
hello, how do you chnage the bacs format in the exported file
-
BACS bulk file missing
hello! in the old nav there is export bulk option.where is this in the new nav
-
Automatically declining sales price for each trip.
Hello I have a serouselly question in the nav 2016 how to Automatically declining sales price for each trip., for exemple Tripr one it lunch for start date 01/01/21 to 01/01/21 with sales price record from contrat for item No 000001 = 100 $ When shipped the first delivery unite price get from contract but when i send a new…
-
Business Central SaaS - Domain Change Question.
Hi all, Popping this in here as I dont see a BC SaaS section, so apologies if it is wrong. Question is around changing domains when having BC SaaS. I have been asked by someone considering getting BC SaaS whether they could purchase it now against their existing domain e.g. reggiescompany.com but are looking to change…
-
How to get container for BC16.7
Hi All We are on prem with BC2020 Wave 1 and CU's installed (Update 16.7 for Microsoft Dynamics 365 Business Central 2020 Release Wave 1 (Application Build 16.7.18411, Platform Build 16.0.18359)) Help says we are on "Version: NA Business Central 16.7 (Platform 16.0.18359.0 + Application 16.7.18411.0)" I want to download a…
-
xRec and Rec have same value in sales line OnAfterModifyEvent (automated tests)
We are using the Microsoft Sales Test Library to create sales lines. We have an extension where we need to log certain changes to sales line fields under certain conditions (change log won't work for what we need) We have a subscription on sales lines that works fine when we use the web client with keyboard and mouse…
-
Assign multiple values to 2d Array
How can I assign multiple values to an two dimension array and not one by one _matriz : array[2,10] of Text[100]; { {""," uno", " dos", " tres", " cuatro", " cinco", " seis", " siete", " ocho", " nueve"}, {" diez"," once"," doce"," trece"," catorce"," quince"," dieciséis"," diecisiete"," dieciocho"," diecinueve"}
};…
-
Field locked for editing
Hi, I want to edit the last modification date in the Item Card after adding or modifying the Unit of Measure records but I have not succeeded and I suppose it is because the field is blocked I have tried it this way: [EventSubscriber(ObjectType::Page, Page::"Item Units of Measure", 'OnInsertRecordEvent', '', true, true)]…
-
Auto import file from folder (Job Queue) - Cloud BC
Hi all, for cloud BC, are we able to auto import file from certain path or folder? 3rd party will export file to the certain folder.. then BC need to auto import from this folder. Thanks.
-
FIFO Unit Cost with lots
Hi all, For what i understand NAV allows the item to be batch(Lot) tracked Purchases: Posting date = 01/01/2021 Item code = A Qty = 1 Item cost = 1000 Lot No = A1 Posting date = 02/02/2021 item code = A Qty = 1 Item cost = 2000 Lot no = A2 When we make a sales order : Posting date = 03/03/2021 Item code = A qty = 1 Item…
-
Retrieve value from XML file with <
Hi I am trying to retrieve values from a retrieved XML file after making a POST webservice call. The structure of the returned XML file is - <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"…
-
External Tables and distributed transactions
Hi all, I am a fan of External Tables. I prefer them to the linked objects for their flexibility and no mandatory use of views. I have a problem with this scenario. I have the SQL instance of Nav on a server while the external table points on a server on another instance SQL. I have to write in the external table some…
-
Problem with jobs in the work queue
Navision 2018. Created a job in the work queue. Registered the schedule. The validity period is not limited. Everything works, but from time to time the task stops working. No error messages. What could be the reason for such strange behavior?
-
MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop
Good day! MS Dynamics NAV 2015 / LS 2015 - Replication issue - Job Queues always stop - every time we turn-on or restart the client computer Job Queues always stop, we need to start it again OS: Windows 10 Pro 64bit and Windows 7 Pro 64bit MS Dynamics NAV version: Thank you.
-
Export to Excel
Hello, a user have to connect to navision using RDP. When she tries to export Vendor ledger entries to Excel, a blank Excel sheet opens. When she tried to copy the lines from Navision and paste it on the Excel installed on her Laptop, the format of the amount changes. For all 4 figures amount, the formatting is as Text and…
-
Zetadocs Express Addin unable to open docs without Internet Explorer
As Internet Explorer is being discontinued later in the year, we have started disabling it in pcs. An issue we discovered though is Zetadocs Express addin is unable to open any documents without IE. Nothing happens. We raised it with Equisys, who informed us of the below KB.…
-
Not able to connect to SQL server from NAV 2009 R2 in Windows server 2016 (Server cannot be found)
Working on a new migration of NAV 2009 R2. So, now we're using a new environment such as Windows Server 2016 and SQL 2017 and NAV 2009 R2. For now NAV client, NAV server and SQL server are all in the same machine(Windows Server 2016) for my troubleshooting. I've installed NAV 2009 R2 but when I go to NAV database open and…
-
Crystal Reports in AXAPTA
Hi Experts, Can Crsytal Reports v.11 be used in inside axapta through x++. FOr example I will make a sales invoice in crsytal reports. How can it be called using x++; IF yes. Can you give me a sample code. Thank you very much. MIKE
-
Debug Onprem with AAD Authentication
Hi! We have a customer that has a onprem envrionment with AAD authentication. Is it possible to debug a user session that is connected with AAD? What I can read it isnt possible which is really awful if that is through. "AAD authentication is supported only for Dynamics 365 Business Central sandboxes. AAD authentication…
-
Webservice with table datapercompany=no
Hello, Business Central Spring Edition, We have Table1, with datapercompany=yes. this table has a field with a relation to table2 table2 is datapercompany=no. Via webservice, we add a value to table2 and after, add a line to table 1 => Error : related info in table1 doesn't exist ... If we look into the table with classic…
-
How to increment a field value if it has same another field value
In Nav 2009, I am creating a dataport export where I am taking values from g/l entry table. My question is For suppose if we are having document no as 'qwerty123' I need to keep '1' in another field 'numbers' and again if I have the same same document no in next line the field 'Numbers' should be incremented by 1 and…
-
Illustrator Tech Pack Fashion integration NAV
Hello, I would like to discuss a possible project to implement and i would be open to read some ideas. Designers fashion use Illustrator or speadsheets to make their tech pack fashion. Imagine a scenario where designers build their tech pack in illustrator and the goal here is to intregate with nav's manufacturer so that…
-
SetRange in Dataport
Hi, Primary: Boolean Item: Code 20 I'm trying to import a CSV file using Dataport. This CSV file has multiple records. I want to check if there are any records in the table before importing the CSV file, if so, then if their Primary field is true, then before importing the CSV File I want to set that Primary field to be…