-
how to create positive entry and Lot for an item
I need to create a positive entry for a item with lot no. so if item dont have Lot No how to create the lot no. then want to create positive entry for the item.. How to do. ](*,) Thanks in advance Shweta Saxena
-
1042-S
Looking to see how people handle these in NAV? Any ideas would be appreciated?
-
Barcode Generation
Hi all, I want to generate a barcode with a combination of itemno. sno, lot no and item product category code. On generating this, i want to print it to a barcode printer. can u suggest an optimal way to do this in navision regards, ramya venkat
-
Merge Conditionally using Excel Buffer
Dear Sir, I want to export custom Table data using Excel Buffer. The custom Table has only two fields one is Name (text 30) & another is Surname (Text 30). I want Excel buffer would merge the value into a single cell if total length(Name+Surname) is found more than 30. kindly reply.
-
POS transaction based on workdate
Hi .. currently if we change the work date,and after POS client login all transaction still posted based on system date. is there any setup can do transaction based on the work date?
-
US Form 1042-S
Will Navision generate a US form 1042-S which I believe is a 1099 to non-resident aliens? If not, has anyone built a solution or have an add-in product that will do so? Thanks!
-
NAV 5 - Filter length more than 256
Hi everyone, I am working with NAV 5 and I need to apply a filter with length of 1024. I always get an error message that the filter is more 256 characters. How can I achieve that? Thanks in advance :mrgreen:
-
NAVISION Customer License & Object permission (by default)
Dear Sir, While working with a client I have astonished to see that in the customer License there is no xmlport execution permission and even only 15 Codeunit are granted. AFAIK that 100 xmlport & 100 codeunit are permitted by default at the time of license purchase. Kindly share your valuable knowledge about nav…
-
How to cancel an UNPOSTED Service Invoice
Hi All, I'm using NAV50FR SP1. I created a service invoice from a contrat service from [Functions] -> [Create Service Invoice] (= CU ServContractManagement.CreateInvoice) In this invoice i have an "Apply to service Entry" that relies on a open service entry. I think it's a bit weird : there is an entry but i didn't post…
-
Month name from a date
Hi, Is it possible in navision to retreive the month name from a date. For instance, I have the date 22/12/2005, I would like to copy 'december' in a variable. Thanks.
-
Logical expression OR on Form propertis
Hi to all, Is there any possible way to put on SourceTableView on Form propertis two conditions associated with logical expression OR. for example (Field1='A') OR (Filed2='B'); Any advice Thanks a lot,
-
Server 2012, Sending Email with Bullzip Attachment Issue
Hi All, I have written a codeunit to process email with attachment as invoice to the customer and it worked great till date. Now my customer have formatted the server and upgraded the Operating system to Windows Server 2012. With this change the latest version of Bullzip was installed. Now nothing happens when i run the…
-
Skipping XML tags that are not in the port
Anyone come accross to this situation when there is dynamic XML elements in importable XML file What are my options to skip these elements that are not included in Navision XML port but might appear in the file? (see attached picture) On the picture I have XML port that works perfectly before you add these <A>, <B>, <C>...…
-
Reset ACY setting in GL Setup
hi all, Is there any ways to get the ACY fields in ILE or VE got back to 0? my company decide to turn on the ACY reporting, but might be only for short period of time and want to check if it possible to reset the whole system like ACY never been used when we turn off ACY reporting.
-
Post ACY only in GL Journal
Hi All, i am trying to find a way to post GL only for ACY only. this is because my company want to turn on the ACY but also want the old entry show in Balance ACY. I have check there "Addtional Currency Posting" in gl journal. it is option field with value of None, Amount Only, and Additional Amount Only. Can someone…
-
Export Bitmaplist
Is there any way to export (to file) the bitmap list within Navision, or just the user-imported bitmaps ?
-
Dynamically choose company logo in reports
Hi, One of our client want to print the company logo in sales invoice report depends on sell to customer field dynamically. I have written code for this and i need know in source exp of picture box how to use IF loop. for ex IF Customer.Picture <> '' THEN CompanyInfo.Picture ELSE Customer.Picture; if the customer rec does…
-
NAV 2009 SP1 Merging Forms: Different Localization
Hi, We are merging customisations in forms, from E.g. GB to DE. With Tables and Codeunits, we used ExamDiff Pro, and it worked very well. As forms have X and Y coordinates, is there a quick semi-automated way to merge forms, instead of merging them one by one to safe time? Thanks in advance Peter
-
Luxembourg localisations specifically Intrastat
Dear Mibuso, The international company I work for are currently investigating intrastat rapports for LUX shipments. Since we are getting close to the legal obligatory threshold of 200000€ in turn over for intrastat declarations. There are as far as I know no MS provided objects for LUX intrastat (Get Item ledger entries,…
-
Runtime error when opening Company
Hi, I have a runtime error when opening a company. Error only happens when opening a company. The event log are as per below: CU1 is unchanged, and it is standard cU1. Client version is 4SP3. ERROR LOGFaulting application name: fin.exe, version: 4.0.3.24080, time stamp: 0x45c3015e Faulting module name: fin.exe, version:…
-
Error While opening RTC client in 2013R2
I have upgraded the database from 2009 to 2013 R2. All objects are compiled. but getting an error while openint RTC client The following SQL error was unexpected. Invalid column name 'Queue Folder Path'. Invalid column name 'Queue Folder UID'. Invalid column name 'Storage Folder Path'. Invalid column name 'Storage Folder…
-
Navision Timer
Hi, How can this be possible,a page to handle time with : 1. Start 2. Pause 3. Stop buttons When workers start there work they click on start, for lunch breaks use Pause and to stop there work-> Use stop. How this can be done, please guide.
-
Manufacturing / workcenter / planning in days
Hi, I understand what a workcenter does. I set up a work center and the unit of measure connected is DAYS. When I make a production forecast for my item and calculate a regenarative plan in the planning worksheet, I don't understand the starting/ending dates the system comes up with. I think the problem is that the system…
-
Function Call Issue
Hi, As all know there is a Change Status function on Order, that works for individual order. I have created a new list page,on which the status must change from Firm planned to Released, for the Order lines which are marked as True. but when i call the std function it works for all available lines neglecting the setrange.…
-
Page Setup and Margins in Ms Dynamics NAV 2009 classic
Hi I would like to understand from where the Page Setup and Margins are inherited in MS Dynamics NAV 2009 Classic. When you run a report, then go to File > Page Setup, the margins can be defined. I want to know if this Page Setup / margins is coming from the default printer set on my PC or is it inherited from somewhere…
-
Non-nettable inventory locations
Good day! How can we apply this option of netting locations in NAV2009 SP1? We want to use this to segregate MRB items with good items and would want MRP to skip this location. Thank you.
-
COMPANYNAME Vs Company.Name
Dear Sir, What is the correct procedure to use the COMPANYNAME instead of "Company.Name" in C/AL programming ? In a scenario we'r using the COMPANYNAME in the Mail body and the "Company.Name" in a NAV report which is being used as a attachment (as PDF format) with the mail. We have found that COMPANYNAME is appearing…
-
System Error when doing input validation
Hi all, I am trying an input validation to test if fields are not blank then Status will be changed to 'Committed'. But I am getting this error 'Type conversion is not possible because 1 of the operators contains an invalid type. Text or Code'. I have inserted my codes on After Get Record on the Item card. Codes: IF…
-
Production Orders Components Update
Dear All, I am currently working on NAV2009R2, in the manufacturing section. We have got a case scenario where component x which is linked to let's say 20 Production Orders has been found to be damaged and the component need to be modified. I would like to find a quick update/report/task which allows me to change the…
-
How to reset Job Queue Processes - NAV 5.0
Hello, I ask you how it is possible to reset/delete all lines of job queue processes in Navision 5.0. I would like to have it empty to restart from a clean situation. Our queue went automatically ok with NASSQL until one week ago when we added business notification on same server. Now there are more lines as following:…