-
Dynamics 365 sales connection
Hi I have Dynamics 365 BC and CE both on premise only. Still I did not buy SSL Hi Necdet, I am working on on-premise installation of both BC and CE. Still I did not get SSL certificate , so I am using http protocol only. I am getting the following error. please help warm Regards Kris
-
Inventory valuation report with detail transaction
Hello everyone, As I know the Inventory Valuation (R1001) show data per item. However, I need the report like inventory valuation report but show detail transaction also. There is any standard report that serve my requirement? Thank you.
-
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?
-
Move a table from an extension to an other
Hi everyone (excuse me for my bad english), Someone told me that he cannot move a table created in an extension to an other because GUID of the extension was directly save into the parameters of the table I'd not the chance to test it by myself already, but I wonder if someone here has have to do that in the past and if he…
-
Can filter the dataitem just load specific value in report
Hi Guys, I have a NAV report as below: - Dataitem is a table has more records many types: 1, 2, 3... - Need to create a report just load the type = 1 when openting the report. Note: Do not allow using the Request page. Could I do it with dataitem not use the request page? Please give me some advices. Thanks,
-
Assign a value from Gen Business Posting Group Table.
I have got Gen Bus. Posting Group field showing on the subform of Sales Order. This Subform is also showing Location Code for the Line. I am attempting to write a logic as such that if the User selects Location Code as DROPSHIP, the Gen Bus. Posting Group should be LOCAL-DROPSHIP. LOCAL-DROPSHIP is a record in the Gen.…
-
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…
-
Powershell Publish APP
Is there another way then using the Powerfull Powershell to Publish developed APP's (VSC - AL) to the NAV Folders ? Problem now is the needed accessrights for using Powershell and the possible danger with using Powershell
-
Technical Upgrade to BC15 possible with BC13 Objects?
Hello, one of our customers had the brilliant Idea, that they want to do a technical upgrade to BC15. And while they have a BC14.5 Client, the objects in the database are actually BC13! Is it actually possible to do a technical upgrade with that constellation? I'm beginning to believe not since while trying it, I'm…
-
Consuming web API from C/AL
Found very helpful post and figure out the basic steps, thank you for you attention :) https://www.kauffmann.nl/2015/11/26/web-services-examples-part-1-the-basic-pattern/
-
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.
-
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…
-
Error during Processing-Only Report trough Table Lock
Hi, we use in a processing-only report the item table as data-item. we iterate over the results and write some data in other tables. from item table we read only. there are no write actions for the item table. some time the report failed, because of a table lock of the item table. why happens this error? the report reads…
-
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…
-
How to SETFILTER in descending order
can someone guide me on how I can filter a record in descending order ? thanks in advance
-
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…
-
XMLPort in DBC on Premise
Hi folks - I created a XMLPort in AL to import gen. journal lines. I complied and created the package without any errors. Now when I go to Web client and try to search my XMLport I cannot find the object. Does anyone know how to search the XMLport. Many thanks for your help. Thanks RJ.
-
To cancel or correct a posted sales invoice
Dear all, I try to cancel or correct a posted sales invoice but I cannot find the actions 'cancel' nor 'correct'. I have tried to customise ribbon and add the action 'Correct' to 'Show actions in this order' under Home or Actions. But I still cannot find them on the action. I tried to change the user personalisation to…
-
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…
-
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 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,…
-
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.…
-
Problem with reconnection of NAV2016 client causing it's crash
Hello, I'm facing a problem with reconnecting to the NAV server after the session timeout. Problem description: After upgrading from NAV2009 to NAV2016, we have encountered a problem, which causes some issues for the users. In NAV2009 if the client timed out, it was able to connect to the server and restore the session.…
-
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 =…
-
Communication Component - waiting for respond if service is down
Hello everyone. I'm trying to understand where my problem is. Most of the time the code is working just fine, but sometimes it is waiting to be respond for a long-long time. Sometimes the service, from which I'm waiting a respond is crushed. Is there any way to find out, that it crushed and don't wait for it? Is there any…
-
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
-
Release Wave 2 sandbox - cannot connect
Hi Experts, I have create the new project from template. When I hit F5 it asks me which sandbox version I want to connect, I select "4.0 Release Wave 2. " It tries to download symbols but cannot. I can connect when I create another project and select "3.0 Spring Update" It seems I do not have enough rights for this, should…
-
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
-
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.