-
Data Exchange Framework - negative sign identifier
Hi!Can somebody explain to me with an example how this works?I have 2 columns (one note transanction mark and other transanction amount) I need to map with one column in NAV (transanction amount)?
-
Data Exch. Line No. is 0 when importing .txt bank statement using Data Exchange Definition
Hello everybody!I have just signed up because I need advice from experts.I have this problem - When I import .txt file for Bank Reconciliation using Data Exchange Definition,everything is fine except value of the "Data Exch. Line No." field,which is 0.Because of that I cant see the detail information about transaction.Can…
-
Where to find archived datetime for Purchase Line Archive Table
I am looking for the date and time for when an entry is done on the Purchase Line Archive. Can that be linked to some other tables or is there just no entry like we have on the Purchase Header Archive (Time Archived, Date Archived). Also i am looking for the Creation Date for Purchase Line Tables.
-
Product or service for Serial No. tracking at outsourced warehouses
NAV serial number tracking is generally bad, because it would post an ILE for every number. But even so it can only be used if you have your own warehouse and can scan the numbers before you post the shipment. What do you do when you have 10 outsourced warehouses all over Europe and they would upload the serials and other…
-
Hi dear. I´m facing this error: Posted document no. 431610001 has allocated but not posted yet.
Hi Dear!.. when i tried to post sales invoices, i face this error: "Posted document no. 431610001 has been allocated but not posted yet. A new number cannot be allocated from the number series FRVR unless document no. 4316010001 is posted or deleted" . Can you help me please?
-
when posting a general journal with 2600 lines, the system is hanging on posting.
when posting a general journal with 2600 lines, the system is hanging on posting. It goes to checking lines successful, checking balances successful, but on posting it gets stuck forever. The general journal lines are set up like this: The first line is debiting customer, I did not put balancing account on the same line.…
-
Why we use Account Interim account in GST.
Hello Team, I have little bit confusion, there is GST Posting setup and there is CGST Account Receivable and CGST Account Payable, and another posting setup CGST Account receivable (Interim) and CGST Account Payable (Interim). 1. what is difference between this? 2. which kind of entry will post A/c Rcble and which kind…
-
NAV2.0 -> NAV2017 (Ledgers)
Hello All, Its Friday and a good time to pose a question. I'm working with a company that is running a mixed version system, several add-ins and mountains of custom code. The DB version is NAV2.0 and they understand there is not a upgrade path, but would like to retain the data. Since 2.0 is pre-(value/detail)-ledger would…
-
GST Prepayment Process in navision
Hi Friends, kindly let me know how the prepayment process is working in GST.. and the payment is adjusted...what are the financial entries passed into the system in case of gst. In case of registered vendor & unregistered vendor... Regards, A.D Singh
-
GST calculation on General Journal
Hello Friends I have a issue related to GST calculation in General journal. Scenario is create journal line with document type Invoice, vendor credit and expense debit and GST related all information filled case for services but GST not calculated in Indian Version. Please help us. Thanks
-
How to create multiple Purchase Order from one Sale Order?
Hi Everyone, Did you have any experience with this issue please, i want to link multiple purchases order to one sales order. i tested drop shipment and special order but these solutions available juste for 1:1 relations. Regards.
-
How to solve this error: Overflow under conversion error in NAV?
Hi, I have transacted an item with 1.628 as quantity and an error popped out like this "Overflow under conversion of Microsoft.Dynamics.Nav.Runtime.Decimal18 value 1.500 to System.Int32". Upon checking on quantity's data type, it appears to be in Decimal which is right. Can someone please help me to solve this error? Thank…
-
Item Ledger Entries gone Wrong
Hi, We have a scenario where we made an error when creating a BOM which has caused the unit cost to go haywire. The issue was as below: 1. Item No 74772 was created which was supposed to be the final assembled part to be sold. 2. The user then created a BOM which said to make Item 74772 it consists of Item 74772-01 only…
-
Insert Company logo in Navision Mail body
Can anyone please look at the next code and tell me what I am doing wrong. I want to add our company logo to the mail. Code:CompanyInfo.CALCFIELDS(Picture); IF CompanyInfo.Picture.HASVALUE THEN BEGIN CompanyLogo.INIT; CompanyLogo.GET; CompanyLogo.Blob := CompanyInfo.Picture; CompanyLogo.INSERT; FileLogo :=…
-
How to cancel unused check ?
There is a way to void unused checks, checks that were not printed but were canceled ?
-
Sweden Chemical Tax
Hi there, in a few days in sweden the chemical tax will be levied. Do you know something about it? How do you make the requirements? Did Microsoft develop a solution and will provide it? I hope you can helo me. Best regards
-
Xbrl
Can someone give me a link where I can download xsd file for Xbrl schemas? I need schemas for Italy.
-
fa posting type must not be " " in gen journal line journal template
Hi, I got this error when I was trying to post a payment in Payment Journal for 1 Fixed Asset but I could not find the FA Posting Type column. Could someone help? Thanks.
-
Service Tax Setup
Hi, I want to know about service tax Setup. with example. What is use of interim accounts.
-
Adjust Cost - Item Entries _Custom Date ranage
Hi, we are using nav 3.0 from Jan 2016 till now, Costing method : Average . so far we never run Adjust cost - Item Entries. Our Finance department would like to run the adjust cost and cost post to g/L from Jan17 - April 17 ( Only for last 4 month) As soon as ran first process Adjust cost -item entries report, it's…
-
Invoice to shipment report
Hi - I'm new to Nav (although experienced on other accounting packages). Is there a report which will list invoices and shipment numbers alongside them i.e. something to allow me to match our invoicing against shipments in any period. Any help appreciated.
-
How do responsibility centers work?
I can't get responsibility centres to limit the view for the user
-
Problem in service tax revsese charge
Hi All , Can anyone help me to make revese entry of service tax revsese chagre entry which is wrongly posted through purchase invoice. When I try to post through purchase credit memo where I am getting error so there is any way to reverse those transaction.
-
Problem in service tax Input
Hi All, Can you Please help me to sort out service tax input at time of Service tax payment, in my case i uploaded service tax receivables amount through Gen .Journal as a opening balance but now when i try to take input of that opening balance at time of service tax payment, system is not showing that amount in service…
-
can anyone help me in sample process ?
How should we deal with the samples we make. These samples are sent to different clients and than it comes back after some time. We would like to know where is which sample… Like in mumbai office, gurgaon showroom or in bangalore office or with a specific client. Also once the client returns the sample we it would go to…
-
Sales Order - Amount must be positive
We are getting the following error message when we try to post a negative line on a sales order to a GL account. Amount must be positive in Gen. Journal Line Journal Template..... I have tried adding a Posting Type of Sales to the GL Account and it still does not work.
-
Applying Entries in Different Currencies
Hello, I have an invoice in AED, I want to pay it in USD. I created a payment line in the journal with a USD currency, I applied it to an Invoice in AED, I set the amount to apply field to 2000 AED, it automatically calculated it in USD to 544.57$. Now when I post the payment and go to vendor ledger entry, in the invoice I…
-
Start report with pre-defined filters
I don't think this is possible, but I ask it anyway. Is it possible to start a report (with serveral DataItems), and fill-in some filters from the start. So the user sees the ReqFilterFields (defined when programming the report) with the corresponding values?
-
Company Select Page - (popup)
Bonjour J'ai des sociétés qui ne s'affichent pas dans la sélection de changement de sociétés selon le profil Elles apparaissent partout ailleurs pourtant Comment puis-je au moins débugger cette minipage "Sélectionner société" , je ne trouve pas dans la partie designer Merci pour votre aide Isabelle
-
NAV Inventory valuation Report Issue
Hi, On Inventory valuation report for some items there was only inventory value. Remaining quantity and and unit cost are blank. While analyzing the reason , we could conclude that there is a difference in Cost Amount(Actual) in item ledger entry for those items. We are aware that if there is any unit cost difference…