-
VAT Setup using VAT Receivables , payable and settlement Accounts
I have checked my chart of accounts and in the COA i selected VAT Input account, VAT payable account. I Dont undestand why the VAT Input account is showing Sales invoices and Payable account are showing PPI's. My FM and me are puzzled. Please give me a understanding. Is this an error or somthing else?
-
Creating a VAT INPUT REPORT.
Any suggested format?
-
Inconsistencies error in the G/L Entry table
Inconsistencies error in the G/L Entry table The Transaction cannot be completed because it will cause inconsistencies in the G/L entry table . Check where and how the CONSISTENT function is used in the transaction to find the reason for the error. Contact your system administrator Tables can be marked as inconsistent…
-
Sales invoice error
VAT% has been changed (initial a job task ; Job No =_____\IB\1801\0001. JOb Task number =DHH) in sales line. Document type ="Invoice',Document No.="PSI/01-18/00132',Line no.='3000' What is this error i am not able to understand. Any Help will be appreciated.
-
NAV Extension V2 Error No source files found
Hi, I try to create a extension for NAV 2018 with VS Code. But when I try to create the package I get following error: error AL1016: No source files are specified Error: The package could not be created I've looked at many boards but couldn't find an answer for my question. The closest answer was to put the right…
-
The field Country/region code of table job journal line . Error in Outbound job lines
The field Country/region code of table job journal line contain a value that cannot be found in the related table error message is being generated in the job lines after change of the post codes , What are possible ways to solve this error? What precautions are to be taken the next time when information in the NAV System…
-
Facing problem with sales invoice report. (Reporting Issue)
Hi Guys, Hope you all are well. I Am facing a reporting issue with my sales invoice report . It is a one page report that keeps generating a second page. Previously it used to come with a header , but after i turned off the header on last page feature it stopped coming. But still the 2nd page is created with the only…
-
Variant code
Hi All, how can i make a variant code mandatory on any transaction (inbound or outbound) if i use variant code for an item. Standard NAV allow you to post an item with variant code blank. So if u setup an item with let's say 3 colors variants: BLUE,RED,YELLOW; you will end up by inconsistent inventory if system allows you…
-
Analysis view entry
Hi All, i have the following scenario: a customer has a big number of employees and he created names of employees as dimensions. from the above he should input any transaction (expense or salary) related to employee with dimension value = name of employee and he mentioned on description of g/l entry the reason for this…
-
Purchase Order invoice - adding VAT?
I've came across a situation where the vendor was initially setup to be paid in Euro and 0% VAT. However arrangements have changed and the vendor will be paid in GBP with VAT added. The issue is that there is an existing PO with receipts in Euro + 0% VAT. I've tried raising a Purchase Invoice, change currency code to Euro…
-
Purchase invoice amount rounding precision
Hello, I have a problem that i will show in the picture. I don´t understand why that value(40426,91) has one cent more than the sum of the two debit direct fields(20213,45). Maybe some rounding precision error? Any ideas? Thanks in advance.
-
VAT Annual Listing Belgium version
Hello, When running the report for VAT Annual Listing, I always get 0 lines . Nothing to be printed knowing that was no filters on running report. Any one have seen this issue for belgium version? When running the french or english version standard I have lines printed with the right amounts... Thabks for help!!!
-
General Journal Line Workflow - with DR. G/L Account & CR. Bank Account
Hello Everyone, When i send a journal line for approval, it creates approval entries for the next approver in cases where i have either Dr. Vendor & Cr. Bank Account or Dr. Customer & Cr. Bank Account. However, when I send a journal line for approval where i have Dr. G/L Account & Cr. Bank Account. The journal line is…
-
Suggest Vendor Payment returns no result
Dear All, Please assist in finding solution to this issue: We are just about to start using the NAV feature "Suggest Vendor Payment" batch job. We ran the batch job setting the field "Last Payment Date" to Today's date (current date), however none of the due and open posted invoices were suggested by the batch job. I would…
-
What does inventory with zero quantity and negative values on my inventory valuation report mean.
I have run cost adjustment post to G/l batch job but when I run my inventory valuation report excluding expected cost in NAV some of my inventory with zero quantity have negative values, how do I resolve this. According to my understanding zero stocks should not have values
-
Impact of changing the "Map-to IC Dimension Value code" field in Dimension Value Table
Hi All, Does anyone know the Impact of changing the existing values of "Map-to IC Dimension Value code" field in Dimension Value? Thanks in advance!!
-
When i import csv Bank statement file in NAV ,It imports dates with all the months as january.
Hi Kindly assist In my data exchange definitions, i have setup a bank import as shown General Tab Field Mapping Then finally columns Now when I import the bank statement in csv into NAV, it imports the lines perfectly plus the amount but converts the months of all the lines to January. For example if the date of my bank…
-
Impact on any posted transaction upon changing the Default dimensions for Customer/Vendors
Hi All, Can anyone let me know, that we change the default dimensions for Customer/Vendors, do we have any impact of the same on already posted transactions? As per my understanding it will not have impact any on historical data. The only thing is when we try post with the Customer/Vendors it will consider the changed…
-
While posting a Sales Return Order selecting Invoice only Then getting the error
While posting a Sales Return Order selecting Invoice only Then getting the error: Microsoft Dynamics NAV Amount must be negative in Gen. Journal Line Journal Template Name='',Journal Batch Name='',Line No.='0'.OK Can anybody help?
-
Customer Statement Filters
Why doesn't the standard customer statement report filter out by the global dimensions specified in the limit totals filter on the request page?
-
Navision 2.1.2.1507 on Windows server 2008 64 bit
Hi, I have a problem running Navision v. 2.01.02 on a Windows server 2008 64 bit. When I try to start Fin.exe it just crashes with the error below. How can I get it working? Thank you. Problem signature: Problem Event Name: BEX Application Name: FIN.EXE Application Version: 2.1.2.1507 Application Timestamp: 37cde6e0 Fault…
-
Currency exchange rate service error.
I am trying to setup currency exchange rate service for a company with Kenyan shillings as the LCY using the yahoo services in NAV.How do I set this up since the yahoo url provided by NAV has a different LCY and when I try to preview I get the attached error And which url can I use to demonstrate how the service works in…
-
Exploring TRANSFORM SCRIPTS IN SERVICENOW
Since there are such huge numbers of various choices for when to run a change content, it can be hard to figure out what will work best for your application. In this post, I'll go over the diverse sorts of contents and in addition the factors that are accessible to every one. ServiceNow has some documentation on the most…
-
Combine Sepa payments (credit memos and invoices) xml.file
When combining SEPA -payments on "Bank payments to send" scrn, and the vendor have eq. invoice 1000 € and credit memo 500€. NAV combines those as it should, but the problem is that xml- file doesn´t include any invoice details such as sums, invoice messages etc. What should do that those invoice details comes to the file…
-
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.…