-
changing customs number
Hi all, first I want to say that I am totally new to Navision Financials, so please don't hit me if this is a stupid question. :-) Because of new regulations we have to change our customs number. I think, this number is part of the master data. I searched for it within the Navision Financials program but I can't find it…
-
adjust exchange rates
I Seem to have a problem with currency revaluation. I ran a currency adjustment and I think it is wrong. How possible can I reverse the same. What I want is to reverse the currecy adjust exchange rates. how posible is it to do so. Please help
-
BIGINT
I am trying to restore a 2.01 backup into a blank 3.70 SQL database and get an error that says "datatype" BIGINT is not recognized. Anyone know the solution to this?
-
Source table temperoary
HI I want to ask the form property which is SOURCE TABLE TEMPEROARY.
-
Format number to string
Dear all, I have got number 22 and I need to convert it into text as 22.00 The issue is that it is being converted to 22 only. Is it possible to create it through format or do I need to manually edit the resulting text?
-
Is it possible to keep converted OFFER in Navision 2.60?
Hi Everybody, I am using Navision 2.60 and I found as long as an offer was converted to a SO, the offer would be deleted by system automatically. Is it possible to keep the converted offers in system? If so, is it possible to let a concrete place of the offer header show "active", "lost" and "converted" status? Thanks in…
-
Cash Flow Statement
Hello Everybody! Can Anybody tell me how can I build Cash Flow in Navision? Should we create report or is it possible to build it using accoutn schedules or smth like this? Thank you in advance for your attention and responses :)
-
Accrued Costs
I am curious to know how other companies handle accruing for costs in Dynamics NAV 5.0 that have been incurred but you have not received the invoice yet. We have a lot of freight costs (as well as other costs) that apply to the value of our inventory and we use charge items to apply the cost to the inventory. Many of our…
-
i want to do a txt file with a table without using dataport
how can i do a txt file with a table, i have to use a report and create a file variable or what...thank you so mach
-
Average Costing - How does it work in 2.xx
My introduction to Navision was release 4.0, but I have a client who is still on 2.0 (or thereabouts), i.e. Navision Financials. They are being audited and evidently don't have any manuals, and I guess we don't either. We have to supply them with something on letterhead on how average costing works in 2.x. I found one…
-
Setups required?
Hi all, I am a fresher joined as an ERP consultant.I would like to have a list of all the SETUPS required in financials.It would be helpful if someone can explain me the required fields to be filled in which are mandatory.
-
how can i do a total amount using GroupTotalFields property
how i can totalizate an amount in a report for a simple data item
-
Opening bal
I have imported journal lines for opening balance . The journal lines have g/l subledgers: bank,vendor. The main problem i am facing is that i cannot post them and the reason is Amount Dr and Cr is not equal because it has journals with multiple currencies however the dr and cr in lCY is equal for the same journals. I am…
-
Inventory Automatic Cost Adjustment
Hi, I need a clarification on the following: On the Inventory setup window, Automatic Cost Posting is checked and Automatic Cost Adjustment is set to Always. If both of the above options are checked, is it necessary to run the Adjust Cost Item Entries batch job and Post Inventory Cost to G/L? Thanks and Regards, Bea.
-
Form Focus
Variables: Purchase Line."no." Text2 var code Code: On the ONVALIDATE section of field Purchase Line."no." If Purchase Line."no.">5 then currform.activate.text2 IT seems so simple but does not work. The cursor remains in the Purchase Line."no." field I have no nextcontrols set. Anybody know why???
-
there is a function to extract only decimal numbers
Hi i want to extract from an amount only the numbers after decimal point, there´s a function or i have to do a little program to do this. thanks
-
IBM Asset Management MAXIMO
Hi, Has anyone experience with an interface to IBM Maximo? Thanks,
-
Opening Bal
I have a great problem . I have a trial balance and also sub ledgers bank and customers to be imported in navision. the volume of the transaction is large .I have searched the forum but i couldn't find my specific answer.I really dont know what steps need to be followed I have details in Excel i have converted them in csv…
-
binoclars filters and temporary table
I have a form which display record form temporary table. I put filters on onAfterGetRecord Without this, filters are applied on "real" table so there's no effect... My problem come from the binoclars. Indeed, i have the same kind of problem like rec filters. So i like to know, if someone have an idea to filter with…
-
Close Income Statement
When Close Income Statement (General Ledger >> Periodic Activities >> Fiscal Year >> Close Income Statement) I get the following message: This Shortcut Dimension is not defined in het General Ledger Setup. In this division there is no shortcut dimension. Only a Global Dimension 1 Someone any idea??
-
cronus 2.6
I am looking for a copy of the Cronus demo data version 2.6 - Is there somewhere I can download a copy?
-
International Characters - Cannot enter
Using Financials US 1.20(US2.00.C) We have a customer in Brazil and its name is "Associação Congregação" We have been told that we MUST have the proper characters on our paperwork but no matter what I do it appears as this: Associaçao Congregaçao I have tried many many different fonts and the 'ç' always appears and prints…
-
Using Abbyy Finereader with Navision
I am currently examining an OCR product called Abbyy Finereader intending to use it with Navision (currently 2.60 but we will soon be upgrading to NAV 5.0). Does anyone in the forum know this product and if it is possible to activate it from within Navision? Regards Tommy
-
BOM components missing in RPO
Hi, I Created a manufacturing Bom with 4 components say a,b,c,d . A,B,C are the component lines that are type:Item; D is the line of type: productuion Bom. when i releases the RPO iam not able to get the components of D in the RPO.How can i get the components. Any suggestions .... :) Deepu
-
Exchange Rate Adjustment Report Manual Posting
The report "595 - Exhange Rates Adjustment" under Periodic Activities, post directly to the G/L. The user can not review the figures before posting. Is it posible to configure this report to create a General Journal BATCH instead of posting directly to G/L?. If this is possible the user would be able to review the figures…
-
See if Record Link exist by customer
Does anybody know how I can show at the customer card that a Record link exist (table 2000000068) for this customer (same as comment exist, with a boolean). The data is in a Datatype RecordID. We use Nav 5.0.
-
Report gets infinite loop when it executes a Doc no.
Hi I have a report gets infinite loop when it executes a document no.. I have checked several tables which contain this document no., but I did not find anything strange. Do you think what would be the root cause for this? I can not paste the *.fob file here, if somebody interested in this, I can send the *.fob file to…
-
Can not invoice an order
I got a functional problem: Sales Order 43489. If we set Fecha registro (Registration date) as 05/20/09, then press F11, and then select the third button to invoice this order, we can get a error message. I have tried to use debug and I found debug stopped at "TEST FIELD (importe)". Then If I press F5 continue, the error…
-
Track posted and unposted
What might be other alternatives to track records of posted and unposted datas in navision. For posted as far as i know it can be done through registers and through navigation. For unposted it is very difficult coz we need to go to each and every window like cash receipt payment receipt. SO is there any option to track the…
-
Navision 2.6 Documentation
I'm trying to obtain some kind of information that would be handy to give to a new user who has never used Navision before. I'm looking for something that would have what all the symbols mean in navision, ie todate...enddate. I'm not the greatest with Navision or else I would just come up with one myself. Any help with…