-
How to Invoice Ressource for time spend for a customer - Consultant Activities company only
Hi, I have'nt find out how to deal with this need : I have consultant ( Ressource ) , how spend time working for different client in the TMA ( Tierce Maintenance Application ) contexte . So we have a contract for each client , for exemple , any hour spend helping you will be charge for 100 Dollards. Ok, great. So all the…
-
How to apply a payment(LCY) to a sales invoice(FCY)
Customer->Customer ledger entries-> Apply a payment with local currency to a sales invoice with foreign currency -> Set applies to ID- can’t apply because there’s a balance available. What should I do in this scenario?
-
Can I implement Business Central NAV using its any existing Codeunits or Procudures?
Given a date, return an array of last 13 months. Example 1, given date is 10th of April 2020 (10/04/2020) Array Returned with 01/04/2020 10/04/2020 01/03/2020 31/03/2020 01/02/2020 29/02/2020 01/01/2020 31/01/2020 ....... 01/04/2019 30/04/2019 Example 2, given date is 18th of Feb 2018 (18/02/2018) Array Returned with…
-
How to use Custom Report Layout in Extension Development
Hi, we are currently preparing our solution in Micorosoft Dynamics NAV 2018 for a BC 14 AL convertion. One problem we are facing is our usage of the ImportLayout, ExportLayout, UpdateLayout and CopyRecord methods from table Custom Report Layout. These methods are not supported in extension development.action(ImportLayout)…
-
Making changes to a table that is included in SQL Replication
We have a NAV 2016 database, on SQL 2016 Enterprise, and we may be adding a (normal) field to a table. The table is included in (transactional) SQL Replication. We know that there are SQL commands to make changes to replicated tables, but can these be used with Dynamics NAV?…
-
Upload data from BC150 to SaaS
Good morning all. I am trying to upload my data from a BC150 to SaaS with all the tools that BC has. But I can not. I have some errors when trying to conect from SaaS to my local BBDD in SQL. By the look of things it is because of the server and DDBB. I use this format: SQLSERVERNAME\DATABASENAME and the diferent process…
-
Data synchronization with user feedback
Hello, On BC cloud I have to build a synchronization between companies. To keep it simple let's just say I have a Customer record that needs to be replicated in the other company that is triggered by an action "Sync". The tricky part is that this should tell the user whether it was successful or failed with an error…
-
Problem with printing large word documents
I have a problem with NAV 2018 and large word documents, build with it's own word layout. My customers wants to print about 5'000 pages from a report with word layout. The report runs a long time until the client crashes. There are only one small jpeg in the layout. Is it possible to print such large documents from NAV? Or…
-
Fail in running NAV BC on Prem & CRM on Prem integration
Hi all, Have an installation of Dyn CRM on Prem and BC 13 on Prem and I'm trying to configure the connection between the two of them to replicate data from one to the other. I'm configuring the D365 Connection Setup with user pass and everything goes through well, the standard table/field mappings are created, jobs are…
-
Does it make sense to create autotests as a customer?
Dear Experts, We have quite a module of customization, which runs on several databases in several countries. Same codebase, different setup. NAV2018 + AL Extensions How do I know whether it makes sense to create autotests? If yes, then should I use NAV TestTool, or maybe some other approaches like testing web-client using…
-
BC 15 webclient how to overview Report Dataset
When we had the RTC client we could get the Dataset for the report from Print Preview page -> About this report Who knows how to get the Report Dataset on Webclient when we don't have RTC anymore?
-
How to add a 'Invoice No' in Report
Hi All, I want to add the 'Invoice no.' in Customer/Item statistics report(report id - 10048). Please help me with this... Thanks in Advance, Jacob.A
-
Replace Text "Additional Fee" on (Issued) Reminders
Hi there, when creating reminders, there's an option to add additional fees per reminder level. The line that is being created for the Additional Fee (G/L Account line) has a standard text: "Additional Fee" (if i remember correctly). Is it possible to amend that standard text to be something like "Reminder fee"? I know…
-
Web services, get items by attributes
Hi guys, I am currently building an ecommerce for a customer. So i have 2 questions. 1. I want to get the items by an attribute, with web services. (Odata) 2. The response is limited to 1000, can i set it to unlimited? Best regards
-
How to export the data of a single client to xml
Hi guys, I'm new to the world of dynamics nav and I want to export the data of a single client in xml. I am studying with the 2015 version. Looking at the documentation there is an example code to export the clients to an xml file, but it exports all the clients. CustXmlFile.CREATE(TEMPORARYPATH + 'Customer.xml');…
-
NAV Performance - JetBrains DotTrace
Has anyone worked with JetBrains DotTrace to analyse the performance of CAL Code. I believe it was used in this Techdays Session (Example 1h13m) Thanks for your help.
-
Item template 'pop'
We want to use item templates, but not for number series. After the user selects NEW (item), we first need them to select the number series before an item template. We'd have too many templates if we did one for every number series/template combination. Is there a way to supress the template prompt without a modification?…
-
Problem with height of Part in a List page
Hello I have a page like this : A Page with PageType = List, containing a group of 3 fields and a repeater and at the end a part page (PageType = ListPart) the part page has to show lines that refer to the record selected in the list page Problem is that this part page has a height problem like here in this picture :…
-
(RESOLVED) How to call NAV SOAP Web Service from NAV (C/AL)
Is there any working method how to call NAV SOAP Webservice (published codeunit) from another NAV using C/AL (using codeunit 1290)? Even with 'contentType' and 'soapAction' modifications I can't pass method parameters - getting 'parameter ... is null' error.
-
How to know which table extends a TableExtension
Howdy. Good morning. I need a piece of code to know a tableextension which table extends. I have code for OnPremise with the table "NAV App Object Metadata" but in SaaS this table is not allowed. Does anyone know how can I achieve this for an App type Extension, not Internal? Thank you in advance.
-
NAV can't create invoices and cash receipts
Good day, We have the job queue that creates invoices and cash receipt for customers once receiving payments from the online payment system. This has been working perfectly but now it is not working though the job queue seems to be running but the automated invoices and receipts creation ends up with an error; The value of…
-
NAV database locking table: log
Hi All, I hope some1 can help. I was trying to log "database locking" system table, into another table, by using few events. However, I can´t make it populate any data. This should make event below to happen. T36.RESET; //T36.LOCKTABLE(TRUE); IF T36.GET(T36."Document Type"::Order,'myoder') THEN BEGIN T36."Sell-to…
-
Payment Reconciliation Journal Error Message: Open must have a value in Vendor Ledger Entry:
Hi All, I have a question, if an Invoice has been cancelled will it appear on Payment Reconciliation Journal? Also if a User has already Applied all the entries on the Payment Reconciliation Journal, is there a quick way to find the entry number/s giving the error?
-
WIP AC value not transferred into inventory GL account
I have created a new dB (BC365), uploaded the raw material inventory ( Rw materials inventory AC debit and Opening control AC credit) Inventory steup - Automatic cost posting - Never. I created a production order - Consume the raw material and then post the output successful. Then finished the production order. And run the…
-
Business central connect to GED Apps
Hi how can do to connect BC365 , to GED Solution web ,knowing that The BC365 Client publich in cloud .? what is the process and requirment procdure to builde and connect between BC365 NAV and GED solution , and another question it's my client need to poste vendor invoice ffrom GED Solution sending to BC365 when The Local…
-
400 Error 'Bad request' API integration
Hello All, Please help me to connect a API. I have written below code in Business central but getting 400 Error 'Bad request'. var Client: HttpClient; Content: HttpContent; ResponseMessage: HttpResponseMessage; dddc: HttpRequestMessage; Result: Text; JContent: JsonObject; JDetails: JsonObject; JLocations: JsonArray;…
-
Visible TAX objects after upgrade to 15DK
Hi all. After upgrade from BC14DK to BC15CU03 DK i got visible TAX objects and fields as VAT as well. All .app files (system, base, etc) for upgrade were taken from BC15DK folder.
-
MS Script Control 1.0 .NET
Hi everyone, Does anybody know if there is a .NET assembly equivalent to the MS Script Control 1.0. COM component? I need to map the ScriptControl.Language and ScriptControl.Eval methods to any equivalent .NET methods. I'd appreciate any suggestion. Thanks.
-
Support for IAS 17 and IFRS 16 in Dynamics 365 Business Central
Hi Can anyone advise if business central offers functionality to manage IFRS 16 in relation to new accounting requirements which came into force in Jan 2019 any advice appreciated thanks
-
An Attempt was made to load a program with an incorrect format
Hello, I'm using a DLL file build for x86 platform to operate an Epson fiscal printer but when the program execute the open port method an error is shown. I'll appreciate a little help with this issue.