-
Problems when generating a file xml
I have a problem when generating a file xml. The problem is the following one: I need to put schema in the document xml and this I do adding it to him an attribute and this it is a node father. After I create a son of this node father and then the node son inherits the label xmlns = "". I could need that this node son did…
-
Item Age Composition by Value
Good Morning, Has anybody had problems with report 5808, Item age composition - value, using FIFO as costing method? My total inventoryvalue is much less than the total of invtvalue! :?: I did a quick and dirty fix in CalcUnitCost function to produce the report for the bank. But I am not sure is this a existing Navision…
-
Navision on Mac
Hello, A customer of ours is using some Macs and would like to use Navision 3.60. Is there a special version of Navision 3.60 for Mac available? Greetings,
-
Common ZUP file settings
Is there a way to transfer a users Zup file to another user. Or make it a common profile? thanks t
-
changing languages
Hi there, I placed this two lines in OnOpenForm SETFILTER("Entry Type", 'Sale'); FIND('-'); and this is working fine. but, when I change language in navision an error occured: 'Sale' is not an option. The existing options are: blah, blah, blah. I know why it happens, but i do not know how to fix it. Please help
-
printing from windows server 2003 on remote desktop
Hi, I have a problem that I can not solve. I use Navision Attain 3.60. On remote location (store) I use VPN and remote desktop to windows 2003. I installed POS USB printer driver (start tsp100) on both locations (server and client). Ther is no problem using client network IP printer (canon iR2020i), A4 print. Problem is…
-
BUG in codeunit 5912 in NAV 3.10
Hello, I'm using Navsion 3.10. I got an error when i'm trying to validate an invoice in the CRM-Service module. I think it's due to a bug in the codeunit 5912 "ServLedgEntries-Post" and that was corrected in version 3.60. Does anyone knows something about that?
-
Employeee ledger entry
hi all, I am not able to find any employee ledger in the HR module and we are not able to post any G/L journal to that specific employees name..... More over we will not be able to select any employeee in the Financial management ---->G/L journals so that we can post salary advance Entry to a specifis employeeee...........…
-
restoring a backup = automatic optimize on tables?
If i have a full .fbk file and restore it in a fresh database will the tables automatically be optimized? It seems that this is what happens based on the size of the database im working with...
-
Prepacks/Size Group Code.. Navision 3.10
Using Navision 3.10. Most of the items we sell are in prepacks.. 1-2-2-1 (meaning 1-Small, 2-Medium, 2-Large, 1-Extra Large) or 2-2-2 (2- 1x, 2- 2x, 2 - 3x). When we enter an item on an order we input that item under the "No." column, for example 2111-7847 is one of our styles. Then it brings us to the "Prepack Code"…
-
Excel Buffer Questions
First off I was playing with Mark Brummels Excel Buffer Sample yesterday and it works great. But I'm not too familiar with the excel buffer so I wanted to check it out to do some exporting of Sales Header info. there is a line of code I added EnterCell(Row, 2, "Ship-to Name", FALSE, FALSE, FALSE); What exactly do each of…
-
Attain 3.10 - Error 1232 in module 19
I am getting a "Error 1232 in module 19" error in the event log on my server multiple times during a working day. I have had the network checked by network cabling specialists and the network seems to be fine. What is causing this error? and What can I do to solve it? Thanks.
-
Help:Performance issue-Posting sales invoices takes 5min/inv
I have a bad problem that affects the activity of entire company. Posting one sales invoice for a custumer that has multiple ship-to addresses takes about 5 min. Taking in consideration we need to post~1000 inv/day and having ~10 customers with this particularity.......it's becoming a sensible issue. Can you help?…
-
Add sheets in Excel
Hello, I'm trying to insert a new sheet in Excel. If I use the statement: Sheets.Add then a new sheet is inserted before the other sheets. It should however be possible to insert sheets after another sheet with the following syntax [IDISPATCH Add :=] xlSheets.Add([VARIANT Before][, VARIANT After][, VARIANT Count][, VARIANT…
-
Dataport:Export in TxtFile with only <TAB> sep
Hello, I try to export data via a Dataport in Textfile with fixed Format. Unfortunatelly the seperator <TAB> writes only Whitespaces. Who can help? P.s. searched forum but found no answer!
-
How to change accounting period
Hi, My customer is changing their accounting period from january 06 month to a new financial year which started at July 07. My question here is that the customer is already running full year 2006. And that the customer is willing to pursue another 6 months transactions just to close of 2006 FY transactions. The customer is…
-
Converting images in Picture Table
I'm trying to read image (in binary formal - SQL image format) from the Picture table (SQL) and convert them to actual images using .NET. All attempts at converting the images have been unsuccessfull. Does Navision encrypt these files or add extra bytes? How can I convert them? This is the vb.net code I'm using. Dim ms As…
-
Shipping No. on Sales Invoice
Hello, In some Sales Invoices, I have the field "Shipping No." filled with an existing values. So when I try to post this invoice an error message saying that "Sales shippment header No. xxxxx already exists". Note that the field is not visible in the form, but when I zoom (Ctrl+F8) i find that it's not empty. Have some an…
-
overflow
I have created a new field with data type date in one table, and based on the table, a new report was created, but when I run the report entering 01/02/07..01/07/07 in the date filter, it gives me an error" Overflow under type conversion of text to text value date. If I enter seperate date, 01/02/07 etc, it will be fine. I…
-
ILE Descrption Change
Anybody know of a senario where making the Item Ledger Entry Description editable is dangerous? Once in a while - we would like to Update or Clairfy a description - specifically for Positive or Negative adjustments. Somtimes there not so great. Thoughts....
-
Configure print preferences / print tray...?
Hello I want to use a printer with 4 trays to print out different types of forms like delivery notes, etc. This printer is configured on terminal server and trays can be manually selected for any application other than Navision, it seems whichever tray the printer it is configured to use beforehand - it always prints out…
-
Account Schedule under SQL Filter Problems
Recently converted Nav40 to SQL. Running the Account Schedule I am getting a circular reference error. Debug reveals tahe the following code does not work NOW! (I have simplified the code, Expression is in the "Totaling" field of the Acc. Schedule Line table.) Expression := '01..75'; SETRANGE("Schedule Name",'MFG OVHD');…
-
Multiple Nav x.xx Servers on one PC
I`m trying to get a new Nav 3.01 server running on my PC. I already have 3 other servers running(Different versions of navision). My hosts and services are setup, and i am able to ping my new server, but I seem to have run out of ports to use. Annybody got some advice ? [EDIT] [SOLUTION] Read the how to carefully it works…
-
Deleting Global Dimensions
We have had global dim 1 & 2 set for 4 years and I'd like to delete them all. We simply don't use them as I thought we would way back when. And since it eating space I'd like to kill them. Is simply changing them back to "Blank" enuf to get the job done. And any estimate on time that it would take would be nice. (We're…
-
Need help in inventory 2006
Hello, After finishing my inventory 2006, I received new material that I must insert in General Leger with posting date = 31/12/2006. Is there any way to do it without having to redo all the inventory? Thanks !
-
Attain 3.6a & Terminal Server 2003
I have installed Navision Attain 3.6a client on a Windows 2003 server, then activated the Terminal Server portion of 2003. Now when a client logs in everytime they go to use Attain it comes up with an install requestor. As long as I keep the client files on a cd in the terminal servers cd drive AND the user is an…
-
Run NAS 3.10 service without administrative righs
Hi, Is it possible run NAS 3.10 with account that doesn't have administrative rights? When i try to start service i get error: In Security log it writes User, assigned to this service as login, have rights "Logon As Service" and belongs to group Users. If i add this user to Administrators group, then it works. I try also…
-
Decimal overflow in Adjust Cost - Item Entries
Hello, I'm using Navision Attain 3.10 and my problem is when executing batch job "Inventory => Periodic Activities => Adjust Cost - Item Entries" Decimal overflow error runs. I don't know what to do to fix it :roll: Can you help me?
-
Sale invoice report problem
Hello, I`am a beginner NAV designer. I have a problem with sales invoice raport. I need to print every invoice in 3 copies. On first i have to add a text "original", on 2nd and 3rd i have to add text "copy". I found the solution of second part of that problem, i used "STRSUBSTNO(CopyText);" in SourceExpr field, but i don`t…
-
Notification on Change Log by mail
Hi All, We have NAVISION ATTAIN 3.60 on SQL Server 2000 that work on Windows 2000 Server. I want that SQL Server notify me when a specific user has inserted or modified a specific field in a specific table by mail. If so, can I use trigger in SQL Server and implement xp_sendmail ? Thank you in advance.