-
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.…
-
Set new qty to ship and qty to invoice from new field
Hi am using business central,I have created a new field executed qty in sales line i want this qty to be used for shipment and invoice not quantity inserted. How can change to use my new field than use quantity
-
Certifcations available for MS Dynamics 365 Business Central
Hello, I want to know whether there are certifications available on Business Central (v14) for functional consultants.I have come across some forums whereby it is mentioned that improvements on Business Central keeps evolving and thus the contents of the certifications should be constantly updated. Thanks to let me know.…
-
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.
-
Incoming document factbox on sales return order
Hi all How to add incoming document fact box on sales return order. regards satish
-
Report printed in Folio format
Hi everyone, Is someone knows if there is a link between NAV and the printing property "Paper Size" ? Few days ago, reports in NAV has been printed in the Folio format for some users (not for all) and we have not idea what happened. Thanks, Michael.
-
Consuming web service in email
Hi, One of my clients wants that Navision(2016) will send their approval requests thru emails & end-users can able to take decision(Approve/Reject) from email body without accessing Navision client. Required details of the documents will be available in email body in row wise & user can be able to Approve or reject the…
-
only single item shows on purchase order of report?
Hi all , this is my second post about issue. i have created custom report for purchase order as it is multiple copies such as original,duplicate etc. on purchase order there are four items but report printing first item only . how i can get all item in line level of report thanks in advance
-
Send to excel incorrect translation
Hi, We have a nav2017 running with french translation. In the general entries page, everything is translated correctly. But when the page is sent to excel, all options fields is in English in excel. Anyone knows why? Jordi
-
Query on Sales Header (filter by customer)
Hi all, I created a simple query calculating for all customers the items and quantity bought. Expanded Type Data Source Name Method Type Method Group By 1 DataItem Item Ledger Entry <Item_Ledger_Entry> No 0 Column Item No. <Item_No> None Yes 0 Column Source No. <Source_No> None Yes 0 Column Quantity <Sum_Quantity> Totals…
-
How do I give a user access to the purch order archive table?
The departments menu does not appear in the design of the navigation pane?
-
Pick According to FEFO and reservations
Hi All I have a customer using "Directed Put-away and Pick","Pick According to FEFO" and "Require Shipment". They want to reserve a salesline to a specific LOT-No. But the pick does not care about that reservation - it picks according to FEFO no matter if the reservation is for another LOT. Is it true, that "Pick According…
-
BC 365 - Team Member permissions
Hello, I have a question about the Team member license for BC 365. Has the user with an team member license rights to an customized installed extension (App)? Kind regards,
-
Non-converted Value in G/L Register Report.
I am trying to tackle a problem I was assigned to solve; In BC when we create General Journals, we get an option to select a currency. If we select a currency other than the LCY of the System, let's say, LCY of the System is set to GBP, and while creating a Gen. Journal I select USD. After posting this Gen. Journal when we…
-
Insert new row in an existing Excelsheet
Hi, I want to add new rows in an existing excel template file, in an existing worksheet. The worksheet contains the headlines and i want wo add data in row 3 and the following. Is there a function in the excel buffer for this? thanks
-
Returning value when performing Odata operation(i'm using postman as test)
Hey, is it possible to return a value when a page is consumed as odata? i published a page as Odata with bunch of fields that can be used externally. The page creates a new customer, and it should return newly created customer number. However, the issues is that, when the action is perfomed, i get the query back as result.…
-
BC140 - bad performance of import via xmlport on SQL Azure (and very fast on local SQL Server)
Hi there, We are experiencing very bad performance of a xmlport that is used to import gen. ledger entries. The server and webclient (Business Central 140 - Spring release cu2) are running on a Azure VM, the dabase is on SQL Azure. I've created some files with different sizes. A small file (50k) takes about 15 seconds to…
-
Web client shows 2 reports when only one was modified
I modified the Inventory Valuation report using the development environment and now on the web client it shows 2 Inventory Valuation reports. One of them work as expected and the other just goes to an error page. I did previously copy the original to a new report I called Inventory Valuation2 but after I was done with the…
-
Deleted report still shows in NAV and Web Client
I recently created a 2nd report named Inventory Val2 to help practice for modifying an existing report in the NAV Development Environment. After all changes were done and copied to the original report(Inventory Valuation) I deleted the 2nd report. But now when I search in the NAV client or Web Client I see 2 Inventory…
-
Replace the warehouse shipment line while selecting the different record.
Hi all, I have created one new warehouse shipment. Here (Ribbon->Getsource Documents). I can able to select any record from the source document page(without considering the 'Destination no' field). If i try to insert another record, it has to delete/replace the first record with a new record in the warehouse shipment line.…
-
can we create Credit Memo on Partial Prepayment Invoice
Hi im new to nav, Can we credit memo the prepayment invoices partially or for a particular invoice can we post credit memo by clicking it. Thanks in advance,
-
Codeunit 5064 "Email Logging Dispatcher" - Stop deleting emails from unknown senders
Hello, what do I have to adjust in the codeunit 5064 "Email Logging Dispatcher" to achieve that the emails from unknown senders doesn't get deleted in the queue folder instead they get moved into another folder named "errors" like the emails from known senders?
-
Printing external excel file with multiple sheets
Is it possible to print all sheets from external excel file?
-
Data Matrix 2D Barcode
Dynamics NAV 2013 I'm trying to get a Data Matrix label printed (have got 2D QR Codes printing using the Mexico version of Nav mentioned somewhere on this forum). There are recommendations to use DataMatrix.net.dll as mentioned on https://forum.mibuso.com/discussion/comment/329727#Comment_329727. Once downloaded I've…
-
Are promoted actions not a thing in Business Central?
Are promoted actions not a thing in Business Central? Or rather, are they not shown in their own tab anymore, e.g. the "Home" tab. In NAV 2013 promoted actions on a role page where shown in their original group/tab, but also under a second group/tab, - the "Home" tab. In Business Central this doesn't seem to be the case.…
-
Business Central Design Mode - can't add field to role centre
Hi All, I'm having an issue adding a field to a role centre in design mode (and personalisation) as below: - I have another question also, is there a way to turn off customization mode for customer so they can't use it ever? Regards & Thanks Roddy
-
BC apps - your service is not ready yet, please try again in a short while
Hi all, anyone ever got this error message? it only appear if i opened using bc apps. use web browser no prob
-
Ledgers entry impact in Inventory valuation report through Job Module
Hi Experts, I have raised a Job sales Invoice through Job Module, with consuming that particular item, and the system generates a Negative impact in Value entries. after running the adjustment the cost item entries, all value moves to GL entries. but in Inventory valuation report the amount and quantity is getting Doubled,…
-
What are the consequences of unpublishing an extension after it has been uninstalled?
Hello, i'm trying to upgrade the prodcution DB in business central 365 cloud Verion from: 14.5.35970.0 ==> 15.0.36560.0. at the same time i have an installed extension with this old version, which i want also to upgrade it. in order to upgrade the Extension from old verion to a new one, i need to uninstall it, then…
-
ODATA - Request result sometimes in 400 error (with no body)
Hi guys, we have a non dynamics nav server, which is sending data to an Australien NAV 2017 ODATA Web Service. The request is sent with a ruby application and with httpparty 0.16 Sometimes we don't receive the data on nav side and they getting are 400 error with empty body (~10 % of the request have this error). If they…