-
Field format dataport export to excel
Hi, I'm trying to export a text/code field from navision to excel(csv), but the problem i'm facing is that the field is not formated properly when I open the excel sheet. Eg. In navision the field contains something like 100210201011 but in excel it appears as 1.0021E+11. Any way i can get the field to be exported…
-
Mail Error when using Citrix
We have a 2.60.b database running with a 5.0 SP1 client. When I use the Mail codeunit, it works fine for anyone logged in via the network. When anyone is logged in via Citrix, the following error appears when the Mail codeunit is called: THIS MESSAGE IS FOR C/AL Programmers: Could not create an instance of the OLE control…
-
MODIFYING PAYMENT DISCOUNT DATE
I am trying to modify payment discount date on Vendor Ledger entry so that the discount value is taken even if the payment was late but cannot change the date. I have checked the fields in vendor ledger entry table and they are editable. So why am I not able to change the date?
-
[solved]Custom Dataport Request Form
Hello We have a problem with a custom dataport request form, Navision 2.6 native. This works ok http://www.mibuso.com/howtoinfo.asp?FileID=4&Type=howto When set the direction to export, a problem arises: Browsing for export-file, we get the error "file xyz.txt does not exist", altough before currdataport.import was set to…
-
Installing Navision 2.60 on a Windows 2008 Server
Has anyone sucessfuly accomplished this? Every time I try to install Navision Server on a Windows Server 2008, I get an error that server.exe has been stopped.
-
Back up Restoration
Dear Friend , When i restore the back up i get the following error ,kindly help me in sorting it out. You cannot delet or change the type of the description 2 field ( in the item table) before the value in the field is reduced to 0(zero) or " (blank) in all records. This message occurred because a nonzero value was found…
-
Sale order
Hey Friends Is there any way of finding or filtering sale order based on Item number. Hope to get a solution for this too Thanks Vijay
-
Item Master
hi all, Item Master in Navision is common for both Sales and Purchase, it there any option to define the item as Sale item , or purchase item or Both. so that the same can be filter in Saler order ( any sales process) & purchase order ( any purchase process) Cheers Vijay
-
How can I upgrade Nav 20 to Nav 40 SP3?
Hi, I would like to upgrade Nav 20 to 40SP3. Can someone tell me how I can do this? Thanks in advance, JBeck
-
Return Order
Hi all I want to make Return order but the quantity that I want to make Return order was transferred in another warehouse and now it is closed. How can I make apply to the entries of the initial Purchase order as I can make correct Return order. Do I have to make reverse to the transactions that made initial entries closed…
-
Euro Conversion tool for nav 2.0
Hi there, I'm searching for a Euro conversion tool for Nav. 2.0 . Can someone please Help me? [-o< Thanks in advance, JBeck
-
Dif b/w posted Sales shipment & posted Whse Shipm
Hi Friends, Can someone tell wat is the difference between Posted Sales shipment and Posted Whse Shipment, When i posted shipment it gets updated in both. Regards Sam
-
Depreciation schedule for IT act
How to generate Depreciation schedule for IT act report from Fixed asset. I given the Start and End date for the particular period, but its not generating. Can anybody say me..
-
upgrade 2.6 to V5SP1
Hi, I'm currently upgrading a version 2.6 financials DB to v5. The first stage of this is to upgrade to V4. Using the upgrade toolkit for this, I seem to have run into a problem at the stage 'Upgrade 4.00 Step 2' transfer data. I keep getting the following error 'Temp Cust. Ledger Entry Entry 'No.' 1 doesn't exist.' I've…
-
Navision Financials Server Can Be Crashed Via the Network
Hi, I have a big problem with Navision Financials 2.60, it was the server is blocking continuously and I have to reboot two times to make it work. I found online that is a port 2407 problem but I'm not sure what I have to do. Can you help me? Thanks a lot
-
Entries marked OnHold included in a reminder
Hello everybody, when creating a reminder, entries marked 'OnHold' appear under certain circumstances. In the online help it reads: "When you run the Create Reminders batch job or the Suggest Reminder Lines batch job, a reminder will not be created on the basis of an entry that is On Hold. However, if a reminder is created…
-
Add a picture to an Excel file without exporting it
Is it possible to add a picture in a report to an Excel file without exporting it? IF CompanyInfo.GET THEN;CompanyInfo.CALCFIELDS(Picture);IF CompanyInfo.Picture.HASVALUE THEN BEGIN CompanyInfo.Picture.EXPORT('C:\logoNavision.BMP',FALSE); LogoCreated := TRUE;END; With this code I export a picture to an excel file, but the…
-
EDI for Navision 2.6
Does anyone know of any 3rd party products for EDI for 2.6, other than Lanham? We would prefer to stay with our own VANS.
-
Upgrade 2.50 to 5 SP1 no objects only executables
I need to do a runtime upgrade from 2.50 to 5.0SP1. My agenda is: 1. Do backup of current db 2. Test current db (File->Database->Test) 3. Restore 2.50 backup into 5.0SP1 4. Test db in 5.0SP1 (File->Database->Test) 5. Upgrade server 6. Upgrade clients 7. Process testing by users Is that all there is to it? Is there anything…
-
Invoice Discount
In Customer table id 18, Field Invoice discount Code has Table relation of Customer Table instead of Customer Invoice Discount ( Table Id 19). Please tell me if it is correct, if yes, then what is the relavance of Look up in Customer Table If we want to make the Customer Invoice Discount % for a particular Sales Order for…
-
Project Dimension
Has anybody used Project as a dimension?
-
Upgrading from 2.60F to 5.1
Hello there, I´m from Spain and I´m upgrading from 2.60 to 5.1 and I must to migrate previously to 4.0 SP3. The problem is that in the "Transfer Data" step in stage 1 the speed is too slow. It is spending DAYS to do the task. Table 32 is huge, more than 5 millions of registers. Please, could you tell me how can I reduce…
-
Wht
1. when i want to post payment that have wht payment and i didn't check skip wht in Payment Journal. There is error "Inconsistency in G/L Entries". But if I check the skip wht payment i can post the payment journal. Does the error because the wht? anyone know what is the journal for payment that have wht and the skip wht…
-
MAPIMensajes.Action
hi all, I'm trying to generate an email using the cdu 397. I create the message with the opendialog property set to false, but Outlook system opens a confirmation message with the followin text: "a program is trying to send an email in your name..." Anybody knows how can I eliminate this message? Thanks
-
Printer routing
I have a specific requirement of Priter routing. I would mention the priters as per priority. If the 1st printer fails to print the navision report, it should get redirected automatically to the next printer and so on. How can I achieve this?
-
Child Vendor to pay Parents Invoice
We have two child vendors of a parent vendor. The invoice is received from the Parent but the payments are to be made to the child vendors. This is the reverse of the standard setup. Has anybody done this or have a clean work around that doesn't involve remembering to change Vendor card settings?
-
Number Series
Hi friends I have a problem in number series, In number series setup, the Number given in for posted Shipment S-001,and the shipment crossed S-999, the number series is properly generating but in list view S-1000 is shown below S-100 and not below S-999. Can someone suggest some solution for it. Thanks
-
Standard month end and year end procedure
Hi Expert, May I know the standard month end and year end step in NAV? Thanks!
-
Upgrade from 2.50 DE AddOn to 3.70 DE
Hello, I need the upgrade objects for 2.50 to 3.70B (German Version / AddOn database) Can anybody help me? Cheers Jörg
-
Change Posting Date for Posted G/L Entry
I used to know this, but I'm having a senior moment. Scenario: An unpaid Purchase Invoice was posted to the wrong month. User goes to the General Journal and credits the expense account on date posted and then balances the entry on next line, using same account and correct/different Posting Date. But, the General Journal…