-
Error with find / findfirst to modify existing records on a table (codeunit)
HI everyone.. I'm having a lot of trouble trying to insert records of a vendor in a table.. In this case I already have a record and I need to update (modify) the content but It raises a error that this record already exists. I was trying to find the existing record making prodform."Vendor No.":="Source No."; IF…
-
Pin in a specific field/column of purchase line
Good morning, I need to know if there's a way to insert a new item in purchase line starting in the column "nº". I need this because with bar codes pistol is easier than type "produto" in the column "Tipo" and then go to column "Nº". thanks a lot!
-
Cost , Purchase Price
Hi How to get the Cost , Purchase Price of Item in Lot Wise Stock report using query. Thanks
-
User Permission
Hi We have 3 Units . Few Users can access the Data ( Insert,Read) of only their Unit . Few Users can access or input the Data of their Unit & also of other Unit . How it can be managed. Thanks
-
Cant get Document no from General Journal Lines
Hi everyone, I'm starting with navision and I have a question. I'm trying to create a simple page to print receipt, and I need to fill the "Document No" field with the "Document no" of my cash receipt journal with the name "GENÈRICO". I cant figure how to do this, because I'm printing the "Document no" always empty or with…
-
Define which report is printed
Hi everyone, I have a page and I need to define which report I want do print but i ant figure out how to do this... In navision exists a configuration place to define which document we want to open for invoie / credit note.. I have created a new report which and when I Select "Register & Print" I need to print the new…
-
difference between Price & Standard Net Price in Trans Sales Entry Table
Hi What is the difference between Price & Standard Net Price in Trans Sales Entry Table in LS Retail Thanks
-
Calculate Average weekly sales.
Hi Experts, I have to calculate 7 days sales average but condition is to take only those days having sale is greater then 0. any suggestion? Thanks
-
Encrypt/decrypt a table
Hi all Am about to make a feature which I (despite my many years with NAV) have not tried before. Want to encrypt all fields on the fly when entering data in a special table and with a form being able to read decrypted information. Have no idea where to begin - how to do? It has to be done in a NAV 2009 Classic, but when…
-
Customer ledger entry edit
An invoice of customer ledger entry has been posted from Nav it can be edited by the registered users Is there a user in this way? Can you share its advantages or disadvantages
-
How to Integrate NAV with CBMS for nepal
Hi All, Thanks in advance. My client in nepal wants to integrate Central billing Management System (CBMS) with NAV 2009 SP1.Please share your experience how this can be achived in NAV 2009 as API is not available for this version. looking for your support.
-
How to open Nav 3.6 At Windows 10?
Dear All Expert I would like to find solution to run NAV3.6 by not used Hyper terminal or remote desktop but I can't find So if who have another ideas please give me for your suggestion. Thanks in advance Funaki
-
About aging report in nav 2009
Hi guys, I have created an aging report in nav for customer table to show the no. of pstd. invoices but I am unable to get the output, I have attached the screenshots of my codes and the output that I get with this post. Please Advise where I have made some mistakes and help to get the output. Thanks in advance Warm…
-
How to get Sales Price for the item on Customer/Item Sales report
Dear all, I've trying to get the sales price for the items on the Customer /Item Sales (P113). First i've made another report with the data from Report 113 and add the Record Sales Price in the globals. But i'm not able to get the correct Sales Price for the Item. What am i doing wrong? I've attached the code where i guess…
-
USPS Address Verification
For years we hyperlinked to: https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&companyName=AAAAA&address1=BBBBB&address2=CCCCC&city=DDDDD&state=EEEEE&zip=FFFFF Where you could insert Name, Address1 & 2, Sity, State & Zip Looks today that USPS has changed their website & now Quick Tools::Look Up a…
-
Regarding Bucket Creation in nav
[img]https://us.v-cdn.net/5022383/uploads/editor/nd/5ml9y11das56.png[Hi all,I want to create a report to show invoices in time time buckets for example i have attached a screenshot above .Please provide me some link on how to do that .Warm regards,thanks in advanceBharath K[/img]
-
GL Accounts & GL Entry Relationship - PowerBI
I am trying to create a trial balance sheet using PowerBI. (not using content pack as it is not available for NAV2009). In NAV Chart of Accounts there are Head Accounts and Sub-Accounts. IN SQL DATABASE Tables - GL_Accounts. (All Acc. numbers are listed). - GL Entry. (Only Sub Account numbers are listed because entries are…
-
Strange error:sumindexfield in non decimal field??
Hi Mates, I hope some1 can help. I´m migrating some code and I get the following error. No clue using debugger or compiling code. I checked if there is any setcurrentkey somewhere, no clue. thx!
-
record all item in the folder
Hi all, I am doing a small program so the user can select a folder on the local and the nav will search all files in that folder and put the path into a table. I use the following code to do the job. Right now I have 2 issues: one, will create "This Automation variable has not been instantiated... " message, even it…
-
No. Series Code'' does not exist
Hi In the below code it gives above error "Journal Template Name":='GENERAL'; "Journal Batch Name":='test'; "Posting No. Series":='JV'; "Line No.":=GetLineNo; GenJnlLine.RESET; GenJnlLine.SETRANGE("Journal Template Name",'GENERAL'); GenJnlLine.SETRANGE("Journal Batch Name",'test'); GenJnlLine.SETRANGE("External Document…
-
Generate Document No In Gen Journal Lines 81
Hi Gen. Journal Line - OnAfterImportRecord() "Journal Template Name":='GENERAL'; "Journal Batch Name":='TEST'; "Source Code":='GENJNL'; "Posting No. Series":='JV'; "Line No.":="LineNo."+1000; Below is the Data. I want if 2 rows no is same then same Document No should be generated . For e.g 2&3 in below case. Is it possible…
-
Regarding Counting of Invoices for one month.
I want to add no. Of invoice field from the customer table to the new report and it should show only invoices for the last 3 months.Can anybody help me...Moreover, it should include all the invoices which have been shipped and not shipped also. Thanks in advance. Warm regards, Bharath
-
update service contract code on a contract ? Nav 9
Hi Is there any way to update a service contract code? I can't seem to update it Nav 9 classic client
-
How to solve the OLE Control could not be compiled error?
Hi all, we are working on transformation of forms to pages from NAV2009 and import it in NAV2017 as pages. We have converted a form to page in NAV2009, but when trying to compile that page. we are facing a error like below Microsoft Dynamics NAV ClassicThe OLE control (GUID: {F9043C85-F6F2-101A-A3C9-08002B2F49FB}) could…
-
Date filter in nav
Hi all, Good day, I have created a report to show the invoices of all customers for the last five years, now I am able to filter the invoices only for the report and I am unable to filter the dates. Can anyone help me on how to filter the date for last five years from the current date. Thanks in advance Regards Bharath k
-
how to use transformation tools to convert forms from Nav 2009 to Nav 2017?
how to use transformation tools to convert forms from nav 2009 to nav 2017? Could you please let me know the steps involved inorder to convert forms to pages that too directly from Nav2009 to Nav2017
-
Untrusted Domain issue NAV 2009
Error: The login is from an untrusted domain and cannot be used with windows authentication. What is the reason of his error ? If End-User re-open NAV Client after 5 to 10 minutes then it connects without any error. If 15 users try to access NAV at the same time then 7 will get error. We have 30 concurrent users license…
-
Item No. cant rename
Hi, While item no. renamaing, i am getting the error message. The following field must be included in the table's primary key: Field: "Description" Table: "Item"
-
How i can connect Navision Client with server out of Lan Network? ( Not in Same network)
Hello Everyone.!! I need to know how i can connect Navision Client with Server,if my server is in one location and client is in another location. they are not in same network..!!! How i can do it?? Please suggest...!!!
-
update cost to G/L
Hi all While creating item card, standard cost is unavailable, however i have posted some transactions for the items like sale and purchases. when i check the value entrie table "cost posted to g/l" shows zero, question is when standard cost was available can and post correct cost for posted transactions this item ? please…