-
Proforma Invoice..
Navision 3.10.. not sure if you guys have Proforma Invoice printing feature. Basically let's say I have 10 items on an order. Only 8 of those items are shipping. Customer wants to see what is shipping and exact dollar armount. Proforma should do that. Ours just shows the whole order. All these years what we've done is copy…
-
2 Databases in Single Database Server
Hi, I have configured Database server in my machine and i pointed my Database Path as "D:\Test.fdb". This database can be accessed by multiple systems. Now i want to add one more database in the same server(my machine). New database path is "D:\Live.fdb". This database will be accessed by multiple systems. Now what should…
-
Images????
Is there an add-on solution for external item images (JPG format) that I can use on both forms and reports? My objects are already heavily modified, so b4 I ask my developers to write a solution, I just wanted to check and see if there was an add-on solution that will require minimal mods. I have objects ranging in…
-
Adding total to a report
Navision 3.10.. Last one and I should be good for awhile... How do I do a report total? When I go to Purchase and Payables and then to Orders Received. I go to Posting and Test Report. On that report it shows me Qty To Receive, but I would like it to have a total on the bottom so we don't have to manually add ourselves. ..…
-
Report: Adding a field that looks up Item.'Shelf/Bin No.'
Hi everyone, I have a basic report that looks up a custom table called Overload Locations, that values are committed to. In the report that is based on this table, I'd like a field that 'looks up' the Item table's Shelf/Bin No. field in real-time, i.e. the values should always refer to what is current in the Item table for…
-
Customer Card printing on Picking Sheet..
Thought maybe I'd open a new topic for this. You might not have seen it since I posted it in an old topic of mine. I have Nav 3.10. In the old topic you helped me add a Discount Comment to Customer Cards, that shows up on a Sales Header via FlowField. You can edit it on Customer Card, but only view it on Sales Orders. It…
-
Variant Wise BOM
I have 1 FG Variant Wise (Nike Shoe Size Wise). For this FG , I have defined BOM without Variant and attached it on the Item Card. But I had to define Variant Wise although NAV has this option, we can define Variant on BOM Line. If I do the same, I have to create Item Card for each Variant. Is there any Option that we can…
-
NAS 3.70.2.19516 printing problem
Hi, I'm using NAS 3.70.2.19516 and I have the following issues which seems to have been reported ages ago: "Microsoft har (unofficially) confirmed this to be a problem with NAS. The problem resides in all versions up to 4.0. NAS will not handle margins, page orientation and tray selection correct. Microsoft has a fix for…
-
Manufacturing for Multi-Location against Production Order
When I create Production Order through Sales Order, Prod. Order Line is created with the Location of Sales Order. It also creates also Reservation Entry and Components Line with same location as of Sales Order. Now issue is that, i have to post Output in different location but System is preventing to do the same because of…
-
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 :=…
-
How to count a particular Character in a String
Hi, How can i find the Count of a character appeared in a string. For example suppose i have a string ABCDEFG@Yahoo.com,XYZ123@Yahoo.co.uk then if i want to find the Number of '@'. how can i do this using string function.
-
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…
-
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…
-
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.
-
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…
-
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…
-
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.
-
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…
-
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?
-
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…
-
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…
-
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…