-
Ask for options before open a page
Hi! I have a page that makes a lot of calculations, so I would like to ask the user for the start and end date before open the page. Something similar to the Request Page of the reports, but to run a page, not a report. Some idea? Some similar behaviour in standar NAV? I'm using NAV 2013 Lot of thanks
-
CreateBookAndOpenExcel function in DBC 365
Hi Folks - The function CreateBookAndOpenExcel is not supported in Extension development. Does anyone know any alternative solution for this issue. Many Thanks for your help. local procedure CreateExcelbook(); begin ExcelBuf.CreateBookAndOpenExcel('',Text012,'',COMPANYNAME,USERID); ERROR(''); end; ERROR The type or method…
-
Export to Excel - Business central 365 Wave 2
Hi folks - I have a processing only report with 2 data items and a procedure Makedatabody. I get the errors that Sales shipment header and Sales shipment line does not exist. Can anyone please let me know how do i refer to a field in 365 BC. Many..Many thanks for your help. Sales shipment header Sales Shipment Line…
-
Adjust Cost/Post Cost Posting Date Error
Hello, In my unmodified version of NAV 2018, my Inventory Setup is configured as follows: My General Ledger Setup is configured as follows: My User Setup is configured as follows: When I run the Post Invt. Cost to G/L - Test report, I receive the following: If I open up my User Setup to Allow Posting From 01/01/19, I do…
-
NAV2018 - Working on file system with different user
Hello experts, i have the following situation: the customer is migrating from NAV2009 to NAV2018. In the older version there are some functions that allow users to open folder (launching explorer) or navigate file system from dialog. The customer's IT have defined a large permission set on different folder in their system,…
-
how to HTTP request POST in AL ?
Hi All how do i do http request POST? actually i generate 1 xml file in for example C:\Test Folder\ and then i want to post this file to this API POST https://qekzvwip-40Xv44445s2mhtti.azure-api.net/api/invoices HTTP/1.1
Host: qekzvwip-40Xv44445s2mhtti.azure-api.net
Content-Type: application/json
Ocp-Apim-Subscription-Key:…
-
How can I use NAV2009 RTC without domain accounts?
I'm porting an old NAV 2009 installation to a new server (from Windows Server 2008 to Windows Server 2012). I installed NAV on the new server and restored the SQL Server database to a new SQL Server (2012) instance. On the old server we had the logins handled with domain accounts. The new server is not the domain however,…
-
Do I need to have a TO character for all FROM characters in CONVERTSTRING
NewString := CONVERTSTR(String, '()[]"&@%^_+=!~', ' '); I need to change any of the From characters to a space. If I have 14 from characters, do I need 14 to characters? I would prefer not to have a lot of spaces in the new string.
-
SMTP in BC365 Saas
Hi everyone, I'm trying to configure an o365 account (used as a maiol account also) into my BC365 Saas instance. I'm configuring like this: But when trying to send the confirmation e-mail, I get this error: I'm looking the different exchange configurations, but everything seem to be enabled. I'm trying to get quite…
-
Customer Statement Report calculate the number of pages per customer
Hi Is there any way in the Standard Statement report 1316 RDLC layout to determine the number of pages being printed for each customer? I need to display Page x of n on the header of the document thanks
-
How to Create a query using multiple periods?
I want to create a query where I can use more than one period in a row. For example: I want to show Item Ledger Entries for each item per month. If I add an other Dataitem the query doesn't work correctly. Can someone give me a hint? What my customer expects: Item No. - Description - Qty January - Qty February - etc.…
-
When trying to run a table in the development environment the following comes up...
The service principal name (delegation) configuration has been set incorrectly, server connect URL: net.tcp://"server path":7046/"Company"/Service".SPN Identity: "DynamicsNAV/"server path":7046" A call to SSPI failed, see inner exception.
-
Error in Report:A DotNet variable has not been instantiated. Attempting to call WinSCP.Session
Hi All I have created a Dot Net Variable with Name SessionOptions with type DotNet and SubType as WinSCP.SessionOptions.'WinSCPnet, Version=1.6.5.9925, Culture=neutral, PublicKeyToken=2271ec4a3c56d0bf' I have clear the Variable. I have also set the property Run on Client to Yes But still this error is coming. Please help
-
Why Copying records using function Ctrl+Shift+C taks very long time?
I am trying to copy entries from G/L entry table about 25000 records, and is taking about 1hour. Is it hardware problem? how to improve the performance?
-
Sharing the global variable between events in AL extension
Hi everyone, I've created two EventSubscribers in a codeunit and I would like to use the global variable for these EventSubscribers. The variable is define in first EventSubscriber but when code is working on second EventSubscriber. The variable is cleared. There is any to shared the global variable for each…
-
Import Excel Files From a Folder in FTP Site directly to NAV table.
Hi, I am trying to import Excel files which are located at a Folder from a FTP Site directly into NAV 2016 Table. Please Share your views.
-
Incoming document factbox on sales return order
Hi all How to add incoming document fact box on sales return order. regards satish
-
Pass value from form (header) to subform (lines)
I have a Header table; table 50108 "Production Time Log Header"
{ DataClassification = ToBeClassified; fields { field(50000; "Entry No"; Integer) { DataClassification = CustomerContent; } field(50002; "Production No."; Code[20]) { DataClassification = ToBeClassified; } field(50003; "Total"; Decimal) { FieldClass =…
-
error in Item table while selecting
The provided statistics stream is corrupt. Page Select must close. Can any one help me with this error when I am selecting item it is giving error in Purchase line entry warm regards Kris
-
Is there any way to hide a standard report from search box by extension?
Hello everyone, I am working on D365BC on-prem with extension. I would like to customize standard report So, I export the report as text file then convert it to AL. After I've published the extension. There are two reports in search box (a standard report and a new one). Is there any way to hide the old report from search…
-
Report printed in Folio format
Hi everyone, Is someone knows if there is a link between NAV and the printing property "Paper Size" ? Few days ago, reports in NAV has been printed in the Folio format for some users (not for all) and we have not idea what happened. Thanks, Michael.
-
Consuming web service in email
Hi, One of my clients wants that Navision(2016) will send their approval requests thru emails & end-users can able to take decision(Approve/Reject) from email body without accessing Navision client. Required details of the documents will be available in email body in row wise & user can be able to Approve or reject the…
-
How to integrate NAV with Sage
Hi All, I have to investigate and resolve issues of salary/employee costs calculation inside NAV 2013 R2 database and Sage. User insert data in NAV so the integration should be somehow designed to transfer data from NAV to Sage (client version 15x). I do not know anything about Sage, but I do have a lot experiences with…
-
Unable to apply filter on Virtual Date Table
Hi, We are facing a problem in NAV 2015 CU 8. Your help will be much appreciated. I don’t know, it is due to some code bug or some NST bug. But sometime, NAV is not able to apply filter out data on the Date Table. It is always picking first entry from Date Table. Rest virtual tables are working fine. And the common thing…
-
only single item shows on purchase order of report?
Hi all , this is my second post about issue. i have created custom report for purchase order as it is multiple copies such as original,duplicate etc. on purchase order there are four items but report printing first item only . how i can get all item in line level of report thanks in advance
-
Send to excel incorrect translation
Hi, We have a nav2017 running with french translation. In the general entries page, everything is translated correctly. But when the page is sent to excel, all options fields is in English in excel. Anyone knows why? Jordi
-
Nav 2009 - Webservice
Hallo, I enabled the webservice for an Nav 2009 client. When I go to http://localhost:7047/DynamicsNAV/WS/Services the webservice give me: But when I go to http://localhost:7047/DynamicsNAV/WS/Test/Services the webservice give me an HTTP 500 internal service Error. And the company Test (capital) does exists. Can someone…
-
Query on Sales Header (filter by customer)
Hi all, I created a simple query calculating for all customers the items and quantity bought. Expanded Type Data Source Name Method Type Method Group By 1 DataItem Item Ledger Entry <Item_Ledger_Entry> No 0 Column Item No. <Item_No> None Yes 0 Column Source No. <Source_No> None Yes 0 Column Quantity <Sum_Quantity> Totals…
-
Pallet Maker
Anyone knows if exist an add-on or 3rd party software for Navison BC to make an optimize pallet? example: I sell 200 products, those products has different packages size, Pack1: 10X10X10 , Pack2: 15X10X5 , Pack?: ??X??X??. I would like to know how many Pallet do I need and optimize how to build the pallet, according…
-
Multiple line of items of PO on the report not printing?
Hi all, I have to create custom Purchase order report in which multiple copies of PO report. I have done that using page loop and copy loop but one poblem is PO having multiple item say 4 item lines then report only showing first line item any solution so i get all four items printed on reportDocumentation() OnInitReport()…