-
Text Field Length limitations and possible work-around?
We currently use the Navision 3.6 objects with the 5.1 executible on a SQL 2005 SP4 (X64) database. We have a project that requires that two tables be created that accommodate all text fields with the maximum length of 250. However, upon compiling the table, we receive the error that "The active fields in a record may not…
-
Answered: Change orientation of report section
Quite new, confused and frustrated with Navision. As a trainee exercise I'm asked to add a section to an existing report (done that) Now I need to find out if its possible to print this 1 section in landscape, while the other 2 should be in portrait. I found out that you have a Orientation property but if I understand…
-
Way to make button show up only if there is something there?
Nav 3.10 On the Shipping tab of a Sales Order. Where it says Ship-to Code there's a box and an arrow. If you click that arrow it will open the shipping addresses (if that customer has any). Maybe there's a way to make that arrow only show up if there are shipping addresses? Some customers have the same billing and shipping…
-
You cannot delete Customer...
Navision 3.10 Someone gave me orders to enter.. they had created a new customer card COTTO012. Three orders, exactly the same. I entered one, then used Copy Document on the other two. Only thing that differed was shipping address. Today, someone is checking over orders and noticed this customer already exists in our system…
-
Tell what is in stock easily?
Nav 3.10 I know my system is different than yours since I have something called Matrix, but I figured I'd ask anyway. Our new merchandise is starting to come in. Some received and entered in Navision, some not yet arrived. At the same time I have a bunch of orders to ship as ready when the items come. Is there a way to…
-
Migration from 2.2 To SQL 2008
Hi We currently have a very old 2.2 vserion of the Navision objects, nothing wrong in that, which we are moving to a SQL database. The current database size is 75000000 of which 59507360 is used. It's a bit of a broad ask but when this is converted to SQL, what would the recommnded size of the ndf, mdf and ldf be? I've…
-
Straight Line Depreciation not working in 3.60
Hi! We have a client who is running the US edition of 3.60 who has reported that Straight Line Depreciation does not work correctly. They have just noticed that the depreciation value for this month has changed for some of their assets. This is -10.08 this month whereas it was -10.41 and has been since January 2009.…
-
Error while testing the tables
I want to test the tables in navision. I go to File -> Database -> Information ->tables -> test Then select File option -> Click OK. Then it gives error. The type of the constant must be compatible with that of the Month No. field, and the length of the constant must not exceed the length of the field. Type: Option<-- Code…
-
Matrix Pebble-Stone
Hello, Help, I need Help. :oops: Can you help me about matrix in Pebble-Stone????? Anyone knows how can I deal with that problem? :!: Thank you.
-
How can i integrate Navision,LS-Retail and Pebble-Stone???
Hi , I had one doubt. Suppose one Customer will use Navision,LS-retail & Pebble Stone. But my doubt is Microsoft will provide Nav+LSRetail and Nav+pebbleStone. these two Databases are different. Is Microsoft will provide combination of these three???? Thanks & Regards, Kishore.
-
Deleting End Blank Spaces
I have a project I want to do because it's been bugging me forever. When we switched to Nav a long while ago we imported our data like everyone else. All of our cust names, address, city etc. have lots of blank spaces at the end so when you put them together you get NEW YORK__________, NY instead of NEW YORK, NY for…
-
C/Front - Date and Time
Is there a way to clear a date or time field to blank from C/front ? Thanks for any help in advance
-
Nav upgrade from 3.60 to Nav 2009
Hi, We need to upgrade Dynamics Nav 3.6. to Dynamics Nav 2009. We need the process before upgrade the database. If anybody having document for upgrade, kindly share with me for both functional and technical part. Thanks
-
Navision login viewing 'black screen' only
Hi anyone, Anyone encounter this phenomenon before, after login, everything is black, no navigiation menu, menu bar... nothing at all.
-
filler and filler character attribute:how does it work?
Yo, I want to export data in a file but I've to format them specially. Example: quantity must be 10 length and filled with 0 before (or after..same problem): 12 pces = 0000000012 location code: 10 length with <space> after LOCA1 =>'LOCA1 ' :shock: and so on. I thought I could use the FORMAT...FILLER attribute, but I can't…
-
Adding stuff to invoice based on alphabet letter of Sell-to
Navision 3.10. Awhile ago you guys helped me add special text to print on an invoice based on what the payment terms are. Example: IF "Payment Terms Code" = 'CC' THEN BEGIN RemitText1 := 'YOUR ORDER HAS ALREADY BEEN PAID FOR.'; RemitText3 := ''; RemitText4 := ''; RemitText5 := ''; RemitText6 := ''; RemitText7 := '';…
-
Sort Item No on Order
Navision 3.10 When entering an order I enter my items. I can go to VIEW, then SORT and I can sort by "No." field. When you exit out of the order and back in, though, it's back to the way I entered it. Is there a way I can make this sort stay? Or maybe I can keep the original sort button, but somehow make a new one for my…
-
RELATİON
Hi ı have a reletion in my Supply table I want open a contacts and 'ST DANIŞMANLIK' in my table This is my Reletion "Ship-to Address".Code WHERE (Name=FIELD(Customer),Name=FILTER(ST DANIŞMANLIK)) But its not work how ı can do this?
-
CALC A TIME
Hı ı want calc a Spending tıme in my form User enter a Starting Time and Ending Time ı must calc a Spending time but this fields type is time :( how ı can calc spending time ? FOR EXAMPLE := SpendingTıme:=EndingTime-StartingTime;
-
GL Inconsistence Error
I am facing a problem in purchase credit memo with service tax then give a error for gl incosistence while not any round off in credit memo Line Amount =1000 S.T. =100 Ecess =2 SHE =1 In Purchase credit memo Calculate service tax wrong ST Base=1000 ST = - 100 Ecess = -2 SHE = 1
-
Bn Server
Please HELP!!! for second time please urgently if anyone can help me..... is Business Notification Compatible with SQL Cluster Service?? there is a customer need to install BN Server into his Company but they have SQL Cluster when we connect to running instance we can't install a BN into LOCALHOST, then we are choosing…
-
SubContract Variance Account - Adjust Item Cost Entry
We are having an issue with the SubContract Variance account. We are hitting the $ values in this account. The dollars hitting are the dollars that have been received and not paid to the supplier (uninvoiced received). Here are the steps they follow 1. They create the Production Order. The Production order has SubContract…
-
Can't create subtotals in Excel from Navision.
Hi, I want to use Excel function "Subtotal" from Navision, but problem is here: When i write sheet.range('A9:U18').subtotal(4,-4157,'6'); all work properly. column F have a subtotals. But I need subtotals in columns F & G. sheet.range('A9:U18').subtotal(4,-4157,'6,7'); doesn't work :cry: as i understand Excel want ARRAY in…
-
Barcode
Hi We are planning to implement Barcode system in our operations. Every carton comes into our cold room and goes out of cold room we would like to scan and store the carton information in navision. Barcode label in the carton will hv information like Vessel Name, Voyage number, product grade, Freezing Date and Expiry date.…
-
Change GST Base Amount (ACY)
hi all... in sales order or sales invoice and the sales statistic there is a GST Base Amount (ACY) can we modified that ?? like in allow GST Difference, then we can change the GST Amount now... can we change for the (ACY) is there a setup that i can tick or untick to update this? thanks
-
Detailed TB (Vendor/Customer) - Navision 4.0
Hi, I am new to Navision (and so may be missing something right under my nose) but I can't seem to get a simple list of outstanding invoices on the accounts payable vendors. The only way I can think of doing it is running a detailed vendor tb, with no date filter (to prevent "opening balances") and using the remaining…
-
Set filter to not blank
I have a report that is currently looping through the Purchase Header Table. There is a CODE field (field class normal) in this header which relates to the Sales Header table. Some orders are linked to the sales headers in this way, some arent. I want the report to only look at the ones where there IS a link so i use the…
-
Navision: how can know which vendor invoice is unpaid?
Dear All Navision Friend I'm a Navision beginner, so i have many problem related to Navision. Would any one help me how to find any report that show the outstanding vendor invoice with its invoice number and balance? Actualy, I've tried on several report such as Aged Account Payable, Summary Aging, Detail Trial balance...,…
-
upgrade nav. 3.01.A to Nav. 6.0 R2 Runtime
Hi, we would like to upgrade the runtime on our old 3.01.A Naitive database to the new 6.0, this is mainly because we are moving to windows7, but i have to say im a bit confused on what to install, under the server folder on the DVD ther is a file called "Microsoft Dynamics NAV Classic Database Server.msi" i asume this is…
-
VAT/CST concern
Hi All, Scenario is - Vendor Location - Delhi Billing Location - Delhi Shipping Location - Bangalore where to mention that billing location is Delhi? as per scenario the vendor & billing location is same therefore the VAT is need to be charge, but system pick up te tax area code (CST) in combination of Vendor and shipping…