-
How to calculate Tax Amount in pre sales invoice.
I knew that "Amount Including VAT" field in Sales line gets updated when we release the order. we can use that field to calculate total tax amount of the invoice. but before releasing we can able view the total tax amount in statistics (F9). i need to show that total sales tax amount in sales invoice form with out…
-
Set default Location Code on Production Order - NAV 2013
I am new here. thanks for any help on this. I am trying to figure out how to set a default value for all new Released Production Orders & Firm Planned Production Orders. I can't find a way to do that. How is this done ?
-
Urgent: Suggest NAV Bar Code Scanner
From the list of below Bar code Scanner, Please suggest me which one to buy.. systemid.com/datalogic/memor/ systemid.com/datalogic/datalogic_elf/ systemid.com/motorola/mc3100/ systemid.com/datalogic/falcon_x3_/
-
Assistance with Output entries in Item Ledger Entry
Hi All, Good day! I was hoping for some guidance please. We have some old Output (entry types) in some items visible in the Item Ledger Entry. For this items: 1. Current inventory (on hand) levels are 0 2. However the Net Invoiced Qty field is coming up negative The negative quantities are coming from these Output journals…
-
problem unapplying customer ledger entries
when trying to unapply a payment from an invoice, I get the following error message: Unapplied must be equal to 'No' in Detailed Cust. Ledg. Entry: Entry No.=498. Current value is 'Yes'. Note that the entry is definitely applied (the only one for this customer). And Entry 498 has not been created yet (last one is 497).
-
Item Packing Rule
I have a textbox in my Warehouse Pack Scanning Form that I am using to predict how many cases will be needed for all the items for an order. It should be using Item Packing Rule but I am not sure how to calculate that. Are there any ideas on how to calculate this?
-
Export to multiple sheet in excel using Excel Buffer table.
need some help in exporting data using excel buffer in nav 2009 but to multiple sheets in same excel file. any idea how to do this? For Example I want to have one sheet per vendor & want to export first Vendor legder's Entry No. to excel in each sheet. codes are here - IF vendor.FINDSET THEN REPEAT gin_row := 0;…
-
How do you Link a text box input to a shipment number?
I have created a textbox for a user to type a number. I want that input to be saved to a specific shipment number so that it always shows that number in the textbox whenever viewing shipment number page. Is this possible? If so, how?
-
Prepayemnts and Sales Tax in NA Version
I support a couple of businesses in the USA and Canada. Prepayments with Sales Tax does not work in NAV 5 or apparently in NAV2009. In which version of Navision / NAV it is possible to use Prepayments and Sales Tax? Was there a hotfix or patch released to make this work? Can you give me a link to the fix? Thanks in…
-
NAV CLOSING when design button pressed on my report-object
hello all.. i'm created report.. it works, but... application is closing when i tried to design my report-object or export it in txt format (fob export normaly, but when importing to other database i'm also couldnt design it)... how to "repair" it? sorry for my english.. and many thanks for answers..
-
ADCS, Stream has returned write Error while entering details
I have configured ADCS Very well. I got the Navision Data on Hyper Terminal, but when i pick a item from Put-Away zone then i got the error "Invalid Bin Code" & 1 more Error : Stream has returned a write Error I mean data doesn't go into Navision Database. Any idea invited. The Screen of "Hyper Terminal" : PU000003…
-
Run table from code without object designer
A customer wants to run the table directly to get at the raw data. But without the rights to object designer. Possible?
-
How to export to excel concurrently using NAV 5.0?
Dear all, I want to export to excel using navision 5.0 but concurrently multiple persons will export to excel. So if I do this then I will get error rows and cols already exists. In this situation how to overcome this to concurrently export to excel by multiple users. Thanks & Regards, sekar.
-
Reordering Policies and Reservations
Hi there, Our company has been researching and testing the Calculate Plan feature in Navision that allows for purchasing suggestions based on the different reordering policies. One topic that I have come across which I did not find an answer in the white papers, user manuals, and online research is why certain reordering…
-
Reconciled Bank Statement Error
Hi all, I reconciled a bank statement that, unfortunately, had an incorrect statement date. Is there a way I can edit this and keep the posting or do I have to reverse it all out?
-
MSXMLDOM6 How to add a namespace
I am reading an xml document that has a namespace (xmlns="http://www.demandware.com/xml/impex/order/2006-10-31"). Findnode does not work when the namespace is in the file. If I remove the namespace from teh xml file then findnode works. The work around is to add a namepsace using the xmldom. I know how to do this in NAV…
-
Byte.Length
Hi Guys , I am writing a function to calculate MD5 Hash in Navision. I am taking a .net code as reference but I got stuck on a code which goes like byte[] data = md5Hash.ComputeHash(Encoding.UTF8.GetBytes(input)); then data.Length So I declared a variable called VarByte in Nav of Datatype DotNet and Subtype…
-
How to add 'available inventory' to Items grid
Hi All, Could anyone inform me how easy/difficult it would be to add 'available inventory' to the items grid? This would assume a single location with the 'available inventory' figure the present moment in time. Thanks
-
Inbound Transit Time from Supplier to company
Hi there, I have not found a field in Navision's functionality that allows an inbound transit time so that we can calculate both a shipment date from the supplier and a receipt date to our company. Has anyone come across a field or functionality that allows an inbound transit time to be used in Navision. How do you guys…
-
Send-ahead quantity - Multi-level structure
Hello, I have a customer using NAV 2009 SP1 classic and they want to use the MPS. The manufacturing process is as follows: Raw Material -> Semi-finished Item 1 -> Semi-finished Item 2 -> Finished Item. The raw material and the semi-finished items are the only components of the next item and the relation is 1:1. The…
-
NAS "file name contains a char that cannot be used
Hi. I am installing NAS and following Alain Krikilion's excellent How-To at: http://www.mibuso.com/howtoinfo.asp?FileID=15 I had no trouble using these instructions a few months ago in an SQL environment. But today I'm on a NAV server installation and am tearing my hair out. Here is my command line: C:\Program…
-
New / Second Hand / Buy or Rent 2009 license needed
Hi, We have a 40 user NAV2009 classic environment and our company is going to be sold and divided in 2 separate companies with 2 different owners. The old owner A is going further with 35 user classic NAV2009. I am the new owner B of a part of the company with 10 employees and want to make a copy of the old database…
-
Entries applied to an Outbound Transfer cannot be unapplied.
Dear all, I have created a Purchase Order on the "Blue" Location with a single Line Item (Quantity 1 PCS) and then made a GRN. After that the Item has been transferred from "Blue" Location to "White" Location using Transfer Order Journal. Now realized that there is a mistake on the GRN and I want to rectify my mistake but…
-
integration nav with office 365
hello, i am trying to do an integration between nav 2015 ( on azure account ) and the office 365 i got the VM on azure account and all necessary components. after importing NAVOffice365Administration module, i try to run the script: Set-NavSingleSignOnWithOffice365 -NavServerInstance “ServerInstanceName”…
-
NAV 2009 R2 Job module, disable usage requirement
Hi All, If you worked with the Job Module you probably know this message: "You should consume Item in Job before you post sales Invoice/Sales Credit Memo" This error message is shown if you try to post a sales invoice / credit memo generated from the Job Module with Items, but did not post usage first. When creating a…
-
How to change old Dimension Codes to new in all rel. tables?
Hi Friends, Version: NAV 2009 SP1 We have a requirement to change the old dimension value to new in G/L Entry and other related tables. Currently, below 10, 20.. 100 are the dimension codes. 10 - DimA20 - DimB30 - DimC40 - DimD50 - DimE60 - DimF70 - DimG80 - DimH90 - DimI100 - DimJ Current requirement is, instead of the…
-
Force Deadlocks
Hi, I am running on NAV 2009 R2. I want to force my NAS into a deadlock. Any idea how to do this reliably? Thanks in advance!
-
How Do You Change the Color of a Record in NAV
Hello, I need to highlight in red a record in NAV given a condition is met. When trying to do this on a form it reports ... The Dynamic Property 'ColorSet' cannot be changed in this context. Please could you advise. Thank You A
-
Coder Challenge - Tricky Item creation
Hello All, I have a client that requires us to create thousands of item numbers based on a intelligent number scope. I need a way to create all the combinations of item numbers based on these options. Item Number = Type + Style + Color + Option Type 1 2 3 Style A01 - A02 A03 A04 Color L01 L02 T01 T02 V01 Option S F 0 **…
-
Sorting attachments in descending order
Hi Friends, NAV Version: NAV 2009 (Classic client) I need to sort the attachments in descending order. When I browse to Invoices through Sales and Marketing > Order Processing > Invoices, I can attach the files as attachments. I can attach multiple files. Now, it shows the lastly attached file in the bottom. But my…