-
Separating informations
Hi, I would like some help for an issue that I have to solve. I´m creating an Report to export Clients information to an .txt file in a specific layout. On the file I have to separate each information using '|'. My problem is to separate the address information because in one field I have two information. Example: On the…
-
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.
-
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…
-
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
-
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…
-
how can i do a total amount using GroupTotalFields property
how i can totalizate an amount in a report for a simple data item
-
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.
-
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???
-
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…
-
First message
Hi, This is the first message in the Navision Financials forum. If you want to submit topics to the forums, you have to register first. Please use your real name when filling in the registration-form. Thank you, Mod [This message has been edited by Moderator (edited 09-11-1999).]
-
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??
-
Copy-paste entire cel from excel to Navision field
We have some problems with copy-paste actions from excel to Navision. When I select a cel in excel and copy it (the cel, not the selected contents) to a field in Navision the cel contents will be pasted, but also two "line feeds". This is not a big deal, I can see the line feeds as two squares and delete them. However we…
-
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…
-
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…
-
Could not load the selected library type (Version 2.60B)
I am trying to add feilds to a current form, (using the feild menu I select the Tool ID and drop it on the form) when I try to compile it gives me this error: Could not load the selected library type. When I select ok the Form Cal editor opens, I am not editing any of the code, nor is there any reference in the code to any…
-
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
-
Demand Planner
can any one suggest me where to get demand planner 2.0 for ms nav2009
-
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…
-
String to get a record
Hi, is it possible to get a record with a string of pk-values? something like this: string: 'Quote,1002' SalesHeader.GET(string); This does not work, because "can´t convert string into option" (error). Is there any solution for this? (recref does not exist in 2.60...) thanks!
-
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…
-
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…