-
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…
-
Stop the user to open new Purchase Order
Hi, I need to do a modification on user permissions to stop some user to open a new Purchase Order. The actually can do anything else in Purchase Order, modify the line or header, insert new lines modify existing lines etc.. they just don't need to have permission to open a new Purchase Order. I did some changes in User…
-
Code editor code line column width problem
Hi all, The code editor is out of its mind!! The code line column width stuck to very narrow and I cannot find any way to increase it. Is there any way to increase it?
-
Help Cash Reciept Question
Dear Expert, Sorry this may sound stupid, but i just wanted to clear my confusion. What is the difference of <Blank> Document Type and Payment Document Type if you have posted it? Because before they're posting Cash Receipts with <Blank> Posting Type. I hope you can enlighten me experts :( Thank you