-
Create a connect to tabel eith a diffrent schema ?
Dear All, All my tabels are lets say located under Navision Database with this schema 123- What If i have another tabels with a different schema that I want to be able to access from object designer(Lets say C/Side), How can I do this? Iam not sure, I heard something like creating XML-port? is this what I need? if yes,…
-
Item Revision
Good day. How can we create item revisions within NAV 2009 SP1? We wanted to maintain revisions for the same item. Thank you.
-
Costing issue with credits
We manufacture an item at a cost of say $3000.00. We can see the part go into inventory at the correct cost. We issue sales order and invoice. We can see the cost coming out of inventory correctly. Curtomer returns item for what ever reason and we issue credit against the sales order. Item goes back into inventory at…
-
Manufacturing Standard Cost
Hello, I have a customer who has a production item, he has decided on this occasion to buy the goods in rather than make them. Can he use the manufacturing part number to buy in or should he create a separate one. If so why ?. Thanks
-
Edit form on next record and reopen on command button
Hi Everybody, I need form to be non-editable when it's open or onafterrecord. If user wants to edit form there should be a command button for user to edit the form. I did CurrForm.EDITABLE(TRUE); on command button and CurrForm.EDITABLE(FALSE); on OnAfterGetRecord. It's all good but one issue After OnPush command button…
-
REST-Api Automationerror
Hello everyone, I'm currently facing an ugly error and I can't find the reason. The scenario is the following: Our customer is having a development machine and a live machine. Both machines are able to access the same database. If I logg on the development machine and run the code to access a REST-Api which lays beyond the…
-
Permission in NAV 2013 R2
Hi Friends, Any tool available to give permission to a specific "Permission Set" Navision 2013 R2. Regards Prakash Skype: Prakashveer.sharma
-
no decimal places without round
Hi experts!! I have 562.321,55 but I need 562.321 (without round) and I don't get it. please help me.
-
Problem send to excel in NAV 5.0
I'm having problems in exporting to Excel for the Nav 5.0 .For instance I use the "Send to Microsoft Office Excel" button to export the data in the Payment Journals data to Excel, but when i doing this then the following message: Problems came up in the following areas during load: Workbook Setting This file cannot be…
-
Optimize Code - Terrible performance.
Hi Experts I need your guidance. One of our clients wants to control what Contact cards the user can see. Each contact card is associated with certain Programs. I created a new table (Program Relationship) to keep track of different programs a contact is associated with. Also, I created a new form called UserSetup Line,…
-
How to pass parameters from report to dataport?
Hi Friends, I have designed 3 dataports: Dataport-A, Dataport-B, Dataport-C and a report: Report-A. From report, I am running these 3 dataports. My requirement is, I need to give FromDate and ToDate in request form of Report-A. In these data range, I need to extract data through dataports Dataport-A, Dataport-B,…
-
Consistency Errors in DB - unknown cause
Hello there! SQL Server 2008 (10.0.4000) Dynamics NAV 2009 R2 (6.0.32012) Classic Client only Background story: Got a call from a client some time ago. The client told me, they had to shut down the server for a planned maintenance work (at the power lines). After they started the server, the database "didn't came up…
-
Performance question, NAV2009R2
Hello everyone. First apologies for asking what has probably been asked before but I can't find anything appropriate. I have a NAV2009R2 implantation, running classic client with 70 users, on a SQL2012 DB running on Server 2008R2. The server is a fairly high spec (although obviously 2008R2 limits to 32Gb) but all the discs…
-
Slovenien additional character is displayed wrong
Hello, since last Thursday one additional character is displayed wrong. Have someone an idea why this could happend? You can see it in the attachment. Yours Michael
-
Error "G/L entry already exists" Entry No. = 0
Hello I'm working with Nav 2009 SP1. When I try to apply a vendor invoice with its payment (in USD both), I get the error: "G/L entry already exists". Entry No.=0 A former applied entry created entry no.=0 and now system it's trying to create entry no.=0 one more time. No records have been manually deleted in the database.…
-
Record already exists during OnModify
Error message: The <table name> already exists. Identification fields and values: <field value pairs> I've gotten this error many times, and it is generally self-explanatory after watching the debugger and seeing that something is trying to insert a duplicate record. However, this time is very strange: 1. no code is…
-
How to upload pdf file in purchase order Navision 2013 R2
Hi, I want to upload pdf file with purchase order as attachment like quotation / Invoice copy etc.. Any suggestion on how it can be done. Thanks & Regards Jyotee
-
AR Aging detail Report
Hi Nav Experts! I modified standard AR Aging report (Report ID 109)as per customer requirement, I couldn't able to retrive data from Detailed Cust. Ledg. Entry for details Invoice wise. In standard AR Detail report is also available that logic is different, I want to use Report ID 109 logic and want to get detail invoice…
-
Open Form form (39) Gen Journal from code without commiting,
Dear All, I have heard that in order to open a form from a code I have o user the commit Function before I call the form. which its working. The problem is that Iam importing 5 lines from an excel tabel in the Gen. Journal Form. At the end of the code I commit the code and I call the form. Now the problem is when I commit…
-
decimal mark conversion
Hi, Hope some1 can help. I´m retrieving the following strings: "netWeight": 19480.0 "netWeight": 19480.2 And I´d like them to be converted to decimal like : 19480 and 19480,2. When I do evaluate(mydecimalfield,textfield) it does like this: 198400 any ideas? thanks!
-
How do I use the "Define Calculated Fields" in Nav-Classic
Hello all noob here, :lol: I am working with Navision Classic 2009 R2 in the object designer, Form, Style Sheet Card. I am building forms and I am trying to figure out how to use the "Define Calculate Fields". I've tried looking online but there seems to be nothing much on using "Define Calculate Fields" on 2009 R2…
-
Tricks to find the Last PK
Sir, The following Standard Code in NAV is occasionally used to find the LAST No. (read Last PK) of the targeted* table. * in where the programme is going to INSERT the records. IF ItemLedgEntryNo = 0 THEN BEGIN GlobalItemLedgEntry.LOCKTABLE; IF GlobalItemLedgEntry.FINDLAST THEN ItemLedgEntryNo :=…
-
Warehousing question
Hello Experts, I just getting my toes wet (just started reading warehousing manual) in the warehousing solution that NAV provides and one of client asked us the following: 1) If the warehouse shipment document can support having multiple lines on it from different locations? 2) If on the pick document, can we have pick…
-
Export consolidation from different database
Wonder if anyone can help me on my problem. I have been trying to 'export consolidation' to file for this particular company but receive the message 'You cannot enter 'DDDDD' in decimal' . Not sure what to check for or rectify.
-
Text File UTF-8 Encoding
Hi can you guy helpme I want to write a text file from navision i can write in the file but som characters as Á or é are not correct when I open the file in the note pad I think it is because of the encoding navision save it in ANSI i think is that. ](*,)
-
Nav 4.0 SP3 report: pages mix sorting
Hello! I got a rather strange problem and was wondering if you can help me! We need to print a letter and send it to 3500+ recipients. Their addresses stored on the same dataitem record. The letter consists of 2 pages. A dataitem is made with 2 body sections with sizes to match 2 A4 pages. The letters start printing well…
-
Allow to see a field on item card
Dear All, Is there a way that i can allow a user from seeing a field on the items card. example i want the user to see the item but i don want to show him the Cost of the item. Best HAYAN
-
Multi company setup - Consolidation question
Hi guys, Need some help on multi-company setup on Nav 4 SP3.. Request the top dudes on Mibuso NAV to help me out if they can. Situation : Multiple companies..similar business..single group-legal requirement,so the multiple companies.. Vendor/Customer ledger Transactions common..as in,A might buy,B might procure,C might…
-
Missing Location Code on Posting Output Journal
MY current version of NAV is 5.0 SP1 W1. I was trying to posting output journal, and error message showed up. The Inventory Posting Setup does not Exist. Identification fields and values: Location Code='',Invt. Posting Group Code='RM-PT' Then I run the debugger and found that the error happened at function SetAccNo() in…
-
GETLASTERRORTEXT question
Hi everyone, I am trying to develop an Item Archive feature for one of our clients. Since they have lots of items that are no longer used, they wish to archive them so that the master Item list would only display items that are currently being used. I created a batch report which will go through all the items and try to…