-
Overhead on Purchased parts
Hi. I need to apply an overhead to Purchased parts. This overhead is part of the valuation of the inventory, but the supplier invoices us without overhead. Originally I asked whether the standard cost should include or exclude inventory, then I was advised to use Indirect Cost %, but I can't understand how this works. Many…
-
Reading/parsing multiple files in a folder in NAV 2013 R2
Hi, I am feeling rather stupid atm... I am trying to read a bunch of .txt files from a specific folder, using a codeunit like this: Setup i my configuration record, ResponseFile is a variable of type record, sub type File. Setup.GET; ResponseFile.SETRANGE(Path,Setup."Import path"+'*.txt'); ResponseFile.SETRANGE("Is a…
-
price credit memo changes after changing the quantity
Hello, I have the folowing situation: A customer in Navision buys 10 pcs of an item for each 20 euro's. He get's an invoice for 200 euro's. The company decides to change the prices from 20 to 15 euro's. After that, an item is returned to the company because there was something wrong. The company creates a credit memo and…
-
Default setup to link trade units
Hey I would like to know what the default setup is to link "trade units" in NAVISION With "trade unit" I mean each unit that can be ordered by your client, a definition used by GS1. (GS1: international standardization organization for supply chians that is responsable for barcodes) For instance when you're distributing…
-
Unit of Measure on Production Order
Hi Guys, I have a customer, who would like to produce packs of 6 pieces. They keep their inventory in pieces, so Base Unit of Measure is PCS. But because the items end up in 6-packs instead of producing say 24 pieces, they would rather produce 4 of those 6-packs - its easier to understand for the production staff. So, the…
-
Change first day of week
Hi all Is it possible to change the Date virtual table first day of week to "sunday"? Thanks in advanve!
-
NAV2009 vs NAV2013 PO Posting - Job Ledger Entry Difference
Hi there experts, I am just wondering if somebody knows why NAV2009 when I posted a Purchase Order using 'Receive' option it creates a Job Ledger Entry. I used "Cronus Canada", PO#6004, then changed the Job Number on the PO Lines. But, when I used the same process, posted a Purchase Order using 'Receive' option in NAV2013,…
-
Looking for the original release of GB 2013R2
I cant seem to find this on Partnersource. I need it for the purposes of localising a 3rd party system, which is at 2013R2, before any updates/hotfixes. The only version I can find includes Cumulative Update 1. Dynamics.71.GB.1456367.DVD.zip. Can anyone direct me to the version I need, please? Is it still available to…
-
inserting date in nav database
hi experts i am reading sales invoice line table through select query and inserting it into the another nav database using ado connection . But shipment date, posting date column incorrect date is being updated. or its format is being changed. Please guide me during insertion date into the nav table what format i have to…
-
Problem with REPEAT loop
Hi everyone, I am having an issue with the following code:Prefixe:='FCM';SalesInvoiceHeader.RESET;SalesInvoiceHeader.SETRANGE("Posting Date",DateFilter,WORKDATE);IF SalesInvoiceHeader.FINDSET THEN BEGIN REPEAT SalesInvoiceHeader.RENAME(Prefixe+ COPYSTR(SalesInvoiceHeader."No.",3,STRLEN(SalesInvoiceHeader."No."))); UNTIL…
-
Where Not Used
I've been asked to write a where not used report and was wondering if anyone has done something similar? I've been looking at making a copy of the Where-Used Management codeunit updating the logic to achieve the output I'm looking for but want to see if someone else has produced such a report first. Regards, Ian
-
NAV 4.0 - VAT Amount is not posted
Hi Everyone, I have a big problem. When i posted Sales Invoice, NAV is not counted VAT. I don't know what i'm doing wrong. I checked Posting groups - All are fine. Customer is the same - OK. Please, give me some suggestions. James
-
NAV 3.7 - Toggle between forms
Hi! I write here to see if anyone can help me... First of all, forgive my poor English. Due to my poor English, I will be very brief. We use Navision 3.70 and an user has request to put a button into form to toggle between forms. To open/close the forms is not an option because to open any one of the forms takes "long…
-
Permission for XML-port
Hi all Have a strange behaviour for an XMLport. It exports various information to another system. Have made an integer-field (50000) in table 17 G/L entry. This field is updated during RUN of XML-port. However, despite I have granted permission in XMLport to write to table 17 "TableData G/L Entry=rimd" I get the error that…
-
Question about limited NAV licence
Hi all, I wan to ask if it is possible to process approval request using limited NAV licence having in mind that write access is restricted to 3 tables only? :oops: Thanks and Regards Meri
-
NAV 5 blank is not equal to NAV 6 blank???
Hi friends, I detected following code in our vertical solution (look at the ' '): CAG := "Customer Status" + "Address Class"; CASE CAG OF 'KA': ... 'KA': ... ' ': ... <<<=== ELSE ... END; This works perfectly with a NAV 5 Client (native database). But if you upgrade the NAV 5 database to NAV 6 and do the same thing with a…
-
Navision 2013 R2 Databse Login
Hii all, I have a very basic question.. I have demo database installed on my system, presently i am logging in using windows authentication, i want to use login without windows authentication
-
Solution developer module in a seperate license?
Hi all, First post but a long time reader.. \:D/ I got an interesting licensing problem to consider... :) I've a customer (we are the VAR for this customer) which has a rather big BRL BE license. This customer now wants to buy the Solution developer and application builder granule. Now - because these granules can only be…
-
T.A.N No. ERROR While Posting a Purchase Invoice with GL.
Hi All, While Posting a Purchase Invoice with Type GL Account and where TDS is applicable. I am getting the below error : You must specify T.A.N. No. in TDS Entry Entry No.='653'. I have already checked the Company Information Card for T.A.N No. Its already mentioned on that. Can anyone tell the reason for the same now.…
-
Error when add users through "Windows Logins"
Hi All Our company has been implemented NAV2009R2 for 1.5 years. Last week when I tried to add user through "Windows Logins", the following error message pop-up:- ================================================= The following SQL Server error or errors occurred: 15138,"42000",[Microsoft][ODBC SQL Server Driver][SQL…
-
Kill Session for Duplicate Login
Hi Friends, My customer do not want any user to login twice to navision with his/her ID. I decided the write the code in Codeunit 1 - CompanyOpen function. If i test the below code by logging in as 'SA' UserID then the code works and the duplicate session is killed. But the code fails if i login twice with any other user…
-
Depr. Schedule for IT Act data
hi experts In Report id - 16534 Depr. Schedule for IT Act under Depreciation heading less than 180 days rs place data is not coming. What is the reason that data is not coming into this section . Plz guide me and how to solve this?
-
CWIP Fixed Asset Details IN Localization
Hi All, Can anybody have functional pdf doc's related to FA Capital Work in Progress for NAV 2009 SP1, or Anybody can help me on that by providing some relevant links on that. Thnaks in advance
-
Indian locali. license to be used to implement in Malaysia
Hi All, we've the license of NAV 5.0, in that license we're operating 3 indian companies, now i want to create a company operated in Malaysia in same license. what challenges we're going to face in that or there is no issue to implement. please advice. Thanks Raman
-
How can I limit the access through F7
Hello Friends, Here is my scenario. We’ve A,B,C&D locations. From the item ledger entries form, I want users to restrict their access to filter on certain locations (A & B) only. I’ve a code written on “Location Code” OnLookup trigger. It is working when user directly clicks on location code and lookup arrow. But, it is…
-
How to: IF {Field:Time} = 0 then....
Hello, I have to write a condition depending on a field of type TIME. If I write:IF {FIELD}=0 Then ... I got an error:Microsoft Business Solutions-NavisionType conversion is not possible because 1 of the operators contains an invalid type. Time = Integer How to write it??
-
Unapply bulk payment
We have requirement where the user needs to unapply an invoice. The issue I am facing is when the bulk payment is applied to different invoices. So when you unapply that payment Navision first unapplies last entry applied and stops there. Then user need to unapply again and the system unapplies the last entries again. Is…
-
DB LINK DATA
hi experts I want to copy data from one navision database to another nav database automatically day basis. Please suggest me how i will do this?
-
NAV 2009 - Light user configuration
How do we configure a particular user as a light user in NAV 2009. Like how we have an option to mention a particular user as a limited user or full user in NAV 2013, do we also have a similar option for light users in NAV 2009. :-k :-k I would be glad if I can get a document which explains this. Thanks
-
Microsoft Dynamics nav 2009r2 autosplitkey error
i get an error message that says This is an invalid type of primary key for the autosplitkey facilty.It should be an integer/BigInteger/Decimal/GUID.this is when i click anywhere in the subform for Microsoft dynamics nav 2009 r2.someone help