-
COUNT Issue
I have noticed that the COUNT function in Navision is not returning the exact count always. Based on the recommendation in some of the other posts regarding this same issue I have optimized the table in Navision and then I got the correct count. We are using Navision 3.6 on SQL database. I have 3 questions. 1. Are there…
-
ADCS
Hello, I am installing ADCS in Microsoft dynamics NAV 2009 SP1, but the object in this database are Navision Attain 3.70. The problem that i have is the next: "Could not communicate with Socket localhost:11322. No se puede establecer una conexión ya que el equipo de destino denegó expresamente dicha conexión…
-
Cache Size when opening local copy of DB
HI Guys We were recently working on something and emptied a table of data by accident and i am now trying to restore from a backup. I managed to extract our 2 FDB files from the backup and have it loaded on a windows XP machine. I have clicked open database and entered client only under server name. I have selected both…
-
Converting Attain decimal datetime field
I'm exporting a Navision Attain 3.60 date field into SQL. The exported field looks like 63,255,909.417785. Does anyone know what SQL calculation I can run to convert it to a human readable date and time?
-
Problem with XML namespaces
Hi, I'm trying to create some XML files from purchase orders. These are to be validated by a workflow system. Thus, the header tag contains references to xml schemas, and the tags inside are appropriately declared with namespace prefixes. The problem is, that the schemas are not available at creation of the xml file. The…
-
Rapid Start - Item Identifier
Hello, I'm trying to import into the Item Identifier table (7704). I created an excel export template using the Configuration Template. I populated the template with the "Code" and the Item No. The file imports just fine. However, when I apply the data, nothing imports. I get an error stating: "Item No. must have a value…
-
Receive from In-Transit Location
Dear all, I have seen that few Item Ledger Entries are still Open for Transfer Shipment entries and someone has deleted the Transfer Order. So Transfer Receipt is still pending. Now my question is how do I receive the Items from the In-Transit Location in the ILE. Please reply.
-
Creating .txt file using Codeunit on local machine
Hi to all, I'm trying to resolve one complicated problem, so every idea is welcome I'm creating .txt file using codeunit which need to be created on my client's computer. But.. info: *My client logs to the server using instance with Credential Type:NavUserPassword and using Certificate. problem *The destination where I…
-
Item Card - Purchase Price
Hi, We are using Navision 2009 R2 and we have two companies created in our database. There is an new requirement like for users who are not having administrator role or Super Role in Navision, they must not be able to view the purchase price field in item card and in item list. This is in form 30 (item card) and form 31…
-
Running Navision 3.10 Server on Windows XP?
I just want to be clear.. I posted here many years ago: viewtopic.php?f=14&t=12459&start=0&hilit=2000 We run our Clients on Windows XP and a few using Windows 7. But I just want to be clear.. will the server run on Windows XP at least (or greater) without me having to buy any software upgrades? I've got a loud high pitched…
-
Upgrade path?
Someone delete this post please.
-
RDLC report, problem with row numbering
Hi to all I have problem with row numbers in rdlc. I need my print layout to be grouped by [field] value. So I've add Row group by [field]. Grouping is ok, but if I count line numbers in C/AL the result in Row number is (for example): 3. Item 2 1. Item 1 4. Item 3 2. Item 4 So to solve this problem, I'm using…
-
Performance of the report depends on size of the data set
hi , the performance of the report in rtc effects the size of the data set ,if it effects the then what is the maximum size of the data set..in Nav 2015 reports.
-
Gen. Bus. Posting Group must be Default error when posting..
I was out of the office yesterday. Someone tried to post an invoice and got an error message. Gen. Bus. Posting Group must be Default in Sales Shipment Line Document No.='SS0033982'. I think that is the whole message given to the person. The invoice indeed got posted, because that number is missing from the sequence in the…
-
How to grab data from last Posted Invoice of a customer?
On customer card, is it possible to take data from a customers last Posted Invoice and display? I might be able to figure out how to get data myself, but how to only grab last invoice? If you go to Posted Invoice on the Invoice tab there's the following fields: "Payment Method Code", "Credit Card No.", and "Expire Date".…
-
Nav Report Font Substitution through a Virtual PC
As many of you are aware, fonts are weird in Navision. Most of the reports in Navision are programmed to use the font “Helvetica”. Helvetica is not a standard Microsoft Windows font. Windows translates the font to be the default font on that workstation (usually Arial). There is a place in the registry that maps this.…
-
Decimal field returns always zero
Hi there. I'm having my first experiences with C/SIDE. I'm trying to make an CodeUnit that only reads values from a table (21 Cust. Ledger Entry) and sends it by email. All is working ok, I read some fields and put them into a text string without problems. EmailBody := 'Document: ' + UPPERCASE(SalesLedger."Document No.") +…
-
Upgrade NAV 4 To NAV 2009
I have a navision 4.0 db and some one has already converted it to 2013(all objects) Its working perfectly Now i want to get data from navision4.0 to 2013. But i dont know how to do this, Can you please guide me to do this Thank you Shan
-
Navision attain aged AR report showing more then i need
Hello, This is my first post to this site. I work in collections and have a new boss I am trying to make the aged A/R report to only show Customer balances where they owe us not ones with a account balance credit due them ( i do not need to see the credit balance due them and it makes the report 100 pages it will cut down…
-
Style Sheet Tool Bug
Style Sheet Tool for Microsoft Dynamics NAV Following the example in the User guide: -"Creating a Style Sheet for a Document" - page16 - for a specific RS, pulls through all sale lines. -everything works as expected. Following the same steps: -Employee Card / Allowances -relationship between Employee (5200) and Employee…
-
Automatic update of Currency Rate with job Queue
Hi All, I was assign to a task of Automatic Currency Rate Update for a client. I have done the Currency Rate update to Currency Exchange Rate Table by creating CodeUnit, which consumes the rate from the URL http://www.floatrates.com/daily/USD.xml. But When I run job queue with Codeunit for automatic update, I receive error…
-
Auto populate field?
When I RunObject from a MenuButton is there a way to auto populate data? Example: When I am on a Sales Order and go to print Sales Order it auto populates "No." field with the number of the current order you're working with. I added a my own report to the Print MenuButton, but when it populates "No." it uses the last…
-
Modify report to only show date of last invoice..
Navision 3.10 I'd like to make a condensed report out of "Report 10042 - Customer Account Detail". I can filter it by Salesperson and only to show Invoices. The problem is that report can become a lot of pages. I don't need a lot of stuff that the report had, so I got rid of them. Anyway, it shows Date something was…
-
Need Help with Excel Buffer
hello, guys. i need help from anyone i have navision attain v3.6,with some modification [Form WHT], the guy who created this modification is not work in my company. the issue about this modification it is this form WHT will show some data, this form is for make a tax report, so the user can make a report for some data…
-
The role permissions are equal - actual acess differ
Hello experts, My client uses a custom version of Navision Attain 3.6 and NAV5 as a client. He has PROD database and a copy of PROD database. Certain user connects to PROD db and reserves an item in Sales Quote. During reservation system tries to find a record in Item Vendor table and returns an error message: You don't…
-
Importing item translations
We are currently creating an Excel spreadsheet with alternative Item descriptions. We want to use these as a "less technical " description of items on Sales documents. I intend to create a language code called "Spares" and use this language code on all customer cards. This will then use the new descriptions on sales…
-
Report Query : Matrix table
Currency Code is repeating in Matrix Report. Give me any suggestions. I added image refer that and give me any suggestions
-
Page Break
Hi experts, I have created a printing file based on three tables, Sales Header, Dropship, and Sales Line. The order number of Dropship will be linked to the No. of the Sales Header, and the order number of the Dropship will be linked to the Document No. of the Sales Line. Below are the data for the three tables: Sales…
-
NewPagePergroup and NewPagePerRecord
Hi experts, in Nav2013, how to set the NewPagePerGroup to NO and NewPagePerRrecord to YES. Thank you!
-
Aged Accounts Receivable
Hi expert, for the Dynamic NAV 2013, several reports cannot be retrieved. Aged Accounts Receivable is one of them. It runs and runs when opened and it will never end. These reports come from the system. Does any of the experts know how to fix it? Thank you very much!