-
Unrealised Profit Account
Hi Everyone, Found difference amount in between In-transit G/L Account and unrealised profit account after posting transfer order. we are using Inventory interim account for in-transit location. in some of transfer orders when order was shipped then transaction hit between interim account and unrealised profit account but…
-
Deleted Budget entries still show on Account Schedule and Analysis by Dimension View after Update
I had some budget entries . I also have an account schedule that is linked to a analysis by dimension. I deleted the budgeted entries but they are still appearing in my account schedule report. When I look up analysis view budget entries , I can see the entries that I deleted from my budget How do I delete these entries…
-
Vendor Prepayments
Hi Guys I wanted to check with anyone out here , if they know , when processing a vendor prepayment and once we receive the goods\services , why is it that we cannot "get receipt lines" from a new Purchase Invoice Document. I have tested where I have invoiced the prepayment , then i received and invoice , then made…
-
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?
-
Generating VAT Input report for BPV and CPV?
Hello everyone, hope you all are doing good. I Have created VAT Payable (customers) and receivables (vendors )report for our monthly FTA audit. we have a requirement to include the CPV=Cash Payment Vouchers and BPV Bank payment vouchers in the VAT Receivables report. I have used the default inbuilt report "VAT Calc. &…
-
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.
-
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…
-
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 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.
-
Item approval
I was just trying to implement the item approval with the expectation that I won't be able to enter the item in an purchase or sale line as long the item has not been approoved. NAV did create an approval but the item has not been blocked in the purchase/sales line in any way. Does anybody have experiance with this Kind of…
-
Proforma Invoices/NAV Prepayments
In the UK, a Proforma Invoice is merely a request for payment and does not represent a legal tax invoice. Therefore no VAT is recognised in relation to it. As such, is it possible to configure Prepayments in such a way that the VAT does not become realized until the full invoice is posted? So far I have managed to get it…
-
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
-
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!!!
-
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…
-
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…
-
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!!
-
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?
-
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…
-
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…
-
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…
-
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…
-
Can anyone like to share me how to deduct TDS on Base + Sales Tax Value
Can anyone like to share me how to deduct TDS on Base + Sales Tax Value Eg. Base Value=100 VAT @5%= 5 TDS should be deducted on 105/- (This is job work case)
-
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…