-
Hi All! I want execute parametrized sql text query in Nav2009
I use microsoft ado library 2.8. Question in how can i pass the parameter to the sql text query? SELECT [Project No_] FROM WHERE [CM FIO] = @UserVariable IF I compile SELECT [Project No_] FROM WHERE [CM FIO] = 'Kanye West' it works, but i want make this with parameter @UserVariable. My function where i am trying to pass…
-
Bin content equals 0
Hello, Hello, i'm a newbie in Navison and i encounters some issues. I tried to make a transfer order between 2 locations and the quantity in my bin content is equal to . When i check the Warehouse Entry, I see 2 lines one with a psoitif value eand the other with a negative value. Is it normal ? Does i'm made something…
-
NAV 2009 Spell Check
I have searched for a spell check solution and followed up with dvp and avf who list solutions, but they either don't support or haven't tested rtc. Has anyone solved this? Thanks, Tom Roberts
-
DATAPORT : how to return to the first line or read again the file ?
I would need to read the whole CSV file (to check each line) then go back to the first line to process the data. Is it possible ? How can I do so ?
-
Payment / Refund in Code
Hello, We have the scenario where the Vendor Ledger Entries have a Payment Entry which is fully applied. The Customer wishes to update the Dimensions they have set for that entry, so manually we would unapply the entries, raise a refund applied to the payment and then process a new payment with updated dimensions and…
-
the G/L register does not exist. Identification fields and values: No
I'm getting an error when trying to post connecting a payment and invoice: the G/L register does not exist. Identification fields and values: next No
-
NAV 2009 R2 - trouble with licensing after moving database
Hello forum, I've done some searching on this, and find a few people struggling with licensing, but none of the issues seem to match ours. The problem is that we've moved (duplicated) our NAV 2009R2 db to a different server, but the license is not working. We dont have the original license file, even though we are able to…
-
Hide receivable menu from 'Sales & marketing' group for particular user.
Hi Everyone, My requirement is to hide one particular menu: 'Receivable' for particular user only from 'Sales & marketing' group using menu-suite. Is it possible? Please help me. Your quick help will be appreciable. Thanks, Mani.
-
Books for Warehouse and Manufacturing in navision.
Hallo, I would like to read a book for advance Warehouse and Manufacturing in Navision. Some suggestions Many thanks
-
How to update COGS account if amount already adjusted
Hi Team, we are using Dynamics Nav 2009 version. We configured Automatic cost adjustment as "Always" in inventory setup. We posted wrong purchase order with wrong amount. After that sales entries also posted and cost adjustment also posted to COGS account. Now by using revaluation journal we updated the cost. But how to…
-
Trace the call to a webservice
(slightly off topic) Hello I'm trying to trace the call to a webservice, using ms soap toolkit. This toolkit ships with "mssoapt3.exe". Does anybody have experience with this tool? Unfortunately I don't even make it to trace a call to a webservice from a browser ](*,) Additional question: Anybody knows how to save a soap…
-
Updating other fields when a related field is updated in NAV Table designer
Hello, I have a table called Student with CustomerNo and CustomerName as fields from Customer Table. I want that when I update CustomerNo it causes CustomerName to get updated to match the name of the customer with the new CustomerNo. Thank you.
-
how to move items in advance warehouse in navision
Hallo all, How to move items in advance warehouse in navision ? Using Movement Worksheets or there is another solution. Any advance Thanks
-
Hyper-V
Hi All, Does anybody know if there's any issues with NAV running in a Hyper-V environment? Host Windows Server 2008 with Hyper-V Guest Windows Server 2003 NAV5.0 or 5.0SP1 If anyone could point me to some documentation as I've been unsuccessul in finding anything that specifically relates to Hyper-V & NAV. Thanks.
-
Can we use HorzGlue on a SubForm inside a TabControl in NAV 2009 R2
I have a Form1 with as Tabcontrol. Inside this TabControl, I have a SubForm which shows Form 2. Inside this Form2, I have a TableBox. Form1 : TabControl : HorzGlue = True SubForm : HorzGlue = True Form2 : TableBox : HorzGlue = True (same size that the Form2 -> Fullscreen if run directly) Why is HorzGlue on TableBox -…
-
Change Navigation Menu background color.
Hi Everyone, My requirement is to change navigation menu background color. could you please guide me, how can i change this blue color to other color. eg. from blue to green or red etc. thanks, Mani
-
Gap between header and detail
I have a gap between the header and the detail that I whant to delete, but i don't know how. Can anybody please hell me?
-
How to Setup Service Module
Hi, what do i need to setup in the service module to get this desired functionallity... When an Item gets sold to a customer, sometimes a Service Contract (OHC) should get invoiced to the Customer as well... This Service contract will be a Contract for Maintenance of the bought item. So it should be something like this:…
-
Going to a job list crashes the system.
Just one computer crashes NAV (it just disappears) every time you go to the job list (<company name>/Home/Jobs/Jobs or N050 Job List-Advanced (11014549) -- yes, we have ToIncrease installed ). I uninstalled NAV, stripped out every registry entry, every appdata entry and deleted all C:\Programs* NAV folders that remained. I…
-
Incorrectly Posted Invoice
Hello all, I am completely new to this program. I am replacing a woman who left very suddenly and has given me almost no guidance. I made a mistake and posted an invoice and did not also receive the shipping. How can I fix this? If anyone can please help I would appreciate it so much. I feel very lost in this program and…
-
Generic onModifyRecord for all tables
My company needs me to add some code every time the user tries to modify any of the fields in all the pages (for example in the customer card and in the item card). I want to know if there is a generic event to which i could subscribe to(like onModifyRecord ) that gets called before the modification of ANY OF THE FIELDS OF…
-
Skip empty field value during import through dataport.
Hi Everyone, I want to import 'FirstEmail' and 'SecondEmail' through dataport in customer table in NAV 2009 R2. But in the list of customer email fields, some customer doesn't have email. So, i want to skip that customer and to import for the remaining customers. But getting below warning:The field cannot be empty. Please…
-
Jobs -->> Invoice-->Credit memo-->Re create Invoice from same Job Planning Lines
After posting sales invoice, I have reversed using Credit Memo. Later I want create new sales invoice from the same job, It is showing nothing to create message. Please anyone help me how to create sales invoice after reversal of Posted Sales Invoice
-
Tools for automated testing in NAV/BC
Hello guys! Could you please recommend any tool (web-client) for automated testing in Navision or Business Central? Maybe someone has experience with it?
-
[Nav 6.x CC] Problem using Security Filters
Hi there, we want to use security filters for fitlering orders per user. Now we have a problem if there is code written. Example Filter: 0000..4999 If there is a programming as exaple get(5000) or reset we get an permission error. is there a way to check the permissions? in the case of reset the function readpermission…
-
Jobs (NAV2009 SP1): Bin Codes on Job Journals
Hi, The functionality of Bin's as on Sales, Purchase and Whse/Inventory documents and journals doesn't seem to work very well in Job Journals (NAV2009 SP1). After adding the field 'Bin Code' to the Job Journal Page/Form all the Bins appear (not only the bins where stock are available to pick from) when you try to select…
-
Best way to do a Gap Fit analysis
HI All what would be the best way to do a gap fit analysis on a clients system to compare business Processes with system processes? Please could someone assist
-
why one table changes can not be logged to "change log entry"?
one specific Table (Vendor) changes can not be logged in the change log entry? I have already activated the Change Log settings..
-
Sure Step Document
HI All i am unable to get the full sure step document without paying for it, does anyone have a link for a free copy of Sure step, i need it urgently
-
Is it possible to send receipts and invoices to mobile phone number from nav
Customers have made a request to receive receipts and invoices through their mobile phone. As they opposed to paper in fear of contracting covid 19.