-
Wrong Accounting
Dear All, A huge purchase vat amount has been loaded into the Inventory G/L Account instead of VAT Purchase G/L Account due to wrong setup. These all happened from the Purchase Invoice posting in the Dynamics NAV 2013 R2 IN System. When it comes into my knowledge I have notice that the entire purchased Item has been sold…
-
Nv5 Permission issue
hi am having this error when i try to restore a backup in nav5 using a developer licence-You do not have permission to run the '0' 8. Contact the system manager if you need to have your permissions changed. how can i go about this?
-
No. of logged users exceed licensed
Hi, guys Customer has licensed 10+1 user in its license file. Some users can log into NAV in case of licensed numberof users is already logged in. In that case there are more logged users then licensed. Some users can not log in with error "Your license file does not allow ....". NAV 5.0 SP1 SQL 2008 Standard with trace…
-
Direct Debit to PLA
Hi All, Can some one help me out on direct debit to PLA . I have availed service tax credit. During sales transaction service tax credit balance is not comming. Regards, Mohiddin
-
Depreciation - Easy and quick, how to?
In Standard NAV you need to enter a Depreciating Book Code to be able to run the depreciation. If many Book Codes it can (as I see it) take a long time. Anybody have a solution how to run depreciation on all Fixed Assets/All Book Codes just one single time? Cheers
-
How to get debit balance and credit from sql server in dynam
Hi guys i have dynamic nav 2009 and sql server 2005 I have this query show data from sales line and sales header SELECT ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [م], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'رقم الطلب', dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'العميل',…
-
Analysis View Budget Entry (table 366)
What exactly is the point of this table? The Analysis View Entry table is straightforward and useful, it compresses entries from the G/L Entry table based on the compression you select on the Analysis View, the budget entry table just... duplicates the G/L Budget Entry table. This is in Navision 2009 R2, we'd made a couple…
-
Interleaved 2of5 Barcode Printing Navision 4.0 SP1
Hi guys, Is there anyway to print Interleaved 2of5 barcodes in Navision 4.0 SP1? Thanks Pamela
-
Behaviour of xRec
Hi I have some code on a Table.OnModify trigger. When modifying is done from a form, everything works fine. However, if the modify trigger is called like "table.modify(true)", rec and xrec in the onmodify trigger are the same. Is this be design? Many thanks in advance Thomas
-
Problem with production order and component reservation
We have a process where a production orders is generated from the order planning and all components are inserted according the item BOM. That works as expected but for some reason it does not automatically reserve the components that are on stock. Looking at the code of the Carry Out Action codeunit it should perform an…
-
check checkbox in excel template
Hi All, i am using excel buffer to send data to an excel template. this template contains checkboxes. i want to check some of these checkboxes. what is the way to do this database nav 2019 r2 classic client excel 2013 have a nice day.
-
Global vs. Local Tables mixup in Objects and SQL
Did a search on the Internet and has not seen anyone else having a similar issue. Read on: SQL Server 2005 Nav 2009 SP1 Build 29626, Classic client only Problem indication: It is not possible to rename a Company. A message is displayed after some time requesting you to open a Company to work with this table. Error message…
-
From Shopping Cart to Navision - Import to Sales Order?
Hi there Nav pro's. The company I work for is using Nav 5 Sp1, native, and I have a general concept question on which I'm desperate for other's input, that is; We would like a way to get a low volume of orders from a website into Navision, via a CSV or XML file that we'd get from the Shopping cart. What is an efficient and…
-
So Slow when Creating Workbook to Excel
Dear All, I have issues that when i try to create workbook from Transfer Order Report or Purchase Order report. it is so slow to generated excel, sometimes took hours to completed it when usually only took few minutes to do that. i wonder where the problem is because the issues exists after I update windows server from…
-
Is NAV 5.0 Sp1 works with sql server 2008 R2?
Hi all, one of my client having nav 5.0 sp1. He need to upgrade the sql server from 2005 to 2008r2. Will NAV 5.0 SP1 works with sql server 2008 r2? Thanks in advance. Regards, Sekar
-
No. Series in Transfer Order
Hi all, I've been using Navision 5 and i got some problem with No. Series in transfer Order. I set wrong No.series for Transfer Order so when i created transfer order it directly set wrong No. Series even before posting shipment. is there any way i can change no series if i already create the transfer order? can i change…
-
RabbitMQ
Does anyone have experience of interfacing with RabbitMQ? We have a client that wants to interface with a retail web application and they want to use RabbitMQ to handle messages. Regards David dwest@jendev.com
-
Adjust Cost
Hi Everyone, I'm trying to put a list together with all the cases where the "Adjust Cost - Item Entries" batch makes changes to the cost. So far, I've only got 3 situations: 1) You sell an item before you've received the purchase invoice. 2) You post and Item Charge to an item which has been sold. 3) You post additional…
-
Abnormal behavior of DateFilter while running RTC Report
Hello, I'm running a report "G/L Trial Balance Report" customized one. The problem i face here is 1. When i first run the report entering Datefilter in (DataItem -> "G/L Account") with "FromDate..ToDate" in the Request Page, The report runs as per the filter which is specified. 2. The second time, the already given…
-
NAVISION 2005 : Fixed asset Posting group
Hi, I am creating a new Fixed asset, and can affect a FA posting group at each line. But, in the List of all Fixed asset, the field is empty . i have other Fixed asset, and all of them have this field (in the fa list) with a value. I can't figure out how to set this value, and moreover why....because each line in the Fixed…
-
export FOB via finsql (with multiple filter Types and IDs)
Hi, My first post but a long time public reader. I would like to ask if someone has done a finsql script with multiple filter types and id and generates one *FOB* file. For example, Page 19009080 Page 19009082 Table 19009097 Codeunit 19009080 If it is not supported by the query. Is there a way to generate one FOB with my…
-
Write/Read files on drive NAV 2009 Classic on Citrix
Hey. I have a customer who runs NAV 2009 via. Citrix. One of the modules they have is to store a pdf file on a shared drive and then attach it to a mail. In the dev environment where we run locally (without Citrix) this works fine. On Citrix we get an error that the file could not be found, contact system admin etc. I…
-
outside SSRS report possible issues question
Hi, We're mainly using data-warehouse to run outside SSRS reports on NAV data. However, for a few reports users need real-time data so I'm going to link those few SSRS reports directly to the production data. I'm considering running stored procedures on the production server or on the different server getting data from the…
-
User Menu Level
We use NAV 5.0SP1 with SQL server 2005. Recently we found that half of our database is occupied by a single table User Menu Level (about 120GB!) Searching the web I only could get this information that it is used to keep the user's permission in the Menu Suite in the Object (BLOB) field. Strangely it shows that it is less…
-
How to add an item to the right click menu
Hi everybody. I want to add an item to the mouse right click menu. If anyone can tell me if it is possible and if thou how can i do it i'll appreciate it very much. David
-
XMLPort Design (import)
Need some direction on how to setup the structure of an XMLport used for importing. I've used XMLports previously, but I need to create a new import for a file that's a little different then I've worked with before. I've provided a screen shot of the xml file. There's several lines in my file I'm not quite sure how to…
-
Item Ledger Error during Transfer Order Posting (Receipt)
Hello Everybody, Have anyone encountered this scenario? I've created a Transfer Order and posted it (to Ship) successfully. But during posting-to Receipt, i encountered an error message 'Item Ledger Entry Entry XXXX does not exist'. I've tried following instructions below as posted in previous forum, but it did not solve…
-
Issue with Prepayment in Nav 2009 R2 SG version
Dear Friends, My customer is having this error while trying to post Prepayment Payment Orders. Error screenshot attached. I did search the forum, googled it, but couldn't find solution for Nav 2009 R2 SG version. 1. Create a PO, enter prepayment% in the Purchase header. Post it. 2. Reopen the PO change the Prepayment % to…
-
Classic Report runs RTC
Hello, I'm programming a report on a NAV2009 Classic Client. The Report is triggered on a form. On my PC there is only Classic client installed (no RTC) and the report prints correctly. But when I run the report on a PC where RTC was installed (without being used) then the system tries to run RTC - which fails because it…
-
new version PDFCreator, classes Option and Error
Did Anyone already use the new pdfCreator 2.0.2.? I do not recognize the classes that should connect to the globals Name Subtype DataType Length PDFCreator Unknown Automation Server.Unknown Class Automation PDFCreatorOption Unknown Automation Server.Unknown Class Automation PDFCreatorError Unknown Automation Server.Unknown…