-
XMLPort Items-Variant-Inventory
Hello, I want to create structured XMLPort like as this example<Items> <Item No="123"> <Description>Item</Description> <Variants> <Variant Code="1"> <Description>AAA<Description> <Inventory Location="120" Inventory="15"/> <Inventory Location="130" Inventory="17"/> </Variant> <Variant Code="2"> <Description>BBB<Description>…
-
Error While sending mail through SMTP(G-Mail)
Hi All, I am getting an error while running a report which sends a mail with SMTP Setup in NAV 5.0 SP1 mentioned below : SMTP Server : smtp.gmail.com Authentication : Basic UserID : specified the user id. Password : specified the password. The error which i m getting is given below :Microsoft Dynamics NAVThe SMTP mail…
-
Mandatory Fields by "Piggybacking" Codeunit 423
Hi, I'm working my way through CSIDE Solution Development (80437) this week and had the thought has anyone tried amending codeunit 423 "Change Log Management" and Change Log Setup (Field) to include a "Mandatory" boolean? I've searched the forum and found a few suggestions on modifying codeunit 1 on modify trigger, but…
-
Difference beetween two dates - 30 days per month
Hello, I would like to calculate the number of days beetwen two dates but with a fixed number of days of 30 per month. It is for interest calculation. Thanks in advance for help
-
NAV 2013 Issue
I just started playing around with NAV 2013 and I am noticing something weird. Lets say I open RTC and then in the development environment, I go and make some modification to a table. If I try to execute the table, nothing happens. I must close the RTC session and then if i try to execute the table, it opens up. Same thing…
-
Add VAT onto food price
Hi, We are using NAV2009 R2 with LS Retail POS. We have various baby food items for sale in our shop, and these do not have VAT on them. However, customers can bring them to our cafe to be purchased as a meal, and in this situation we need to charge VAT, and increase the price accordingly. Has anyone done this before, and…
-
LibreOffice and NAV2009
Good day! We have clients with LibreOffice and would like to export reports or grid information into a spreadsheet. How can we directly configure NAV to use LibreOffice Calc instead of looking for Excel? Thank you.
-
Approval Document set up query
Hi All, We're trying out to use Approval Document after using Nav 2009 for some time now. I am setting up the Purchase document approval for Purchase order. When I take the "Approval Test Report" (for all users) it is saying ok. Users had been set up in Approval User Setup. Approval Template for P-Order is Enabled. Users:…
-
Developers Toolkit error Bug
i couldn't find this in google, i suppose there's not in mibuso, too... Do anyone have ever seen this? This happens when i'm trying to import a text file in dev toolkit, version 2.00.291 (the last one before the one that support nav2009) Developer's Toolkit for Microsoft Dynamics NAVThe Object Imported table contains a…
-
Columns as a sub total and grand total in A/C Schedule
Hi Experts, I want to show 2 columns in Account Schedule(using column layout),first one is for showing subtotal of individual values and 2nd one is for showing sum of a group total(or sum of a specified range). Actually i am creating Profit and Loss A/C & Balance Sheet and i want to separate individual values,subtotal and…
-
2013R2 Excel Buffer - excel formula
](*,) Dear Experts, I am making a report export to Excel by Excel Buffer. In classic client, i can easily make excel formula like: ExcelBuf.AddColumn('=(RC[-4]*-1)-(RC[-3]+RC[-2]-RC[-1])',TRUE,'',TRUE,FALSE,FALSE,''); But now in 2013R2, i make it:…
-
Entering Opening and Closing balances as per given Trial bal
Hi Experts, In a new implementation,when i had received a trial balance through our client,a trial balance which contains both opening and closing inventory values;like i have received opening inventory on 01/04/13 is 1,00,000 and closing inventory on 30/09/13 is 40,000(A half month trial balance). I have entered closing…
-
msxml6.dll error SelectSingleNode Failed
We are running NAV 5.0 SP2 on Windows 2003 SP2 with SQL Server 2005 SP2, whenever we go to try and import data from Administration>Application Setup>company setup>Data Migration we receive an xml error: This Message is for C/AL programmers: The Call to member selectSingleNode failed. msxml6.dll returned the following…
-
Saving PDF to a BLOB filed
Hi, I'm new on this forum. I'm looking for how to save any file in a Blob Field. As Import function is not supporting In NAV 2013 I'm Working with NAV 2013- with SQL 2008 R2 .
-
Upgrading to 2013 from 3.7
I posted a while back in regard to the best practice in getting our 3.7 native database over to 2013, and I believe we have that nailed down. What I'm looking for advice on now is on getting the objects over there. We have what I'm assuming is a pretty simple NAV setup: 80GB database, one company, not much in the way of…
-
DataItems and Level of Indentation in Reports
Hi ALL, Can anybody tell me how many maximum no. of Data Items I can add in a NAV 2009 and NAV 2013 Reports? And According to my knowledge we have a maximum 10 Level Indentation (Limit) in NAV 2009 Reports, But in NAV 2013. What's the maximum limit for that? Thanks in advance.
-
Excise Entry Correction After Posting Using new Excise Setup
How to correct the Excise for the posted document with new / updated Excise setup in Microsoft Dynamics NAV 4.0?? At the time of posting Excise setup was wrong, so system not calculated the Excise. So is there any way rectify the posted document with updated Excise setup...
-
Load InStream to Xml Automation
Hi All, I'm really struggling here with something that should be simple.... What I am trying to do is to load a stream to the XML DOMDocument automation without saving it to a file and then loading it.......but it doesn't work the load instruction fails without any error but simply not writing anything to the automation...…
-
VAT VIES Webservice
Hey, I am quite new to the forum, but I believe I have just about read every single post regarding webservices on the forum, without finding the answer to my problem. So I decided to post a new thread about how to validate a EU vat number against the european database in VIES. Can anyone give me a hint to why the following…
-
Import Consolidation from File works very slow.
Dear Colleagues, We have performance problems while consolidating data from daughter companies and we would appreciate any comments and suggestions how to improve/overcome the issue. Environment: NAV classic client (32 bit, finsql.exe, MS Dynamics NAV 2009 R2) in 2-tier configuration. Report 92 “Import Consolidation from…
-
XMLport Filters
Hi to all. I'm trying to add filters from form to XMLport but don't know how to do it right) For example that helps me, when I'm adding filters to report: Employee.RESET;Employee.SETRANGE("No.",Rec."Accountable person");TReport.SETTABLEVIEW(Employee); And the same doesn't works with…
-
grouping the Posting date in the G/L entry table
Hi guys, can any one help me, i have a report consist of two data items,Customer and G/L entry with DataItemLink: Source No.=FIELD(No.) i am trying to group the posting date in the G/L entry, i have the GroupTotalFields:Posting Date and the DataItemTableView:SORTING(Source No.,G/L Account No.,Document Type,Posting Date)…
-
NAV Allocation Documentation
We are currently in the process of setting up and testing our allocations in NAV (NAV 2009 SP1 - 6.00.01.02) We seem to have a good handle on setting up NAV allocation process However, we cannot seem to find documentation of the different columns (example - period type) used in Allocation screens (mainly setting up…
-
NAV 2013 Upgrade - Conversion of Exe
Dear Everyone, We are doing the data migration from NAV 5.0 to NAV 2013. Now we have successfully converted the DB into 2009. All the steps we are doing exactly as per the quick-guide provided in the product CD. Now while doing the migration from NAV 2009 to NAV 2013, the Step 1 data migration is also completed…
-
Customized Field in Sales Invoice and displayed in CLE & ILE
Hello Everyone, I want to add a new field lets say "Field1" in the Sales Invoice and wants that field to be displayed in Cust. Ledger Entry and Item Ledger Entry as well after posting the Sales Invoice. I have added the new Field "Field1" (with same id and datatype) in the sales Header table (36), Cust. Ledger Entry Table…
-
Reprocessing Production Order-Manufacturing
Is it possible to reprocess a production order in NAV4.0 -sp3? How we can manage reprocessing in Navision
-
Question about Inventory Availability
We have a customer that has raised a question about inventory availability that I haven't thought about before, and frankly, don't know how to respond to. Here are the steps to recreate the scenario (The customer is using NAV 2009 R2 classic): 1) Let's say the customer would like to purchase item no. ABC on 06/10. This…
-
Tagging Sales person code
hi experts I want to tag more than one sales person code in customer card. is it possible ? If yes please suggest me how can i do this?
-
What is this error - Copying all filters at once..?
Hi Experts! Can you tell me, what I have to do, when I get a following error in NAV:
-
[solved]Changing Base Application Object
On C/AL Programming Guide I have readen that I must add documentation, for example They had wrote on the manual Changing Table Fields Updates of Microsoft Dynamics NAV will not affect new fields that have been added to existing tables. That is, the new fields and their properties will be left intact. Because the fields are…