-
Apply in different currencies
I have the following situation: exchange rates in currency table: 31.12.04 - 1EUR=39663LCY 1CHF=25513LCY 21.01.05 - 1EUR=37998LCY 1CHF=24636LCY The following transactions were made from general journal: 1) 31.12.04 Account=customer X; balancing account=GL account Y amount=2865 EUR - (exchange rate…
-
Get dataitem / filter on request form
i have created a report with the data items Customer / Value which shows items sales by customer. Although working, i now need to filter on a particular field in the item card, so rather than adding the item dataitem to the report, i have done this as a GET item as : Item.GET("Value Entry"."Item No."); IF Item."FIELD" =…
-
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…
-
Dataport - Exceeds Destination Buffer
Having created and tried to use an Import dataport (format: variable), I got the following error message: THE LENGTH OF THE SOURCE EXCEEDS THE SIZE OF THE DESTINATION BUFFER Could anyone help me to solve this, please? Thanks. Zin
-
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
-
Granule Price - 4080 - Inventory - Sales Qty Discount
Anyone have an approx price of this granule?
-
How to calculate the standard cost of item without Routing
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
-
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.
-
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…
-
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…
-
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…
-
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…
-
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
-
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
-
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.
-
Print a report with only 2 items per page
I need to print out a report with only 2 items per page. Presently the report just prints items sequentially so half of one item can be printed on one page and the other half on the next page. Problem is I dont know where to start to put a Counter that counts the number of items that have been printed and to initiate a…
-
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
-
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.…
-
Records shown in Form
My problem is the need to show only specific records from a table in a form (similar to reports, currreport.showoutput). :( I generated a form based on table 5409 (prod order routing line). Now I only will show records in the form, which are based on a production order with status "released". I tried in the…
-
Commerce Gateway Client problem
Hi all, any idea. little History about calling microsoft no solution about this ??? When installing Attain 3.70 with commerce integration on xp and 2000 everything works fine connection to biztalk server. When we installed attain 4.0 as additional installation nothing works any longer same when we uninstalled both clients…
-
Problem In Double grouping in report
How can i make double grouping in my report?Like i have a table and i wnt to generate a report with grouping upon Document No. and then grouping upon Operation No. so that i can generate total of quantity under same operation no. with same Document No.Kindly reply as soon as possible.
-
Adjust Cost
Knows somenone why I've received the following error messaje when I run Adjust Cost-Item Entries and I have to do: "Another user has modified the record from this item after you retrived it from database. etc.."? The database is on SQL and the cost method for all of the items is Average. I didn't received this error…
-
Connecting to Navision 3.6 via c/odbc & .net
Hi all, Anyone know any step by step guides for connecting to Navision 3.6 using Visual Basic.net? Cheers jim
-
XML in 3.10
How do i get XML output from several tables in V 3.10 Navision?? I take it i use a dataport but the only way i can see to do it is to create the tags manually?? Do any of you guys and Gals have some sample code for doing this, Im afraid ive been spoilt by V4 XML Ports!! Thanks in advance Andy
-
Email Navision Document
Hi, We are trying to email our Navision invoices and credit notes but when we send the document, our company logo does not show up. It just X's out. Has anyone had this problem and tell me how to fix it? Thanks Rosemarie :?
-
Option string when querrying from a SQL Server Navision DB
Hi, In order to make several Data Exports & Publication, I planned to use SQL Views, DTS & Planned jobs on SQL Server. The principle is OK! The problem comes from Option string fields: when exported (or querried) they are shown as integer. For end users, the information is not meeningfull ](*,) DTS could be used to solve…
-
I can't evaluate decimal value to decimal FieldRef
I have a problem with evaluating decimal value into a decimal fieldRef. Everything works ok , but when i try to evaluate values smaller then 0.0001 in tables it shows like '0' and i can't understand why. For example if i evalueate digit 0.00001 to decimal field via fieldRef it shows zerro. :( this is my code:…