-
General Docment association question
So sorry for the seemingly obvious question ... but coming from a 2009 environment i dont know the answer to this ... So it sounds simple, NAV has a sales order that can have multiple warehouse shipments, and each warehouse shipment posts to become a sales shipment - was my understanding.... BUT why do we have "posted…
-
Linked server
I'm using linked server to use external table in Nav but when try to open table return an error: "The microsoft DTC ha cancelled the distributed transactions". How I can solve?
-
The type NavBoolean is unknown
I am getting the following error when trying to rename the record in the table. Any ideas? There is no any code OnRename trigger. NAV2013.
-
Business Central OData Price Look-up
Hi experts, For an e-commerce solution, I am looking for a way to look up the prices og multiple items which a specific customer number would have to pay right now using an OData webservice. Let's say a customer in BC browses a webshop and loads product lists with 20 products at a time, I would like to fetch the "Best…
-
Bank payment Integration with BC 365
Hello Guyz I have a task on Business Central 365 in which I have to do Integration with ICICI Bank for Payments. I am new for Integration, please help with Coding part in VS Code to do this encryption. Thanks In Advance(Please do reply if anybody has any idea) This is the Technical Information: Encryption is done at JSON…
-
Assign serial numbers to purchase order line
Hi, Trying to find a proper solution for assigning serial numbers to a purchase order line through extension or API method. BC version is 19.3.0.2 on-prem. Here is the extension method code: In NAV, you would pass serial number directly into CreateReservEntry.CreateReservEntryFor method, like this: But in BC,…
-
D365BC: Publish through vs code without code ?
Is there anyway I can use vs code, using a 3rd party extension or any other way, to publish an .app file without actual source code through vs code ? (I'd like to do schemaupdatemode: recreate)
-
Close/Open Balance Sheet too slow
I need to run Close/Open Balance Sheet report but time needed to complete task was 8/9 hours. There are 2.000.000 record in 17 table but I believe that the time required is excessive. Nav version is 2013 R2. There is a way to speed the report?
-
multiple selections
Hi experts!! How can I make the multiple selection of the attached image in any other page? I have it done but putting the filter manually with OR: A|B|C but now the client asks me as in the image Thanks for advance!!!
-
Object extension(Table, Page) ID is not showing in AL object designer.
Hi Everyone, Good Afternoon, I have created some extension in VS code for my Business central sandbox(Trial), able to publish, getting custom field in user interface; but not able to see the Object extension ID in AL object designer. What is the issue, that i am not able to find. I checked the AL object designer extension…
-
Rename Item No
I created a report to rename the "No." field in the Item Table. Since this field is a primary key I used Rename function as shown below I know my code is working as I tried it already for another Item No, but for this certain "No." I'm getting the following error NAV Version Does anyone know how to resolve this issue?
-
Item CRM -> BC/NAV Sync Fails
Hello! We've been facing an issue when coupling items. The direction is CRM -> BC14. The record in table CRM Productpricelevel already exists. Identification fields and values: Product Price List='{00000000-0000-0000-0000-000000000000}' The sync works for the first time, but the next time it fails with this error. Any help…
-
App Install error
Hi, I'm trying to install 3rd party apps (Continia). I'm getting an error about a codeunit (6192809) in the core app (which is installed without any problems, so it does exist). Below the error: Could not install the extension 'Continia Document Capture 365' by 'Continia Software' (version '9.1.0.0') on tenant 'default'…
-
SQL Error when I compile the object in NAV 2016
We are using NAV 2016 -(version 9.00.46621). I get an error when I compile the Service Header table object. This error occurs only for this table. It started happening recently. I can compile all other objects. I get the following error : An updated definition for table Service Header cannot be applied in SQL because the…
-
How do get Attachment from API? (Cloud BC)
Hi All. are we able to pull attachment from BC via API? I tested from this link --> https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_attachment_get it is for Incoming Document Files but i need from Attachment (Document Attachment) Please advise Thanks.
-
Custom Automatic Posting of Purchase Invoices via Job Queue results in Job Queue Error (Error Mgt)
We are facing an issue where we would like to post all released Purchase Invoices via the Job Queue. If there is a validation error during posting of the invoice, it will skip posting and then move onto the next one. I have built a 2 Codeunits to handle this. 1 to run on the Job Queue and the second to handle the call of…
-
Moving or adding Sorting Filter
Hi Everyone, is there a way to add or move a sorting filter on a report? I want to add/move the sorting filter from Customer to Sales Order Line instead. Thank you
-
Time interval in the task queue
Can a time period be specified in the job queues in the date formulas? I would need a job that starts on the 5th of a month until the 13th of the month at 6:00am, 11:00am and 3:00pm respectively. I have not found anything in the forums. Is there any way to control this via powershell?
-
How would an end user identify they are using extensions or objects in a deployment?
Assume for a moment you're dealing with a non-technical end user, and simply want to know if they are using an ISV solution deployed as objects vs. extensions. Also assume this customer is on NAV2018 or BC13/14 where it could be either option. How would you get them to give you this information?
-
propoer item configuration for both sales and production
Hi, we are sales company, that started small production of goods item "03L". Previously it was only sub-manufacturing, so product was configured simply as "goods" because we bought it from contractor. Now we would like to continue purchase it from subcontractor, and start produce of "03L" in our factory. Our partner says…
-
Discrepancies In general ledger and subledger
I have an issue with transactions in my payment journals. When I enter an amount in ACY, it is translated to its equivalent in LCY. However, when I preview my journals, my amount in ACY differs from the amount on the journal line which matches what is in the subledger. . Any ideas on what I can look at?
-
Passing value from Job Ledger Entry
Hi All I've been trying to pass values to and from job ledger entries but it only works for header level fields like document no. This is the trigger trying to get the job ledger entry line linked to planning line:[EventSubscriber(ObjectType::Codeunit, Codeunit::"Job Jnl.-Post Line", 'OnAfterJobLedgEntryInsert', '', true,…
-
Need help to Upgrade D 365 BC Spring (14) to D365 BC wave (200)
Hi, I am an It person from a user company. It is a very small company with no partner because we can't offer to pay them. I have the NAV database of BC 365 Spring (14), with data. I want to upgrade to D 365 BC wave (20). I have tried but it is giving an error at using the txt2al tool. 1. Please help me with these errors.…
-
How to change Date format in Standard Statement (Report 1316)
Hi All, since the Standard Statement is mm/dd/yyyy I want to change all the date become dd/mm/yyyyy is there a way that i can change the date format? or need to duplicate this report and change ? Thanks.
-
ExtendedDataType Phone No. not calling
Hi, In a Dynamics Nav 2018 environment, the call button next to a phone number is not doing anything. It concerns the Customer Card Page (21), field Phone No. 1. It has ExtendedDatatype set to Phone No. This is the default situation, no custom code or properties. We have installed a Phone client (SwyxIt!). When we run…
-
Why we can't query with Record link (table 2000000068)
My client wants why can't we query for Record Link ( table 2000000068). I look forward to a detailed explanation, many thanks !
-
In Manhattan Scale WMS Application, How to do a replenishment demo? Where can I find bulk storage?
I am just learning Scale application, I am a given a task to do replen?
-
JavaScript SOAP Call against Container (CORS)
Hello, I wonder if there is anywhere a working example for javascript Soap calls (prefered with axios) against a local running NAV container? Has anyone done this and is willing to provide the working example including the container script? Have not found anything up to now and the Chrome "Moesif CORS" plugin seems also…
-
Your program license does not allow you to publish Business central ver BC 14
On installing some extension to a BC ver we get this error, We are using a runtime ver og the extension and our developer licens, to install the extension. How to fix Sync-NAVApp -ServerInstance $ServerInstance -Name 'Sproom' -Version 14.0.0.15 Publish-NAVApp : Your program license does not allow you to publish…
-
Installa extension to BC ver 14, does not show up in BC
After a installation of an extension, everything went ok, no errors The extension is is in Extensions mgt. but is visibel in BC anywhere Its is in the BC where we develop the ext. and also in other BC ver 14, but not in "this one" Other extions is installed and working Any ideas how to get visibel.