-
SQL Error when copying a company - Execution Timeout Expired
Hi, Everyone. I would like to seek help on the issue I'm experiencing when trying to make a copy of our Live company. I keep on getting the error below. The following SQL error was unexpected: Execution Timout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I've…
-
Check report formatting
Hello there. As you know if the check is printing more than 10 lines of payments (lets say 15) , the first page will be a voided check with 10 lines and the next page with be the check with the remaining 5 lines. Client would like a new report to print to replace the first page that is printing in check stock paper to save…
-
Data Exch import: get a substring of XML value
Hi Experts, I have an XML file with very long descriptions in one of the node. I would like to take only first 10 characters from the node. Is it possible to do somehow with XPath? I tried /CustData/Line/Item/substring(ItemDescription,1,10) as a "Path" in Column Definition, but this fails with error "expression must…
-
Pick Qty. is always 0 Upon Creating Warehouse Shipment
Hi All, I'm Having trouble in creating a pick in my Current Warehouse shipment Document, the Error I receive is "Nothing to Handle" after check for several hours I noticed that the Pick Qty. in my Current Warehouse Shipment Document is 0. ( I don't know if this is the cause, but literally Speaking and based on my hunches,…
-
TestPages - Create Customer with OpenNew
Hi All I'm writing and AL extension (on-prem). I'm trying to create a customer (for now I want it committed, so I set test isolation to "Disabled") I'm calling the following from an action button. My No series is set for Default and Manual nos is disabled codeunit 50006 ClesenTestRunnerCodeUnit
{ Subtype = TestRunner;…
-
End user access to test tool and libraries
Hi All We are an end user and are writing our own AL extensions (365 BC 13 on-prem). I want to use the MS test tool and test libs. I can't find the test tool and if I try to access a codeunit from the test library, I get an error: You do not have the following permissions on CodeUnit Library - Sales: Execute I thought I…
-
How to production Journal Should Exactly Same As consume quantity?
Hi Experts In Sub contracting process when Quantity consume from Delivery Challan and receive Sob-contracting order.and in production journal enter output quantity. Now I need output quantity On production Journal Should Exactly Same enter by user As consume quantity at subcontracting how to Achive this ?what restriction…
-
No Test Tool BC130 on prem
Hi All Working on an extension on on prem install I've imported the following from Dynamics.365.BC.33838.NA.DVD\TestToolKit * CALTestRunner * CALTestCodeunits.US * CALTestLibraries.US When I search for "Test Tool" nothing shows up I can run my test code units and pages OK from my own test runner, but how do I get the MS…
-
NAV 2018 has no Sales Lead Time per item?!
To my knowledge, NAV 2018 can't create a Sales Lead Time per item. Only when you use the production module is it possible. If this is true, are there any workarounds or add-ons which could resolve this? When entering a new Sales Order, we now have to remember manually which (assembly) Item has which sales lead time. We…
-
Web Services REST API
Hi Experts, I'm newbie in web service. If I got 10 Items in Business Central and I want to use loop to calling httpClient.POST for 10 times. Is possible? I have successful to POST first call, but started 2nd calling is failed. Do you have any suggestion? Thanks.
-
Error while accessing 365BC NAV RTC Client, help
Tóm tắt luận văn thạc sĩ về quản trị vốn luân chuyển Trong bài viết sau đây Luận Văn 24 xin chia sẻ đến bạn nội dung tóm tắt luận văn thạc sĩ về quản trị vốn luân chuyển. Nếu bạn không có thời gian để hoàn thiện bài luận văn của mình, bạn có thể tham khảo dịch vụ làm luận văn thuê của chúng tôi tại đây: viết thuê luân văn…
-
Rebuild Dimension Set Entry Table
Hi, does anyone have a report to hand that can rebuild the records in the dimension set entry table based on the dimension set entry tree node table. The tree node table is correct but the set entry table has been corrupted. Regards
-
Viewing archived purchase orders
We have recently started to archive Purchase orders once they have been invoiced. Unfortunately now when we want to look at a previous order for reference the archived list shows all the versions of the purchase order. Is there a way that we can look at old purchase orders and only see the latest version, similar to how we…
-
The type 'UNDEF' is not defined for the function during upgrade from 2009 to 2013
Hi, I'm new here and this is my first question, but I already found a lot of helpful discussions here. However, during an upgrade process from NAV 2009 R2 to NAV 2013 (RTM) we came across this error message: 'The type 'UNDEF' is not defined for the function'. I have done a thorough search on the internet (most of on…
-
Mail Triggering through workflow for approval process
hi i want o know how can we send mails to approver id's when we send approval request for purchase order in navision. waiting for the response. its functionally we can do or through code we have to do?
-
Merging duplicate records into one in excel sheet report in navision
Hi Experts, i want to Merging duplicate records into one in excel sheet report. in excel attachment if you see one purchase order have same SKU code with two lines..now i want to show that purchase order in one line by combining both lines. please help me out
-
Field selection
Hello I am wondering if they are a way to use something like Mouse over or field selected in nav? what I am trying to do is make a new functionality to copy the selected value on an x column of course those values are not the key values any idea, so when you click copy for example you get the value selected
-
Jet Reports NAV Cash Flow
Hello, Could anybody help with a Cash Flow example for NAV Jet Reports. There is an example on the Jet Reports website but it could not be downloaded for Jet Reports Basic that I'm trying to use to learn it for now. Thanks
-
Lanham EDI materials
Hello, Could anybody help with some basic materials for Lanham EDI setup for NAV 2013 R2 or any RTC NAV as it could be all the same or similar. Thanks
-
How to Debug in VSCode in BC130 on Prem
Hi All I'm using BC130 and RTC on prem. Here's my launch.json { "version": "0.2.0", "configurations": [ { "type": "al", "request": "launch", "name": "Dev", "server": "http://10.10.0.24:13069", "serverInstance": "Dev", "authentication": "Windows", "startupObjectId": 22, "startupObjectType": "Page", "breakOnError": true,…
-
Attach multiple files - Send to Email - Business Central
I'm using NAV Send Email on Sales Order, now how can we attach mulpile files here. the files stored in Media Type on Document, Using File Management BLOBExport function able to download file but needs to attach on mail automatically?
-
FlowFilter with NOT Equal to Sign
Hi, My system is getting hanged while applying filter with <> Sign on Chart of Account List Page in NAV 2016. Please look into the attached screen shot for details. What is the reason? Thank you, navuser1
-
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
-
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 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:
-
Ls NAV - Offer if an item costs over a specific amount
Hi everyone! We want to setup a special offer in Ls Nav. If a customer buy any item from a specific Item Category, and this item costs more than a specific amount (e.g. 50€) we have discount amount -5€ (for example). So, we want something like "Amount to trigger" setting but not for the total amount. Only for the specific…
-
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:…
-
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?
-
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…
-
Business Central AL , disable Factobox Calculation
Hi all, everytime I Open a customer it's a pain it's very slow, I already disable facboxes but keep calculation those fields. exist any way to stop that calculation behind ? Thank you,