-
SQL Statement
Hi All, I have a question here whereby i am trying to write an sql statement for the following as an example from Nav 1. Table: sales order (Asia Area) Sales Order Number Customer Date SO001 Singapore Faire Price 2017.1.14 SO002 China Wu Mei 2017.1.30 SO003 Singapore Giant 2017.3.8 2. Table: sales order Detail (Asia Area)…
-
Table Item in SQL Server
Does anyone know why the NAV 2015 table 27-Item is not appear in the SQL SERVER using Management Studio??? I am not able to find it....
-
Compare two dates from table Dynamics
I'm having problem with my little task. I have a table with information about two users who are working during this time. If this time intersect I need get a MESSAGE/ERROR about it. Can you explain how to do this? Thanks!!
-
Handling Flowfields in SSIS/DTS
Hi, how is your approach to handle flowfields when filling tables using Integration Services when copying records from one database to another? The package I created complains that the flowfields can't be assigned with NULL, so I'm in the process of using the derived column tool. But the table I have to handle has a lot of…
-
SQL Server collation vs. NAV DB Collation
Hi, My customer requests recommendations for collation on SQL Server and NAV database. I have been told (years ago), that it is good practice to ensure, that SQL Server collation and NAV DB Collation match. Failing to do so could potentially cause trouble, allegedly because in some cases (temporary tables, perhaps?) system…
-
SQL QUERY TO CREAT TRIAL BALANCE
HI AM WORRKIN IN NAV 2009 CLASSIC CLIENT I NEED TO CREAT TRIAL BALANCE VENDORR AND GENERRAL TRIAL BALANCE AND COMPARED IT ? CAN YOU HELP ME ?
-
Problem while using NAS
Sir, A codeunit is made to create a PDF file (from navision report) & sending mails this pdf as an attachment to specified mail ids. When we run this codeunit manually It works fine as per the expectation but when we use the Scheduler (NAS) for the same purpose it does not work properly(occasionally). It creates blank pdf…
-
How to add database in Sql management studio?
I have already database but i want add that into management studio. how to do that please help me
-
how can we take Bakup & restore of single table in sql using query ?
i had also take backup on temp table but not able to take restore from temp table.
-
NAV and MS Analysis Services
Hi All! I am building the multidimensional cube over Dynamics NAV database. Does anybody ever have a success in the creating a cube dimension, based on the Dimension Value table? What is the trick? Thanks in advance!
-
Report Page numbering at page footer depending on instances
Hello everyone, I have the following problem: I want to increment the page number at the page footer after each instance of a row group in the SQL Report Builder And thank you.
-
Error executing procedure from access
Good morning experts !! I have a procedure in SQL Server 2012 that uses views from another database on another server with SQL Server 2008, the SQL procedure runs smoothly. It happens that this procedure I have to run it from Access (Microsoft Office Professional Plus 2010) by a pass-through query. The user who runs it has…
-
Sales for customer
Hi all, I'm fairly new here so please bear with me :) I'm writing TSQL for simple report which shows Sales (LCY) by customer. As a reference I'm using the Customer Statistics window to check if my values are correct. Initially I went with the Value Entry table by summing the Sales Amount (Actual) column. The reason is the…
-
copy data from one table to another but only data fields are called exactly the same
Good morning to everyone s, SQL Server 2003 R2 I need to copy data from one table to another but only data fields are called exactly the same. tabla_A fields: field1, field2, field3, field4, campo5, campo6 talba_B fields: field2, field3, field4, campo5, field8, campo9 You need to copy data from field2, field3, field4 and…
-
How to get data from Excel into a SQL table
Hello everyone. I have an Excel spreadsheet with a few thousand items in there with the weight - just two columns. What I want to do is for each "Item" in the spreadsheet column "A" get the weight from column "B" and populate the weight field in my Item table in SQL. Can anyone show me a script by which I could achieve…
-
SQL data types represented in MS NAV
Hello, i'm using Nav 2016, so i try to get data from other sql data base by using table (prop. external SQL), it's look good, but i've got some conflict: 1. i can't represent column with datatype smalling in MS Nav 2. i can't represent column with datatype nvarchar(max) in MS Nav (there's the limint in 250 char.) As i…
-
LEFT JOIN
Hi I am using Microsoft Dynamics NAV 2013 , SQL server 2014 , Tableau Desktop I have created a new table which contains data from the Excise Rate, Location , Item and Item Unit of Measure tables in order to calculate Transfer Excise. Transfer Excise is Tax that we pay when our wine gets transported from one Warehouse to…
-
How to install Nav 2016 with the Always on feature of the SQL 2014 Enterprise ?
Need to implement Always on and the problem is that NAV will store data (licence) in the master database and that the master database is not replicated from one cluster to the other one. is it possible to replicate $ndo$srvproperty manualy by script ?
-
An ODBC error occurred, but no error information
SLQ 2008 R2 NAV 4.0 SP3 Scenario: Sales-post is called by a document, in codeunit 22, the insertitemledgerentry function is going into error on a random document line when it is called by itemqtyposting function. (although it's always the same line in a document, no relation between the different lines that give the error…
-
Cannot Open Dynamics NAV with a replicated Database!
Hi! Experts I was able to replicate an NAV test Database to another server instances. I used Transaction Replication. This was successful, whenever a transaction was completed in the original database, the results could be seen in the replicated SQL Database (e.g. posting sales orders). However, when I connected the…
-
Installation of SQL server 2012 on windows 8.1
Hello there, i was installing SQL server 2012 on my windows 8.1 PC then i got this error requesting that i enable Netfx3. visit this https://social.msdn.microsoft.com/Forums/en-US/2ab7b1b3-ed97-4d86-92ae-40d39399ab70/netfx3-error-while-installing-sql-server-2012-on-windows-8-pro?forum=sqlsetupandupgrade
-
SQL Server Reporting Services installation and configuration
Hello I was trying to explore SSRS for SQL 2012. I had problems with installation and configuration. I looked around the web for some solutions. The articles i found were helpful. You may visit http://www.sherweb.com/blog/installing-sql-server-2012/ http://www.sherweb.com/blog/installing-sql-server-for-reporting-server/…
-
Update Posted Sales Transaction Fact Table
I cannot use ISNULL , If you look at my screenshot I am trying to update the actual sales cost , sales support and sales cost , all these dimensions related to the sales amount(actual) , cost amount (actual) in the Value entry table my script to update the fields marked in orange on my screenshot is UPDATE [dbo].[Posted…
-
Altering the Collation of NAV SQL-Database not working - NAV 2015
Hey guys, after successfully upgrading our solution from 2009R to 2015 i've run into a problem with the sorting of fields. Sorting in 2009R2* AL-PHA * ALPHA * BE-TA * BETA Sorting in 2015* ALPHA * AL-PHA * BETA * BE-TA I've already changed the collation of the databse using the msdn Altering Databases - Collation Tab Guide…
-
How to automatically import Sales from another Software
Hello community fellas ... I am currently using a Rapidstart services to import sales from another software but now im trying to make an middle software for this regard... I have analyzied tables and columns but i need expert help if possible. Can some help me in this regard. I need to know which tables do i need to insert…
-
Create New Table and update table with data from another
Hi I have created a table in SQL , the table will contain selected columns from the Value Entry table in our NAV database. I do visualization in Tableau , however to do visualization with data containing the Item Charges is a bit tricky and difficult to add to the visualization in Tableau. This is the for me creating a new…
-
mdf file in SQL 2012
Hello everybody! I’m working with sql database for couple months. Today I have opened it and see pop-up window: “The header for file 'xxxx.mdf' is not a valid database file header. The FILE SIZE property is incorrect.” I don’t know what to do next, some ideas? Thanks in advance!
-
What technology to use to exchange basic sales data between server and POS?
Hello all, I need an advise from our experienced and valuable members, we have a task exchange data between sql servers. 1. From server /MS SQL 2012 standard/to POS database import basic information like customer, item, sales price etc. /no updates on POS/ 2. From 4-5 POS databases /MS SQL 2012 express/ to the server…
-
Report Inventory Value using SQL server
Hi all, I have to do Inventory Value report, using SQL. How to do this? Which tables and filds must to use? Thank you
-
Snapshot Replication Failure
Hi, Our snapshot replication just stopped working about a week ago, and I have been trying to get it running ever since. It seems to fail at the snapshot generation. I get error messages containing such things as "unable to read column". There are also numerous timeouts on various steps with the notation that they will be…