-
Balance of rm sand is wrong in chart of account
Hi guys Suppose I produce concrete this concrete consist from sand and cement when i add account in chart of account as rm sand(raw material sand as inventory) what type of transaction must added to it(type of sales and purchase and consumption added) I ask this question because i have wrong balance in rm sand account in…
-
Nav 2.5
Anyone happen to have an original Nav 2.5 database? Doing a pre-upgrade review and looking to get a base set of objects. Thanks
-
Reg:year ending procedure
Dear All , How to close the year ending procedure (retail level as well as financial level )what kind of precaution has to be taken to do smooth functioning of next financial year . Thanks in Advance
-
Lost all username and passwords
Hi, We are an old customer of Navision Financials and have a database file (.fdb) that we cannot open as we have lost all the username/password information. We have tried the 20 ? approach and have been informed MS don't support that since v4 of the product. Are there any other ways of gaining access to the company files?…
-
Issue while correcting purchase Invoice
At a time of Posting Purchase Invoice wrong amount is entered in Amount column however Quantity is correct. Now I need to correct the amount value of this purchase Invoice, Keeping in mind that the reversal should affect the value of the inventory & my Vendor. For an Ex:- When i purchase Amt is 1000 USD Now i need to make…
-
Problem for search
Hello, I have a problem in finding a code seller. I look for the most recent sale with a vendor code active. And retrieve this code seller. Here's what I do: EnteteFacture.INIT; EnteteFacture.RESET; EnteteFacture.SETCURRENTKEY("N° donneur d'ordre"); EnteteFacture.ASCENDING(FALSE); EnteteFacture.SETRANGE("N° donneur…
-
Change the sense of sorting of a key
Hello, I have a key with a date of command(order) and a code seller. When I use this key in my code, the result is in the increasing order. How may I change this order and have by decreasing? Thank you
-
Repetitive buckle (NEXT) of the last towards the first one
Hello, First of all sorry for my English. I want to use the instruction "NEXT" of the last recording to the first one because i have a record sort out on a customer number (SETCURRENTKEY) and my result is tidied up by increasing date. Except that I have a test to be made from the most recent date to the oldest date. How…
-
function MESSAGE()
Hello, First of all sorry for my English. I would like getting back the field of a table which is there to integer in the function MESSAGE (). What I have to make to transform of the integer into text? Thank you
-
In-Transit Asset Valuation
Can someone please comment on this issue. How does NAV handle inventory valuation in-transit? Ihave just purchased product from my vendor and it has been shipped but is in-transit. How do I record this asset as I have not officially received the product yet. Is there an 'in-transit" location?
-
Report Export to Excel - Formating problems
Dear all. I have write a function for exporting report to excel sheet and it is working well. But thing is some of cells in rows int this sheet is much off big then normal size. I have attached a screen shot of this excel sheet and i have highlighted this area. ExcelBuf.AddColumn(FORMAT("G/L Entry"."Posting…
-
Dimensions and Close Income Statement
Hi all! When I run Close Income Statement and I don't Close By any dimensions or Business Unit Code, no lines are created in the General Journal Line. If I specify dimensions the Close Income Statement works correctly. Can someone tell me why? Thanks - Simone
-
Issues with posting description
Our Sales Invoices are mainly using Resource or G/L Account type rather than Item and has been heavily customized. This is because we have 3 Finance Departments with difference businesses and requirements sharing a common database and reports. In our situation, if our invoice has 10 G/L Account items of the same G/L code,…
-
Flow of Global Dimension value
Hi Dear. I prepared Purchase Order and done invoicing I have selected Dimension Value at Line level. Now I am going to pay to vendor via Payment Journal. When I am applying entries to pay, Dimension value is not populating in Payment journal from Posted Purchase Invoice. Kindly suggest. Thanks, Puri
-
issue with the Service tax reverse charge hotfix
Dear all, Have anyone tested service tax reverse charge (India) patch released by Microsoft, both invoice and payment? Is it working properly? I was testing the service tax reverse charge (India) patch released by Microsoft on a client system and found that the invoice is working fine and it is creating and updating the…
-
nav 2.60 server installation
I need urgently the Nav 2.6 server installer and maybe any of you are able to send me the files. If so please let me know. I really need to get it asap. Thanks
-
Payment receipts need to be disabled
Hello all, I have a client that is trying to post check receipts. Whenever she tries to post these receipts she automatically gets payment receipts. She wants these payment receipts disabled as she has no use for them. I think I may have to dvelve into the the Gen. Jnl Post code unit for this? Any ideas?
-
Temp and Zup
I posted long ago on the Zup. Now I have a new insight and experience and need help. I don't understand Zup. We use in house Navision 2.01b located on the Domain Controller. The issue is on Term Server Windows 2000 Citrix Metaframe. Recently I had to setup two workers who need to work from home (illness). They need to…
-
Bank Reconcilliation Statement
Hello Team, Can any one please provide me step by step process of Bank Reconcillation with screen shots attached for classic client, will be grateful.
-
HI! I need the Instalation CD NF 2.01 in Spanish
Please I need the installation cd Navision Financials 2.01, I have lost, and I need to reinstall my server. It is very urgent. I have backups of my files license and de database as well. Is in Spanish. Any can helpme please ¿? :cry:
-
Posted Item Charges and Assigned GRN(Receipt)
Hi, I'm entering item charges as a seperate invoice and assign it to the posted receipt and do the assignment automatically. Once I post the transaction, I'm unable to see to which receipt I have assigned this new item charge PO. There is a Line option as "item receip lines", nothing happen clicking there. Can anybody…
-
Posted Purchase Order
Hi All,, I am creating a report using the Pur Inv Header and Pur Inv Line. Suppose am creating a PO with two items and Charge (item) along with it and am assigning the Item Charges either Equally or Amount vice... the charge (Item) get divided to those Items. How can i bring this splited amount to my report. I suppose…
-
Exchange Rate Register shows one adjustment entry for Bank
Hi Experts, S/w version : NAV 6.0 R2 Issue: Exchange Rate adjustment Register shows only one Bank account with the adjustment entry although there are multiple currencies in the company. (SGD, JPY) LCY= USD, Reporting Currency is SGD. Testing done: All the bank's were tagged to one posting group," B1" tagged to one Cash…
-
Reg Exporting to excel
Hi All,,, I am trying to export a report to excel using the ExcelBuffer table. My issue is when i export to excel am not getting the entire records shown in the Navision report. suppose if 55 rows of records r there.. i am getting 45 only is exported to excel.. how do i bring the entire pages of reports to excel. Thanks,…
-
Pur Inv Line
Hi All,,, I am creating a report from Posted inv Header and Line table fetching the item details and so. The issue is... i am fetching the amount value from the line table as the invoice value. So when the type is item,Fixed Asset, G/L Account it comes under Invoice value. But if the type is Charge(Item).. thn i should…
-
computer restart permenant when i install dynamic nav sp1
Hi guys when i install dynamic nav 2009 sp1 in my computer computer restart i test this in more computer are there are some files must found in computer to prevent this .the windows i use is xp sp2 when i remove it from system computer not restart
-
How to get Cronus Database
Hi All... Please help me to get Cronus Db for Nav 5.0 SP1 Thanks, Rekha
-
Flowfield to return price for current WORKDATE
Hi Guys Not sure if this is possible, I have a simple table as below Start Date End Date Price01/01/10 31/12/10 £10 01/01/11 31/12/11 £20 01/01/12 31/12/12 £30 Is there a way to put a flow field (i.e. no coding) on this table to return the Current Price i.e. if the workdate is 20/09/12 the table would show as below Start…
-
Expected Cost Posting
Dear All, I have checked mark expected cost posting function and now i am using all docuemnts of manufactuirng process like ouput, consumption etc. does system create G/L entries for the same like sale and purchase. TNX in advance Syed.
-
why same number repeated in creit field in report
I have report found in this link: http://www.mediafire.com/file/ipgkmlkj0 ... output.rar as you see in link above there are duplicate value one value found in debit and same value for credit this report about customer statement(number id 50078) report and i take screen shoot to problem already attached with this report as…