-
Error on Posting Purchase credit memo
Hello Everyone, While Posting a "Purchase Credit Memo", I am facing the below error : "The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error. Contact your system administrator.…
-
NAV 2009 payment voucher reporting
Hi All, I need to print invoice tax amount in Payment voucher which is applied to specific related invoice tax amount. i have used detailed vendor ledger entry table to develop this payment voucher. how can i get this invoice tax amount to this report
-
Cost Adjustment Report takes too long.
Hello, We have a client that is having issues running their adjust cost item entries routine. The report takes way too long to run. I ran the report on Friday (may 2nd), and until today (monday - may 5th) it was still running. Any idea why it might take so long to run and what can be done to speed it up. Or if someone else…
-
Access, Edit, Save BLOB at runtime - Auto export / import
Hello, My plan is to store a RTF or DOC file in a BLOB field, and when user requests it via AssistEdit, I want to export and open the file, maintain the connection between Navision and the file, and when user closes the file, I want to update the BLOB field. so in steps: 1-User opens the file 2-User Make changes 3-User…
-
Excel Buffer/Automation
Hi to all Can someone explain me please, how to use Automation? For example I have such simple code (using excel buffer, as u see).WITH ExcelBuffer DO BEGINRESET;DELETEALL;SETRANGE("No.",Rec."Accountable person");NewRow;AddColumn('First Name',FALSE,'',FALSE,FALSE,FALSE,'');AddColumn('Middle…
-
Nav sending email problems (TNEF Correlator)
Well, this is the situation: Nav standard SMTP creates the email and then are sent using linux sendmail server. Old email receipients are unable to read it (winmail.dat attachment) seems like NAV smtp codeunit (the automation inside it) adds this string to the emails: X-MS-TNEF-Correlator:…
-
2 IE windows opens when calling HYPERLINK
Have a customer where 2 IE-Windows opens when calling HYPERLINK in a codeunit. I cannot replicate this on my test system, so it has to be an "undocumented feature" on customers machine. Any ideas where to begin to look for this?
-
Is it possible to Delete Navision Variables dynamically
Hi Everyone, I need to delete all the code,functions and variable of particular table dynamically. Is it possible in navision...i need only fields in the table.
-
Returning multiple values from single function
Hello, Can anyone help me in that, how can I return multiple values from one function? As NAV allowed to select only one return type in function declaration. Thanks in advance.
-
Difference between FINDFIRST and Find(-)
Hello Everyone, Can anybody help me in that, What's the exact difference between FINDFIRST and Find(-)? In what scenarios its feasible using FINDFIRST and in what scenarios we need to use FIND(-)? Thanks in advance.
-
Item Quantity and Remaining Quantity do not match
We have an installation which 6 or 7 years old (that much data). On random check on Item Ledger Entry table, we find few items Sum of Quantity and Sum of Remaining Quantity per location DO NOT match. I am asked to find a list of mismatched transactions. I know the list of items to check and the location. How can I run a…
-
Req. Worksheet versus In-Transit
One of our customers has an issue with their Req. worksheet. After running the 'Calculate Plan' option and posting Req. Worksheet lines for transferring Inventory between locations (and Transfers are created) it will re-create the same lines after a new 'Calculate Plan' run. It looks like inventory in-transit is not taking…
-
assembly Item.
Hello; how i can manage the follow situation: Item X is formed by Item1(Qte=7)+Item2(Qte=5). please i need to know how i can get item X in stock using item1 and item2? thx
-
Tabledata does not exist after renaming the table
i renamed the existing table with some new object id(original id is 70000 and renamed to 70001) . after renaming i compiled the object it is compiling without error. but when i try to run the table its showing error as "tabledata 70000 doesn't exist". so how to run that table without error i tried to insert data its…
-
Errors in text conversion (text no. 1969-0 does not exist)
There are errors in the text conversion because text no. 1969-0 does not exist in the .stx file.Internal error: 47-1 This error appears in NAV (2009 R2 Native), when we try to start a backup. Any idea why? And how to solve it? Thanks. Best regards, Emerik
-
Analysis View Entry table
Hello, We need to use analysis by dimension reporting but on some dimension we not been using and how we can do that.? Can I delete data in the Analysis View Entry table by going to the table and delete? Will anything serious happen? Thanks
-
DR procedures NAV 3.70A
I have a client that is still on NAV 3.70A. I am working with them to get them to upgrade. The project I am working on currently is to test a DR plan for them. Do you have the procedures to restore their NAV 3.70A to a new server? I have a VM setup and have NAV installed, but am realizing that I don't know how to apply…
-
HTTPWebRequest target principal name error
Hi, We are trying to get a webservice call from NAV to NAV in NAV2013R2 (to synchronize contacts between company's). We did this before using automations, but for NAV2013 we need to use .Net. So we took Gunnar's sample, modified it for utilizing XMLports, and get the following error : System.Net.HttpWebRequest.GetResponse…
-
Bin Replenishment without Directed Put/Pick
Hi All you clever people, I have customer, whose warehouse location is NOT setup with Directed Put-away / Pick. However, he would like to use the bin replenishment functionality (or something similar). The location is set up with Receive and Put-Away. When they receive pallets from their supplier, a warehouse receipt is…
-
NAV 2009 R2 - ERROR - The file is not a database. -
Hi NAV experts, I have a strange error that appears when I try to open a database (.fdb file) with NAV 2009 R2. Microsoft Dynamics NAV ClassicThe file is not a database. OK I have searched but no luck. Can someone help me with this? Did someone encountered this before?
-
Dynamic Report controls
hi experts How to show or hide controls into the report dynamically. Is there any method please guide me.
-
Unit Cost Update in Stockkeeping Unit table
Hello, I run the "Calculate Purchase Cost" per location for an Item, but the "Unit Cost" for the item in the table Stockkeeping Unit is not updated!. Is this how it should work? Do i do something wrong? Is it a bug? I would really appreciate any help. Thank you
-
Charge Item Tax Calculation
How to calculate the Charge Item Tax? I have cross checked on Navision version 4 to 2009 and found tax for the Charge Item is not working on Purhase documents. Let me know is it possible by any manner to calculate the same. ](*,)
-
Error on Revaluation Journal
Hello Everyone, When I ran the "Calculate Inventory Value" batch job on Revaluation Journal, I got an error : You cannot assign new numbers from the number series IJNL-REVAL on 31-3-12. I have already created the number series for the revaluation journal. Can anyone suggest ? Thanks in advance Vivek
-
how to empty BLOB Datatype
i have one variable called "ClearPic" with datatype of BLOB. assume that the variable is holding some value of BLOB datatype. now i need to empty that variable and assign null value(i mean it should not have any value in that variable). so need to empty blob datatype.
-
"Job Ledger Entry"."Remaining Amount" ?!?
I'm working my way through "C/SIDE Solution Development in Microsoft Dynamics" (as I've mentioned elsewhere) and I've encountered another puzzlement. On page 4-28, field no. 22 in the "Seminar Ledger Entry" table makes mention of "the Remaining Amount in the corresponding Job Ledger Entry". Here is my puzzlement: there is…
-
Lot No change if there's a condition
Hi guys, i need to modify the Lot No on Puchase Order if the Item has a particular Unit of Measure Something like this: Lot No. SL120330 HN (where HN is the Unit Measure Code) Since the Lot Nos are defined on the No. Series table how can i accomplish this automatically when the condition is verified?
-
Automating FTP transfers in passive mode
We have a process that is creating a batch file that sends files through FTP using the windows command prompt and FTP commands. This has been working fine until recently. The server where the files are sent now requires that we use passive mode. QUOTE PASV doesn't work properly with the Windows command prompts. The server…
-
Adding filters to report
Hi to all, Have some problems with creating of report. For example, have 2 tables - "Employee" and "Pers"(have some key fields from Employee). Data from those tables have to be shown in report, on pressing special button, that is on the form. I can set filter in such a…
-
automate change of production order status
Good day! Is there a way to have a batch job that will automate the change of status of completed production orders to finished? It's currently taking around 5 mins to change a status for an order and I would like to improve that process.