-
Unable to Run Batch sales Posting (Report 297) using Job Queue
I want to batch post sales invoices for which I am using Report 297. which is working fine if run the report manually. However, when I schedule the report 297 to run through Job queue, it shows successful in the Job queue logs but doesn't post the unposted invoice. NAS scheduler is working for other reports and codeunits…
-
Data Exchange Transformation Rule
Hello All, Setting up a Data Exchange Definition two transformation rules do not seem to work. Initially I want to remove - from the Bank Account Sort Code for example 20-55-77 should be set to 205577. Please can someone review the setup and give any suggestions to correct it. When I do a Test on the transformation rule it…
-
How to add new Custom Module in Business Central.
Dear All, Can some one please explain me how add custom module in Business Central.
-
cant open my database error showing is "this file is not a database".. dynamics nav 2009 r2.
Hello, Recently i lost my database and later was able to recover it and restore it back to its original file location. Since then i have been trying to open the database file but i get this error message "this file is not a database". The file recovered is a .fdb file. I have also tried creating a new database but i still…
-
NAV BC Planning Worksheet Page (99000852) - Column Sorting
Hi Everyone, Is there a properties field where I can allow column sorting for the user so when they click on the column it will sort? It was by default in NAV 2013 and now it seems users can't sort on this and other pages. Thank you
-
[NAV 2017] ODATA Web Service - POST Json Body with root
Hello community, I have a problem with above topic. I published a simple page as ODATA Web Service. If I test the web service with postman it works with a simple JSON body as POST statement: { "Field1":"Value1", "Field2":"Value2" } But if I change the JSON body to the following, it don't work: { "JSONBodyRoot" [ {…
-
Business Central 14 upgrade to 16.2, error during upgrade.
Hey I'm trying to upgrade a BC 14 to BC 16.2 and got stuck at the process, where i need to sync the base application. I am following the steps in "https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-unmodified-application-v14-v16". When I run this command below: Sync-NAVApp…
-
Microsoft Dynamics 365 Business Central On-premises on Windows 10 Home
Hi, Is Microsoft Dynamics 365 Business Central On-premises (demo installation) compitable with Windows 10 Home ? Kindly inform. Rgds, navuser1
-
Txt2Al Conversion Tool --tableDataOnly parameter
In this page txt2al there are instructions for using the txt2al tool with the tabledataonly parameter. Unfortunately, this parameter is not available in any version of BC14 and in subsequent versions the tool is not available. Where am I wrong?
-
Dynamics 365 for Smart Cities
Hi, Greetings of the day. Visiting Mibuso after longgg time. Recently I have seen videos of Microsoft Dynamics 365 for Field Service. Is that an add-on on top of Microsoft Dynamics 365 (Higher version of Ax)? Does this product have other modules of ERP, like Financial Management, Sales, Purchase, Project Management,…
-
BC 365 SOAP web service timeout
Hello, Can anybody tell me how can i limit soap web service timeout BC 365? All i can see is OData or Rest service timeout. i have published SOAP web service which is successfully consumed externaly, but sometimes the web service that calls my web service doesn't receive any response after 60sec and it generates failure…
-
How to apply SSL in Four-Tier Architecture
Hi All, I installes the BC14 as described in the below blog: https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--installing-the-microsoft-dynamics-nav-web-server-components-on-three-computers Server1 - SQL Server2 - NST Server3 - IIS, Web Server Client - Browser Client All are working well with windows…
-
BC on-premise - ISV solution - new version notification
We are an ISV with a solution for NAV/BC. With the more rapid release schedule of BC, we find ourselves providing more frequent releases of our solution. Up to this point, new releases involved manually contacting customers via email, but we'd like to streamline this process and provide information about new releases of…
-
Copy posted invoice to Sales Invoice Diffrent Debitor with dynamics BC on Prem
Hello I wander how to code (subscribe to over write) the Copy posted invoice to a Sales Invoice from different debtor without recalculating the linces, the description field should not be overwritten by the default value. incloude header = false Thank you Rgs. Firas
-
Experiences with Workarounds for Mixed Keys
Hello everybody, in AL there is the problem that you can only create keys in TableExtensions with fields from the TableExtension itself. It is therefore not possible to use fields from the original table in a new key of the TableExtension, e.g. in a new key of a TableExtension that extends the Table Item, you cannot use…
-
Prepayments:I deleted 2 pre-payment invoices and now cannot change anything in the original order
I am trying to understand the functionality. I am stuck with this. I am on the demo version of NAV 2013 R2 * Create new order, 100% prepayment on header * Enter one item line (bicycle), qty=1, create a prepayment invoice for 4000. * Re-open the sales order * Update qty to 2, create a second prepayment invoice (another 4K)…
-
REPORTFORMAT::Html crashes Windows Client
I just installed a new BC 13.18 and have run into a weird problem. When I try to email the statement on a customer the client crashes with only an ArgumentOutofRange error in the event viewer. I have debugged it down into cu 8800 where we try to create a HTML file using REPORT.SAVEAS that crashes the system. I have made a…
-
OnPremise region selection, show wrong decimal separator (comma instead of point)
Hi, I've a BC16.1 onPrem installation. Where can I change the regional settings to have a DOT instead of a COMMA in my decimal separator? It looks like this is managed on the serverside (NST or IIS) - unfortunately, Microsoft decided to have a , for the swiss-French region- I changed it on the server but maybe only for my…
-
NAV 2017 - Prevent NAV from converting a backslash to a CRLF
Hi everybody, Is somwbody knows how to prevent NAV from converting a backslash to a CRLF ? I created a we service that return a JSON as a text and I apply a Json.Encode(myJsonText) to escape all the special characters. The problem is that the Json escape the special characters by adding a backslash and in place of return…
-
How to import all type of files in a page in business central
Hi i'm new to nav , how we want to import files in page by clicking action or assist button of a field in business central Thanks in advance.
-
convert time to decimal Codeunit
I want this date to give me any date instead of today, how to change this date . DateTimeToDecimal(TODAY,TIME,'UTC'); LOCAL DateTimeToDecimal(date : Date;time : Time;timeZoneCode : Code[10]) decimalDate : Decimal IF (date = 0D) THEN EXIT(0); IF time = 0T THEN EXIT((date-01010000D) * 86.4 - L_TZDiff*3.6) ELSE…
-
How to convert Date to decimal codeunit
I want this date to give me any date instead of today, how to change this date: It's my date DateTimeToDecimal(TODAY,TIME,'UTC'); LOCAL DateTimeToDecimal(date : Date;time : Time;timeZoneCode : Code[10]) decimalDate : Decimal IF (date = 0D) THEN EXIT(0); IF time = 0T THEN EXIT((date-01010000D) * 86.4 - L_TZDiff*3.6) ELSE…
-
How to set the Accounting Periods for the inventory stock not at the last day of month.
My NAV ERP system use the monthly weighted average cost. Usually, we will inventory stock at the last day of month and create the next fiscal period. if i want to inventory stock not at the last day of month, how could i set the Accounting Periods for the inventory stock not at the last day of month?
-
Why Microsoft Dynamics 365 April 19 updates could be the best cloud-based Business Software Yet ?
Hi guys, do you have any insights on Dynamics 365 Business April 19 updates ? I would like to share our blog by on this topic, I hope you will find this useful: https://karyatech.com/blog/microsoft-dynamics-365/why-microsoft-dynamics-365-april-19-update-could-be-the-best-cloud-based-business-software-yet-2/
-
Configure Live Metrics from Azure Application Insights
**Apologies if this is in the wrong category** Hello, I'm trying to connecting application insights to my SaaS BC server and take advantage of the live metrics. I was hoping someone has done this in the past and would be able to give some advice. I've never messed with the actual code of BC so Im not sure if these links…
-
Internal error 6 occurred in module 11. Contact your system administrator.
Dear Friends, I am getting the error "Internal error 6 occurred in module 11. Contact your system administrator." when I close the NAV 2019 session over RDweb. This is not happening regularly but happening occasionally. Did anyone come across this error, if yes, could you please let me know the reason for this error and…
-
NAV 2016 Error: "A profile with ID 'Windows' could not be found."
Attempting to login to a NAV 2016 instance, via OAuth: Can't find any help on the internet with this one. Thanks.
-
Create xml signature in a Secure Envelope in NAV2017
Hi. I would like to create an xml file, and in the Signature there is a tag called DigestValue. The content of this file is calculated based on Method in the feild DigestMethod. My problem is that I cannot find a description of how to calculate the content of DigestValue. Thankful if anybody could point me in the correct…
-
Cash Receipt With Different Customer Name
Good day, Our NAV system is integrated with an online payment system that exports customer payment transactions into NAV. In turn NAV would automatically generate invoices and cash receipts for our customers. However, there is something wrong since one of our customer's cash receipt is generated with a different name (NAV…
-
I want to ignore thousand separator from RecRef filed.
my code is this. IF (TableID = 271) AND (BankMapRec."Field No." = 17) THEN IF EVALUATE(testDecimal,FORMAT(RecField)) THEN BEGIN RecField.VALUE(FORMAT(ABS(testDecimal),0,9)); But this is not going correctly. Still appear thosusand thousand separator. what should I do?