-
Purchase Invoice Extra unfilled line error while posting
I'm getting this error when i post only the filled purchase lines in the invoice. The lines from 100000-150000 are filled correctly.But when I post its showing:- No. must have a value in Purchase Line: Document Type=Invoice, Document No.=EXP/CMUM/20-21/00161, Line No.=160000.It cannot be zero or empty. Although, line No.…
-
NAV Upgrade Tool-Set
Hi NAV community. I would like to bring your attention to the tool-set designed and was used for internal use in NAV upgrade projects. It was successfully used and adjusted in 200+ NAV Upgrades from Classic to RTC and BC. Since the fact, that our company SWP was acquired by bigger MS partner, the tools are not used…
-
Hotfix Search for NAV/BC
Hotfix Search for NAV/BC Hotfix Search Transform the way you search for hotfixes to be fast and sharp. This cloud tool allows you to search through all hotfixes released by Microsoft across all Dynamics NAV and Business Central (BC) on-prem, and by country versions - in just seconds. Azure hosted tool for Dynamics NAV and…
-
Sync-NAVTenant crashes for database converted from NAV2013
Hello, I am doing NAV2009 to NAV2015 upgrade. I got fully upgraded tables and data for NAV2013 (7.0) and I am trying to convert the result to NAV2015 (8.0) format. I am opening the database in finsql, all is going well, then I am invoking Sync-NAVTenant and getting the following: Sync-NAVTenant : "§", hexadecimal value…
-
is it passible to validate field value through Navision web service before insert or update
Hi All: Navision provide web service that you could call it for insert , update ... etc. The filed value will be validated when you call web service Create / Update function. But I just want to validate field value before call Create / Update function for checking filed value legally . Is it passible to validate field…
-
Upload Files from NAV 2018 to AWS S3 Bucket
Hi, Can you please help to know the possible ways to upload file(*.CSV) on AWS bucket s3?? Please help me Thanks so much
-
React.js to NAV17
How can you connect to Navision 2017 from React.js or React Native. I want to both create data and read data. Say I want to create my own Navision client with React. Is there an example of this? Thank you very much stony
-
Data migrate?
Hello BC experts, I have a quick question regarding data migration. We have an app/extension based on BC al programming in 14m range ISV range. Now we have developed same app in a PTE range which is 90k series. Now, we want to move all the data from 14m objects to 90k objects. Is there any tool or code that can help us to…
-
Item tracking
Hi NAV Experts, I am new to NAV. And I am working on Item re-classification. (Generally moving some items to another location.) When I click on item Tracking Lines and on the Item tracking Page I see the Serial number and lot number. On Assist of Serial number, I am able to view the available serial numbers and the Lot…
-
NAV2013 FTP without Libraries
NAV2013 FTP without Libraries No need of DLL. RAW FTP commands implementation with .NET 4. This lib was tested with 2013 both NAS and RTC. After some magic should also work on 2009 RTC. Use and enjoy :) Functions: GetFilesList, UploadFile, UploadFiles, DownloadFile, DownloadFiles Easy-to use, .NET Framework only based, no…
-
Converting Data from NAV 2009 R2 to NAV 2013 R2
Help: I converted the data (tables only) from NAV 2009 R2 to NAV 2013, according to the upgrade toolkit of Nov 22/2013. This worked fine with the "short version without installing NAV 2013. After this I attached the database to NAV 2013 R2. When I am trying to open this database in the NAV 2103 development environment with…
-
Hi All! I want execute parametrized sql text query in Nav2009
I use microsoft ado library 2.8. Question in how can i pass the parameter to the sql text query? SELECT [Project No_] FROM WHERE [CM FIO] = @UserVariable IF I compile SELECT [Project No_] FROM WHERE [CM FIO] = 'Kanye West' it works, but i want make this with parameter @UserVariable. My function where i am trying to pass…
-
Problem creating middle tier
Hi, I am trying to create a new middle tier on Nav 2015 and I keep getting this error. Unable to locate the default ServerInstance. This happens if I use the admin tool or if I use the powershell command. I don't know where I would find or configure the default instance. Can anyone advise? Thanks
-
How to get
Hello, All of the "Header" data fields in the Demand Forecast page 99000919 are global variables. I want to default the View by Period to Month and also verify the same when the page closes. How can I get that value? A. I have tried using Modify(PeriodType) to get the value from the OnAfterValidate trigger. PeriodType…
-
Whether it is possible to use a debugger to understand from what place object are call?
For example I can view page as a developer. But I have to understand the place which page is calling from? Can I use debugger in this case?
-
Web Client Signin
I've installed BC14 on two server. First with SQL and BC Server. Second one with web server component. When Login with URL https://localhost/BC140 all works great and I can login. If use https://servername/BC140 after login return on signin page. In browser address bar: https://servername/BC140/SignIn?ReturnUrl=/BC140/…
-
XMLport import error when Nodename ends twice
Hello mibuso-members I've got a Problem with an XML import. I get the Files from the Customers and can't change how they are. Here's an example how the XML-Files look. It all works when the "NotMandatory"-Field isn't empty (No.1). As soon it's empty (No.2), two closing </XMLSample>-Nodes appear and Navision gives an Error.…
-
Loggin HTTP traffic in BC SaaS
Hi all, Is there any way to log the http traffic into a BC cloud tenant? The thing is that I have created an integration with an external service. I'm sending a job with the related tasks and planning lines to that service. Each entity creates an entry into the external Service, I know that the call via HTTP post is…
-
RDLC: Error in fill background color of row
Hi all, When I want to fill the background of a text field in an RDLC report I get the following error on the Description field, all the other fields in the same row don't give this error and work perfectly. =IIf(RowNumber(Nothing) Mod 2, "LightGrey","White") Any thoughts?
-
Bin content equals 0
Hello, Hello, i'm a newbie in Navison and i encounters some issues. I tried to make a transfer order between 2 locations and the quantity in my bin content is equal to . When i check the Warehouse Entry, I see 2 lines one with a psoitif value eand the other with a negative value. Is it normal ? Does i'm made something…
-
Group Data in List Pag
Hi, How can i group data in a list page by item code? I have developed a Matrix page on Item ledger entry, i want to group data by Item code. How can the same be done?
-
Saving a file to Sharepoint
Hello, I would like to know the setup required to automatically save a file to SharePoint from Business Central. Please could someone direct me to any blogs which explain this well. This will be on the back of creating a .txt file via Data Exchange. We are on Business Central 16.1. Thank you.
-
API Query in BC
I want to make a custom API with items and customer discounts. So I made a query and connected the item table to the Sales Line discount table. query 50100 "Itemprice Entity" { QueryType = API; Caption = 'Itemprice API', Locked = true; APIPublisher = 'Me'; APIGroup = 'Client'; APIVersion = 'v1.0'; EntityName = 'itemprice';…
-
Business Central: How can I do automated testing of Processing Only Report ?
Hi Community, I need to do automated testing of processing only report, I need to cover the code written in OnPreDataItem and OnPostDataItem triggers ? Can anyone give me head start, i'll be very thankful. thanks
-
Order of triggers in Table
Hello NAV experts, What is the order of triggers execution in a Table Object? exemple: is onModify before onValidate ? Regards.
-
XMLPort In Business Central
Hi! I need to catch the URL of a file imported with the XmlPort. With the Windows client, i can get the total file name (URL+File Name) with CurrXmlPort.FileName, but with the Web client, i can only get the File Name (without the URL). I need this info to save it in a log table (with other infos like File Size, Date, Time)…
-
Workflow Setup question
Hi Guys, I'm going around in circles a little bit with a workflow setup I need to do for my customer. Looking for any help if you have experience with this scenario. There are 3 levels of approval based on value, 1: 0-5000, 2: 5001-200000 and 3: 200000 and above. So far so good and I can set this up in approval user setup.…
-
Item charges affecting unit cost
I'm facing the following problem: when a Purchase Order with a respective item has some charges, for example transport and insurance, and i invoice the Purchase Receipt of the item and only one of the charges, the charge pending will affect my Unit Cost The cost expected of the insurance is afecting the unit cost. The…
-
Cannot generate SSPI context. State ID: HY000
I know there are other posts about this, and I tried it all out. I have Navision 5.00 on a SQL2005 standard edition on an XP (my portable). If I try to connect to the SQL DB with Windows login (with nettype default,Named Pipes,TCP/IP Sockets,Multiprotocol) I get this error. The strange thing is : if I connect with MS SQL…
-
Link tables in one
Hi, I have a project for Nav 2013r2 and Nav2018 I have a table with many fields(photo) I must to create a process(batch) that take value from other table and insert in this( for example id_customer = Sales Shipment Header"."Sell-to Customer No." and other field from another table and so and so) Many fields are from Sales…