-
Saving a file to Sharepoint
Hello, I would like to know the setup required to automatically save a file to SharePoint from Business Central. Please could someone direct me to any blogs which explain this well. This will be on the back of creating a .txt file via Data Exchange. We are on Business Central 16.1. Thank you.
-
API Query in BC
I want to make a custom API with items and customer discounts. So I made a query and connected the item table to the Sales Line discount table. query 50100 "Itemprice Entity" { QueryType = API; Caption = 'Itemprice API', Locked = true; APIPublisher = 'Me'; APIGroup = 'Client'; APIVersion = 'v1.0'; EntityName = 'itemprice';…
-
Business Central: How can I do automated testing of Processing Only Report ?
Hi Community, I need to do automated testing of processing only report, I need to cover the code written in OnPreDataItem and OnPostDataItem triggers ? Can anyone give me head start, i'll be very thankful. thanks
-
Order of triggers in Table
Hello NAV experts, What is the order of triggers execution in a Table Object? exemple: is onModify before onValidate ? Regards.
-
XMLPort In Business Central
Hi! I need to catch the URL of a file imported with the XmlPort. With the Windows client, i can get the total file name (URL+File Name) with CurrXmlPort.FileName, but with the Web client, i can only get the File Name (without the URL). I need this info to save it in a log table (with other infos like File Size, Date, Time)…
-
Workflow Setup question
Hi Guys, I'm going around in circles a little bit with a workflow setup I need to do for my customer. Looking for any help if you have experience with this scenario. There are 3 levels of approval based on value, 1: 0-5000, 2: 5001-200000 and 3: 200000 and above. So far so good and I can set this up in approval user setup.…
-
Item charges affecting unit cost
I'm facing the following problem: when a Purchase Order with a respective item has some charges, for example transport and insurance, and i invoice the Purchase Receipt of the item and only one of the charges, the charge pending will affect my Unit Cost The cost expected of the insurance is afecting the unit cost. The…
-
Cannot generate SSPI context. State ID: HY000
I know there are other posts about this, and I tried it all out. I have Navision 5.00 on a SQL2005 standard edition on an XP (my portable). If I try to connect to the SQL DB with Windows login (with nettype default,Named Pipes,TCP/IP Sockets,Multiprotocol) I get this error. The strange thing is : if I connect with MS SQL…
-
Link tables in one
Hi, I have a project for Nav 2013r2 and Nav2018 I have a table with many fields(photo) I must to create a process(batch) that take value from other table and insert in this( for example id_customer = Sales Shipment Header"."Sell-to Customer No." and other field from another table and so and so) Many fields are from Sales…
-
How to find table 2000000041 ("Field") in MS SQL?
People. Tell me please - where table 2000000041 ("Field") is stored in MS SQL. - how to find table 2000000041 ("Field") in MS SQL. Field numbers of the tables in view sys.columns do not match the actual field numbers in the tables. Is there a way to get the actual field numbers?
-
NAV 2009 Spell Check
I have searched for a spell check solution and followed up with dvp and avf who list solutions, but they either don't support or haven't tested rtc. Has anyone solved this? Thanks, Tom Roberts
-
DATAPORT : how to return to the first line or read again the file ?
I would need to read the whole CSV file (to check each line) then go back to the first line to process the data. Is it possible ? How can I do so ?
-
Unable to open SQL Server database file (.mdf)
Experts, I have a SQL Server 2005 database file (a .mdf file) that I am trying to open in SQL Server Management Studio so I can add a field to a table, but I am unable to open the file. I can't say that I really understand how SQL Server handles these databases. I especially don't understand the "attaching" and "detaching"…
-
Views and OData webservices
Hi everyone, I created and saved a view in dynamics NAV 2017. Is it possible for an OData webservice to run with the filters from that view? I mean is it possible for the webservice to retrieve dynamically those filters? Thanks in advance :smile:
-
how to send data to webhool
Can anyone help me to synch data using webhook. I have doubt only URL. what is URL for data exchange for example customer card I have both https and http with SSL for on-promise need few steps Warm Regrads Kris
-
Extension disappearing from user menu
Hello, I'm having problems with an extension in version 2018. Sometimes it disappears from the RTC menu (it's always visible from extension management) and the only way to make it visible for the users again is to restart the service tier. It disappears from all users (both super and other types of users). Does someone…
-
Calling BC web services from Postman/Fiddler
Hi all, I'm getting an error 401 Unauthorized, when I'm trying to call BC web service from Postman/Fiddler. Username is my user in BC and the password is generated web service key for that user. Just to mention that, when I copy same link in browser, I'm getting right json response from service. Does anyone faced with a…
-
Use a value in a Request Page's field
Hello, I want to use a value from a record in a request page's field. I used a method "SetParam" to transfer the Primary Key to the report in order to select the right record. This is the code in the Card Page: trigger OnAction(); var locCalculLoyerEntete : Record "Calcul Loyer Entete"; repDCL01FDL : Report "DCL 01 FDL";…
-
Get current Matrix cell
Hi, I'll try to be clear on that one. I want to get the column ID i'm currently focusing. For example, in the screenshot : 1. The user type default values in Area 1 (Red) 2. He focuses the cell he wants the default values to be typed (Area 2 in blue + Area 5 in pink) 3. When he presses enter on the cell, the line is…
-
Copy a BLOB to another record
Hello, What am I missing to copy the BLOB "Texte" to the BLOB "Documents Manquants" ?if locExtendedTextHeader.Get(locExtendedTextHeader."Table Name"::"Standard Text",'DCLDOCSMAN','FRB',1) then begin locExtendedTextHeader.CalcFields(Texte); Validate("Documents Manquants",locExtendedTextHeader.Texte); end; Thanks in advance.
-
PowerBI factbox error
I have converted a 2015 Nav database to Business Central 14 (spring 19). Everything works fine except for the pages where the POWERBI FACTBOX is present. In this case I get an error: Microsoft.Dynamics.Nav.Client.PowerBIManagement;PublicKeyToken=31bf3856ad364e35, The page contains a control add-in that is not permitted.…
-
NAV 2018 TaskScheduler
Hi you all I have an issue with Scheduled Tasks. Looks like some of them do not get processed at all. Even after setting a new Not Before dateTime it does not move. We generate about 20 Tasks running an own codeunit .. Most of the Tasks are processed but from time to time for a reason i don't understand Tasks do not run.…
-
Merging FR with BE localisation
hello, has anyone tried to merge the FR localisation with the BE localisation? what are the difficulties encountered?
-
Reverse Payment that already applied to Invoice
Hi all, I'm trying to reverse automatically a payment to a Vendor using these steps. Step 1) Unapply the payment from the invoice Step 2) Reverse out the transaction. Step 1 i have no problems. When i try to reverse automatically Payment of a Vendor, i'm getting this error: LOCAL InsertFromGLEntry(VAR…
-
BC Automated Testing: Code coverage page is not opening in Business central 17 on premises version ?
Hi Community, I was doing automated testing on BC 17, what I have noticed is that you cannot open code coverage page. it says 'You can only run code coverage in a sandbox environment'. Previously I was able to open code coverage page in BC 16. Can someone tell is there a workaround to open Code coverage page ? thanks
-
AL begin..end blocks changed colour?
Hi All, I hope every1 is safe! There is something that I´ve realised in my code, for some reason "end" blocks come as red? I experienced this I think when I copied some piece of code from classic nav but as the codeunit is very long I can´t identify if I did this now at some point. Any ideas? thanks.
-
VS Code for AL: Timeout after 2000 ms for 'terminate'
Hi All, I hope someone can help. This is nothing to worry about but it started to happen suddenly. When I stop the debugger this message comes up: Timeout after 2000 ms for 'terminate' Any ideas if there is any setting for this? Thanks.
-
import AR Balance
Is there an easy way to import open AR so that both the Original amount and the remaining amount show? Often this is different depending upon payments made to reduce.
-
Problems creating a WebIntance for BC160
I'm trying to create a WebInstance with 2 different version of BC, 140 and 160. 140 works, but as far as BC16 is concern, when it opens the webbrowser it provokes and error: The client version does not match the server version. You can only connect to a server with a matching version. Client version: 14.0.38650.0 Server…
-
BC 14 on-prem NAVUserPassword Windows & Web Clients - Certificates
Hi We need to implement NavUserPassword authentication for both Windows clients and Web clients, on BC14 on-prem. The Windows client was tested with self-signed certificates and worked. We created these certificates based on older documentation, which created a Root CA, a certificate revocation list, and a Service…