-
NAS Report Error
A report needs to be run using NAS, therefore, we cannot have any popup windows (i.e. message, request windows, error, etc). If I were to run the report (50006) manually, in the request window, I need to input a PostingDate. Since we are running the report using NAS, I need to suppress this request form and apply the…
-
Dataport cannot support LS Retail Scheduler
I used Navision 4.3 in my office. My user must to update the table ITEM at Item.description field. ฺBy have a lot of data. I used dataport with table ITEM. By have 2 fields : No. and Description. After the dataport updated from the import excel file. I run the Scheduler Job and found that it does not send data to other…
-
Salesperson Commission State-wise
Hi, In salesperson/purchaser, there is a commision % field, on the backend of that field i create a new table containing following fields 1. Salesperson Name 2. State 3. Commission Percentage So now I can select the percentage on salesperson/purchaser table. But the problem is if for eg: same salesperson does the sales…
-
FORM1.RUN :- SETTABLEVIEW & Temporary Table
Hi, How to run a form object variable whose SETTABLEVIEW has Temporary Record set. formobjcet.SETTABLEVIEW(TemporaryTable);formobjcet.RUN; kindly reply.
-
Budget Import Question
Is there a limit to the number of worksheets that Nav will process when importing a budget in Dynamics Nav 2013 from Excel?
-
Report Print out to Local Printer, Login to Terminal Server
Hi, Can any one help how I can send Report print to Local Printer which is installed to that branch when I loged at Server through Remote Desktop Connection. My version is Navision 2009 Classic. Thanks to you in advance.
-
Error running SMTP component on Citrix - NAV2009 R2 Classic
Hi, I have some users running NAV2009 R2 Classic client (build 6.00.34591) and executing some processess that user the standard NAV SMTP component on a Citrix server farm. Several threads here on MIBUSO reference the same error we are getting: Could not create an instance of the OLE control or Automation server identified…
-
he Record variable must belong to 81 and not to 50009
Dear All, I save table 81 as table 50001 but after compile I am getting following error Microsoft Dynamics NAV Development EnvironmentThe Record variable must belong to 81 and not to 50009.OK Pls Help me to resolve
-
Sql Server restore
Hi, I have changed our NAV application (2009 R2) to a new server. I took the sql backup and restored it into new server. Now every thing is fine except few issues. Issue 1 : Few reports are not opened in Report Designer (It is hanging) Issue 2 : While takes Backup from NAvision, application hangs (Sql Bakup is OK). If any…
-
Problem with copy document feature on BOM lines
Hi, I'm creating new Sales Order and would like to copy lines from old Posted Sales Invoice lines The posted invoice has some item lines that are just basic items and then there is some exploded product structures when I use the function copy document and select this old invoice and recalculate the document it creates the…
-
Export flowfields to Excel connecting from SQL Server
Hi, experts, I need to export Item Ledger Entry table into Excel. I export data using "Connect from SQL" function in Excel. It works fine but it does not export the content of flowfields, namely there is no fields "Amount" and "Adjusted Cost" in the resulting Excel file. I understand that "Amount" and "Adjust Cost" are…
-
Unit Cost Calculation
Hello Experts, I will like to know if the unit cost calculated on the item card included Routing information (i.e cost of machine centers capacities) Thanks
-
Error C/AL Programmers The call to member IsActive failed
Dear All, On posting a credit memo in Navision, I am getting the following error message: 'This message is for C/AL programmers: The call to member IsActive failed. Webservice Wrapper returned the following message: Object reference not set to an instance of an object'. Does anyone have an idea what might be wrong please?…
-
whats the latest 2009 R2 build?
Who knows whats the latest 2009 R2 build? And where to get it on PartnerSource? My searches are worthless.
-
Serial No. Duplication
Dear Experts, I do not know why one of my items (item tracking code : SNALL) has two quantity for a serial no. Item: ECM001 Serial No.: 12002, Quantity:2 Duplication occurs. How would it happen?? Is there any bug? Can i use item reclass journal to fix it? thank you
-
Error when Posting Revaluation Journals???
Hi Guys, I am getting error when i posting the Revaluation Journals(Warehouse -> Inventory -> Revaluation Journal. The error is "There are new postings made in the period you want to revalue item no.123. You must calculate the inventory value again." First i run the Adjust Cost - Item Entries report upto date. Then after i…
-
Fatal Internal Error - Custom Code
Guys, i have a function that evaluates some conditions and then based on those conditions prints up to 3 reports. At times "Fatal Internal Error" happens and i suspect that this code is causing this error. I can see some obvious enhancements this code could use, but not sure if it would be the cause for "Fatal Internal…
-
Howto find service contr. with non-created service Inv.line
Hello, Iam beginner in C/AL. I want to create report, which can find service contract with non-added service invoice line. But I dont know, how to write a permision to find just service contract, which isnt connected with field in service invoice line table. Can you please help me with this problem? Many thanks for…
-
Inventory Valuation
Item is a Standard Cost Item, but cost was set as $0 in error. Item was received into inventory using Item Journals and posted (at $0 cost) Inventory Valuation report shows $0 cost. I have set the Item to correct Standard Cost. What do I need to run in order to update the costing (value entries)? Thank you.
-
What is a cyclic BOM? What is its functionality??
What is a cyclic BOM? What is its functionality??
-
"T_id should come here." - import txt error
Hi 1. I export almost 200 object's in one txt file. 2. I renumbering this file with renumbering tool 3. Import give me that error "T_id should come here." When i cut 5 codeunits form file(Line where import stops) import works fine.What means that error? Object structore in file is good for me..but..i can be mistaken…
-
Change Date format to YYYY/MM/DD
Hi guys, i want to change the format of date to DD/MM/YYYY to YYYY/MM/DD. How can i accomplish that? Thanks for your help!
-
How to give back ground colour in NAV 5.0 reports?
Hi all, I want to know how to give background colour in nav 5.0 reporting. If anyone know how to achieve the above scenario, Kindly let me know. Thanks in advance. Regards, chandru.
-
WEIGHBRIDGE AND NAV 5.0 INTEGRATION
Hi guyz Has anyone ever tried to integrate any version of Navision with Weighbridge?? I would like to capture the weighbridge readings directly from the weighbridge into Navision for any Receipt of Raw Materials/Returns and also Shipments. I wouldn't mind if anyone has used a third party component to capture the readings.…
-
Navision Data Cleaning
How to come up with the data cleansing strategy to make sure the data is reliable and accurate and free of errors. Did anyone work on it before?
-
Is the recordref open?
Am I missing the obvious parameter or function in C/side which would actually allow me to check if a recordref is open? This to avoid the error from NAV saying RECORDREF variable not initialized. Hope any one knows or maybe have a workaround other than keeping some parallel index for open or not. It is needed for a…
-
Receipt error for FA line
Good day! We could not receive an FA line in a PO. We have this error "You must specify depreciation book code in purchase line document type=xxx, document no.=xxx, line no.=xxx" We are using NAV2009 SP1. Your assistance is greatly appreciated.
-
Link betwen unrealized Gains and Losses in DCLE/DVLE and GL
Hello everyone, I want to ask if someone can help me with the following: While running the Adjust Exchange Rate batch job, the system creates entries for unrealized gains and losses in Detailed Customer and Vendor Ledger Entries and also in G/L. What I need is to link the G/L entries with the detailed customer/vendor…
-
Adding a Field to the Item Table
I have to add a field to the Item card. Can I add this field to the table while people are using the system. Everithing went ok in the test environment, but I was the only one on. Thanks
-
REP1007 / PrintOnlyIfDetail problem
Hi I've got at problem with REP 1007 - Job - Transaction Dertail. A customer wants a minor change, where the budget per Job Task is printed in the group header and thus must be printed although there are no job transactions for the job task in question. So in the report I set the PrintIfNoDetail property for the Data Item…