-
lettering general accounts.
Hi; Please can any one help me. is it possible lettering general accounts in Navision 2009 R2? thx
-
Size of a list of article in a invoice report
Hi, I am trying to design a report, with the list of article corresponding of a Invoice. And I am trying to put them all in a list element. But, when I got just a few element, my list just got the size of the number of element... And I would like to have a fixed list size, for exemple, the half of my page, and fill this…
-
moving filters from one FILTERGROUP to another
A form is called with some filters in FILTERGROUP(0). I don't know which fields have filters. In OnOpenForm(), I would like to move all filters to FILTERGROUP(200), as I do not want users navigating to this form to be able to change the filters that were passed in. First thing I tried was: myrecordref.GETTABLE(Rec);FOR i…
-
Fob build version indicator ?
When importing a fob from a different version NAV will give you a warning: "The objects in this file are from a different version of Microsoft Dynamics Classic. If you continue, the objects will be recompiled which may leave the system in an inconsistent state. Do you want to continue?" But sometimes, you just want to know…
-
Implementing NAV Security
Hi Everyone, I am implementing Security for one of our clients. The client is on NAV 2009 R2 and they use RTC. This is what I came up with. Rather than creating a Permission for Read, insert, modify, delete, execute permission for each Role/table data. I was thinking about making everyone a super user (aka all the users…
-
Export list to xml
Hi everyone! I'm trying to export a list to xml but the xml port has to be dynamic length meaning only the user knows how many items the xml will have. Is there a way to add nodes to a xml port from c/al code? Or is there a way to create a full xml port from c/al code? I hope the question was clear I appreciate any advice…
-
EXPORTOBJECTS / Object."Blob Reference".EXPORT
Hi all, Version: NAV2009 R2. Issue: Export "Blob Reference" to Text File from a new table "Object Version". I've started working in a project where a new Table "Object Version" is used to Store a Backup/Version from the changed objects. The table is similar to Table "Object" but with a new field "Version No.", this field…
-
Different OptionString values per different Company
Hello, I have an option data-type custom field in the Customer table. Would it be possible to have different OptionString values per different Company? Thanks
-
Get older Last Direct Cost of an item
Greetings all, I currently need to retrieve the average of an item's Last Direct Cost by month. According to this piece of code, we can get it from Purchase line as hinted in the help file: http://mibuso.com/forum/viewtopic.php?p=206243#p206243 However, I am not sure if this is enough... Does it get updated right after a…
-
National letter 'ø' missing in the classic client
Hi, I have installed NAV 2009 RT2 SP1 on a US version of Windows Server 2008 R2 standard SP1. In the classic client the danish letter 'ø' is not shown correctly, but the danish letters 'æ' and 'å' are shown correctly. In the RT client all three letters are represented correctly. I have tried to uninstall and change…
-
CSV from Excel Automation
Dear All, A dataport is customized to create a csv file. After that a third party tool consumes this csv file for internal use. Dataport has the following propertities . 1. FieldStartDelimiter =<"> 2. FieldSeparator = | As dataport is not acceptable in NAS environment & the client does not have xmlport executable…
-
the unit cost on item card is displaying wrong value (FIFO)
Hi all I am using FIFO method for inventory items and there is one item in particular which is having a very strange behavior in the Unit Cost field. I have some transactions on this item and always the cost was 12000 or 8000 ALL. I check all the entries for this item and confirm that the cost on the transactions was only…
-
Intermec Printer Integration with Ms Dynsmics Nav 2009
i have an intermec printer that i want to integrate with microsoft dynamics Nav 2009. i want to pass readable information from microsoft dynamics nav 2009 and have it printed as barcode lables by the printer. microsoft is a partner of intermec printers. how can this be done? i assume there is a dll one needs to call to…
-
Configure NAV 2009 Classic client
Hello I have installed Microsoft nav 2009 R2 classic with native database on a server and have installed same client on several PCS. But when I tried to connect to the database from the pc, it cannot find the server. Is there any setup to add on the windows system etc/hosts files? Thanks for help.
-
Problem on Amount while posting Credit memo
This is the first time I faced the problem. After Posting Credit memo, In Detail Customer Ledg. Entry table Amount and Amount "LCY" Field is zero but "Debit Amount", "Credit Amount" have the correct values. Is there anything I missed or its a bug of system. Dynamics NAV Classic 2009 SP1
-
Deleting tables in NAV2009 R2 not permitted in license
After restoring a backup (without objects) in a standard NAV 2009 R2 database a lot of tables have been created in the 5012xxx range. These are tables from the customer's previous NAV partner that have never been used by the customer. For some reason NAV adds these tables to the backup (.fdb) even though they are empty and…
-
Font on Navision
Dear all, I have a question about font on Navision. Default font on NAV 50 is Tahoma, but i dont want this thing. Because i want to use VNese font like VNI-HELVE. If i want to do that i select each control (Label,Textbox..) and change font of it. It takes time so much. I wonder how can we change the default font??? It is…
-
Dimension interval for G/L Account
[Moved from Navision Financials] Hi Probably I already know the answer to this, but I have to ask if anyone have solved it. I have a customer that want to setup a dimension interval restriction for specific accounts. Example: When posting on G/L account 5820 it is mandatory to use PROJECT values 1-4 When posting on G/L…
-
Odd behaviour of ID changing in NAV 2015 client
Hi I recently encountered a strange issue. A user logins as Fin-Asst into Windows with the correct domain and user id. When the NAV 2015 client opens up, the id is shown as local-server\Administrator. This only applies on one machine. We have never used the local-server\Administrator account on that machine before. This is…
-
ItemLedgerEntryTable & ItemApplicationEntryTable out of sync
Hi There, I was wondering if you guys could help... The Item Ledger entry table has many open entries against the one serial number. It appears the ILE table and IAE table are out of sync. The Item application Entry table seems to be confusing serial numbers and adding them to the Item Ledger Entry tables under the wrong…
-
print a list of reports in Dynamic Nav Classic
hello everybody, our company want to print a list of sale invoices, for example in the report 50037 at the No filter we introduce: NoBeginning..NoEnding (with NoBeginning is the first sale invoice to print). but us result we obtain reports with missing informations,like total amount is matching at the last report
-
Date Format in RDLC Report
Dear all, The 'MM/dd/yyyy' date format is appearing in a particular report from a particular Client(PC) whereas other clients can see the date format as dd/MM/yyyy in the same report. I have SET the date format as 'dd/MM/yyyy' in the 'Regional and Language' Setting window but it does not change anything in the Report…
-
Invoice Rounding Account
Hello, I've seen this behavior in a Nav 2009 SP1 Cronus: If I insert a new sales credit memo with a product that has 1000€ in "Line Amount excl. VAT", VAT (IVA) of 16%, and 4% EC, when I go to statistics I have the correct amounts: 160€ VAT and 40 EC. But if I have checked in Sales & Receivables Setup the Invoice Rounding…
-
Why is the "On Hold" only 3 characters?
Just wondering if anyone knows why the "On Hold" field in the Customer and Vendor Ledger Entries is only Code3.
-
NODBC <> SQL Database
is it possible to use NODBC for a navision SQl-Database or is it only possible to this for a native one ? the usages of microsoft-ODBC gives no informations for flowfields and if data should be rewrite to the SQL-Database problemes with NOT NULL will occour. Did onyone have informations for me ?
-
Insert files into external SQL database
Hey everybody, Here's my problem: We've created a codeunit which creates xml and pdf files and sends them out automatically to the customers. Now I want to store these files in external database (to avoid growth of NAV database). I've already got set up reading from that database and I can run stored procedures without any…
-
Double byte data truncation in Navision (SQL) 4.0 client
We have a Navision 4.0 client. We are modifying input fields for our AP system to be exported to a secondary system. We are dealing with a chines double-byte character set. A couple of these fields will contain English/Chinese combinations. In order to have these export from SQL properly we need to change the field to an…
-
How to combine the field value and store in single variable?
Hi Friends, From Cust. Ledger Entry table, there is a Document No. field. The values are: Document No.A001A002A003A004 I need to store the combination of these values into one variable and export it in dataport. That is: varX := A001 + A002 + A003 + A004; How to do this? Can anyone help to achieve this? Thanks in advance,…
-
Should website customers be actual customers?
In short I'm working on an implementation for web ordering with 2009 R2 classic Nav and I'm torn between implementing the web customers as actual customer records vs creating a separate custom table to store the records. Certainly making them full customers provides a lot of benefits, but it also means the customer table…
-
How to remove duplicate record in dataport?
Hi Friends, I have a doubt in dataport. I am exporting a set of records from G/L Entry through dataport. After exporting, I could see that, there are some records with duplication. I need to omit the the next record if the "Document No." value is same so that I will get the unique set of records. Can anyone tell me how to…