-
Is there a fix for Document No. not incrementing in Payment Journal after posting?
When I post an entry in Payment Journal, let's say document No. is A001, after successful posting, the document stays A001, it should be A002. I also noticed that the No. Series Last No. Used is empty, it should be A001. Is this doable in NAV Setup or there are some code changes at the back?
-
Navision Partnership What is Necessary ?
Hello, We'd like to add to our service implementation of navision for companies who are in a need of ERP. Can you tell me please what we have to do, where we should see prices of licenses and e.t.c. shortly to say we need every information.
-
Dynamically creating a process only report without the use of "Processing Only" property
Hi everyone, Is there a way to create a process only report without the use of 'processing Only' property In NAV 2009? I want a standard report with sections to behave as a process only report depending on a condition. Looked into skip and showoutput functions didn't get the desired result. Thanks in advance. Mathan.
-
An attempt was made to change an old version of a transfer header record in dynamics nav 2015
Hello Everyone, I add two fields in Posted Transfer Shipment table Total Quantity and amount by using calcfield on Transfer Shipment Line table. To calculate amount against each item i use code and insert in Amount Field and modify that field. It work fine but is that when i create new transfer order i display error…
-
Integration of Siebel CRM with NAVISION
Hi, I'm very new to integration part of navision with Siebel CRM. I have some doubts in this integration. Actually my client is using siebel CRM currently. They are going to use NAVISION too. Now they want to integrate Siebel CRM with Navision. So, I need to know the following doubts. Kindly assist me on how to achieve…
-
How do I make Phone number a fixed pattern
If the user enters 9 digits: 01202345678 I need it to be changed to 10202 345678 (5 characters + space + 6 characters) The problem is to know where to enter the code. The On Validate is not good as if the field is changed by code, it triggers the code again. I can run the code after leaving the record bit is it possible to…
-
What is the ZUP file?
Hi folks, Sometimes when i'm exiting Navision im asked if i want to replace the ZUP file....will one of you tell me what it is please? Cheers, triona* :D
-
Find Items with missing shortcut dimension
I need to find a way to find or filter Items that are missing an important Shortcut dimension
-
It is not possible to open the report for edition (start-end tag issue)
Dear all, I am getting this error message saying, it is not possible to open the report for editing, detailed description: The "Value" start tag on line 6538 position 44 does not mat the end tag of "TextRun", Line 6543 position 43. Any suggestion how to fix? (I am new to NAV)
-
Item Ledger Entry Table
Hi, In Item Ledger Entry table, there is a field called source name which displays customer name. But it is only doing for document type called as sales shipment. I did opened the Item Ledger Entry Table, look inside the table, there is a field called source name, with field no as 50100, when i look at its property, it…
-
The sales invoice line does not exist Identification field.
Dear Experts, I am getting an error " The sales invoice line does not exist Identification field & values. Doc no " abc " Line No :"10000" while doing copy document in Credit memo form. I selected doument type as posted Invoice & document no., include header is checked .I tried to debug but could not find the link. If any…
-
automating Payment Allocation to invoice
Hi I want to automate payment allocation to invoices. Eg, if i have 1 payment that needs to be applied to 1 invoice and it needs to be allocated. I want this process automated rather than going into customer ledger and set applies to id and then post. I wrote a code unit that takes the parameters and set applies to id,…
-
Dutch XBRL schema
Dear all, Since BAPI will be replaced by SBR(XBRL) i'm investigating the changes that have to be made. Luckily XBRL is supported by NAV and the schema's can be imported. I tried to import the IFRS schema with success, but when I tried to import our Dutch XBRL schema's for ICP and VAT declarations provided by the Dutch…
-
Blockchain importance in Finance
Hi All, Traditional financial or ERP systems operate with a centralized database, which would help to analyze the business transactions by using various reports such as Balance sheet statement, P&L statement, Cashflow, TB.... and ERP's can be accessed by the authority people, who all have appropriate access. In addition to…
-
how to export the sign "µ" into textfile
Hi all Classic 2009 - I want to export data to a textfile. Have made a report taking vare of this. Problem: the sign (letter) µ is exported as a special Danish character (Extended ASCII code 145). I can't make it work. Can anyone help me out in this matter?
-
NAV 2009 SP1 - GET data from an API using 'Microsoft XML, v6.0'.XMLHTTP60
Please would someone be able to help point me in the right direction with this? I am using NAV 2009 SP1 but need to GET data from an API using 'Microsoft XML, v6.0'.XMLHTTP60 The API also needs an API Key to be used and this key has been made available to me. So far I have a codeunit which has the following global…
-
Definition of Item table has changed. Possibly related to out of hours SQL job
Hi all, We have a customer that is getting a sporadic issue where users are getting an error that the definition of table 27 has changed. This is simply and easily rectified by re-compiling the object, however we are trying to get to the root of what is causing this error. From looking at the event viewer, it appears that…
-
Access Username & Password protected folder share (Windows) through NAV 5.0
Hi there, I want to automatically (no user interaction!) save a file to a network shared folder that is not inside the same Domain as the NAV 5.0 Client. If you access the folder through the explorer you'd need to enter the credentials (Window pops up). How can I achieve that (Establish connection, login, save file) in…
-
Basic Manufacturing Question
Hi, I'm trying to determine the necessary steps to post production output in the production journal. I've read in several articles that "only the output quantity on the last journal line with the entry type Output will adjust inventory level when posting the journal." So if I have a production order for 10 units, and…
-
Getting the First Date of a Shortage
Hi I am new to Nav. I need to run a report that shows me what date and SO we will be short for an Item. example for the item listed below I need to get the date 11/21/2018 and the SO SO100306. Item No Date SO QTY Inv after Order F100314S 10/26/2018 SO100296 420 628 11/16/2018 SO100307 420 208 11/21/2018 SO100306 420 -212…
-
Sharepoint
Hello, I need help to cut(or copy) all files in Library from SharePoint to local C:\ tanks
-
Alternative to BigText return value in nav 2009 R2
Hi, I'm working on a webservice that returns invoices as PDF. In this I have a function that is supposed to flush a base64 enocoded PDF, which works fine i more recent version, but in 2009 R2 the text return value is limited to 1024 bytes. Is there anyway to work around this inside the codeunit? Plan b is to generate the…
-
Message after select an fieldoption
Hi, I have a field, type:option. Option1,Option2. If i select Option 2 in a form I would like to get a message " you selected 2,are you sure". Can someone give me the code how to do this. Thanx !
-
We have purchased a new printer how do I set up in Nav?
The version we are currently using is 2009R2
-
There in no Cust.Ledger Entry within the filter error
We are using the Dynamic Retail module in Nav2009 to connect with our Depots using Replication. There were Sales invoices made at one of our depots that replicated well but are failing to post to the GL in the main database. The schedule log shows the error below "There is no Cust. Ledger Entry within the filter. Filters:…
-
Transfer orders GL impact is not correct(debit leg of entries is missing)
Hi all, The general ledger entries are not getting effected correctly(debit leg of entries is missing), while posting the transfer orders. please help,Thanks
-
Calculate Invoice Discount on Prepayment Invoice
Hi all, In standard nav, when you calculate an invoice discount on a sales order, if the order has prepayment %(ex: 50%); the invoice discount does not show on the prepayment invoice. I need the invoice discount to show on the prepayment invoice. Can i solve this without adding code? Any idea about this? Thanks
-
NAV strange behaviour when doing a get()
Hi Mates, I hope you all right. A colleague and I are a bit surprised with this: I´ve got some strange behaviour (see attached screen) For some reason get() for rec37extendida.get does not work unless you set the values into code and integer variables. vCode:=Rec37."Document No."; vLineNo:=Rec37."Line No."; This has been…
-
Report with automation
Hi, I need a blank report number 50136 with some variable of Automation type of 'Windows Script Host Object Model'.WshShell. Can someone please send the fob file to me? I would like to try something, but don't have sufficient license. Thanks!
-
Get Amount Including Vat of Sales line in purchase Line
I have the "purchase quote" page and in the lines section uses the page "Purchase Quote Subform". I need to create a new column in the lines part of the page (Purchase) and show the actual price of the item. So in order to his I have two options: or use the sales line table (amount including vat) or use sales price table…