Microsoft Business Solutions online community

Hello all, I have the following question. When I do warehouse shipment and put away is created, by what logic is the bin code defined on the line where the action type is place? Does it depend on some setup?

Is there a we can identify if BC is opened on tablet on on tablet view?

I Have a problem about my filter, i want filter to posting date in same year but different month, like this, if i put the filter range 2023/04/1..2023/04/31 for my filter field show the data about the range, but my code doesnt work, he show the data form my filter untill current month. i wont if i set the filter range the…

I try to add a new function AutoFilter to ExcelBuffer (370). attempt (without succes): XlWrkBk := XlApp.ActiveWorkbook; XlWrkSht := XlWrkBk.ActiveSheet; XlWrkSht.AutoFilter; Anyone ever written something similar and can help me out? Thanks in advance!!!

Hi guys, when opening the Sales Order Page (9305) the data are shown after 11 seconds. While analysing the performance, I figured out, that the subpage "Incoming Doc. Attach. FactBox" causes these problems. It is strange that this is not always the case. The same fact box sometimes causes this problem also when opening…

I'm trying to modify the Send Email "CC" field in Posted Sales Invoice page to populate the value of the custom email fields(Email 2 and Email 3) that I have in the Customer Card I have found the following event to subscribe to in order to modify those fields (To, CC, or BCC) but I encountered an issue when they have a…

i have created a table with fields id,name,roll no,age id name rollno age 1 A 1 20 2 b 2 20 3 c 1 20 i will create a actiuon called unique now i have to count unique records in roll no field like it should show message after clicking on action unique then it should show "No of unique records is 2"

Three email fields have been created, and I want to take all those emails from all those three fields and add them to the "To" field. Anyone knows which event I should subscribe to or what needs to be done to include those emails?

hi all , I am using Nav 2018.in the report 1401(check),the base functions are missing. I have checked with someone who have same version of navision 2018. for the reference i have attached the screen shot of the function which i have currently. I need to use the FormatNoText function from report-1401.but it is missing for…

Hi everyone, after upgrading from BC17 to BC21 onprem we are encountering the issue that some users will get caught in a seemless infinite loading loop after changing the language or company in BC. We are using AAD fot authentication. After clearing cookies it works just fine. The event log for the time of the problem is…

is it possible to run a report from BC showing user access over a period, so who logged and on what dates?

Hi I need to add another company to our system. It isnt live yet but is is based in SWITZERLAND so I need to maje sure the tenant set up etc is correct. Please advise how to add a company?

Hi, can someone please help? on Business Central AL, I am trying to set a rule, where if a Field Property Editable is set to true then another field should be set to true, if it's set to false then the other field should also be set to false. field (Record1Boolean) { Editable=true } field (Record2Date) {…

We are looking to upgrade to BC later in the year and would some information in regards to how the POST CODE LOOK UP function we have currently works in our current version of NAV. Are you able to provide the information?

Users getting repeated message asking to refresh, see image

Dear community, I've a question regarding Dynamics NAV 5.0 (2007): Dear Community, perhaps someone can help me. The following: I have added a discount to some of the prices (under "line discounts"). When I create a "quote", these discounts are shown in a separate column, so far so good. However, when I create a "sales…

In Business Central, it is possible to create a pick per zone, bin, etc. But is this not possible for Warehouse Put-Aways? For example you want to create 2 picks for 2 different zones? Thanks.

Dear community, I've a problem with Dynamics NAV 5.0 (2007): Could you please indicate how to modify the "Credit Limit (LCY)" of a customer. By default, I always have €1,000.00 filled in, but I want to give a customer more, but unfortunately I cannot edit the field on the customer record. Do you know how this works? I hope…

what procedure to add to upload a file of type text??

I need to delete a set of record in a table (Table1) applying filter. For each record in this table there may be other records in a secondary table (Table2). In onDelete trigger there is code to cascade delete all record related in Table2. But in this code there is a confirm to ask user every time a record was deleted. I…

Hi , Anyone has idea how Image can be converted to Base64 in navision?

I am trying to make a connection to external WS and I get an error related to - Misused Header name. I believe this is due to "Content-Type" and may be the syntax is incorrect.??? I have tried to access the same WS via Postman and I was able to get a success message.… Any Ideas what is wrong here? TIA //Header…

Hi community, I need to write a boolean value to an xml file and am always getting a "Ja" (German for Yes), instead of a "true". I've tried all of the options shown here under "Standard Boolean Format" (Link) but without success. And I don't wanna do stuff like "if value = 1 then 'true' else 'false'" or so. Does anyone…

This is an interesting request and its the first time I heard about it even with my prior job with Nav vendor. A little background, the company I work for is medical equipment suppler and we are ISO compliant and under FDA rules. We got audit by one of our customers. Based on the Electronic system audit checklist from FDA,…

I am attempting is to create a page on a role center that calculates the total amount for G/L Entries based on specific dimensions. Currently, the page performs this calculation when it loads. I have created a query for this purpose, which is functional but not optimized for performance. I'm wondering if there are any ways…

A third party vendor added some granularity to our license and our partner downloaded it and sent it to us. Now we can no longer publish after importing the new license. It is giving the error: [2022-12-08 10:35:10.50] The request for path…

Am trying to convert picture to bigtext or base64. Again On xmlport am trying convert text to stream and save it in field of Mediaset type.? but it is not working Please find attached code . Please let me know where am wrong? With the above setup and code if i run i get the following error Please help

Hi, I am trying to IMPORT 'Item Picture' for a particular Item present in NAV by using XMLPORT. I can't find out how to do it. Can anyone suggest the C/AL required for this operation? Best, Souvik

Hi everyone, I want to customize the creation of the Corrective Credit Memo from Posted Sales Invoice so that it only adds a line of type G/L Account, is it possible to do it from an extension?

Hello everyone, I'm new to this group and I have a question regarding our retail operations. We are using Dynamics NAV 2016 and LS Retail for our system. We want to allocate a specific POS Terminal for Home Delivery orders only. Additionally, our management wants to apply a 10% discount on products that are billed through…