-
Not able to Scan a barcode in RDLC report
Hi All, I have designed a report in NAV2018. It used to show the picking lines based on the shipment no and Pick no. Now our need is to scan the shipment no and Pick no. Please see the sample screenshot(how my report header look like) I have made the textbox to show the shipment no and pick no separately with barcode…
-
Named User Licence for Partner / Administrator
Hi mibuso community, could someone please explain me how you manage the user accounts for system administrators and Microsoft Partner access in BC with the named user modell? As I understood the licencing guide, every physical person needs a separate licence now. So if my Microsoft Partner that supports our BC has a team…
-
XRec Values = rec Values in Modify Trigger
Hi, it seem i have found a bug with the XRec. Please confirm me or correct me. :D Vendor.INSERT(TRUE);Vendor.Name := 'Name 1';Vendor.MODIFY(TRUE); After this piece of Code in the Vendor - OnModify - Trigger xRec.Name is equal to Rec.Name. Is that correct or do I something wrong? Should it be so? I tested in NAV2013…
-
Change serial number for reservation entries
Hi everyone! Could you please recommend me the standard objects and functions, how to change through code the serial number for output of production order, if it is already reserved. If it is not reserved I discovered something like this: Thanks
-
[Solved] Adding Word content from a blob to a Word Report Layout
Hi all, I have a question not entirely dissimilar to this one. Background Information We have the option to store equipment configuration option specs in a Word document and attach it as a blob to that configuration option record. These specs contained text, tables and/or pictures, all in one. In the "old days" (pre-Word…
-
Dynamics NAV 2017 Office.dll is being randomly deleted on some user's machines
To email out of Dynamics NAV 2017, the Office dll is located in the folder: c:\Windows\assembly\GAC_MSIL\office\15.0.0.0__71e9bce111e9429c. The Office dll is the only file in the folder. In the last few days, for some, but not all users, the entire 15.0.0.0__71e9bce111e9429c folder is being deleted along with the Office…
-
How to import custom report back into OnPrem version
I have exported out the 10075 Sales Order report as report 50100, converted it to AL and published it via Visual Studio Code. It is working as desired. How do I now import it back into the OnPrem dev environment so that it shows up with the rest of my report objects? Thanks...
-
How to write JSON file in multiple records?
Hi Experts, May i know that how to write the AL code to generate output below? Clear(ItemJsonObj);
ItemJsonObj.Add('name', 'Item ABC');
ItemJsonObj.Add('name2', 'Test');
ItemJsonObj.Add('vendor', 'XYZ Ptd');
ItemJsonObj.Add('item_categorty', 'Test'); I don't know to code for multiple variants. Anyone, could you help me…
-
Run cmd line as admin
Hi Expert, Am trying to run net stop && net start for restarting NavInstance but I always encountered error "Access is Denied". Does anyone tried doing this successfully? Here are my codes: Process := Process.Process; Process.StartInfo.UseShellExecute := FALSE; Process.StartInfo.FileName := 'cmd.exe';…
-
How do i add a file preview
Hello mibuso community, as the title says, im trying to find out if there is a free Control AddIn that allows someone to preview a file like pdf, docx, txt, etc.. on a page as a factbox. heres an example:
-
Dealing with Amazon MP Date Formats
An Amazon Marketplace VAT Calculation report no matter in what language you download it, lists dates as "30-Jan-2020 UTC" which cannot possibly be EVALUATED into a NAV 2015 Date or Datetime in a German settings computer. I suppose I have to do string processing with the month names in a CASE statement and all that. Just…
-
Unapplying Customer Ledger Entries
Hi, I am trying to unapply a Customer Ledger Entry in a company which has the Additional Reporting Currency populated. However, I am receiving an error "You cannot unapply the entry with the posting date %1, because the exchange rate for the additional reporting currency has been changed." Basically there is a check in the…
-
How to Filter Tokens in Microsoft Dynamics 365 Business Central MSDYN365BC
If your customer is using complex filter in List page and wants to save the Filter of list page and use the Filter Frequently for all the related pages then we can use Filter Token. In the client, when filtering lists using the filter pane, users can enter filter tokens, which are special words that … Continue reading How…
-
GRN reversal
Is it possible to reverse a posted purchase receipt? The amount on the GRN differs from the posted purchase invoice. Please assist.
-
JavaScript Error in 365 BC WebClient
Hi! i'm new in connecting JavaScript and AL, so I hope you can help me: i wrote a little JavaScript/ HTML CardPage Connection to viaualize some data. So this is my Code, it's working perfect in my SandBox, but in Production Enviroment i get the Error: Cannot set property 'innerHTML' of null. So my major question to you is:…
-
BC 14 Communication with the server failed, and the content cannot be displayed - custom binding
Hello, Ive installed BC 14 update 09 recently, server on one macine, clients on the other. When Im accessing webserver on the server machine through default http://localhost:8080/BC140 everything works fine. When trying to access through added binding for the site http://domainname/BC140 I'm receiving error given in the…
-
Data upgrade to Business Central Cloud
Hi all, What tools/options do we have when we want to upgrade data to BC15 cloud from previous version of BC onprem? And how we actually do that data upgrade? Thanks, Stefan
-
Auto selection of item from that lotNo,which has expiration date near during creating sales order.
Hi Everyone, I am creating sales order, so i need to select in sales line item from the LotNo which will expire first[ie. which LotNo 'expiration date is near']. It should be automatic. How can i proceed this; whether i should try with codeunit or should create a button in sales order page. eg. ItemNo LotNo Expiration-Date…
-
Reports assigned on RC
Dear All Is there any table holds records of reports assigned to each RC. Report settings list is not helping me because some reports are attached in RC without entry in report settings page. Going to each Role Center design and pulling from the property list is taking lot of time due to large number of RC pages. Kindly…
-
getting error during sending mail through SMTP.
Hi Everyone, i am sending mail through smtp in server, its working fine but when i am sending through local machine its showing error. like: the temporary file does not exist. what should i do for temporary path so that from both server or local machine take the path from server only. Thanks in advance, Mani.
-
How can i change amount in words for example one lakh four thousand -> one hundred and four thousand
Nav 2016 - How can i change amount in words for example one lakh four thousand -> one hundred and four thousand
-
Fix dynamic header in RDLC report
So, I am trying to fix a report and keep running into a strange situation. This report prints multiple Sales Order Confirmations from the Sales Order List. On this report there is a textbox for a field of concatenated comments on the order. The initial problem was if the textbox spanned more than a page, the header data…
-
ABA ROUTING NUMBER MOD 10 USA
Hi whow work with checkdigit routing naumber as MOD 10 using navision 2013 or NAV... , can you please put the code on comment Thank you
-
Windows PowerShell ISE - New-NAVCRMTable
Hi people, i would like to execute this script by PowerShell: New-NAVCRMTable –CRMServerMyOrg.Crm4.Dynamics.Com –EntityLogicalName systemuser,campaign –ObjectId 5340,50001 –Name “CRM Systemuser”,“CRM Campaign” –OutputPath c:\CRMObjects but it can not find cmlet New-NAVCRMTable. Any suggestion? I imagine i have to import a…
-
Field #99 VAT Base Amount in Sales Shipment Line
can anyone tell me in which cases field #99 of table 111 (sales shipment line) is valued?
-
It is possible to hide "Clear Filter" action on List page?
I want to hide "Clear Filter" action. How can I do this?
-
BC15 - more than 5 decimal places for a currency
Hi guys, we've come across a first large issue with the newest version of BC. I need to set a currency to operate with 8 decimal places (Bitcoin). So I did the usual trick with "General Ledger Setup"."Amount Decimal Places" and "General Ledger Setup"."Amount Rounding Precision" in code, which was successfully set to 2:8.…
-
NAV 2018 BC - CueGroup number showing 999+ instead of actual number
Hello Everyone, We have a user who would like to see the actual number of current Released Prod. Orders instead of the "999+" number he is seeing. Is there a way to change that to display? I see the page is on 9038 and the field is set but I don't see anywhere you can change the format. Thanks
-
Generate Empty Row
Hi, i'm building a report with Sales Invoice Header as a parent dataset and Sales Invoice Line as child dataset. I want the report to generate 10 rows before page break. 1st. If the records per document no in sales line is less than 10 records, for example only 6 records, then it will generate 4 empty rows. 2nd. If the…
-
Issue with filter groups when inserting new record
Dear Community, If certain filters are applied (e.g. by a view or a link) and the user creates a new record, then the fields affected by the filter are filled automatically. So far so good. More specifically, the following case is at issue: The user creates an extended text for an existing item. He opens the extended texts…