-
Print Image in Footer
Hi Experts, NAV 2009 R2 Classic - LS Retail I need to add image/picture in Footer in sales receipt. For that I have added one BLOB field(receiptLogo_Footer) in Hardware profile. Added below code in 99008910 - POS OPOS Utility codeunit in PrintBarCode function Now when I tried in virtual printer it is working well. i.e.…
-
Fix skewed SQL Server plan in C/AL
NAV 2009R2 I have a moderately large table with an indexed field that is tremendously skewed toward one value. NAV, of course, tells SQL Server to optimize for unknown, so SQL Server is choosing a hideously bad plan for the particular situation at hand. NAV Psuedocode: The query NAV is issuing looks something like:…
-
Gantt Server
Hi, we use navision 2009 r2 (Classic client) in our system and we want to work with Gantt Server control. In my pc, Windows 10 x64 I've tried to run the NavisionGanttServer.exe from instalation dvd path: "Microsoft Dynamics Nav 2009 R2\CsideClient\program files\Microsoft Dynamics NAV\60\Classic" But nothing happens, no…
-
Purchase Invoice
How to create Purchase invoice using import process. One header record and all the available rows will be invoice lines.
-
import text file
How to import text file by using report and when I run the report the data in text file is shown in purchase invoice....Any suggestions please its urgent
-
Reading a Text file in Navision
Hi All, I need to read a text file in Navision using a file variable. I need to read each line by line until End of the file. Please provide me a Sample code for this. Regards, Anil
-
C/AL programming
Hi, Can any one tell me how to be a perfect C/AL programmer...what steps i want to be taken...please any suggestions.
-
Form clear
Hi, I navigate my form from sales order menu item.My form source table is sales line table. while I navigate to my form.it shows already existing records.how I can remove these existing records please suggest me..
-
forms
I created a form using the sales line table and added the table in line menu item of sales order form.My condition is that when I open a form in menu item I should only see the value entered in sales order subform... I am using classic client nav 2009 r2
-
ExcelFormula from excel Buffer
Good afternoon together. I've the following problem in a classic report this is the CAL Code ... exclBuf.AddColumn('=SUMMEWENNS(.....'); ... when I start it with my user on a virtuel System the attached Error occurs. also with 'TEILERGEBNIS' or something like this other users on the same virtuel system did NOT get this…
-
Navision Load Testing
Hi, Has anyone ever used a load testing tool with Navision. I need to test Navision under a number of users. Is there a tool available to stress test the system. If not what procedure have you used to do the above? Thanks in advance Peter
-
C/AL program
Hi, CommonDialogMgt.OpenFile(Text006,'',2,'',0); can any one tell me what is the meaning of this code
-
Import excel sheet
Hi, import data from excel.
-
Start navision from url in excel
Hallo, Each time when I click on an url (link to a form in navision) in excel, navision starts and i have to logon with username and password. Normally when navision is open the form should be shown immediately. What could be the cause ? Thanks for your help ......
-
HOW TO RESOLVE THIS ERROR "THERE IS NO G/L ENTRY WITHIN THE FILTER. FILTERS: ENTRY NO.: 0..0"
This error occurs during posting of received items with purchase order
-
how to use one table field to another table
Hi, I want sales line values to another table.
-
Posting
Hi Experts, How to write the code for posting the item charges in background while posting the item in sales order As I have created a field carrier charges in sales line and in sales order sub form I added this field, when I am posting the item in sales order the carrier charges should come as item charges, the new line…
-
How to Print Barcode in Navision
Can anyone tell me how to print barcode from navision.
-
OPC-Interface NAV <<>> OPC server: "The RPC-server is unavailable"
Hello together with the classes of QuickOPC-software I have to send and receive information of sales orders between NAV2009R2 and an OPC server. The information of sales orders are collected in a buffer table and should be transferred to the OPC server by NAS with the help of a codeunit. Lots of configuration in different…
-
How do you change 1 item variant to another without an item journal
We are moving a company that make rubber bales to NAV 2013R2 now. They only have a handful of items, but requires many variants (+-15 per item). *BUT* they need to move the bales between variants without item journals, i.e. only as a warehouse movement. What would be the best way to achieve this? Thanks
-
sales order form
I should create a form which is related to sales order subform with fields like type, no, quantity, qty to ship. This form should attach to the menu items in the sales order. My condition is that when I press the menu item in sales order I should see the form and when I enter values in that form and press ok menu button…
-
How to check if Rec IS TEMPORARY
i need to write-protect a table but still want to allow writing to temporary version of the table is there a way in table's code to check if the instance of a table is temporary ?
-
C/AL code for adding new line automatically
Hi experts, How to write the C/AL code for adding the new line of item charges automatically without using the insert function in the code?? Please suggest me the code Thanks In advance
-
how to filter two fields
Record.SETRANGE(Field [,FromValue] [,ToValue])// this is the setrange functon syntax ZIPCGRec.SETRANGE("Post Code",ZIPCGRec."From Zip",ZIPCGRec."To Zip");//this is my form syntax here post code is a field not in ZIPCGRec table....is my code is correct or wrong
-
Based onZip codes sales/service amount calculations
Calculate sales/service charges on ZIP
-
NAV is running slower on windows 10 than on windows 7
We are using NAV 2009R2 Classic Client and decided to upgrade to windows 10 Professional. Our users have noticed that NAV is running slower than on windows 10. Every other program runs great except for NAV. Any ideas why this would be or how to resolve this issue? We have tried disabling onedrive and using the performance…
-
Sales Tax Filing/Area code update software
Hello folks, I was looking for some input on what other people are currently using for sales tax software. Currently we use Tax Bridge, but they were bought out by Avalara and support for the old version is ending. I found some threads in regards to this on here, but they were older, and since things change..well you know.…
-
C/AL code for posting the item charges on the fly?
Hi, Experts How to post the item with item charges without selecting the charge(item) in type field, I wish to select only item in type field of sales order. can any one please suggest me the code for it and where I have to write this code Thanks In advance
-
Remove Carriage Return from the string
Hi guys, I have a quick question. How do I remove the carriage return from the text string before writing it to the file? Thanks! Oleg
-
How to pass parameters.....?
I want to pass zip code in sales order form to another new form..but I didn't create that field in new form....plz suggest me how to pass