-
Remove or Hide Menu
We have developed a barcode scanning screen that automatically comes up when the user logs in. It's the only thing that they can see except for the File Edit View menu at the top of the client. Is there a way to remove/hide this menu? I know most of the things are greyed out, but I don't want these users seeing this. Thanks
-
Items Mixing between tables /LS Retail 6.02 with Nav 2009 R2
Hi everyone, i got the following scenario in a restaurant using ls retail 6.02 with dynamic nav 2009 R2: I got a pc working with a local database server, this one is used by the cashier and i got a second Pc connected in this same service, this one is used by the sales person. The idea is add more pcs, in order to use many…
-
Why 'Sale (Qty.)' in Item is calculated from VE, not ILE
Hi everyone, when I check flowfields in Item table, I find 'Sales (Qty.)' is calculated from 'Value Entry'.'Invoiced Quantity', not 'Item Ledger Entry'.'Invoiced Quantity'. (For other quantities, like 'Purchases (Qty.)', 'Transferred (Qty.)', 'Positive Adjmt. (Qty.)', 'Negative Adjmt. (Qty.)', they are all calculated from…
-
Automation DOMDocument
Hi, We have installed a bunch of new servers, and has encountered some issues with one of the Automations that uses 'Microsoft XML, v6.0'.XMLHTTP and 'Microsoft XML, v6.0'.DOMDocument. I was sure that it was the two were a part of the MSXML 6 Core Services installation pack, but that seems not to be the case. Does anyone…
-
Get file size for files > 2GB
Hi folks, my envirionment: Nav 2009 R2 Classic client, no RTC my challenge: import xml files > 2 GB in size ( using INSTREAM) my problem: the file.LEN reports the wrong file size, instead of 2.478.870.528 Bytes I got -1.7....... somewhat. (Minus!!!) Regardles of the field type: Integer, BigInteger, Decimal. Even if I use…
-
"Unable to start a nested transaction.." deleting linked rec
Hi, I am reading records from a second (non-NAV database). The records go into a General Journal. After reading all the records, I want to delete the records from the source non-NAV table. Rather than using the "standard" ADO method, I created a linked table in NAV. I can read the records just fine, but when I try to…
-
Non-Inventory Items
Dear Experts, we have some Non-Inventory items like repairing, gift Wrapping & I have marked the item as non-Inventory in Retail item card.But when we are selling them their qty is getting deducted. So is there any way the qty should not be deducted?? no matter how much we make sale for that. since it is a service item and…
-
do is need to buy a License for NAV and SQL server
Hi, i hope you guys could help me out here, i've just upgraded my native database to SQL on SQL server Express 2008 but now i would like to go in the production. i have a nav license for 60 session, so do i also need to buy 60 or more client licenses for SQL Server. Regards, Ratish
-
NAV2013R2 : Active SQL Connexion for LADOConnection
Hi, Is there a way to use the current SQL connexion using by NAV to create a LADOConnection object and use it to execute SQL query ??? i say a lot of topic , explaining how to use this object, but creating a new sql connexion : this one for example : viewtopic.php?t=23038 I would like to avoid to write the connexion…
-
Return Quantity Shipped Not Invoiced
Hello Everyone, Is it possible to return the only the Quantity Shipped Not Invoiced on Sales Documents. The Scenario is like this: I am shipping the Item A with 1000 Liters, and it happens all the time that i ship at the customer point thay say that are not 1000 liter but 950, so at the end of the month i have to invoice…
-
Connect Navision with Shopware with WinHttp to REST-Api
Hi, i want to send Items and more to the Shopware using the REST-Api. So i think the easiest way is to connect over WinHttp. But how? I get no connection to the api. Does someone has a cool (or hot) Tip for me? I started with this code (found the basics on the shopware forum from DonAlfredo) CREATE(WinHttp);…
-
AutoIncrement does not yield sequential numbers
I have a strange and somewhat worrying problem with a customer's Change Log: the Entry No. field is not sequential. This field has the (SQL) attribute AutoIncrement=Yes. The problem has occurred twice, both times across dates. I suspect both have happened in conjunction with a server reboot. 30-09-14: Entry No. = 11192…
-
Problem Creating PDF files in NAV
Hi all, i have a report to create PDF files automatically, the reports works fine, but i don't know why every PDF is created, the pdf program opens the file... I have a Runmodal like this: Report.Runmodal(ReportSelection."Report ID",FALSE,FALSE,recSalesCrMemo); This report is used by terminal server, and gets the…
-
How to use CalcDateBOC, Code unit 7600
Hi, I found this function to calculate a new date base on a spécific calendar : CalcDateBOC. But i don't know how to use It.... My parameters are : -initial Date. -my calendar -number of day to add to the initial date. Don't understand all the parameter in the codeunit 7600.... Anyone could help me ? thx.
-
Excluding held inventory from planning availability
I think I know the answer to this question, but I'm going to ask it in the interest of being thorough. We have a business process where we move materials to a QC area/bin/zone for inspection in cases of damages or other quality issues. Where that happens, my operations team would like the ability to exclude that material…
-
Cheque Run problem
Hi, Is it possible to manually change a cheque number after the cheques have been printed? (not yet posted) We have a small cheque run but when I select print cheques Nav changes the numbers to what it thinks will be the number on the last cheque stub. Any help would be greatly appreciated! Thanks
-
Probelm-Dataport Import for BIN table
HI,I am creating a datport for bin table.Want to import data in the same.I ma getting error as field cannot be empty.please specify a value..I searched mibuso but none of soultions work.The field in the file are bin code.zone,desc.I ma careting dataport eith fields like code,zone,desc.Acc to mibuso since it was not working…
-
Void Unposted Invoice That Contains Duplicate Invoice #
Hello, hoping someone can help me solve this.... I create thousands of invoices using the Dataport in Object Designer by individually uploading Excel files that contain the headers and the lines. Once the invoices have been uploaded, I then go in and post them. However, mistakes have been made and there are now several…
-
Erron in Puchase Invoice Costing
Hi, Has anyone encountered this error? I encountered this error while posting Purchase Invoice using get receipt lines: "You must specify Account No. in General Journal Line Template Name=",Journal Journal Batch Name=", Line No.=0" Thanks for the help, Hd0911
-
Job Scheduler issues
Hello All, Our Job schedule Management has been running for the last 5 years with out any issue. Suddenly stop picking (running) assigned reports or code units. Objects are enable and job schedule is running. Pic below is showing scheduler running but "Last Job ID" is blank, meaning that so far no job has been executed.…
-
ILE and VE not created with sales statment posting
i notice that user when post sales statement entries from " open statment". NO" ILE" and "VE" created, the status in statment header is " sales entry posted", also transaction heade marked as (item posted) how can ensure that all sales " Qt sold posted " is reflect in ILE?
-
Service Tax Payment in NAV 2013 R2: Indian Localisation
Hi mibuso members, I want to know how service tax payment is done in MS Dynamics NAV 2013 R2. For payment of Sales tax, we have 'Pay tax' option there and have option to select Sales tax there. But I did not find similar option for Service tax. Does this means we need to select normal GL Entry for payment. Thanks Jiju…
-
Navision 2003 - Item Ledger Entry \ Country of clients
Hello, I am new there and I really need your help. I have alot of clients and it seem some of them return a blank country! (not all but some) The client setup have the country and when I click on a client in the Item Ledger Entry It show the country but not on the current line of sales in the Item Ledger Entry. Is it has…
-
LSRetail Scheduler Subjob Filter and replication by action
Hi The Scheduler Subjob Filter is allowed only with the normal replication. There is a way to do this with a replication By Actions ?
-
Using NAV on Amazon's AWS / RDS
Hi Everyone, Has anyone gotten NAV to work on Amazon's AWS, specifically the database-only version of RDS (Amazon Relational Database Service)? http://aws.amazon.com/rds/sqlserver/ I started doing a little testing, and it seems that Amazon RDS for SQL Server has the master database pretty locked down, and NAV seems to need…
-
Service Management
Have noticed when entering a service invoice that it does not complete a credit check, is this normal behaviour if so why and is there away around this ?. Thanks A
-
Install 2009 SP1
Hi all, After a hardware crash on my computer i have had to install everything once more - wnets fine untill NAV 2009 SP1. Copied the install disk to harddrive - but when doubleclick on setup.exe - nothing happen. Anyone know the trick? (win8.1)
-
Report previews unreadable (data with low resolution)
Hi everybody, I have got a problem with my NAV reports that since a couple of days every time the users open a preview it shows the letters/numbers with a low resolution that is in some cases unreadable. When they zoom the page in, everything looks normal but they have to scroll it left/right to see the data. As this is…
-
Cyrillic
Hi experts, We have a web page conected to NAV, where all the sales are posted in NAV 2009 r2. Now, it turns out that our client wants to sell their stuff in Russia. Then, I find out that when I transfer the cyrillic words from the web page to the proper fields in NAV, it is stored with rubbish, I mean instead of setting…
-
Blank labels (2 and more) are feeding out inbetween printing
Can anyone suggest me a solution. Blank labels (2 and more) are feeding out inbetween printing. Printer used : Datamax H-6308 Application Version : 83-2546-12G1 12.071 4/8/2010 Do i need to upgrade the firmware to fix this issue ? :?: :? Is there anyother solution please let me know. Note : Pallet printing