-
Use TableFilter Field as Filter
Dear all, If I have a field which has TableFilter DataType so that user can set the filter for table by them self. How do I apply this filter value into filtering the real table ? Is it possible to do this ?
-
Hi, I have a column in my report which is not in the dataitem/table, but I want it to filter.
Hi, I have a column/field in my report which is not in the dataitem/table but I want users to be able to filter for records in the table based on the value in my field. The values in my field are gotten onaftergetrecord. Any help?
-
report bilder
Hello, I have MS Dynamics NAV version W1 10.0, I would like you to point me to an application with which I can edit the layout of the reports. Thanks.
-
help for a barcode font
i have to do a report with a barcode in format pdf 412, where i can find this font free?? thank you
-
Why does a team member's licence not allow a user to create purchase orders via sales orders?
What is the proper user licence for users?
-
One or more return document lines were not copied. This is because quantities on the posted documen
Hi, how to reverse a transaction for this? Thank you.
-
NAV 2009 RTC Export to Excel not working occasionally
Hi there everyone! I have a user who uses CTRL+E to export sales orders to excel and this works normally but every so often this stops working. When attempting to export the blue busy circle is appearing briefly but it isn't opening excel or anything. I've attempted exporting the same order on my machine and it works…
-
GetRangeMax and GetRangeMin
Can you explain the Both Function give me the examples and where should I sue this two function while develop the code what is the use of this two
-
How to subtract current value from previous value in a column
I have a column that i need to subtract a current value from the previous value and save the result on another column. The value is incrementing instead of decrementing. Here is the image of what i want to achieve This is my code:LastDailyReturn := 0;
TempFundPriceNew.RESET;
TempFundPriceNew.SETCURRENTKEY("Fund…
-
upgrade Server version
Hello Guys. I need your help. I need to install my old navision server into a new Virtual machine , I've installed the Client and server. classic is working well but when I open RTC . I got this error. My question is , how can I upgrade de server version and where I get the upgrade.
-
I don't see automation dbOleWrapper.ocx in variable editor on Win10 x64 or Win Server 2019 x64
Hi. I need to use some automations methods in Classic Client. And some of them are params of type SAFEARRAY. So I downloaded here component "dbOleWrapper v 0.2". Then I copied dbolewrap.ocx to C:\Windows\SysWoW64\ and exec by admin:%SystemRoot%\SysWoW64\regsvr32 C:\Windows\SysWOW64\dbolewrap.ocx I recieved message that…
-
Can a payment be applied to specific invoice lines? Can you query for that if it is possible?
I'm using Navision 2009 R2 and querying in SQL Server, can I find if a payment was applied to specific invoice lines (assuming that's possible)? Here's what I'm currently querying:SELECT pmt.[Entry No_] , inv.[Document No_] , d_inv.Amount , sil.[Line No_]
FROM dbo.[<Company>$Cust_ Ledger Entry] pmt -- payment entries
INNER…
-
Links
Hi there, I created a codeunit to insert links where I use ADDLINK etc... when I try to open the link in Nav it says "Link address is not valid" but if I add it manually the same link is OK. When I look at the Link record (See pic) the entries added by my codeunit looks exactly the same as the one added manually except…
-
Add new field in the form from other table to be used as storage once data is posted
Hi, I would like to seek help from all experts here. In the Warehouse Receipt Header form, I wish to use one of the fields of the Purchase Header table into the said form so that I can input remarks and these remarks can be seen in Purch. Rcpt. Header table upon posting. Thank you in advance experts.
-
Can't connect to sql server via NAV 2009 classic
Hello, everyone. Here's the story. I've created two machines on HyperV, "Client" and "SQL-Server". On "SQL-Server" I've installed ubuntu server, and mssql on this server. Restored company DB, set sql authentication. I've got access to DB via SSMS, sqlcmd, Azure studio on all machines, but in NAV 2009 classic client, I…
-
SQL 2008 vs AutoIncrement
Hi I' ve a SQL Table which contain a field IDREC as primary Key with property Identity = yes When I try to open the table in Nav 4sp2 I receive the following error : "The Table xxxx contain a field which Autoincrement value daesn't match IDENTITY status of SQL Server : field IDREC" Navision AutoIncrement property is set to…
-
how to add a QR code
How to add a QR code NAV 2009 R2 Thank You
-
Change LCY in a company
Hi, Our customer is using NAV 2009 R2 and in one of the companies in the database, the (blank) LCY code should be changed from th national currency to EUR. As we see it there are 2 options: * Use "Euro Conversion Tool". MS has a tool for NAV 5.0 but we have never used it before and the database is highly customized. *…
-
How to install eksisting Dynamics NAV 2009 R2 on a single client..
Hi. Hope that somebody could guide me in how to install our eksisting Dynamics NAV 2009 R2 on just a single client.. Reason for this is that it runs on a server today, but as it is only used for looking up old data as it is not used anymore we want to take and just have in on a client instead. It is version DK 3.70.A…
-
HttpWebRequestMgt.AddBodyAsAsciiText is working HttpWebRequestMgt.AddBodyAsText not!
Hi All, I'm using HttpWebRequestMgt with a json body to call a rest api. It works when I add the body with function "AddBodyAsAsciiText", but i want to send some text in german and that is not working with special chars like ä ü ö. So i tried to use AddBodyAsText, so the text is utf-8 encoded. But then it's not working…
-
problem about VAT while transaction in LS Retail-POS
Good evening, I have a problem about VAT while transaction in LS Retail-POS. When I want to starting create transaction by calling an item, an error message occur "invalid VAT setup on item" I have already check my VAT posting setup, but I found nothing wrong with the setting. Can any body help me please.. Thanks before…
-
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.
-
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 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 ?
-
Surcharge over Line Amount in Table 37
Hello, one of our customers has commissioned a surcharge that is to be calculated as a percentage of the sum of all line amounts in table 37. The line amounts are changed in various places, e.g. by changing the quantity, the ex-factory price, etc. This surcharge would therefore always have to be updated if the line amount…
-
Bin Quantity - SQL
Dear All I am trying to pull in to Excel the current quantity in each Bin Code using SQL and the Nav db as an external data source. Can anyone advise which Table holds the current bin quantity for items. We are using the Warehouse module
-
MRP Planning Worksheet, show the reservation Production Order Number
We have a small number of purchased items where the Reordering Policy is set to Order. We use this so that an automatic reservation is created between the requirement (Production Order) and the corresponding purchase order. This works well and when you examine the resulting purchase order you can see the Production Order.…
-
First Day of the Month
Hi Say, DateX is a date variable holding some unknown date. How do I find the first day and the last day of the month in that date variable? TIA Maluwa
-
is there anyway that i can mark checkboxes in word from navision 2015?
i created word template where i have some quick parts, i wrote code to fill quickparts and it works but i also have some checkboxes that i want to check based on option field value that user chooses, i couldnot find any solution for this.