-
Cannot find Table 37
Hello together, I have the weirdest of errors on my screen right now. On NAV2015 Development Environment, I click on table 37 (Sales Line), I try to Run it (click on "Run" button) and I get this error: "Cannot find Table 37" :shock: :shock: :shock: This is the only table with this problem. No other table, system or…
-
NAV Database Test fails
All, Our customer has encountered a NAV database crash over the holidays. In fact the entire VM that housed the SQL Server and NAV crashed. Long story short, the NAV Database is back up and running, SQL Services are back up and running, however when we ran CHECKDB and File->Database->Test, we encountered the following…
-
get table property: DataPerCompany
hi, is it possible to get a certain table-property out of the sourcecode (in this case datapercompany) ? i'm processing all fields of all tables of all companies with recordref and fieldref and do not want to repeat tables with property datapercompany=no because of the hughe number of records. are table and field…
-
Hi can anyone help we are using ms nav classic 2009 in our office
Hi can anyone help we are using ms nav classic 2009 in our office which was victimized by a certain ransomware that the last back up that i have was also infected by this ransomware now i cant restore the back up coz it says that the back up is not a ms nav classic copy, though it was a back up from the nav classic how can…
-
Code to deduct values between field
Hi All, My company would like to roll out customer loyalty program...a part of tasks will be make use our current Nav 5.0 (with LS-Retail POS 5.0) to accumulate customer's purchase amount ($1 = 1 points). Currently we are using this already as my predecessor had written some Reports to accumulate the transactions and to…
-
Cannot start navision
While opening the development environment I get the error "The file name C:\Users\name\Appdata\Local\Temp contains a character that cannot be used. Check the file name. You can find additional informations about file names in the documentation for your operating system". How can I solve he problem? Thanks
-
XML Order Import Articledescription
Dear Forum members im quit new to NAV and new to this forum. I have a question about XML order import. This is a XML code provided by Microsoft MSDN <Root> <Header> <DocumentType></DocumentType> <SellToCustomerNo></SellToCustomerNo> <No></No> <BillToName></BillToName> <BillToAddress></BillToAddress>…
-
table is getting to large
The table sales header is getting to large (more than 4'000 Bytes) after adding various new fields required for additional functions. Does anybody encountered the same Problem and what is the solution? Shadow table? Thanks for any help und ideas RalphW
-
pallet specific info/receipt of goods
i have a couple of questions about receiving goods in NAV. We store steel plates in our warehouse, and i would like to know if its possible to put into NAV the pallet-specific information when receiving goods? Now when receiving goods, we receive for example 2429 kgs of one product and NAV only teels me that we have 2429…
-
Blanket order to Sales order
Hi masters, I created a Blanket order with different shipments like this sales line :10000 Item : 1000 Shipment date : 09/29/07 sales line :20000 Item :1000 shipment date :10/01/07 salesline :30000 item : 1150 shipment date :10/09/07 to customer 10000. Now i want convert only sales line 10000 with Shipment date : 09/29/07…
-
display a field
Hello, if I have a list of 3 records(R1,R2and R3), each record consists of three fields(F1,F2,F3), I want to display only one field of each record on a factbox (i,e F1 of R1,F1 of R2, F1 of R3) .How can this be done?
-
Entries applied to an Outbound Transfer cannot be unapplied
Hi! Anyone who is using the Application Worksheet? What is this intended for? I've been using this whenever there is a difference of the Qty calculated using the Revaluation Journal and Inventory Valuation. Is there any way to avoid using this application worksheet to balance the Qty generated from Revaluation Journal and…
-
Empty Value through Webservice
Hi, I have a problem with a field of type Date in a table in NAV which is part of the primary key. The issue arises when trying to update an already existing record with the Date field filled in through a webservice and try to make the field empty. What value should I pass through the webservice to make NAV accept an empty…
-
Adding a Toolbox Indicator
Hi Guys, I'm trying to add a Indicator to display the progress of a change log search on NAV 2009SP1, But I'm not sure where it needs to be pointing at. Any help would be great
-
Get IP Address
Hello can someone tell me if there is a chance to get the IP Address of the client from NAV? Thanks for your input!
-
hidden tables
Hello, is there anyway to access the fields of a hidden table, in specific table 'AllObj (2000000038)' ?
-
How to instance mscorlib in Nav 5
Hi! I'm trying to instance mscorlib.dll in Nav 5 but I can't. I'm trying this code: IF CREATE(varArray) THEN [Code] With this variable: varArray Automation 'mscorlib.dll'.Array How I make this? Thanks!
-
How to create recordlink by C/AL-Code
In NAV09 I'm able to create recordlinks manually including the possibility to generate a message for a specific user. Now, I want to create such a recordlink with a message by using a C/AL function, but I don't know how. Could anybody gives me some advices or hints? Many thanks.
-
I m getting an error,during creating a new database from Power Shell...
C:\WINDOWS\system32> New-NAVDatabase -FilePath C:\Dynamics.90.W1.42815.DVD\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\90\Database\Demo Database N AV(9-0).bak -DatabaseName NavBase -DatabaseServer RAYMUNDO\NAVDEMO New-NAVDatabase : A positional parameter cannot be found that accepts argument 'Dynamics'.…
-
Conversion of a string
I'm trying to assign a string with a decimal (myVar := '* ' + Amount;) it gives me an error of conversion... How can I evaluate this? Thanks!
-
.Net DLL as a automation variable - No class shown in selection
Dear Community, i got a question about using .Net DLL's in Navision Classic Client. I wrote a test dll for testing how to implement da dll file into navision, that it is able to use as automation variable. Picture of my C# class (developed in .net 4.5.2) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I added my…
-
If statement in a report
I have two fields, a and b. If a is empty and b is not I want to write b, if b is empty and a is not I want to write a, if both are not empty I want to write "a / b".... I don't know how to do this :( ... Thanks!
-
The Gen. Journal Template does not exist. Identification fields and values: Name='PAYMENT'?
When I try to create a payment journal in payable accounting, I got an error: "The Gen. Journal Template does not exist. Identification fields and values: Name='PAYMENT'". I don't why I got this error, so can you please give me your advice.
-
Issue with Microsoft Navision Mail. IMessage
Hi, I had a request to replace the Port number for emailing in Navision 09R2 - found a modified version of the Microsoft Navision Mail for Nav 09R2 on a partner site and eventually did the changes. Client then decided not to change the port number. I have revert back the dll to original one and objects have successfully.…
-
Issue with Microsoft.Navision.Mail.dll
Hi, I'm having an issue with while registering the Microsoft.Navision.Mail.dll. I have place the DLL in the folder C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic and did the following steps. 1. Right Click and Choose open with 2. open with Microsoft register server I am having the attached error.
-
Qty. to ship must not be greater than 0 units in Warehouse Shipment Line
I am trying to complete a transfer order, in doing so I am going to the Warehouse Shipment card to complete the shipment. I get the error nothing to post when I try and post the shipment. When I try and autofill qty to ship the page cycles but nothing happens. When I try and change qty to ship from 0 to 1 I get the error…
-
Running Multiple Reports
Hi everyone! This is my first time I make a question here. I am new working with NAV, so I hope I don't ask any stupid issue... I am trying to run different reports, this reports are invoices for diferent clients. I don't have any problem to run the report from the page of one specific invoice, but the problem comes when I…
-
Sales Order Header Shipping Date not computing/ adjusted GST computation for Service Charge
Hi! I'm a newbie in NAV and using the classic version. Just have 2 question now: 1. why is the shipping date on sales order header not computed same way as the shipping date on the sales line? i noticed that the date on the header was the one displayed for printing. Any effect on anything? 2. i ticked the allow gst diff on…
-
How can I populate value automatically instead of the selection in Payment Journal?
In Vendor Card >> Bank Account I already fill in the data, the point is I checked at "For Direct Credit" already. The Question is 1. In "Payment Journal" in "Export Type", Why do I have to select the data again? 2. Is there the way to populate that value automatically instead of the selection? Thank you for helping in…
-
Balance in Sales Prepayment Account
Hi Our client is using NAV 2009 r2 Classic Client. The user posted Sales Prepayment for full order amount with foreign currency (USD), which results -164,885.78 (LCY) in the Sales Prepayment Acccount. When posting the actual sales invoice in the next month after the prepayment is received, only 164,885.77 (LCY) was posted…