-
VAT Statement Line - Column amount calculation
Hello to everyone, I don't know where to post this thread, because I am new on forum, and I am posted here. I used Business Central, and added two new fields on VAT Entry table: TOTAL = Base + Amount, TOTAL UNREALIZED = Unrealized Amount + Unrealized Base, and on VAT Statement table field "Amount Type" (Enum) I aded two…
-
XMLPORT:Skip Empty Tags
Good Morning. does anyone know how to skip empty tags when exporting with a XmlPort? I tryed to do that setting the MinOccurs property of the element to zero but does'nt work. It's a great problem form me because my commitment don't accept empty tags. Can somebody help me? Thanks for all.
-
Unable to post Purchase Invoice
Posted a Purchase Receipt for GL Lines( Productive Indirect Cost) and there is Quantity in "Qty received but not invoiced" field is 123 But while posting the Purchase invoice "Quantity Received" field is getting Blank. And we are getting belowerror: "You cannot invoice Order xyz for more than you have received." Please…
-
How to transfer custom field amount to the right G/L account (Chart of Account)
Hi I would like to send the custom field amount (Allowance) [as the blue box in the image] to the bal. account allowance [50113]. May I know is there any event that I can subscribe or any custom code that I can use? I've tried using the method in base app but it doesn't work.
-
Unable to post Purchase Invoice
Posted a Purchase Receipt for GL Lines( Productive Indirect Cost) and there is Quantity in "Qty received but not invoiced" field is 123 But while posting the Purchase invoice "Quantity Received" field is getting Blank. And we are getting belowerror: "You cannot invoice Order xyz for more than you have received." Please…
-
Type 5053 was not defined for the function
Hi, when i try to export some table, i receive this error . Type 5053 was not defined. I had a similar problem with type 5056 , and solved exporting the objects in a higher CU of NAV and then deleting the "Dataclassification". type Now i have a similar problem with data 5053, can you tell me to what correspond type 5053,…
-
How to receive a JsonObject by parameter in web services
Hi, I try to create a web service in BC that receives this structure curl --request POST \ --url 'https://api.businesscentral.dynamics.com/v2.0/XXXXXXXXXXXXXXXXXXXX/Testing/ODataV4/Test_CreatePurchase?company='XXXXXXXXX\''' \ --header 'Content-Type: application/json' \ --data '{ "_Header": "00007180", "_Lines": [ {…
-
Excel Nav Add-in exciting sheets on new server
We are in test phase of moving a NAV 2017 to a new server. We are going from on prem AD to Azure ad. Customer has like 50 sheets with various BI like reporting made with the Excel Nav Add-in. We have the add-in on working new server. But the old sheets does not work. Is there any way of making the old sheets working?
-
What is the best way of exporting BLOB?
Kicking and screaming we are now entering BC! Therefor I am facing a big upgradeproject which includes going from TempBlob Record to "Temp Blob" Codeunit. Therefor I am looking for some information on how to best use/transfer the old pieces of code into the new one? For intance I have a lot of places where various files…
-
Object License in Dynamics BC OnLine/OnPrem
Hi, In classic NAV (version NAV2018 and below), you would need to purchase objects if you use them in customisations. Is this still required for Dynamics BC Online or OnPrem?
-
How Lot no tracking works for a component in Work orders?
Sir/Madam, How lot no tracking Works at various stages of Work order process? While creating a work order, whether it is placed in any table...? Also while creating a warehouse Pick (not posted) where it is stored ? Where it is placed in order to check how much quantity is reserved for one component while creating a pick…
-
BC 18 - Microsoft.Dynamics.Nav.Runtime.NavHttpContent variable not initialised.
Hi all, I am using On Prem BC 18 I have called API to BigCommerce... testing from my local is ok, no issue. I got this error message from production server. any idea what's wrong with my extension? thanks.
-
[solved]Use Default Synchronization Setup - Sorry, we just updated this page
Hi all, I have an issue with the BC-CRM integration through the dataverse. When I try to set the Default integration settings on the Integration Table Mappings I get the error "Sorry, we just updated this page. Reopen and try again.". Has anyone else got this error? The version is BC 19.3.34541.34662. I do have some…
-
Item Tracking in Business Central
Items are assigned Lot number and expiry dates when items are shipped, but on the receipt side either the Batch number or expiry date or both do not show. what could be the problem ?
-
Character XMLPort in soap UI
Hello: I don't understand why I get weird characters in soapUI when I mount a webservice with an xmlport. The definition is correct And the xmlport is simply the webservice works in SoapUi and Postman even though it has the characters, but the provider can't get it to work because of the characters. Any ideas?
-
Will stock adjustment function in Business central affect blocked items ?
If stock adjustment function is run in Business central, will the adjustment affect items which are blocked ?
-
File Management limitations in SaaS using BlobStorages
One of the major limitations we face when upgrading to Business Central’s SaaS environment is the usage of our local or server’s file system. Quite often, various NAV or BC solutions use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of…
-
Reading event in .NET from event in BC
Hello, To give some context regarding my issue. I currently have a codeunit set up with an event subscriber which looks out for the OnAfterInsertEvent event for a specific table. This is because I want to extract the newly added data I added to my specified table. I also set up a web service on C# from the codeunit…
-
Do we have a solution to integrate business central with Amazon Web Services S3 (AWS S3)?
Hello, We want to import the files from Amazon Web Services S3 (AWS S3) and export the files generated from business central (BC) to AWS S3. We found no references on the web on how to integrate business central with Amazon Web Services in perspective of AL coding, rather we found "No code integration". Some pointers in…
-
Issue in passing a String from NAV to a DotNet Method
I was trying to pass a text variable txtStartDate from NAV2017 to a DotNet Method: SomeMethod(String StartDate) I found that when I pass a value directly to the DotNet Method like this (1) SomeMethod('2022-02-25T13:30:00') it behaves differently than when I pass (2) SomeMethod(txtStartDate) [although I have assigned…
-
Modify Notes FactBox
How do you set the Notify field to TRUE once the user creates a new note? Thank you in advance.
-
Unable to Finish Production Orders
Hello, I'm having problems Finishing Production Orders. Let's say, for example, the Quantity is 30, the Finished Quantity is 0 and the Outstanding Quantity is 30. When i go to Change Production Order Status (99000914) and set the Output Quantity to 30, the boolean Finished to YES and then press Register, it says it…
-
[solved] Print and Send to Excel produces an empty sheet.
Hi there, an employee of one of our customers has the following problem: If he sends data from an overview to Excel by Print and Send, Excel opens, but the sheet remains empty, no error message, nothing. The addin for Navision in Excel is disabled, and that's the way it should be. When exporting to word it works. Does this…
-
[SOLVED]Could not find server AAA in Sys.Server - Linked Servers View - XACT_ABORT option
Hi all, We are facing an issue with a NAV(NAV2015) set up that has some views connected to Linked Server: after having migrated the databases of the linked server to a new server, there is one particular process that errors when we try to update data from the linked server, making reference to the old linked server.…
-
Unable to process table changes
Dear Sir, We're not able to compile any object in NAV 2016 Database while working remotely. Suppose NAV SERVER & SQL SERVER are installed in a Machine Called 'PC1' & we are trying to modify & compile its object from a Client Computer. The following error is popped up from the machine. The Firewall/Anti Virus application…
-
Item Ledger Entries - Cost Amount
I wish to import the Item Ledger Entry for an item in to Excel, using SQL and the SQL database as an External data source for Excel. When I do this the 'Cost Amount (actual)' does not pull through as it is not kept on the Item Ledger Entry table. Which table holds the financials that I can 'join' to the Item Ledger Entry…
-
Pegging Report
Is there a way to obtain a 'pegging' report for an item after MRP has been run? Nav 2009
-
Is there any way to update Global Variables from subpages ?
Hello In BC14 is there any way to access and update global variables from subpages ? I know about UpdatePropagation but I don't think is what I need. I also read about protected var but this feature it's available for newer versions. In order to see global variables values on pagepart I have created a global function and…
-
I have a problem configuring the export of excel from business central
I have a problem configuring the export of excel from business central Here is the error message that appears
-
upgrade from nav2015 to bc19
hello NAV experts, I have just upgraded a client but got two issues with permissions - some did not get transferred across, not sure how this is even possible and when then importing them via rapidstart (xml did not work) got the following error - "The field Object ID of table Permissions contain a value xxx that cannot be…