-
navision 2009 r2 jobs
hi We scheduled one job in Navision 2009.if the number of records to process is same also it will take different times to complete. sometimes very long time. Somedays we notice even if large amount of data also it will complete within fewseconds but sometime if less also it will take long time to complete.We findout Table…
-
usage of infocode
Hi, I want print an extra text on each item in POS Receipts. I have tried to attach Infocode for the Retail Item but it is not printing. Please suggest Warm regards Krishna
-
POS Receipt print Arabic
Dear Friends, After changing code page to 1256 arabic and when print the POS receipts, items with Arabic name are printed in right to left. Amount figures also reversed for example 17.00 , it is 00.17. May be small correction in setup. Please advice Warm Regards Kris
-
My navision get closed when i select the variant code in production order line, Any solutions.
I am working in navision 2013r2 when i select the variant code in production order line my navision gets closed. My table no is 5406 i.e Prod. Order Line.
-
Pass Variables to Codeunit.RUN
Hello, I am having an issue with the log and maybe someone can help me out. I need to pass the BatchScriptCode field a particular codeunit. But I am not sure how I can do this. I cant use the typical way of doing it, where we create a codeunit variable in the globals, in the codeunit, we can create a function called…
-
How to create a new Product(Car) in Manufacturing?
Explain the steps clearly.
-
Table lock issues during upgrade from 2009 -> 2013
Hi All Im currently attempting to upgrade a database from 2009R2 to 2017. On the step where i upgrade the database from 2009 to 2013 by opening it in the development invironment im experiencing issues with table locks. (this is the step where sql data types and colation is changed) I have tried running the database in…
-
Wanted to use multiple Lookup in FlowField
Hi Friends. I have G/L Entry Table which has "Source Type" as 'Customer'/'Vendor' and "Source No" contains Customer Code or Vendor Code based on Source Type. Now I have added one more field called "Party Name" which is Text (30). Using this field I changed FieldClass = FlowField and put CalcFormula as "Lookup(Customer.Name…
-
Filtering substrings
Hello, today I have a problem related with text input, here's the explanation: Variables used: gItemNo - Text 100 lRecItem2 - Record 24 Trigger: OnValidate - Page IF gItemNo <> '' THEN BEGIN IF STRPOS(gItemNo,'|') = 0 THEN BEGIN lRecItem2.RESET; lRecItem2.SETRANGE("Balance Code","Balance Code");…
-
How to get long text from the clipboard into Navision variable
Hello everyone I have read some discussions on this forum but i didn't find solution. I need to take long text from clipboard into variables. I read on this forum about this OCX: http://www.mibuso.com/dlinfo.asp?FileID=149 and I tried to use it but it work fine only when the text length in clipboard is less than 255…
-
issue in Style sheet
Hi Team, I imported style sheet 2.0 objects and i tried item card & customer card forms. By using style sheet i created No. column. when I click sent to word it is showing Customer/item no.s successfully. But if I did with customized table it is showing only Table field name. it is not showing data. It is showing data as…
-
Arranging Pick list in Bin order
Hi Guys, So i have a report for pick list that people run to pass to warehouse to be picked. We use Bin Locations and the picklist comes off in line order. Is there an easy way to modify the report to allow it to come off in bin order (our bins are ordered like A1B, A4B, B5C etc... - so alphabetical would do it).
-
Generate XML File
I want to export xml file from Navision 2009. I want to have this structure, If I have table A with field X (data x1,x2,x3) and field Y (data y1,y2,y3). xml file will be: <x1> y1 < /x1> <x2> y2 < /x2> <x3> y3 < /x3> is it possible with xml ports? or I must use another solution? thank you
-
How to change code page in navision
Hi, Do anyone can suggest me/guide me how to set codepage in navision. I want type Arabic in Item card description field Please warm regards kris
-
DISTINCT rows in a table based in conditions
Hello! I'm creating a chart based on data stored in a table with tables 5772 and 5773 as source of these data. I want Picks and Put-Away lines based on his header (per User). So I created a code to do it but it's not efficient and decreases NAV's performance. // Works only for Put-Away - approximately 341 lines in the…
-
How to post a Payment Journals?
guide me to post payment journals in finance and management section
-
Problem while importing merged objects.
Hi guys While upgrading from 5.0 to 2009-R2. As I import the merged objects to converted database in 2009-R2 I have got following error that I do not have permission to create a standard field in sales header table. I have confirmed about license. its right. please help.
-
Diferent Count Columns in the same Dataset in Queries
Hello! So I'm here with a problem (might not be a big deal for you) with a development i'm actually doing. I have to create a chart for Productivity so i'm using tables 5772 and 5773 to count Picks and Put-Aways per worker. I'm trying to this with a table and with a query (testing both ways), but with a query seems to be…
-
Arabic data in Nav 5.0 SP!
Hi everyone, If you have arabic data in your database (in awindow like analysis by dimensions) and you expoted it to excel by functions/export to excel the data in excel will be in unreadable format. Can anyone help us with this? By the way this only happens with 5.0 SP1 if you use 5.0 only this will not happen. Thank you…
-
how to create a new company in NAV 2009 and configure the required setup to post the Sales Order?
step by step guidance needed.
-
Pivot table - How to hide subtotals?
Hi! I'm making a excel pivot table out from Nav (5) Everything works fine, but i need subtotals to be hidden. Can anyone post the exact C/AL code for it? In VB it is:ActiveSheet.PivotTables("PivotTable1").PivotFields("My Field").Subtotals = _ Array(False, False, False, False, False, False, False, False, False, False,…
-
Transfer Orders 2009 R2
We have never had a need for Transfer Orders but now we have. We have one main warehouse - with warehousing picks and put-aways etc. What I need is to set for other locations which I can transfer inventory to when it goes into off site storage. The other location will not have warehousing and is a third party company. When…
-
XMLPort in NAV web service imports only first record
Hi, I've exposed a NAV 2009 web service like that: WriteItem(Item : XMLport "Artikel Import Webservice2") result : Text[30]
Item.IMPORT; The XMLPort has a few lines of code to handle empty date fields, nothing else. Its properties: Properties of the root element: I can't upload the XML here, but it looks fine and can be…
-
SETSELECTIONFILTER in Actions
So, It was asked to me as learning exercise, to create an action in a page to pick a boolean Field based on the selected lines, so for exemple: 3 lines selected = Boolean Field of each line picked. I created the code of this action in a codeunit to select the lines and fill the boolean field, but only fills the boolean…
-
Calculate Plan - Plan.Wksh. Batch Job creates too many lines in NAV2009 R2
Hello, we use the planning batch "Calculate Plan - Plan.Wksh. Batch Job" for planning in NAV2009R2 for a customer project. Purchases, transfers and production orders are to be planned. The components are set up with item tracking (lot no.) The production takes place in location '01'. The components are located in location…
-
Write on .mdb file from "Job Queue Entry"
Hi all, I'm migrating a codeunit from 2009 to NAV2015, that uses automations to update an mdb file from "Job Queue Entry". But I can't found a way to do the same with DotNet variables whith RunOnClient=No (the code is executed from "Job Queue Entry"). In 2009 I have this variables: Connection Automation 'Microsoft ActiveX…
-
empty /blank spaces Navision 2009
Hello everybody, I am importing data from an excel table, in a cross reference, but I need to upload the information with an empty space at the beginning of the number, like this, ' 123 456 466' In the excel table is written: ' 123 456 789 , but when the data is imported is deleting the empty space, is there a special…
-
SelectSingleNode does not find node
Hi! Straight to my problem... In the following lines the call to selectSingleNode throws NullReferenceException: XmlDocResponse := XmlHttp.responseXML(); XmlDocResponse.selectSingleNode('BarcodePrintZplResult'); And this is my XML doc: <?xml version="1.0" encoding="utf-8"?> <soap:Envelope…
-
XMLPort: OnBeforeInsertRecord is run twice
Hi all, I'm consuming a NAV 2009 web service in another NAV 2009 database by redirecting the XML response to an XMLPort to import records. The target table is empty. There is no code in the XMLPort. It appears that for certain records the ObBeforeInsertRecord is run twice, which results in the "the record already exists"…
-
Navision Database Schema
Can sombody help me of how to view the navision 2005 database schema Thanks.