-
Fix item unit price in Purchase Invoice
Hi Anyone, Could someone help me please. I have a problem, my client post some purchase invoice with wrong unit price, some of the invoices have higher prices and some have lower price. Quantity of item in every invoices are OK, the problem only with the unit price. I tried to solve this problem by creating purchase…
-
VAT Invoice - All VAT!
I need to input a VAT invoice into Navsion. It is all VAT so how do I input an amount into the VAT field without an update to the "Amounts" field which should stay at zero? Any suggestions welcome!
-
Error for negative inventory
Hi instead of warning if I want to get an error after entering the quantity ...what to do for that?? Also, I don;t want that warning form 342 to run,instead of that i want error of -ve inventory.
-
finsql.exe error in Nav 2.6
Hello Has anyone seen the error before finsql.exe has encountered a problem and needs to close. I am only getting this on one users machine no matter who logs on to navision. The problem occurs when you try to print a pick note? Any help would be much appreciated. Thanks,
-
Liquidity module training material required
Where i can get the training material for the Liquidity module available in Malaysia 5.0Sp1
-
Easy one := Can i convert text to int?
This is an easy one im sure but can i convert text to an integer. ie the opposite of format like the VAL function in VB (i think its VAL) Any help much appreciated <img border="0" title="" alt="" src="images/smiles/icon_cool.gif" />
-
Document type reminder in Gen Journal and Currency form
There is several Document type in general journal, such as : Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund my question is.... what is the function for document type Reminder ?? and in form currency exchange rate (Form 511) there Currency code Exchange Rate amount Relational Exchange Rate Relational…
-
Polish language translation
Hi All, we have got a client who has Navision in English language. Client is setting up a new office in Poland. My client say there are 32 characters in polish language. Question is can we translate Navision 2.0 (existing s/w) they have got from English language to Polish. Regards,
-
Case unsensitive LIKE query
Hello, I'm connecting Navision with ASP.NET but if I run a query with the LIKE statement I get a case sensitive search. Is there a function to make the LIKE case unsensitive? Regards, Hans
-
Subform unfocusable / editable
Hi I have crated a form with several subforms. Some of the subforms are of tabular/matrix, some of standard layout. The forms contain some controls and links to other windows in NAV. When i open the subforms seperately with the object designer everything works fine. i can change control values and follow lookup- or…
-
Formatting of a PO report
Hi all, Can anyone guide me of how to enhance the required formatting of my PO report? Can you also guide me how send an attachment via this forum because I need to send you the layout of my actual PO report and the required one Thx regards Nalinee[/url][/list][/code][/quote]
-
Looking for Navision 2.50 US standard DB/client
Hello everyone, I need a NAV 2.50 US standard DB for an upgrade project, but unfortunately it seems it's not available on PartnerSource. Does anybody by chance have it in their personal archives and could share it?
-
Bom roll up
Morning We use Navision to create batch sheets from our BOM's these are at a single level. What we have found is that when a item contains made in items that have their own BOM, and you expand the view in the item view it cannot be reversed so now when you print a batch card it has all the raws including the made in items…
-
1.30->2.00 - anyone has the upgrade toolkit/objects
preferred language danish - guess W1 could do the trick. :D Regards.
-
Financial management manuals for indian version navision
i want financial management manuals for indian version navision for VAT and TDS setup............. please send the manuals if anyone of u have................please help me in this..................
-
Expiry Date Calculation Formula
Hi All, I required a item wise Expiry date calculation formula. On item i created a Item Tracking Code In Expiration Calculation i put 36M, but system not calculating the expiry date, please suggest, what is missing. Regards, Jai Verma
-
Customer Sales Report
I need a sales report that will show me my 10 largets customers in sales. Also, I need a report that would show me what percentage of my sales are from domestic customers verses sales that are from foreign customers. Is there a report that will give me the needed information?
-
Challenge: Nav 26 native to sql server 2008
Hello, this is my first post in this forum. i try to do the following: upgrade nav 26 database to sql server 2008. what i already did is: backup with navision + try to restore but i have an error linked to sql server: "The current ANSI or OEM Code Page on your computer does not match the code page on the server" ?? any…
-
Bank Receipt error
Hi Friends, Im New to NAV 5.0 ….. when im trying to post a Bank Receipt Voucher it throws an error as “ Account Type must be Bank Account in Gen. Journal Line Journal template Name= ‘BANKRECEIP’ ,Journal Batch Name =’Default’, Line No =’10000’ ”… Plz Tell me whr I can correct it ……….. Need Help Regards Manickam
-
letter of credit
if you provide the Information related the following query pls tell me about the Letter Of Credit functionality in navision? What is the role of LC Journal in the Functionality?? :
-
update field quantity remmain in table Item Ledger
I registered a Sales credit Memo fo one Item "X" and I need update the field "Quantity Remmain" in table Item Ledger entry, but this field is showing the quantity before register credit memo even though the quantity in Inventory has been correctly. for instance: Inventory => Item X at 6/15/2010 = 18un Inventory after the…
-
Fixed Assets Depreciation
hi friends whenever i post new invoice in my old assets and want to calculate depreciation through periodic activities it doesnt calaculate also does not show any error. while i can post depreciation manually thgh FA G/L jounl can anyone suggest the solution Suppi
-
Microsoft navision automation
Hello guys , i am new to Microsoft navision. i want to know how to automate the daily revenues from a certain application using say a (php + mysql) . I know xml webservices can do but not sure on Navision . Secondly i need Navision demo software to practice where can i get that software? i went to microsoft it is…
-
Posted Return Receipt Remaining Qty
Hello all, I have a returns order which was receipted by mistake, now when i try and undo the shipment the following error message appears 'Remaining Quantity Must be 1 in Item Ledger Entry...' does anybody know what the implications could be if this was amended in the table? Or is crediting it and recreating the order…
-
Invoice Disc. Code
Hello all, I have a customer which has outstanding orders however i have now applied an Invoice Discount Code to the customer card, when i go back to these outstanding orders and use either F9 or Calculate Invoice discount function it dosen't do anything. Is there another way to validate the discount? Thanks
-
Year End Process
Hi, I've close the F.Y. from Accounting Periods - Close Year. After this i 've run the Close Income Statement Batch job, then i post those entris from 'General journal'. But even after all this process the balance of Income-Expense head is carry forawrd in next F.Y. How did i nullify them? pleas suggest. Regards Jai Verma
-
Best process to delete company
hi, Is there any difference anyhow to delete a compnay(in both case SQL and Native) from company Talbe or delete from file---compnay--delete.
-
Polish Corrective Invoice
I have a requirement to develop a Corrective Invoice for our business in Poland. Has anyone had any experience of such a developent using a UK version of Navision and can advise how they went about it? I know this exists in a Polish Localisation of Navision but my company uses a UK version of the system. Or can the…
-
Error when unapplying Customer Ledger Entry NAV 4 SP3
Customer is running NAV4.0 SP3 SQL and is getting the following error message when attempting to unapply a Customer Ledger Entry. "Before you can unapply this entry, you must first unapply all application entries in Cust. Ledger Entry No.59583 that were posted after this entry" There are no applications for 59583 posted…
-
Negative quantity in positive Adjustment - Item Journal
Hi All, I need some help for my project. One of my customer has problem related to their inventory. A user enter item journal with type = Positive Adjustment for an item, but unfortunately she made mistake by entering negative quantity and post it. My question is, how can I fix this problem? Can I create item journal, and…