-
Job Queue functionality in NAV3.70
Hi there, Client is running NAV3.70 but runtime NAV2009R2. I need the Job Queue functionality in the solution, so shouldn't it be possible to bring in the Job Queue objects from NAV2009R2, make a few tweaks here and here. Install the NAS and off we go?
-
Item Sales by State
I haven't written a Navision 4.0 Native Report in quite a while and I have to create a new report that can give me the quantity of items sold for a given item or items within a posting date range. I believe the report should have tables: Customer Value Entry There should be. Data Link of Customer."No." and "Value…
-
Old Sales Line Affecting Inventory Availability
Hello. I'm using MS Dynamics Nav 2009 R2, Classic Client. I'm having a situation where there are several sales lines in table 37, that are affecting my inventory availability for the inventory items in those lines. The thing is these lines are from sales orders that don't even exist. They were either deleted or totally…
-
invoice prepayment
Hello my friends I have a real problem I want to require the system to apply a new accounting scheme written in the accounting table after the validation of the final invoice ,i programming the account of prepayment
-
error with sum
Why it gives me an error? SumCharOdd += CharTable.ValueOdd;
-
change color font
How can I change the font color of one record based on a condition? thanks..
-
Can't understand why I've got the error
I have to separate vocals from consonants.... I'm trying this but if the word begins with a vocal, the vocal is putted in the vocals variable... why? thanks! FOR i := 1 TO STRLEN(wordL) DO IF wordL <> ' ' THEN partialL += COPYSTR(wordL, i,1); FOR i:=1 TO STRLEN(partialL) DO IF isVocal(partialL) THEN vocalsG +=…
-
Why does Nodbc perform very slow on native database (Nav2009)
After some strugles we succeeded in connecting DMS Document Management System with Nav2009R2 fdb database through NODBC, to enrich data in DMS (Content Central). But performance is very bad. At the moment it is reading ca. 300 invoice header per hour. We are using NO. to find recod in sale invoice header table using SELECT…
-
Code doesn't work
I'm trying this: TableMonth.SETFILTER(Month , FORMAT(DATE2DMY(TableFiscal.DOB , 2))); FiscalCode += FORMAT(TableMonth.Letter); MESSAGE('%1',TableMonth.Letter); the message is empty.... why? thank you!
-
How to expand Native database size when I dont have super
Dear all Can anybody tell me how to get the password for my super user id? Now I want expand my Native database size and I don't have super user id password. Please help me,, KMK
-
In nav 2009, SMTP Error
Dear friends I am using Nav 2009, I wanted to use SMTP objects to send email. sample odeToAddresses:='krishna@jitsystems.net'; kSubject:='PO for '+FORMAT(Amount); kBody:='PO Document '+"No."+' '+"Pay-to Name"+' for your approval'; CLEAR(kmail); kmail.CreateMessage(smtp."User…
-
Exporting data from table
Hellooooo
-
Warehousing - Max Quantity field Issue
Hello Warehouse Experts, Background Info: - - The client is currently on NAV 2009 R2 Classic with SQL Option - They wish to implement Advance Warehousing (since they want directed picks and put-away). - Due to the varying bin heights and sizes, only certain type of items can be placed in a bin. Thus, we are using warehouse…
-
coupon issue
Hi !!! Hi, I am new to Navision. We are using Navision 2013 and I want to Fix The Coupon Issue Eg. : 100 QR Transaction 20 QR Coupon Free. But When POS Billing And Posting 20 QR Transaction That Bill Also 20 QR Coupon Printing So How I Will Clear This Issue. Please tell me how I can do the same...
-
get function
If a table has only one primary key, and I want to use the get function to search a record corresponding at one value, how can I do it? thanks!
-
can i create a custom field in table ?
can i create a custom field to be filled from another field in the same table where i need to replace empty value with a specific value?
-
THE CODE APPLI IN G/L ACCOUNT
HELLO I WANT TO INCREASE THE NUMBER OF LETTERING CODE SYMBOL, NOW SHOWS THREE SYMBOL IN LETTER IS THAT POSSIBLE TO INCREASE THE NUMBER OF SYMBOL AT SIX THIS PROBLEME IN 2009 R2 THANK YOU FOR HELP IT IS URGENT
-
connect to SQL port other that 1433
Hello Does anybody know how to connect to sqlserver\instance and different port. I'm trying to create a new db on sqlserver\instance:port (ie SQL\CLIENT:5555) but that doesn't seem to work ? I've tried to telnet SQL\CLIENT 5555 - and this works.
-
Link of G/L Entry - With Value Entry or other Table
Hi Guys, I have this requirement from our finance group to indicate the Item No. for G/L entries. I'm trying to get the item number from the Value Entry using the link G/L Entry > Value Entry Doc. No. = Doc. No. Amount = Cost Amount Posted to G/L However when there are two lines in Value Entry that has the same DOC NO. and…
-
Report - 795 Adjust Cost - Item Entries
Hi, After executing Report - 795 Adjust Cost - Item Entries, i can able to see the "ItemRegister" entries but i couldnt able to see the "GL Register". What would be the issue?
-
sales order invoice discount
in the sales order i want to keep the same invoice discount amount even if currency is changed
-
Cisco Aironet 1240AG Series Access Points
I'm implementing a Wireless Network for my 300,000 (1000 feet long, 300 feet deep and 30 feet tall) square feet warehouse. I've purchased some Hawking Technology Hi-Gain Antennas (15dbi up to 1 mile) and some Hawking Technology Hi-Gain 300N Access Points. I just realized that the Operating Temperature my the Hawking Access…
-
Disable locking or part-table Lock?
I have some trouble with locking in my new table. What we have: New document (I've developed it) with header and lines that created autimatically (on button). Lines have many columns and document will be created around 5-10 minutes. Also user can update document (delete old lines, and create new ones instead). And manually…
-
Report
How do I add quote service's print layout? thanks!
-
job module
Hello, how do i know that my job is completed?
-
uncorrect return value
I'm trying to concatenate parts of a string but it returns a number... why? thank you! IF (STRLEN(consonants) = 2) AND (STRLEN(vocals)>0) THEN finalstring := consonants[1] + consonants[2] + vocals[1];
-
Function
My aim is to remove the second consonant if the letter before is also a constant. Ex: from "best friend" to "best riend"... I tried this: <i>DeleteDubleLetter(word : Text) finalstring : Text</i> Array_Vocals[1] := 'a'; Array_Vocals[2] := 'e'; Array_Vocals[3] := 'i'; Array_Vocals[4] := 'o'; Array_Vocals[5] := 'u'; FOR i :=…
-
closed period inventory
hi i need to close inventory period in dynamics nav 2009 R2 if i closed the period a can see a modif in table period inventory checked by (checkbox) so this is possible but ow can applied to ptogram closed the period ,
-
Auto post item journal with spesific journal batch name
Hi Expert, I am trying to do like "auto post" with specific journal Batch name. and I see that the code for posting in item journal like 3 lines below CODEUNIT.RUN(CODEUNIT::"Item Jnl.-Post",Rec); CurrentJnlBatchName := GETRANGEMAX("Journal Batch Name"); CurrPage.UPDATE(FALSE); and when I test and debug it, it show error…
-
in the sales analysis report i want to show 12 columns when i click print report it only show 5 colu
how i can change it to 12 columns