-
How can I create a decimal field that multiplies every user entry by (-1)
Good day. I wanted to ask, how I can implement a negative field calculator. For example, if a user enters the value 6, the field auto calculates this entry to -6, and if the user types -3, the field auto calculates the result to 3.
-
Add Validation on PAN no. Field on Vendor
I want to add validation i.e PAN NO field only allow 5-Char,4-Numbers and 1 Char otherwise it's gives an error message e.g - PAN No. = AGHCC6789V
-
agent.exe
Hello, Is there somebody who knows what the functionality is of the executable "agent.exe" in the client directory of Navision ? Thx in advance
-
How to send pictures to Excel in NAV 5.0?
Dear all, I gone through one blog and followed the steps. Created a function in excel buffer table ExportPicture CompInfo.GET; CompInfo.CALCFIELDS(Picture); IF CompInfo.Picture.HASVALUE THEN BEGIN FilePath := ENVIRON('TEMP') + '\IMG.bmp'; CompInfo.Picture.EXPORT(FilePath); END; ExcelBuf.ExportPicture(FilePath, 1, 1, 0,…
-
TDS on Advance payment to vendor
Hi All I want to know that whenever we are giving the advance payment to Service vendor in which TDS is applicable. When the System post the transaction in the navision it will post the TDS amount in the G/L entry correctly. In the vendor ledger entry it will not show the payment entry as deduction of payment after TDS…
-
Print BLOB file to Printer
Hi All, 1. Is blob field only for 1 file? 2. Is it possible to get blob data (pdf file, image file, text file, etc) and print it to default printer without open the file ? If No 2 = Yes then please let me know the pseudocode.
-
NAS is not printing report to printer
Hi, I have created a codeunit in NAV 2009 finsql to print the Packing list report through job queue when I manually run that codeunit it runs without any issues and prints the report in printer which I selected in Printer selection. But when I run it through NAS, the job queue status gets stuck in "In Process". if i…
-
Call to DLL fails on NAS but works on client
Hi, I have created a DLL wrapper NAV2009FTP around WINSCP so I can call it from a NAV2009R2 classic client and NAS. It works perfectly on the Classic client on my computer. It works perfectly on the Classic client on NAS computer logged as as the user that runs the NAS service. It fails when the job is run in the NAS with…
-
need help - outlook client - nav 2009 - sync
HI, i am trying to setup Outlook Sync with Nav 2009. we are using Database logins due to mixed environment. some workstations are domain memebers and some are not (salespeople). but i need the contacts of the sales people in nav now. can anyone help? thank you
-
LS Retail customer's receipt annulled
Hi, We presenting an issue with the LS retail. This one do not make any sale on the system, when you try to make it the system print on the fiscal printer (Annulled). This hardware is new (the fiscal printer), the other one spoiled. i searched all the configuration but everything looks fine. maybe i'm skiped a step.
-
ls retail module compatibility
Hi everyone, I've installed the ls retail module in nav 209 version 4 sp3 to work as a pos. Although when I enter in the pos system it pops the error "Transaction error in receipt no xpto". The problem is that receipt no is temporary, it doenst exist in the system. My tough is that ls retail 4.24 (which I've installed)…
-
NAS not printing
Hi there, I have a problem with printing through NAS. I have setup the printer for the NAS user in the Printer Selection table. If I log into to the system using the NAS user login details, I can print just fine, but as soon as NAS gets to the code where the report is suppose to print, it just hangs, I cannot stop the…
-
Setup a Job Scheduler in NAV 4.0 SP3
Hi, I have to setup a job scheduler for NAV 4.0 SP3. After some research I understood that for this I need to use the automation 'Navision Timer 1.0'.Timer in a single instance codeunit. Problem is, I don't see this automation in the client, and if I import an object that has it (for example the codeunit Job Queue…
-
Error mscorlib
HI everyone, when trying to register a new invoice I'm getting the error below In the folder C:\Windows\Microsoft .NET\Framework\v4.030319 I have files like mscorlib.dll Anyone can help me pls?
-
accounting schedule year to date reports wrong numbers navision 5.0
good day, year to date column layout in accounting schedule for dynamics Navision 5.0 pulls out numbers that include previous year data and data till current period. the comparison date formula is left empty, but still does not pick up based on the date filter provided. any help. month to date works ( comparision date…
-
Copy report layout don't print exactly as the copied one
Hi everyone, I have two different objects and I need to copy the report layout (header + body + footer) to the other report layout. I'm able to copy and the properties of header / body and footer remain the same, the problem is when I print the layout it starts printing in different pages instead of one (from where I copy…
-
Problem with Object Designer and filter
I have problem with Object Designer which works wrong ... Problem: I run Object Designer I set filter on for example Version list *Something* (the filter can on any fields in object table) I change field Modified for one record or Version List or anything. .. and filter is gone. I see all tables twice (TableData and…
-
LS Retail - Data Director
Hi, I have a question regarding a setup we are doing at a customer. We currently have an installation with a HO database running SQL and NAV 2009 clients. Then we have stores running Native DB and NAV 2009 R2 clients. This has worked fine. Now we are moving one of the stores to a SQL DB instead, but keeping the R2 clients…
-
Payment Journal Template / Recurring Journal ?
Every month I have a payments journal which tends to repeat Payee / Amount Is there a way to set this up as a recurring variable payments journal? Thanks
-
How to create an error message when Dataport import an Empty file ??
How to create an error message when Dataport import an Empty file ?? I am importing CSV file using dataport, If file does not contain any data it should throw an error.
-
How to count distinct records in a table?
Hi All, I have a table with "Table Name,Employee No.,Line No." as keys. You can enter the same employee no. more than once in this table. Now i want to count the employee numbers in this table onces. for example, If i have 1222, 1222, 1222, 1333, 1333, 1444 employees numbers recorded in the table, i want to count 1222 as…
-
How to create a process only report to create Posted sales invoices data explicitly?
Accidentally we got our posted invoices deleted how to explicitly enter data in Sales invoice header and sales invoice line by a process only report?
-
BigText on nav classic forms
Hi All, Is there any chance of using BigText as datasource for a textbox? I´m speaking about forms, not pages. I´ve just realised that I won´t be able to read a blob into a bigtext type variable, I would need to split in text (1000) type variables. thanks.!
-
Error message hijacking my message popup.
I want to display a message to the user, letting them know why a page cannot be edited. But when I put in something like:OnAfterGetCurrRecord() IF (CurrPage.EDITABLE = FALSE) THEN MESSAGE('some message'); Then i instead get an error message saying: "Server page is not open. Page <page name> must close." (<page name> being…
-
Purchase Order to General Ledger Entries
Hello, Good day. Newbie here. Every time Purchase Order is posted it will create a new Entries in General Journal Entries and posted purchase invoice. Now, I cant find the function or block of code for for Purchase Line to General Journal Line to G/L Entry. I keep on debugging but it seems I can't find it. I need your help…
-
Error when invoicing partially shipped sales order after applying item tracking
Hello, When trying to invoice one of our sales orders, I get the error "Item Entry Relation does not exist. Identification fields and values: Item Entry No.='0' ". I have figured this is due to item tracking. When opening item tracking for the sales line on the sales order, the unassigned qty = 1, which I read can lead to…
-
Issue in running automation from Citrix.
Hi Friends, [Version: NAV 2009] I am using automation feature in NAV to trigger a batch file in server local folder. Below is the code am using and it works well when I try to run an .exe file from NAV in server through remote desktop. IF ISCLEAR(WSHShell) THEN BEGIN CREATE(WSHShell); WinStyle := 0; WaitForCommand :=…
-
PDF995 64 Bit on Windows 10
Hi Folks - One of our adamant customer who does not want to upgrade are on NAV 5.0 and they are using PDF995 to email Sales invoice using NAV wherein a report has been created that uses PDF995 and it attaches the invoices and sends it out without any issues. They were using Windows 7 32 bit and there was no issue. Recently…
-
Payment Services in NAV 2009 R2
Hello, I read article about Payment Services on the link below and wonder why I couldn't find any forms or tables related to this Payment Services. https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2009r2/gg502506(v=nav.60) Like on step 1, I couldn't find the highlighted on my Administration menu: What did I…
-
Advice and VAR to discuss Upgrade from NAV 4.03 to ?
Forgive me if this is posted in the wrong place. I see that plenty of companies are running NAV 4.03 and 5 still in 2018! I have a client using NAV 4.03 native database. I would like to have discussions with some VAR's regarding the best way to upgrade in the near future (1 to 2 years). There are customized objects and an…