-
How to add a barcode to a form
I would like to add a bar code to a form. In this case it will be the Sales Order form. The barcode will contain the Sales Order Number. We want our warehouse employees to scan this bar code from the Sales Order form and have the result populate a field on a spreadsheet. Can I place the SO number on the form, use a barcode…
-
Navigation Pane menu item change
hi, is there any way to change left pane menu items on database? when i change a menu item's name with navigation pane designer, all users see this change. So i think it's keeping in some table, not local file. But which table and how can i update this table? Navision 5.0 Sp1 with Sql Server 2008. regards.
-
How to limit the posting of a Bank Account?
Hi Nav Experts, This might sounds stupid. I would like to ask if Navision is capable to limit the posting of a certain bank account? Am not talking about blocking the Bank Account itself. It's like limiting the other user to post on that bank acc. so that there will be no other adjustment can be made while the treasury is…
-
Error when transfering objects
Hi Can someone tell me why we sometime get error when we transfer objects from developer database to live database. NAS service has been restarted. The objects from developer has been complied correctly. See the attachment. Thanks. Best Recards Javaid
-
Production Journals - Default Quantities
Hi There, I have a Released Manufacturing Order. In my manufacturing setup, I have the Preset Output Quantity set to Expected Quantity. I click the Production Journal, set the Flushing Method to Backwards, and my Consumption and Output line appear. However the Consumption Quantity and Output Quantity default to zero. Can…
-
Editable Field in Posted Purch. Inv.
Hi all, I added an editable field in the table 122. Purch. Inv. Header. I also added in form 'Posted Purchase Invoice' but how can i make editable in form. I need this field to put in each Posted Purchase Invoice a int. 0 or 1 and than using this filter generate a report in Purchase Book.
-
Display column value differently
hi, firstly i'm beginner and i could not find any other question. i have a table box. it's listing some values. but i want to display a column different value. e.g. if Entry No_ = "5" Entry No_ must be 9999. is this possible? if yes how? Nav 5.0 Sp1. best regards.
-
Customer Card Performance
Hi all, I know that this isn't the first post about this and I already read a few posts for the issue. Indeed I know that flow fields are probably the problem but I would like to ask the following questions: 1. How many records considered a big number for the source table of a flow field? I mean which is the threshold that…
-
Adding a Field to a Report from a Different Table
I have a report called Quote Analysis that's made up of two DataItems: "Sales Header" and "Sales Line". The report shows information such as "Quote Number", "Customer Name", "Quote Date" etc. I'd like to add a new column to the report called "Branch", which needs to come from the Customer table from a field also called…
-
Russian Database Backup
Hello, today I have a problem to open a database I just restored from a SQL Backup. The company name is in russian. I attached the images below where you can see how the company name looks in nav and how the company name looks in the SQL table itself. If I open the database I get "TableData XY not found". I installed…
-
Calculate Size (in bytes) of a Table
Good morning, I'd like to ask if there was any tool to calculate the size (by adding up field lenghts) of a Table. Thanks in advance
-
Specific Serial Number Information
Hi, I have an inventory number that is lot tracked. I enter a purchase order for the item and assign a serial number to the item. I have a sales order. I want to reserve the specific serial number on my open purchase order to my sales order line. How do I do this? When I click Reserve on the Sales Order Line, I see the…
-
Serial Number Information
Hi! How can I see a list of serial numbers on hand and the serial numbers that have been reserved? When I open sales quote or sales order and go into Item Tracking Lines, and click the elipsis next to Serial No, I see the the information I need. However, when looking at the corresponding table, the Entry Summary table…
-
what is the function of order multiple in item table?
Hi guys, i want to know what is the function of order multiple column in item table? it is related to purchase order? please let me know tq
-
Renaming Customer Price Group Loses Prices
When you rename a customer price group the sales code on the sales prices isn't updated to the new name. It just stays with the old name so the price group no longer has any prices associated with it. I can see why this happens, the ValidateTableRelation property is not set on the sales code field of the sales price table.…
-
MSR CARD SETUP
DEAR FRIENDS HOW TO SETUP THE STAFF CARD LINK TO MSR CARD IN LSRETAIL 2013 R2
-
SalesBook and PurchaseBook divided by VAT Prod Posting Group
Hi everyone, We have two VAT levels. I opened two VAT Prod. Posting Group but i also need that in reports SalesBook and PurchaseBook the sales and purchase to be divided not only by the invoice header but also by the VAT Prod. Posting Group. For example in one sales\purchase invoice i have two lines one with VAT Prod group…
-
Create Filter string based on selected objects ?
Hi In the development environment, is it possible ( maybe with a tools ), to select for example the modified objects, and create a FILTER string from that.. ? Thanks Regards Kenneth
-
Indian Sales Tax | Detailed Tax Entry Table | NAV 2013 R2
Dear All, I have navigated a Posted Sales Invoice and found Zero (0) value in the Amount Field in the Tax Entry Table (ID -13700) but I have found some value in the Tax Amount Field in the Detailed Tax Entry table (ID-16522). When Posted Sales Invoice does not calculate any Tax then why does Detailed Tax Entry table…
-
Item Journal > difference "unit amount" + <=> - adjustment
Can someone explain me why there is a difference between the value that is used for the field "unit amount" in a positive and the one that is used in a negative adjustment item journal line? positive adjustment = cost - overhead rate - indirect cost % negative adjustment = cost why not 2 times = cost? Best regards Tom
-
posting Statement IN LS Retail
Dear All, When we post the Statement of LS Retail, the entries that are posted to GL entry and recorded in the GL register is not same Document number but however it is balanced, anybody has an Idea how Navision allow this.? Best HAYAN
-
Add Last Direct Cost to Production BOM Lines Page
Hello all, I am trying to add the Last Direct Cost from the Item table to the Production BOM Lines Page (99000788). I cannot figure out how to do this. I have added the Item table as a Global variable and then added the Last Direct Cost to the Production BOM Lines Page but everything always shows as 0.00 for the Last…
-
CurrRec,Rec Variable and Clear All Function
Dear all, Can u explain me about the CurrRec and Rec Variable. I already looked on the help, but it didn't give me any information. Does this thing Hardcoded by Navision? Cause when I read about ClearAll Function, it says that it won't clear the Rec variable. TIA
-
PDF Creator Unknown Automation issue
I have an application which emails PDF's from an Invoice List. Compiled on my machine fine. Didn't work on a user's machine, came up with the "Could not create an instance ... " yada yada yada Went on their machine and gave them Object Designer access. I opened up the form, noticed that the PDF Automation variables were…
-
ADCS/VT100 Plugin Slow Performance
I am upgrading our server that is running the NAS ADCS service with the VT100 plugin from Windows 2003 32-bit to 2012R2 64-bit. We are running Navision 2009 R2. Everything seems to be working, but the handheld scanners that we use for inventory and receiving are slower than they were when the ADCS and VT100 plugin were on…
-
Classic Report not printing lines
A customer asked me to look at a report which when "written" was apparently derived from the Sales Shipment report and is now a 5k range report. The issue was the customer wanted the report print comments. When I took a look, all the standard code was in the report to print the comments, but nothing was coming out. Using…
-
The best way to create automated NAVreport with excel export
How a NAV report can be run automatically with automatic export to excel feature in 2009 classic. The report need to be scheduled and that report must export to excel. Thanks
-
Default a Language code on Item translations
We would like to have a default language code on Item translations when we create a new Item Card. Is this possible? If so how do we do it? Alan
-
Block serial nos. (scrap) vs. Output
Hi all, i am asking for your help with a "little" problem of mine. i need to create serial nos. for traceability items in advance, when releasing an production order. After creation, we print barcodes and attach those labels to the item during the manufacturing process. This means, the once created serial nos. may not be…
-
SQL ERROR while Upgrade from 2009R2 to 2013
I made all steps to upgrade a NAV 2009 R2 database to 2013 up to here https://msdn.microsoft.com/en-us/librar ... 71%29.aspx When i open the database with the 2013 Client Build 40468 (https://msdn.microsoft.com/en-us/librar ... 71%29.aspx) i get the following error.