-
BOM will not post
I have just upgraded a client from 2.0 to 3.7. They are not using manufacturing and the BOM Journal will not post only on a few items. The error messages indicate that the item does not exist, however they do and the quantity on hand is more than enough to handle the consumption of the quantity needed. ](*,) Can anyone…
-
Reset and Deleteall
I see Deleteall used quite a lot in the standard navision codeunits, and lines like the following puzzle me somewhat: TempJnlLineDim.RESET; TempJnlLineDim.DELETEALL; Given that TempJnlLineDim is a global variable for Record 356 (Journal Line Dimension), this would remove every row in that table would it not? My issue here…
-
Apply to customer entry (closing "by date")???
When I set on the customer card that their entries be closed "by date", and when I post the customer payment through the journal, it applies to and closes the oldest ENTRY (entry no.) in the table customer ledger entry regardless of the date it was created!!! How do I make it apply to so it closes the oldest entry starting…
-
BAConfigurator40
Hello! Someone knows if the BAConfigurator40.exe works properly??? :? I can not execute it, because an error... the error tell me that there is a problem in the name of the file :shock:
-
Correction problem with FIFO and Adjust Cost.
Ok, here is a situation... The costing method on item is FIFO. Now: 1. okt purchase 1 PCS of Item by 100 $ 3. okt purchase 1 PCS of Item by 300 $ but second invoice was wrong, i made an mistake... so i must do Credit Memo with "Correction" = TRUE when i do that with same values, same date as second (the wrong one invoice)…
-
Image in footer always shows
Hi, I Have a report that has an option to put an image in the footer. Based on a value I suppress the footer with this: CurrReport.SHOWOUTPUT(FALSE) The strange thing is, no matter if the image is shown or not, it always print print the section. If the image is shown, then the image is printed. If not then the size of the…
-
How can I pass a temporary table by reference?
Hello. I have a question for you. How can we pass data of a temporary table by reference without having copied it? Use of var-parameter of a record type is not this case. I want to store the only the reference. That's the case. I create a form with a temporary table and fill it there. Then, I want to store a reference to…
-
Export to excel from Analysis by dimension
Hi, You can export data from your analysis view into Excel. But what's up with the column accounting period ?? I have for every line the value 1-1-2005 seems the system ignores the posting date. Or am I missing something here ?
-
to release production order
Is there a possibility to releas just a part of a planned production order? thanks for helping
-
Date
hi! how do i format a daterange keyed by a user in a textbox (ex. 01/01/01..02/02/01) into a date format?..... i want to use this value as a filter in a Date field...however, navision seems not to take this value as a date. hence, i get a type conversion error. hope somebody can help... thanks! :D
-
Currenttransactiontype
Hi Can anyone tell me what this function CURRENTTRANSACTIONTYPE does?? Also is it possible to do a table level locking when we use a SQL Server. TIA Sri
-
Closing connection in ASP
Hi, i have to write a connection in ASP to Navision DB Server 3.6 it works, but when i close the connection in the code, and i look to the connection in the database, the connection is still shown. So i conclude the connection in navision is still pending. in ASP however i am sure the object and the connection are…
-
trouble with report request form
Hi all, I don´t want request form to show properties for all tables (dataitems) used in report. For example a report based on Sales shipment header and Sales shipment line...I want request form to show me only properties of Sales shipment header so I can choose filter for Document No. or something. Does anybody know how to…
-
Totalling an Integer Field
I am trying to add a total to a field which is classed as an integer. the contents are 1 2 3 etc i would like to calculate them to give total 6. From my understanding, as this is not a decimal field then i cannot calculate on it? Is this correct, and if not, how would i go about adding a total field to the footer? Thanks
-
Item Standard Cost without Routing Granule
Hi all, We haven't the Routing granule in our Navision licence. In another hand, the standard cost of an item = unit cost of article in his BOM + 30% of this cost. So, how to add this 30% of cost after using "Output Journals" in Manufacturing Module ? Please, help me, it is very urgent! Thank you in advance
-
C/ODBC in combination of Crystal Reports 10
I've a problem using a Navision DB in Crystal Reports. I've created a DSN in ODBC Data Sources using C/ODBC. And connecting to the database works fine. I only have a problem connecting to/inserting tables to Crystal Reports which have boolean fields. Then I receive this message:Query Engine Error:'22003:[Microsoft Business…
-
Granule Price - 4080 - Inventory - Sales Qty Discount
Anyone have an approx price of this granule?
-
Quote char in odbc query
How can I escape the quote charachter in a ODBC query? I tried to double the quote: 'o''hara' and the backslash char: 'o\'hara' but none works. Marco Morreale
-
Comparing UOM
What code is it to compare two units of measure? One Item Two Units Of Measure (Each & Deal) Each always 1 Deal Always > 1 I want to pop a message up that says "Both Qty Per Units Of Measure Are The Same" (or something) I was thinking simply IF "Code" = 'DL' and "Qty. Per Unit Of Measure" := 1 THEN ERROR('Wrong QTY…
-
Navision 3.10A UK Client
Does anyone have the Navison 3.10A UK Client and Database from the Product CD that I can download? I currently have the 3.70B UK version only. Thank you.
-
More Options for Item Card?...
I'm trying to find out if I can add more fields to the item card. Like retail, export, etc. pricing. Alot of our items can not be grouped into item discount groups because they have individual discounts for each pricing (retail, export, etc.) group.
-
Faxing problem
I recently bought a new PC for a user on my network and they previously faxed orders directly from navision. Under XP she is no longer able to do this. I hit print and select the fax and the fax screen comes up but I can not keep the window active. I get no error message or anything I just can't keep Navision from…
-
Upgrade of Navision Fin. 2.00 Adv. Distribution to 2.60
Hi, I would like to know the steps to upgrade an Advanced Distribution 2.00 database to 2.60 (as a temp. step to finally upgrade to 3.70). The steps are basically: - Restore 2.00 backup in 2.60 version. - Import upgrade1.fob and run for duplicate names. - import 2.60 object set (mods included). - Import upgrade2.fob and…
-
Item Turnover Form (158)
I have a question & I just can't seem to figure it out. ](*,) The item period for this form can scroll up & down endlessly. Needless to say I don't need it to go to year 1784 for example. How can I change this range so it only shows 1/1/2000 to say 12/31/2010? Thanks
-
Problem with different VAT percent....[URGENT]?
I have two items with different VAT group(8% and 18%) in same purchase invoice, and when post it, both items are with the same VAT(8%). In VAT Prod. Posting Group setting are adequate values. But, when i use Sales Invoice, everything is correct. Why? Thnx
-
Setfilter with an option field
Hello. I need to make a filter to a table using the value of one option field. The value of this option field has blanks so the setfilter command doesn't run. I've try to use the number of the option but also doesn't work. Can anybody help me? Thank you very much.
-
Pre-Assigned No. <> Invoice No after posting an invoic
Hi All, ANyone has any idea why does the Pre-Assigned No. is different with then Invoice No after posting? This happen occasionally. Thank you.
-
Automatic Order Form?
Hi, I'm trying to find out if there is a way to make an excel or other type of order form that would automatically work with navision through email? Example: Customer fills out order form, emails it, customer service agent then enters automatic order. I'm bacically trying to keep from entering each individual item.…
-
Transfer Orders and Intrastat
Hello, We have a small problem regarding Intrastat and Transfer Orders. Why isn't a transfer order from a domestic location to a foreign location (clearly this is export) taken into account on the intrastat module of Navision? Does anybody have a clue? Greetings
-
How to manipulate the MS Navision Attain Help ???
Hi Folks, I have created a form and I would like to explain its functions in the MS Navision Attain Help. Does anybody know how to implement additional information in the Ms Navision Attain Help? Thank you very much blub