-
Insert records in same table
Hi I have Main Form (Location) & SaleDeposit SubForm (Source table is SaleDepositLines) . I have 1 Button . On Push Trigger of Button I want those lines which have ReceiptAmount > 0 should be inserted in same table SaleDepositLines. I am trying below code but not working CDLine refers to the same table which Subform refers…
-
How to read Data from Subform
Hi https://imgur.com/scLGnHa I have Main Form (Location) & SaleDeposit SubForm (Source table is SaleDepositLines) . I have 1 Button . On Push Trigger of Button I want those lines which have DepositAmount > 0 should be inserted in same table SaleDepositLines. I am trying below code but not working CDLine refers to the same…
-
Validation
Hi https://imgur.com/scLGnHa I want if Deposit Date is not empty then it should be validated that it should be >= Date & <= Work Date Thanks
-
Use variable in IN statement
Anybody succeeded in using a variable with a IN statement? Sort of IF AnyRecord.Field IN [TextVariable] THEN ... where TextField should contain something 'VALUE1,VALUE2,VALUE3'. Thanks
-
Simple Question - IN Statement
Hi master, Is it possible to use "IN" statement for choose range of value? for example, If GLAccount."No." IN ('50000..51000') then ... I've already tried but cant. Maybe there is something missing in my code. Please advice.... Thanks
-
Set Series number according to user logged in
Hi everyone, I need to set a document number using the last series number used according to the user logged in the NAV system. So I have the user1 and user2 and for the first user I want to use the series "MRVRPOS1" and for the second I want "MRVRPOS2" I thought to create a var to save the last series number and set to the…
-
Undo Receipt when Transfer Order was made
Hi, I am new to NAV and I have read many topics about my problem, tried many things. Sorry for my English, I will try to be short. Here is my problem> I purchased some Item and then transferred to other warehouse (B for example), within my company. The I saw that my Vendor is wrong. No harm done, I have 1pcs item in B…
-
Is NAV 5.0 Update 2 Compatible with sql server 2017?
Dear all, Navision 5.0 Update 2 is compatible with which versions of SQL. Please let me know. Thanks in advance. Regards, sekar.
-
Report in Nav 2017
I am creating a report that will get data from two pages with the same table. Both page contains the PIN as field But Reason exist code of one =5 and other = 13.
-
LS Retail - NAS Scheduling
We are working with LS Retail POS, we need to replicate the data from stores to Head Ofiice Now we are running the manual job from stores as the End of the day activity. Now we need to schedule the same NAS before the store closing time. The NAS is running properly with the given parameters but the job is not working. Can…
-
Update Main form from Subform
hi all, I want to know is it possible to update the main form from subform please tell me how.. thnx...
-
Record shown in title-bar
Hi all, Nav 2009 Classic - 1st. record is shown in title bar on a form - how can I avoid this. I have seen how to some years ago but cannot remember how and my search didn't give me any results. Anyone knows how to? Thanks in advance
-
Error 183 in Navision 4 DB
Folks, My navision 4 native Database just CRASHED, and it can't be open. Anyone knows how to resolve this?! Please help! [-o< Jemmy
-
Hesitating debugger
Hi all, 2009 - classic. When using the debugger it seems to hesitate and only move forward if I continously move around with the mouse. Rather annoying. Do anyone know the cure for this? Thanks
-
Export menusuite
Is it possible to export the menu in the menu suite. I need the structure of the menusuite in excel for other purposes. I hope somebody has an aswer for me Greetz, Mark Landman
-
Post negative quantity invoice
Hi Guru, I tried to post sales invoice with negative quantity, but is not record in posted entries.
-
RelationShip Between Tables
Hi How the data flows between Trans Infocode Entry , Trans Sale Entry Status , Trans sales Entry , Transaction Header. What is the relationship between them i LS Retail. Thanks
-
Newbie needs help with "A value or expression was expected."
I have created the following code. I am just trying to return a variable in a report. The two tables are the tables in my report the variable I am trying to get is in the main table and I want to use it on a line in the body of the secondary table. IF [Item Ledger Entry]."Item No_" THEN BEGIN PubDateV :=…
-
Create Purchase Order from Sales Order(Copy Sales Lines in Purchase Lines)
Hi all! I have to create a Purchase Order from Sales Order with C/AL. I create so far Purchase Header but I am facing problems with Purchase Line. Please can you help me how can I copy fields from Sales Line of Sales Order in Purchase Line of my Purchase Order? BR, Maddy.
-
description field character limit
Hi, I am just starting to learn NAV Classic after joining a new company. Every field seems to have a max character limit of 50. I deal with configured part #'s that are frequently more than 50 characters. Is it possible to increase the character limit in the description field on POs and SOs? This limit significantly…
-
"A value or expression was expected."
I'm trying to set in my report a expression depending of a boolean but i cant linked the expression to my global var aux. proforma Boolean aux Text To turn around this problem I tried to create a column and with a/c code I set the column value depending of a boolean anyone can help?
-
Creating Replication counter field
Dear Experts, We are using NAV 5 SP1 along with LS Retail 5. We have issue updating Prices stores The jobs are being pulled from stores using scheduler server. I have tried by action method and even tried normal method by keeping the filter as "Starting date" ="W" and "T" which works on today's date. Which i beleive…
-
Report Layout Mismatch
Dear Sir, Same report generating two different Print Layout when User Print from two different position. 1. After Report Preview 2. Before Report Preview What is the reason behind it ? Kindly reply. Thanks, Navuser1
-
Report for Inventory Received during a date range with quantities, costs, and totals
Is there an existing report in Nav 4.0 SP3 for Inventory Received during a period with costs? All I need is to show received dates, quantities, costs, with totals for a given date range. If not, what's the fastest way to create one?
-
TLS1.2 in Classic
Hi With various internet services changing to only allow TLS1.2 communications, does anyone know how to do the equivalent of System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; in NAV2009, as this is a dotnet command which will not work in the classic environment. We have a customer who this will…
-
E-Mail Validation
Hi All, Is there any way to validate the entered E-Mail id, :?: Thanks in advance. =D>
-
Is there a means in MS Dynamics NAV of knowing all the tables used by a program?
Is there a means in MS Dynamics NAV of knowing all the tables used by a program without going to the program code?
-
How to filter unwanted data
Hi, all. I'm new in Nav. I faced a doubt. I don't want display the "NCB discount" in the report. How can i filter the unwanted data? Anyone can give me hints? The data is get from this table
-
link b/w customer or vendor table with G/L entry table
Good day to all, I am having a field in G/L entry table "vendor or customer name " which should be populated when "G/L acccount name" field is given as Vendor or customer. So here is my exact Question i need to know the link between customer Or Vendor table with G/L entry table. once it populated in G/L entry table it…
-
Why would I not have an invoiced QTY on a Finished Prod Order?
A production order was Finished, with consumption and output, however the value entries show an invoiced quantity of 0. When the Adjust Cost was run that night it stopped with an error there is not enough memory that can be caused by a recursive function. After running the Adjust Cost without that item Adjust Cost ran all…