-
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
-
Is it possible to calc invoice disc. on Amout INCLUDING VAT?
When creating a Sales Order, applicable Invoice Discount is calculated on Amount EXCLUDING VAT (that is VAT base amount is "Quantity*Unit Price"). Is It possible to make system calculate Invoice Discount on Amount INCLUDING VAT (vat base amount would be "Quantity*Unit Price + VAT").
-
Posting Groups - Inventory Adjustment, COGS and Direct Cost
Could any one explain me the use of Inventory Adjustment account, COGS account and Direct Cost Applied Account in the General Posting Setup in Financial Management. Thank You Saritha
-
Super Crash and inclompete database backup
Hi everyone, a customer of us recently suffered a server hard disk crash. The data recovery company which was involved to recover the data reported that they can´t recover data. Since September 2007 the backups written on tape are incomplete. Only 4 of 6 *.fbk files of the the backup have been written to the tape. Now my…
-
Excel Export for Version 2.x
Hello All, I'm looking for a excel exporter that is dynamic like the current contributions, but using the logic available in version 2.x. Without the RecordRef or FieldRef types is there a way to allow a "very NON tech" user to select a table and then fields within the table and click a button to export data into excel…
-
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
-
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.
-
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…
-
Importing csv file
I have a csv file I am importing data to update customer records using a codeunit. I have successfully completed this task in the past but these records contain several boolean fields. It seems that when I import the first record and attempt to assign the first field of data using SELECTSTR(1, TrainingInfoLine) it gives me…
-
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 -…
-
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?
-
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…
-
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…
-
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?
-
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…
-
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,…
-
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…
-
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...
-
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
-
C/FRONT error: Field contains tens in time
I am trying to read from the time field in the Object table like this: oTime = ocx.GetFieldData( htable, hRec, 11 ) c/front displays an error message: --- C/FRONT error: 10120 C/FRONT error: Field contains tens in time --- Where's the problem?
-
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?
-
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.
-
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…
-
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?
-
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
-
Application Builder or Solution Developer
Can someone tell me wich license I must have for accessing the C/AL code in tables, forms and codeunits? And what is the difference between Application Builder and Solution Developer?
-
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,