-
Error when trying to post/receive a Transfer Order
We have a transfer order that has been fully shipped, upon trying to post and receive this it comes up with an error "lot No. is required for item ???" This line for the item specified in the error has a lot No. assigned, we cannot receive it due to this one line outstanding. Any Ideas what could be causing this?
-
How to put a RunningTotal in ERP Navision 2009 Report like Customer Transaction Detail Report?
Hi I am a Beginner here, we have a Customer Transaction Details Report in our ERP Navision 2009, which has Amount & Remaining Amount (LCY) Column. My Boss requested me to put another column for Running Total/Cumulative Sum for the Remaining Amount (LCY). Please, any advice how to put this? Thank you.
-
The value Entry already exists. Identification fields and values. Entry No. =
NAV 2016 W1 Build 46621 When posting Item Journal - Negative Adjustment, the system prompts an error "The value Entry already exists. Identification fields and values. Entry No. = 19" Upon checking Value Entries, the entry no. is already at 83, thus Entry No. 19 already exist. Then we checked the Item Ledger Entries, and…
-
Forex account
Hi. In navision Eg - if we book invoice of 100 $ and value of 1 $ equal to 70 RS so total invoice value is 7000lcy sales invoice And when we receive payment of 100 dollar and value of 1$ is Rs 71rs then total value is 7100lcy So dollar value value gets equal to customer account bt balance lcy of customer increase by 100 rs…
-
NAV2018 CU22 All Ribbon Buttons grey out for users after a few hours.
Hi Mibuso Hive Mind Got a customer on NAV2018 CU22. They are working fine for any where between 30 minutes and 3 hours before they suddenly find their ribbon greyed out. They simply close the RTC and load is back up again and repeat exactly what they had just done. Once the ribbon is greyed out, it's greyed out for all…
-
Business Central: Renewing OAuth Token
Hello all, I am facing the following problem: We have a web application (built with PHP and Symfony) that exchanges data with Business Central via SOAP web service. Since the SOAP web services are to be removed, we are currently converting the application to OAuth2 and (JSON) API calls. An app is also already registered in…
-
Clean Isolate Storage
Is there any way to clean the Isolate Storage? I know I can do: IsolateStorage.Delete(key), but what I want to do is delete ALL the keys, because there are millions and I do not know the keys and I want to clear them all. Thank you
-
Upgrade NAV 2018 to BC 18 On-premise
Hi Experts, How to upgrade custom fields and table extensions data from Nav tables to extensions? How to Upgrade NAV to BC 18 Onpremise? Thanks in Advance.
-
Telegram Messenger NAV
Telegram Messenger NAV Presented Telegram integration in Microsoft Dynamics NAV. Telegram messenger in Navision gives you the opportunity to directly communicate with mobile gadgets. The core of the development is an automation server, created in the DotNet C# environment without use Telegram NuGet packages. Through the…
-
Save time during upgrades to AL with new automation tools
I am pleased to announce that Simplanova AL Tools (SALT) is finally officially released! From now you are able to automate Dynamics Business Central C/AL code to AL conversion. This platform can help you address both challenges by providing automated fixes and guidance for your team. By using an automated approach, you can…
-
Flow Field Performance on page
Hi All I normally create flow fields for various calculated fields required for pages and reporting. My understanding is that the flow fields are triggered for only the records displayed on a page rather than the whole table. For example, say we have a flow field on posted sales invoices and the underlying table contains…
-
"The metadata object Table 2000000053 was not found" upgrading from 2016CU13 to 2017RTM
Hi, I'm in the process to upgrade to Dynamics NAV 2017 from the latest Dynamics NAV 2016 CU (13). While all CUs upgrades in the 2016 works fine, I can't understand what to do with this error: PS C:\Users\Administrator\Desktop> Sync-NAVTenant -ServerInstance Company100 MicrosoftDynamicsNavServer$Company100
Confirm…
-
Notes factbox very slow to load on cards
We are finding that the notes factbox is sometimes slow to load. Typically the first time the factbox is opened (on a card page) the page will take 3+ minutes to load. After that, its fine (on any card page). The only clues I have to its cause are: 1) It seems it is the first time the factbox is loaded in editable mode…
-
done
done
-
NAV 2016 debugger Watch window and program stack and variable window disappear
Hi, I'm running NAV2016 CU32 in a Docker (development) environment. After I build a new Docker container and run the NAV2016 debugger, the "Watch" and "Call Stack" windows are not there (they don't appear). And if I click on "Variables", the Variables window is completely empty. The debugger otherwise runs OK. If I do the…
-
Function to update a DateField with a new Date
Hey, i'm on a beginner Level :s my task ist to update a Date Field with a new Date in the PurchaseLine. Therefore i need a variable, which replace the old date and set the new, or overwrite the current Date...
-
Are there any resources that document the Integer values for various type groups?
I've been working a lot in the SQL Server backend of a Navision 2009 R2 client. I can't seem to find information on what the different integer values mean for various different type groups that are human readable to a Navision Client end-user. For example: - Account Type (G_L Account) - Invoice_Balance (G_L Account) -…
-
How to Access OneDrive using Graph API in Business Central
One of the significant limitations we face when upgrading to Business Central’s SaaS environment is our local or server’s file system usage. Various NAV or BC solutions often use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of refactoring…
-
How to force NAV 2013R2 to honor PromotedIsBig No for Custom Action button
We have several custom action buttons we want to promote to a custom category on the main ribbon. There are 2 primary and 6 minor actions to promote. We want the 2 primary actions to be large buttons and the other 6 to be 2 columns of small buttons stacked in groups of 3. The 2 primary buttons are defined first and appear…
-
Modify procedure
Hello, still a newbie here with the AL. I have a procedure I want to modify, just add a block of new code in it, how can I do that? I see no option/property for it?
-
"Block Movement" Field Permissions
Hello. I was wondering if anyone had any good ways to restrict access to the Block Movement field to only a select few people. I'm working with base Nav2018 permissions, but I'm not seeing anything for that field. Thank you in advance!
-
How to sync Dynamics 365 Sales to Dynamics Business Central (variant Code)
Hi All, I am new to Dynamics 365 for sales in the Dynamics 365 for sales we have Variant Code in Sales Order. the question is , is there a way to sync this customized field (Variant Code) to Business Central Variant Code in Sales Order line ? Please advise. Thanks.
-
Who Imported object?
We are using NAV 2018. Is there a way to tell who imported an object into the production database? Someone imported something into the production database without proper authorization, and the users ended up getting the "The tenant “default” is not accessible" error. We want to find out the following: 1) Who imported it?…
-
BC20 Convert-PermissionSets.psm1 error
Hello I would like to convert our costume permissions from database data to permission objects, but i am getting so many errors when i try to Import-Module -name "C:\Path\Convert-Permission Sets.psm1" library . Regs. Firas error sample At C:\Program Files\Microsoft Dynamics 365 Business…
-
Inventory Valuation
I used report from NAV 2017 - R1001 - Inventory Valuation, to create a new report that could group by location. Because in the original report i can take the results of all Locations or filter by a specific. My goal is to show all locations . I added Location as Data Item, and indented Item , and dataitemlink by Code -…
-
How to Prevent Users from Viewing Chart of Accounts in Business Central
Hello, I have a small company with only a few employees, so we don't have full on User Groups and Permission Sets set up. I want to only restrict users from seeing financial data. What would be the simplest way in doing this?
-
how to start application server at service.msc
my company was using Navision 5.0 SP1, and now i have migrate to Windows server 2019 & SQL 2019. i can running finsql at client side properly . but i can't make the application server start normally at service.msc ! anyone have idea ?
-
When I select date from calendar why year always wrong? (Dynamic NAV 2018)
Hi Expert Please see in attachments why year always wrong ?? Actually when I type be manual if I input year 4 digits such as 01/01/2022 error still occur but if I input 2 digit it's can work by properly. May be I think error is came from SQL. please give me some suggestion How to fixed its? Best Regards, Funaki
-
CardPart in content area
Hi In an EDI context I have a transmission with one or more documents, each document having one or more lines. In a Page a want to show the document. Along with the document I'd like to show transmission details. So I created a Page with PageType=Document and added a Part Subtype=Page, referencing a Page of…
-
Read the field note on the table record link in sql server ?
Hi, I'm looking for read the field note on the table record link in sql server. I have find how read the field record ID with that :SELECT CONVERT(varchar,substring([Record ID],8, LEN([Record ID]))) as 'ID',* FROM [Record Link] But I can't find how read the field note in sql ](*,) Any ideas ? Thank for your help