-
End of Month
Hi Everybody, I need to get the end of month for a date provided. Is this possible with Navision. I'm assuming that I should use ROUNDDATETIME but I'm not sure how to use it.
-
Remaining quantity
Hi to all Can somebody please tell me how the remaining quantity is calculated in the item ledger entries. We have enouph quantity in the appropriate location but when we try to post transfer order to another location, it is shown that this item is not on inventory. Thank you in advance.
-
Back up Restoration
Dear Friend , When i restore the back up i get the following error ,kindly help me in sorting it out. You cannot delet or change the type of the description 2 field ( in the item table) before the value in the field is reduced to 0(zero) or " (blank) in all records. This message occurred because a nonzero value was found…
-
Navision 2.6 Native - NTFS Block Size
Hello, I have a native Navision 2.6 database that is currently 31 gigs in size on one .FDB file (not split) and located on a single RAID 1 disk array (10K rpm 36 gig drives). The system partition is located on another raid controller and another set of RAID 1 disks. The memory setup is 2 gigabytes with 850mb configred for…
-
Fixed Assets Written Down Transaction
Hello, If I want to write down a fixed assets I should have mapped Write-Down Account and Write-Down Expenses Account in FA Posting Groups setup. In prinicpal which account I should map against the Write-Down Account. Whether it will be a Balance Sheet or Income Statement account? Thanks! Bhushan
-
Error ID 109
Hi everybody, I found this message in the event log: Type: Warning. User: N/A. :( Event ID: 109. The system failed to update Navision Database Server Service Connection Point in Active Directory. The registry entry does not exist. We are using Navision Financials 2.6D and the database size is 70GB spread in secondary…
-
Line loop
I seem to be missing a table referance somewhere. I have a report with 2 dataItems salesInvoiceHeader salesInvoiceLine the Header got x lines bound to it. On the data items I make a file that with the data from the tables. salesInvoiceHeader salesInvoiceHeader salesInvoiceLine salesInvoiceLine salesInvoiceHeader -…
-
get data from table
I got a small problem I cant seem to get this to work bom_Salgsfakturahoved - OnPreDataItem()InvoiceNum := 'F1000000'; //global variable set to invoiceNum (change to dynamic)SETRANGE("Nummer",InvoiceNum); //range on this dataItemIF (EVALUATE(globalInt,"Kundenr.")) THEN…
-
Average costs per item for period
Hi Can please somebody tell me how to get a report in which I can see the average costs for the items durng period. For example I want to see which were the average costs for the items for the period 01.05.2008 till 31.05.2008. How can I get this report?
-
User Permission
Dear Frnds I have 2 question Regarding user Rights 1) Can some one say where i can find notes for User Rights/ Permission.. 2) User Rights and Permission are configured by Funtional or Technical person?
-
Sale order
Hey Friends Is there any way of finding or filtering sale order based on Item number. Hope to get a solution for this too Thanks Vijay
-
Footer Logo
Hi, :) to start with I just want to say that I have no prior experiance with navision nav but I been given a task to add a image at the buttom of a Invoice report. looking around in here I figured out how to display a image on a report. have table called Image File (int field) (blob field) where I got a picture imported…
-
Export to excel problem - Bank Account Reconciliation
We tried to do an export the 'Bank Account Reconciliation' to Excel and received an error because Excel don't allow the creation of a file with tab name that contains a '/'. It relates to the 'Deposits/Transfers' tab the bank rec that Nav is trying to bring over to excel. Any ideas or suggestions please? Thanks Rudy
-
Service tax as excise credit problem
Dear All, Can any one tell me how's Service tax register get updated after running batch job for Claim service tax as excise credit. I am facing problem while clearing exicse duty through RG etc. there i was not able to get the service tax figrure in main sheet which i want to use. Please help me out its very much urgent.…
-
C/ODBC 2.01b
Hi everyone, after so long time, I lost installation CD for C/ODBC for version 2.01b. Does anyone know where can I download instalaltion? Or anyone can send me installation...
-
Account schedule Gross Profit calculation?
I am trying to insxert a line in the account schedule that will calculate the gross profit %. Example: Row #, Description 10 Sales 20 Gross Profit 30 Gross Profit % (The formula I used was (20/10)*100, but it is giving me the wrong answer.) I used 30/10 before and it would give me an answer of 0.28 which is correct but the…
-
Locking time
I have a 2.60B Database. Could somebody tell how I could increase the locking time ? Thanks for sharing !
-
Bugeted fixed assets
Hi, can some on tell me how the book value of a bugeted asset is closed when you buy the real asset at lower price? Does anyone know what are the implications of removing the restriction of buying an asset that was bugeted at a higher price?
-
Creating user ID and permissions
We are using Navision Financials GB 2.60 E, we need to create a new user (set a Database login) with roles, permissions and rights to the inventory module only. Can you help. Regards
-
Turn the property focusable of a (sub)form On/Off
Is there a possibility to switch the form property focusable. In this case the salesline subform will be focusable on user request, default you can only see the saleslines. I have tried with two different subforms, one focusable and the other not, but without the expecting result.
-
Print out report
Hey Friends My Client requirement is such that when printing the Sales Invoice,they need five copy,but in each copy they need a different name (print copy name) in the printed report by single click. Example :- 1.original 2.Duplicate 3.Triplicate 4.Quadrapliate and 5.Transporters copy There is any option in Navision,if no,…
-
Calculating Taxes in Payment Journal
Hello there experts. Does anybody know how to calculate taxes in Payment Journal window. Not really sure if this is possible but I wanted to check with all the Navision Experts out there. What I wanted to accomplish is that when ever I enter a GL code "61000" in the GL line, it should automatically calculate the "TAX…
-
General Posting Type
Hi All Can anyone explain me the significance of General Posting Type and is it required when i use a G/L Account No directly in an Invoice Thanks in advance Regards Saritha
-
Going Live
Hello Friends 1) What are the intiall process when a project is started for a client? 2) Is there any method of Documenting the requirement given by clients? 3)What are the essential things (esp in Finance and gen)/ to be considered for Navision to go Live?( Final process before going live). Thanks in Advance for replying.…
-
Navison Financials 2.6 (FDB) - Basic data
Hello all, We are a group of international companies. I have Navison Financials 2.6 (FDB) database used on one of our companies. I need to have a copy of the database with basic data only without any transactions, this copy will be used on another sister company on the group with the same basic data. Plz help. Regards
-
Number Series
How to Increment number series in the middle eg: PO-0001-08-09 ( 08-09 is year) My client requirement is such that year should succeed the Number series, is there any way of incrementing the number inbetween?
-
Refresh a form
I have a Form(A) with two Sub-forms. The firs form is just a frane no table linked, and the two sub-forms are the same form, just filtered different. I want to put a monitor in my traffic dpt. with this FORM, but i have to click on it to refresh the info. :D Could I auto refresh the form? Thanks,
-
Navison Financials 2.6 (FDB) ODBC drive
Hello All, Once again , I need a link to download Navison Financials 2.6 (FDB) ODBC drive Regards
-
How 2 convert Navison Financials FDB to MDB
Hello All, Can you guys show me 1- how to convert Navison Financials 2.6 Database (FDB) to MS Access DB. 2- Where can I find download link for 2.6 ODBC driver. Many thanks
-
Printout not identical to preview
Hi, we have a special table with a textfield where additional multiline texts for sales documents are entered. Those texts will then be printed on reports 204, 205 and so on. The users often try to create "columns" by inserting spaces, so I formated the textfield in the form like in the report (helvetica size 9). In the…