-
Report problems, no longer an issue
Hello all, I got 2 reports that are showing unexpected behavior that's very easy to reproduce but almost impossible to debug. Both reports are about pick-ups of goods, and 2 problems occur. Both reports contain a section that needs to be shown if any good on the pick-up is on a specific unit. When I want a specific pick-up…
-
Tabs in Reports as per our Choice
Hi Experts, Is there any option to align the Tabs in the report as per our choice. For Example: I want Options Tab first and then followed by that <FirstDataItem> tab. I required this in both Classic Client and RTC. Thanks
-
Report looping (help needed)
For one of our clients we're making a new waybill report. On each page of the report we have 12 lines with the goods. Now under the goods we want the barcodes for those goods,7 lines in total.The barcodes have to be pasted together and you have to go the next line if the length of the barcodes supersedes the length of the…
-
Selection of Documents among all document
Dear All, Can someone please advise how to resolve this issue please?? The problem is: I need to run a report that will print only the selected documents that I need. I have already applied my filters. For e.g When doing my look up , I have records from 1 to 10 ..but I want to print only record 2,5,8. What I thought is to…
-
SETRANGE & SETFILTER function
I have report from SalesLine Table and Item Table. With Function SETRANGE i get record from Table Production Order Header (C/AL Global variable) called ProdDate (AvailableDate). The problem is - in Production Order Header Table i need to get for respective Item Available Date, but there are many Available dates, because…
-
Filter what customers attend what shows?
I am trying to figure out, maybe there's an easy way to accomplish this. I am using Navision 3.10. On our Sales Order form I have a textbox that shows "Event Code". I looked it up and there's a Form 50002 named Event Code. If I run that it just shows me the following: CODE DESCRIPTION The code is used to quickly shows what…
-
Record found not matching record present
Hello I'm currently developing a new functionality to one of our codeunits. This codeunit is ment to send an email when an edi file is processed, all the code for it exists already. I just have to make sure the mail gets send to the right email address. In order to find the email adress for an edi file we have to look up…
-
Certification of BOM very very slow
Hello, we have a problem with BOM certification that is very slow (about 30 minutes each one). On various your post on mibuso I read that you advice to unflag the field "Dynamic Low-Level Code" on Manufacturing Setup. Doing that the certification is immediate. I ask you if there are risks to unflag this field and negatives…
-
Default Location for Production Order
Hello, Looking for clarification. On the sales orders and purchase orders, the system will put a default location code in based on the company info and user responsibility center. I notice that there is nothing like this for production orders, which seems strange. Is there any reason you see why I wouldn't default…
-
Recovery from Hotcopy
Last night I had to recover a client database from Hotcopy. After moving the DB files back and logging in, I found the database to be at 100% used. I suspect that this was caused by user activity when the hotcopy was made. My solution is a backup, new DB , restore to recover the free space. That is currently running. Are…
-
Database suddenly at 100%
This is for one of our clients that is approachign the 256 GB limit of the C/Side database. They are currently involved with us in an upgrade to NAV 2009 with SQL. Over this past weekend we worked with them to delete some historical data. That brought the free space to around 25% as of Tuesday. This mornign they reported…
-
[ASK] Relationship table of [Transaction No_] field
Hi, i'm new in this forum.. & quite new in Navision programming.. i have been trying to find the relationship table of [Transaction No_] field that was in G_L Entry & GST Entry.. but cannot find such table.. did anyone knows which table has it? Thanks
-
Subcontracting with bin code
When i send item from company location to subcontractor location the system given a error "you must specify bin codein item journal line journal template name=",journal batch name=",line no.='0' " while company location have bin mandatory. Any suggestion here.
-
Copy & Paste in Shortcuts Menu
Hello I am facing a problem that case is- User A which have not permission order & User B have permission of order creation User A Copy the form of order from user B & Paste his user's in Shortcut Menu what security available here stopping this .
-
Deleting Purh. Rcpt. Lines with a Zero Qty.
I have made a custom program to link all purchase lines to either a transfer order to a branch or a sales order to a customer. Because we now print pick labels for the transfer and sales orders when we receive these purchase orders, we only post and receive one line at a time. The problem is that we create a lot of Purh.…
-
DrillDown with RecordRef
Hi there, I am using RecordRef and FieldRef to get values from tables that the user specifies. He enters the table number into a setup table and the field to get the value from. I need to allow him to do a DrillDown with only the Table number to go on. I don't want to create a bunch of Record Variables or Form Variables.…
-
Is there a way to find table ID bas on tablename
Hello, I've gotten an intresting question, we got 2 tables with the same name, diffrent ID off couse. We now are getting unexpected behavior from a codeunit that uses 1 of these 2. We suspect that the record variable is pointing to the wrong one. When we look into the global/local variables we get offcourse the variable…
-
Where to get Cronus 2.5 Database?
Hi All, Does anyone know where I could find a copy of Cronus 2.5? We need to get an object, Codeunit 1, and for some reason, it's the only Cronus database we don't have in house. Alternatively, does anyone know if Codeunit 1 is the same version in 2.6 as it is in 2.5 (we have a copy of 2.6).
-
Designing a report, can't reach all sections
I can't really find a better title for this problem. I'm editing one of our existing report and for this I need to add new sections, everthing went fine untill I noticed that the vertical scroll didn't adjust. So I literally can't reach the lowest sections to edit them, in this case I can't get to the Footer(7)
-
Random Number
I have managed to create a "random" number field, simply by RANDOMIZE; RndmNumber := RANDOM(12); Which gives me a number between 1 and 12. How do I give it a minimum? ( I only want 8 - 12) ? Thanks :)
-
Date not printing on first Print.Reprint printing the data.
Date field is not printing on the first print and its print on the reprint. I need to print the date on the first print itself. Kindly assist. Report Code: The below code will assign current date value to "License Reprint Order Line"."Date to Publisher". License Reprint Order Line - OnPostDataItem() IF NOT…
-
Filter data tablebox based on textbox data
Well I solved the problem that I had so I'm changing the post to share it rather then have the question here for all 'eternity'. I had a form that needed some change, you had to be able to fill in a barcode and that had then to retrieve the location of the packet. On the form was already a tablebox showing all valid…
-
Looking for a way to find records created before a date
I need to find all the records in a table created for a certain date, and do that for each table in a list. Is there a way to find these records
-
How to write multible lines to a textbox.
Hello all, I'm currently tasked with writing code that will display when we can accept certain pallets on a transaction based on the country code of the delivery. Now on one of the reports that need this, I need to display in the first line that we can trade in that pallet. and the second and 3th line should display that…
-
I need a pop-up message system in Navision
Hello everybody, I've Attain 3.70 and I'm looking for an advise system. I've tested the Chat and Messenger download aplications from this page but, to see the message, you have to stay in Chat or Messenger form. I need a pop-up message system in Navision. Is there any aplication for it?. Thanks for help.
-
Adj. of Opening Balance in Vendor Trial Balance
Hello, can anyone tell me, what exactly the Adj. of Opening Balance in Vendor Trial Balance (Report 304) stands for? One of our customers got it (they had 2.01 B before, where this did not exist) and is very concerned. In the documentations of financial management, I could not find a description so far. Thanks and kind…
-
Symbol in Code Field on SQL-Server option
While migrating a customers database to the SQL-Server option we came upon the following error, when restoring a navision backup into a Microsoft Business Solutions-Navision under SQL-server option : "The Production BOM Header table contains a value in a Code field that cannot be used with Mictosoft Busniness…
-
Transfer of data from Excel Buffer to Currency Exchange Rate
Hi All, Can somebody please let me know how to transfer data from Excel Buffer table to currency exchange table(No.330) using a codeunit. In NAV 2009 SP1 ,We managed to import the data from Excel file to Excel Buffer table using the below functions, Excelbuf.OpenBook(FileName,SheetName); Excelbuf.ReadSheet; Appreciate your…
-
One product and two boxes
I have a product which consists of two boxes. Each box has a Item card and barcode. How to solve this problem - i need to see in SalesOrder only Head Item, but after Order posting from stock will be deducted NOT head Item, but sub Items - box 1 and box 2 Item
-
Can you change subtype of a record variable
Hello I'm quite new at Navision, using Navision 3.6 atm. One of our databases has started to show unexpected error messages. A lookup on these found out that either *The database or a portion was corrupted *A function is running infinite loops *The database has almost used up its free space We found out that the database…