-
How to provide adding data into new empty line in table without clicking "New"?
I have a card page from which user can enter values in field of table. My task is provide an ability for user enter data by one field (like this ) With my code (in the OnValidate trigger) user have to always click New button ( ) to enter the value in new record. I would like to provide next situation: when OnValidate…
-
How Can I change Size of field in a page also the color of caption in navision 2016.
I want to change height and width of a field in page how can i do this. secondly how to change caption color as there is a method to change color of values not caption
-
How to: Join Data Items to Define the Query Dataset in Microsoft Dynamics 365 Business Central MSDYN
Hi All Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset. Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset. As an … Continue reading…
-
can you filter table for closing entry?
Hello! I am doing something which includes excluding all closing entries from GL Entry table. Can someone help me, please?
-
use tax
can I use 'use tax in stead of credit memo to correct incorrect things
-
RDLC Report layout for report 1322 purchase order - Does anyone have a copy?
Does any one have a RDLC Purchase order Report layout they could send me, as the default Word one isnt great..... Kind rgds
-
job queue no rights to start the queue entries
hi, we just upgraded from NAV2015 to NAV2018. we get the error, the we have no rights to create or execute the planned tasks if we want to change the status of an entry from hold to ready. not even as superuser or windows admin. we are desperate ... is this a bug?
-
Docker New-NavContainer using external SQL server
Hi, I'm experimenting with NAVContainerHelper in Docker. I'm getting a docker image running of any NAV/BC version build or cu now. That's nice! But now I'm trying to get it running using a sql server instance and database outside of the container. I just want to update the parameters in the NAV service to do that, and…
-
Report designing
I modified a report named Simulation Order report.This report is used for displaying the details of Work Order. My client need some additional details in this report .they need to view all the bin details of each component item No under each work Order component Lines. I modified the report and getting the correct result…
-
Session expired when logging on
Hello, We are currently upgrading from NAV2017 to BC14 (CU8). On a handheld scanner (Datalogic with Android 6.0.1) we use the NAV app. This works fine in NAV2017, but with BC14 we immediately get the message "Sorry, your session expired. Please refresh to continue" after log in. The App is updated to version 2.6.9101…
-
Need to update blank field in a table
If the field is empty for today then I need to find the same field with yesterday date and increment the yesterday value and update the empty fileds today.
-
how to split getfilter into 2 dates
hi! I've got getfilter, which contains 2 dates from..to I need to get the first and second as date fields I tried everyhting but I couldn't work it out
-
D365 BC versions comparison matrix for developers (for on-premise)
Hi guys, Hope you are well. AFAIK, there is a big difference in development process for different versions of D365 BC (13, 14, 15) - C/SIDE was retired as well as C/AL, new classes were added etc. Does anyone maintain comparison matrix for developers for D365 BC on-premise? Or maybe any blog where I can find such an info?…
-
Timezone of Service User
Hi guys, quick question, does anybody know where the NST User gets its timezone from? It's obviously not the same that is set in the NST config. It's also not changed if you enter it in the User Personalization of the Service User. And maybe another question that someone can confirm. Are the timezone settings only applied…
-
Table lock issue after upgrade to the NAV business Central
Item Ledger Entry table is locked always . When we checked this no user is entering data to the system but system is locked. Inventory setup has already adjusted by ; * Automatic cost posting - No * Automatic Cost adjustment - Never Please help me ASAP.
-
Report called from search have different buttons
If I call the report 116 (Statement) from the object designer it is fine, I can print it in pdf, excel ... (1.), but if I call the report on the RTC's search box then it doesn't have print and preview button (2.). I want that when I call from RTC it should have the same 3 buttons.
-
Production order management
Hello, I’m planning production orders in NAV and have a question regarding it. We have setup and run time specified in routing of an item. If I run “Replan…” in production order management, I get following production plan for Item A: My question is: Which setting should I change that setup and rum time will be without time…
-
Extension "loses" connection to dll
I have created an extension where we are using WinSCP, through a default extension that we reference/have dependencies for. The winscp files have been added to a folder in the add-ins and everything has been running fine. Now we have extended some of the functionality in the extension. No change relateded to the Winscp,…
-
Wrongly Posted Invoice
Good day, NAV user has posted a Purchase Order (for Customer A) but mistakenly the invoice paid another Customer B. Now on settling payment for Customer A the invoice is missing since it has gone to Customer B. To correct the error, user posted a Credit Memo from customer B to Customer A which left a negative amount in…
-
Posting a Purchase Order with Partial Items
Good day, I have processed the purchase order with number of items of which the vendor would come and supply half of them. How do I receive these partial goods, in NAV, that I would later use the same purchase order to receive the rest? Thanks, Nagaboona.
-
How to Stop reservation from Purchase Order
Hi Everyone. I have a question about Item Reservation in the Sales Line. How to stop reserving Items in Sales Line from Purchase Order? We would like to reserve only if Item is in Stock in Inventory. Reservation is set as optional in Item Card, but still, the Sales Line Item is reserved from Purchase Order. How to Stop it?…
-
Print layout in reports in Microsoft Surface
Hi, Anyone knows how to resolve this problem? Printing layout on Microsoft Surface is all messed up. In another machines, it's fine but in Surface is very bad. Anyone knows how to solve?
-
Issue with Multiple Mail Attachments
Hi I have been playing around with the Email routines in NAV, specifically the Mail codeunit 397 and trying to send multiple attachments by Outlook. However, what seems to be a simple modification is being anything but! I have added a function which is based on the standard CreateAndSendMessage function, but accepts an…
-
OptionString in XML
I try to create a sales order using a standard web service. It works fine with items, but I cannot create sales lines that uses G/L Accounts. I write this in XML: <Sales_Order_Line> <Type>G/L Account</Type> <No>1485</No> <Description>Description</Description> <Quantity>1</Quantity> <Unit_Price>59</Unit_Price>…
-
Error in getting access token for azure key vault in business central?
Hello Everyone! I am trying to POST an HTTP request with different parameters in the body, but i am getting the message "oauth2 error AADSTS90014: The request body must contain the following parameter: 'grant_type' ". Through Postman i am able to get the access token, with the same parameters. I don't know what i am doing…
-
Merged GL entries
Hi, I have dilemma with customer requested modification to BC. In BC, GL Entries with same dimension set are combined into one gl entry. Now I'm requested to do a mod to BC with a purpose of not to combine gl entries. Rough Example --> Sales GL Account is 3000 Sales Invoice with two lines and with identical dimensions is…
-
SMTP Email without Server Internet
Hello Team, I need a help on the below scenario.It would be great if I get a solution. While I am sending mail from NAV 2013 I am getting this Error " The SMTP mail system returned the following error: "Failure sending mail. The remote name could not be resolved: 'smtpout.secureserver.net'"." In the above scenario My…
-
Adjust Cost Item Entries batch job (795) is taking long time
Adjust Cost Item Entries batch job (795) is taking more than weekend hours (38 hours) to execute and we cannot run this batch during working days due to table lock error?: Server Configuration Windows Server 2008 R2 Standard, Service Pack-1 Processor:- Intel(R) Xeon(R) CPU X5650 @ 2.67 GHz 2.67 GHz Installed Memory(RAM) :-…
-
Issue in Event
Dear Sir, In NAV 2016, there is an Event function called OnBeforePostItemJnlLine in Codeunit 22 Item Jnl.-Post Line. I am subscribing the same function in my custom codeunit & call the Codeunit 22 Item Jnl.-Post Line to Post something. It's working with a message "There is nothing to Post" & it does not clear the Page.…
-
Reverse G/L Entry From Code
Good morning, I've been trying to create a general ledger entry that would reverse the desired purchase transaction (or a part of transaction). All I really want to do is find the one general ledger entry and post it with negative amount, then post it again to another account. I'm using BC15 and the only event I found,…