-
VAT input credit amount gets added to cost of inventory
Helo experts I am from india localisation .when purchase invoice is done ,vat amount is not posted to the G/L a/c but instead added to cost of inventory.In Tax structure details ,"loading on inventory' is unticked and 'available for VAT input" check box is ticked.Am i missing any posting/setup? Regards Tharakan
-
Combine Licenses
Good day! We have 3 companies under a single management. Companies do have their own NAV2009 SP1 instances and licenses, 2 are under a 1 business partner then the other 1 on a different partner (a headache in terms of getting support). To improve the administration and leverage on the available licenses, I'm thinking of…
-
permission
Hi expert, I have a question on a permission. We have switched from the 4.0 to NAV2013. All of the users roles for NAV2013 are exactly the same as those in the old system. But we have a user who cannot place the purchase order. Every time when he selects the vendor id from the purchase form, the system crashes and…
-
Question about limited NAV licence
Hi all, I wan to ask if it is possible to process approval request using limited NAV licence having in mind that write access is restricted to 3 tables only? :oops: Thanks and Regards Meri
-
Updating objects in NAV2009SP1
Hi all Have a weird problem. Trying to update som revised objects in a customer database (native), but it stops - simply stops with no error messages at all. Then copied customers database to my local PC and here the updates just slipped in like a ...... Have visited a billion websites trying to find out what is happening,…
-
Vendor charges tax but also need to post use Tax
Scenario- Vendor A sends us an invoice for $104 dollars. On the Line is the G/L account XXXXX with a price of $100 and the line is marked “Taxable”, with a Tax Group Code of “taxable” and a Tax Area Code of Louisiana(which is 4%). So the vendor is charging Louisiana Tax but not the Parish Tax (3.5%) for which the customer…
-
Cancel PO
A PO-49330 has 4 lines. Two lines have been received and 2 lines have not been received. A new PO-49687 is created to correct the vendor and we need to have two received lines of PO-49330 to incorrect vendor cancelled. Issue -> 1) The first 2 lines have been received, and final two lines need to be cancelled. How can we…
-
How to relate ILE entry no. to posted credit memo line
Hi all, While posting the credit memo, i m trying to take ILE entry no. for each credit memo line. I am getting the posted credit header no. in ILE, but line number is not there . help me to find out :-k :-k thanks in advance
-
Production Order Creation Date
What triggers the production order creation date to change? I noticed that after changing the status to "finished" the said date changed to the current date. How can we retain the original creation date to? Thank you.
-
Gmail SMTP configuration
Dear all How to configure Gmail SMTP services on NAV 2009 R2 SMTP Mail setup? Client outlook has configured with different email domain and cannot configure Gmail on outlook due to internal policy restrictions. Thanks satish
-
Document Approval not responding
Good day! We have setup document approval using the purchase amount approval limit. We are having performance issues if we use this function but with the unlimited PO approval, we can process the document. With amount approval, the session does not respond and will have to terminate the test client. Any known bugs or…
-
Upgrade DataBase Nav5 to Nav2009R2, is RTC available?
Hi, I would like to upgrade my Database from Nav5 to Nav2009R2 and I would like to know if RTC will be available? Thanks!
-
NAV 2009 R2 Test Database
Hello, I recently took a full backup of our Live database and created a new training database to load some test objects in. My users are getting various permissions errors, one common one is "You do not have permission to read the Object table", not sure as to why due to the fact the permissions were copied over from the…
-
Navision and SQL Display Different
I have facing one issue with Navision front end shows one record say time as 3:00 but SQL table shows time as 22:00. Anybody having idea what was the route cause for this?
-
passing large parameter to sql stored procedure
Hi I'm trying to pass a large text parameter to SQL stored procedure (where it declared as NVARCHAR(MAX) ) I do the following:paramHistoryTempList := myADOCommand.CreateParameter('@HistoryTempList',200,1,1024,HistoryTempList); where HistoryTempList is BigText And get error like this: If i trying to pass a variant,…
-
Fixed Asset opening balances
Hi All, I have one question about the consolidation - FA acquisition date , hope fully you all can answer me. I have 3 companies - USA , AU, IND , parent company is USD. When it comes to Consolidation process we need to consider the different exchange rates for the Balance sheet , P&L and Fixed Asset accounts. Closing rate…
-
applies to document no in sales credit memo is blank why
When i want to return invoiced sales order it is accept to return order and applied to doc no is blank and applies document type is blank how i know which document sales invoice returned and how to block invoiced sales order from returned where not have applies to document no in sales return order and after posted sales…
-
Printer Queue
Hi Mibuso.Com :D When am online remotely its great to be able to print locally but when the printer is offline the print queue stacks up. When I print a NAV document a few days later, I've forgotten that there is previous prints awaiting in the job queue and get all those prints first before my recent print! Other than…
-
Connect Navision with Shopware with WinHttp to REST-Api
Hi, i want to send Items and more to the Shopware using the REST-Api. So i think the easiest way is to connect over WinHttp. But how? I get no connection to the api. Does someone has a cool (or hot) Tip for me? I started with this code (found the basics on the shopware forum from DonAlfredo) CREATE(WinHttp);…
-
cin number
hi experts I have to maintain corporate identification number for my company in company information table. Is there any inbuilt field in company information table or i have to create a new filed. please guide me
-
APPCRASH NAV 2009 R2
Dear ALL, we have one pc in which nav very random crash with message - Insufficient Memory. then we have updated to latest NAV build - 6.0.36259 also tried to reinstall .net framework. but still nav crash, with Message - Microsoft Dynamics NAV Classic Client executable for SQ has stopped working. Please advise, anything we…
-
Create a column in a nav page 2013
Hello; Thank you to assist me on the following: I try to create a new field (Cd lettering) in page 25 (Accounting Entries client). with: If the value (Sequence No. final lettering) = 0 then "Cd lettering" = "Sequence Number" Otherwise "Cd lettering" = "No final sequence lettering" thank you
-
Account schedules and column layouts
It we have create an account schedule and the column layout we use against it has a column type of Year to date and a formula on the Comparison Date Formula of CM-1Y, but then we change our accounting periods to NOT report typical calendar months could we then amend it to get it to show the accounting period dates rather…
-
Changes to Current Inventory Setup
Hi, Please can anyone offer some guidance on how best to approach this, we are currently in the middle of integrating data from one system into our navision system and have 2.5 million items that we need to A) Switch from using locations without the ''bin mandatory'' checkbox selected to with ''bin mandatory'' selected B)…
-
Strange issue in NAV ; please help
I have been using NAV long time but never faced this issue. In the printer selection table when I enter User IDs which is windows logins in User ID field I get no issue. But when other user in his computer enters his own user id it comes up with a slash '\' in front of it. If user id is DOMAIN\Mibuso for example is his…
-
FILTERGROUP on INSERT
While doing an upgrade, i came across this piece of code in OnInsert trigger of a table FILTERGROUP(2); "Location Code" := GetAllowedLocationFilter(); FILTERGROUP(0); Based on the customisation elsewhere in the DB, I think this was done to save the allowed location code irrespective of selected location code. I think this…
-
How to add code in print button of a report in nav
Hi everyone, can anyone help me to add code in the print button of any report. In design mode of report, it does n't show any print or preview button. Thanks in advance...
-
Production Order Posting Error (CRITICAL)
Hi Experts, We have discovered this issue at our client who is using production module in NAV 2013 R2. The issue is that NAV is intermittently posting Production Output(FG) at standard cost rounded to 2 decimal places when usually the std. cost is 4-5 decimal points. There are following points to be noted 1. It is…
-
Production Rejects
Good day! How can we report reject quantities under a specific production order? Say we have 10 required quantity, 5 good 5 reject. What column or session should we use to post this transaction? We are using NAV2009 SP1. Thank you.
-
Trace or Capture Company Rename
Does anyone know if there is a way in Nav to capture if someone chooses to rename a Company? Like if I need to do something pre/post to the actual event, Clean something, remove some setting or what-not...