-
Linking field from one form to another..
Using Navision 3.10. I've went into a Table and added a field called "Standard Discount" which is text, with a maximum of 3 characters. I've then went into my Form for Customer Card and added a label and textbox to make the above Standard Discount show up. That part works fine and will save us time. This way we can easy…
-
Payment Due Date no longer working..
Using Navision 3.10. On my Posted Invoices I have a problem. On the right hand side I have Sales Invoice No, under that Sales Invoice Date, both of those work fine. Under those two it used to say "Due Date:" (later changed to say "Payment Due Date:") which you guys helped me with in THIS POST to implement and get working.…
-
Filter Files on Timestamp
I need to set a filter on the Time field of the virtual File Table. The filter should show only the Files with a Time < now-5Minutes (e.g. older then 5 Minutes) I tried so many ways to convert currentdaytime back and forth and nothing worked. Most likely it's a simple task but right now im a little bit helpless. Thank you…
-
xml import
NAV310, fdb Hi everyone, this is my first experience with xml, so, promise you'll be kind :) This is a "chop" of the XML i want to import I am currently using this code to read the split tag (this is a prototype, a little hardcoded): TXTNodeName[1] := 'trn:split';TXTTrnID :=…
-
Printing special item numbers for certain customers..
Is something like this possible? We use Navision 3.10. Currently we have options to print Packing List, Sales Invoice, etc. A few customers don't want our item numbers on those documents. They want their item number. Currently I output the files to PDF, erase what's there, type new stuff in a similarly sized and style…
-
Migration from Native database(4.o) to SQL DB
Hi all, We currently have Native data base for Nav4.0 the size of the database is 9GB. We are migrating it into SQL. The backup taken from Native takes about 70hours to restore in SQL. Can somebody please help with the following querries: 1) Process of Migration from Native to SQL. 2) Does it take 70 looooong hours to…
-
error Posting Sales Order with sales unit of measure Nav 4.0
Why when i posting sales order from warehouse shipment always getting error say there no item on Bin content?
-
Kitting and Return Order
Hi, Version: Nav 5.1. Is there a reason why stock Navision doesn't have kitting in Return Orders and Credit Memos? The reason why I'm asking is that one of our customers would like to see kitting lines coming back in a Return Order when doing a 'Copy Document' from a posted sales invoice (or posted shipment) back in a…
-
e-mail body formatting using c397
hello, can you help me? - i'm using c397 smtp codeunit form newest nav version. everything is ok, but can you suggest me, how to format body lines "user friendly" from navision client? :) br.
-
Update Primary Key and Modify the same rec....
Hello all, Is the following code valid in Navision? RecA ponits to a Table with PK: Document Type, Document No, Line No. RecB also points to the same table. IF RecA.GET("Document Type"::Order,'123',10000) then begin RecB := RecA; RecB."Document Type" := RecB."Document Type"::Quote; RecB."Document No." := '123'; RecB."Line…
-
PDFCreator to combine multiple files
Hello everyone, I am using PDFCreator to combine multiple files into one PDF file. The code looks like this: ... PDF.cOptions: = PDFOptions; PDF.cClearCache (); PDF.cDefaultPrinter: = 'PDFCreator'; PDF.cPrinterStop: = TRUE; FIND ('-'); REPEAT PDF.cPrintFile (FileName); files: = files + 1; END; UNTIL NEXT = 0; / / Wait…
-
The sales line already exists...
Using Navision 3.10.. I have a semi-difficult customer.. they want us to enter the items on Sales Order in order of material.. ie: cotton, rayon, knit, etc. They're an international customer and maybe they do this for customs.. not sure. So, let's say I have entered 10 items on a Sales Order. I put them in the correct…
-
Bulk printing of invoices to PDF
Question: Does anybody know a way to bulk save/print documents from Navision and using the Documentnumber as input for the filename? Reason: We are working with Navision 3.6 since 2003. Some of our companies print their company information via Navision (no preprinted address on company paper). It now appears that for some…
-
Item Journal Line Posting
I have an odd question. I have written a custom mod that replenishes a customer's retail stores based on average sales. The function calculates a required quantity per item, per store (location) and writes the results to Item Journal Lines as transfers from the warehouse to the stores and then posts them. My customer is…
-
2GB limit or did I do something?
I've noticed my FBK backup files are split into two files now.. is it because I did something or is it because of a 2GB filesize limit? The first file is 2,097,152 and the second is 85,000 roughly and growing.
-
Variant Code not always showing..
I have a weird problem. Navision 3.10 We have entered most of our new items in Navision for the 2010 season. We followed the steps we normally take to create new item cards and item prepacks. For example let's say our item number is 1450-0111 and it has colors Red, Black, and White available. When we are entering orders…
-
How to not splitting grouped data?
I regrouped information in report by Sales Item Group. I need to keep one group of data is on one page. Now i get, for example, beginning of one group in a end of first page, but end of this group in a beginning of next page... i know, how to get NewPagePerGroup, but this isn't a good idea... The i get one grouped data in…
-
Printing Problems with NAS
Hi! We have problems to print correctly reports using the NAS. If we run the codeunit under a client (in the same server) it works properly but using the NAS, we get incorrect margins in the reports. We have try with many printers and drivers and it seems that NAS have a bug. We have install the last Service Pack for the…
-
Update only one sales line per Trip
Hi, "Trip" is a custom field linked to a new table, it basically identifies the lorry a sales line is being shipped on. Each sales order can have different Trips against each line, eg: 10000 / Item 1 / Trip 5000A 20000 / Item 2 / Trip 5000A 30000 / Item 3 / Trip 6030B etc. I need to find a way to loop through the sales…
-
custom paper size
Good day fellow developers i have a problem in defining custom paper size in the server properties the option for create new form was disabled. any idea why the option was disabled?
-
Installing BA using Citrix Server Farms......
Hi, I am able to install Basic BA W1 ver 4.00 successfully on a SQL Server environment. But when i try to install the same using Citrix environment, i always get the error when i run the Configurator manually... DBNETLIB[SQL Server doesnot exist or access denied].... My Client's scenario... SQL Server / Demo database /…
-
Due Date passed, need the remaining amount
hi guys, i need a hint how should I present the remaining amount, on report, that customer need to pay, after the Due Date? Example: The Due Date was 20.09.; amount to pay 100$. customer paid 80$. today is 30.09, and the customer is owning us 20$. I need that 20$ on my report... i can't figure this out this report is not…
-
I want a new location for ZUP file - but how?
Hello We have at the moment the ZUP file placed at C:\Documents and Settings\USER\Application Data All users will soon get new PC's and therefore i need to change the location for the ZUP file to prevent loosing personal settings. Can I move the location to a server? All users will have the same personal server harddrive…
-
Rolled-up Capacity cost - calculation problem
Hello all, There are items in our Nav 3.60 database which don't appear to be reporting the correct rolled-up capacity cost and I can't figure out why. If I work it out manually, or run the Detailed Calculation report (99000756), the cost on the routing comes back as 1.24. However, the item card says 1.20858. I know the…
-
Create Form with multi-filter
Hello everybody, i use Navision attain 3.6, i have to create a form that shows the records from table, filtered by three fields (field1, field2, field3), at least that one or more of that fields is not blank. For example in language SQL is like if i have to execute this: " Select * from table where filed1<>'' or field2<>''…
-
Something to show # of boxes?
Navision 3.10.. Do you think this is possible or too much for me to attempt? When mailing out invoices and packing lists to customers we have to manually draw a line to indicate what is in box 1, what is in box 2, and then the total number of boxes on the last page. Would it be possible to have a report that asks me for…
-
Sales Invoice in Waybill
Hi All I want the Sales invoice number to appear in the Delivery Way bill. so in the Sales Shipment Header i hv changed one unused filed as "invoice number" and in the property, Table relation specified as "Sales Invoice Header".No. WHERE (Posting Description=FIELD(Posting Description)) after doing this when i run the…
-
Shipping Agent Service Code not populating..
Navision 3.10 Short version: "Shipping Agent Service Code" is entered on Customer Cards, but does not show up on Sales Orders. We have to enter it each time. When entering new customers in Navision on the Customer Card we have a few fields we fill in reference to shipping. On the main Customer Card under the General tab we…
-
Change Salesperson Code in 3.10..
Again, an issue with "spaces" in Navision bothering me.. We have 3.10. Whoever created Salesperson code did them in two different ways and it annoys me. On some they created, for example salesperson code as "RM-M" and another as "SH-M"... no spaces in between the dash. Then they created a third person as "LS - M".. with…
-
You do not have permission to run the Sales Header Table
Hi All What is the exact permission you need to see when i get the following error. "You do not have permission to run the Sales Header Table" Thanks satish