-
Drilldown to another company
Hi All, I am using BC SaaS. I have created new page that show total sales for all companies. let's say I have company A,B,C so it will be something like Name Total Sales Company A $1000 Company B $2000 Company C $4000 then user open company A. what i am looking for is when user click $2000 (which is for company B) then it…
-
How to apply entries between 2 GL accounts on the CoA
Hello, I am currently on a Business Central version 19.1 w1. I want to know if its possible to apply entry between two GL accounts. I am unable to spot this functionality. Is there a limitation? I have seen that this is available on the French and Belgium localisation. Can you please help? Thanks
-
Navision Table Lock Issue
When users are trying to delete Items from Planning worksheet then Reservation table is getting lock. Is there any way to stop this locking issue? Please suggest.
-
Date Compression for Job Ledger Entry ?
On NAV 2017 (16585) , I can see that there are date compression options for several ledger entry types ( including Cust. Ledg. Entry , Vend. Ledg, Entry, Gen. Ledg, Entry .Bank Ledg. Entry. etc) . However I couldn't find a way to date compress Job Ledger Entry records. ( also searched on Google ) . Do you know a way to do…
-
Webservice can not return response when calling from CRM
Hi All, We are using BC 16 Onprem and published a soap webservice which is consumed in CRM to push sales order data. sometimes it does not return response from BC to CRM in few cases and prompt below error in CRM. have anyone faced this issue before?
-
BC14 - NavMetadataNotFoundException in Event viewer when starting BC Service
I have completed a technical upgrade from NAV 2016 to BC14 - all is seamingly ok - but when I go to the Event viewer there are some errors that appear every time I start the BC Service - the Page ID's that are mentioned are not in the Database - not in BC and not in the old NAV 2016 database. Message…
-
BC14 config file resets itself ???
Does anyone know how to prevent these observed behaviors upon server reboot??? 1. BC14 service A copies config settings from BC service B and will not start because the ports (and everything else) are the same. 2. BC14 service resets to Demo database even though this is not installed. These are probably the same issue.
-
NAV 2017 Page webservice error "401 - Not authorized"
Attempt to consume page webservice via code: Customers_Service customersservice = new Customers_Service { UseDefaultCredentials = false, Credentials = new NetworkCredential("xxx", "*****", "domain") }; List<Customers_Filter> customersfilterarray = new List<Customers_Filter>(); Customers_Filter f1 = new Customers_Filter {…
-
Add Cash Flow Chart to NAV Client
I'm trying to add the Cash Flow Chart that is available already in the Accounting Manager Profile to the Staff Accounting Profile When I went to the Staff Accountant Profile -> Customize ->Customize this page, and I added the chart in there, for some reason the chart keeps loading as the screenshot below and it doesn't…
-
How to get the value entered in the Request page
I'm trying to set a range between a date field of 0D till the date entered in the Request Page Can anyone help me with how to get the value of the date entered by the user? Also, I want to make the "Created Date" field mandatory. My code so far, when I hard-coded the date, the report runs perfectly fine, but I don't want…
-
Export file from Cloud BC to Sharepoint Online
Hi All, any idea how to export file from Cloud BC to Sharepoint online? Thanks.
-
Why I cannot find "To" and "Notity" in Notes
Hi everyone, I am working on Dynamics 365 BC14 and using web client. While I opening Sales Order then click on Notes button. I cannot find "To" and "Notify" in Notes . But I check in Windows Client, they occur as normal. How can I do if I would like to display "To" and "Notify" in Notes? "To" and "Notify" disappear "To"…
-
Can't see serial numbers at invoice screen
Hi Guys, We took the product, whose serial number we tracked, into stock. We transferred to another location. Then we want to make sales from that location. However, it does not appear among the available serial numbers in the item tracking section of the sales invoice section. When we examine it from Ledger Entry, there…
-
how to find name within a name
Hello, newbie here I have this name 'Name Name2 Name3 Surname'. From this I need to extract the surname. How is this possible. If they were two names only, I could exclude up to the first space but what if they are more?
-
Sub Page ProviderId and updting a factbox based on a temporary table
NAV2013 I have a Page, with a SubPage (ID:1000000001) and a factbox (ID:1000000022 and Provider ID:1000000001) with appropriate SubPageLink. All works. However, I need the factbox to be based on a Temporary table pulling out various fields from the factbox SubPageLink record and showing them in rows rather than columns. So…
-
Combining two role centers into a new one
Could anyone guide me on how to combine two role centers into a new one please? What I meant by that, I want to add all the pages actions and queues for those two role centers "production planner" along with the "Purchase Agent" into a new one. Thanks!
-
Records, RecordIDs, and RecordRefs OH MY!
Arg. Ok, I grew up on MS C/Side documentation examples like: Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy…
-
How to send item picture to SOAP web service?
Hi experts, I need to create a SOAP web service codeunit that gets an item number and returns the picture that is on that item in Business Central cloud. (I think there can be more that one picture, but I only want to get the first picture.) I have made the procedure below on a codeunit, but it doesn't return anything.…
-
Delete Large amount of Records
Ladies and Gents, Due to some wrong functional setup and programming, one of our clients now has a table with 2bln lines which takes upto 2tb of storage. The table data is not being used anywhere anymore.....;) I have been trying to delete these through processing reports and codeunits, with deleteall. This does not work…
-
Notes with Notify deprecated in Business Central ?
Does anybody know why I cannot see anymore in Notes, Notify field in Busiess Central ? It was deprecated ? Can it be replicated in the BC as it is in navision ? And if that is not possible can someone tell me what it was replaced with? Thank you.
-
Problem running Web Client - NAV 2016
Since updating to CU64 this client has had issues running Web Client. They see different behavior depending on where the browser is run. Obviously these are not the real server names. Running from "mywebserver" (where IIS is installed): Using: https://mywebserver.mydomain.com/NAVService/WebClient/?company=My Company FAILS…
-
BC: PageExtension - placing the standard field from standard group to custom group
Hi All, How to properly move standard field to custom group? I am designing page as pageextension of standard page "Create Interaction". I know how to display custom fields on a page, but I just don't understand how to move standard field from standard group to new custom group that I placed on the page. placing the field:…
-
Upgrading Customized C/AL Application to Microsoft Base Application Version 19
I'm trying to upgrade from BC14 to BC19 following the directions in the Microsoft document. At task 11 step 4 (Synchronize the empty versions of system application, base application, and customization extensions that you published in Task 8) receive an error: I am sure I have performed the indicated steps correctly. What…
-
1099 report for year ending 12/31/2021 for NAV2016
Hi all, As formal support for NAV2016 has ended, Microsoft has said it will not be issuing 1099 updates for NAV2016. I'm wondering if it's possible to "downgrade" the version from NAV2016? I'm fairly certain that the database hasn't changed, but I do know that the 1099 report layout has significantly changed, and the 1099…
-
Not able to add Authorization: Basic in HttpWebRequest header Navision 2013
Hi Everyone, I am trying to get token using the POST method. I have created the same request in Postman and I am getting token there. in Nav, I am getting the below error Microsoft Dynamics NAVBreak On Error Message: A call to System.Net.HttpWebRequest.GetResponse failed with this message: The remote server returned an…
-
Char for sign Σ
Hello together, I would like to set the symbol Σ in a Code field. I tried with a char but i do not know which number i should use. Have someone a table where i can find the special characters? Thank you very much.
-
Block Jobs for Orders
Hello everyone, we are using NAV 2016 ; Vers. 9.0.47042.0 and have following problem: we would like to block a job (card 88 / table 167) in a way that any new order (Page 42 / Table 36) cannot be assigned to it. Blocking it didn't help. In the end it should work the same way as a blocked customer. As soon as somebody is…
-
Missing objects
In the live system, we are missing many menu items as shown below with EFT and others. Can anyone help me with what might happen and how to fix this? As all the needed objects are showing just find in TEST but not in PROD The following screenshot from Prod The following screenshot is from TEST I tried to update the…
-
How to change tax (VAT) amount on sales line from code (BC SaaS)
Hi Guys I have asked this question in another forum but haven't found a proper answer or why others haven't found this problem. When synching orders from web store like Amazon we need to change the tax amount per line to accommodate for rounding etc. And the statistics page where we do this in front end is a temp table.…
-
How to set Amount to Apply in Payment Allocation to invoice from code
Hi Guys I thought it's simple to allocate payments to invoices from code but after couple of days of trying I need help..:) Basically it works setting the Applied-To-Id and remaining amount , but always takes the remaining amount instead of the amount to apply This is my simple codeunitvar CustLedgEntry: Record "Cust.…