-
Break bulk-NAV 2009
Hi, we have some problems with break bulk function in warehouse picks. We are using Nav 2009. Break bulk works fine when gathering smaller UOM (pieces → boxes) (only pieces in inventory), but it doesn’t work the other way around (boxes → pieces) (only boxes in inventory). The base UOM and sales UOM is always the same…
-
Item template configuration
Hello for importing list from excel (create item and update existing item) how can apply item configuration template for new item in c/al ou al Thank you
-
Printing external PDF-files in NAV2009
I'm looking for a method to print external PDF-files in NAV2009
-
Allocate costs
Hi. I have a question regarding Allocate costs. When posting purchase invoices, they are correctly transferred to cost entries (entries are separate). The problem arises when we run the function allocate costs for the specific date, for example 05/22/2023, function combines all cost entries (all the previous dates too)…
-
Can I add a front page to a RDLC layout
Hi there, is there a way for me to add a front page to a rdlc layout? Our customer wants his Sales Quotes to have an additional front page. Is there a way to add one in Microsoft Report Builder? Since you can only add one header, i assume it's rather tricky to do.
-
The requested member does not exist
Hi, I'm trying to use the Microsoft.Navision.Mail.dll v7.3 in a classic 5.1 client thru the cu400 smtp. cu400 compiles. all works as expected on the development machine. On the client machine i get an unexplained error. Could not invoke the member AppendBody. The OLE control or Automation server returned the following…
-
Ways to deal with vendor consignment
I want to set up a vendor consignment. Basically most of the physical stock would actually be a vendor consignment. The things we should be able to do are: * At the and of each day let the vendor know what we consumed so he can invoice us. * Let the vendor know what is returned to the consignment each day so he can credit…
-
RAID10 configuration for 6 drives
Following on this thread. I've opened a new one. http://www.mibuso.com/forum/viewtopic.php?p=127281 My Basic question is how can you have RAID 10 configuration with 6 drives. Thank you.
-
Write Adjust Cost routine as a SQL Query?
Is it possible to write adjust cost routine as a SQL query? Adjust cost routine takes about 2 to 2.5 hours to run. We run it nightly at 1 AM. It causes tons of locks/blocks. The client that I work for, runs 24X7. I was wondering, if is it possible to convert the adjust cost report to a SQL query. Has anyone been able to do…
-
how to set up Tax bus. posting groups and Tax prod posting groups on G/L Account card
Hi I'm wondering if user needs to set up the Tax bus. posting groups and Tax prod posting groups on G/L Account card. It seems those fields are VAT related but I'm not sure. If user posts a purchase on a GL account using sales order, the tax could be calculated using the vendors' business group and tax area setup. But what…
-
Where is the bottleneck?
Hi, NAV5 with file database here. a report runs for about 100 seconds on old HW with 10K HDDs and Win Server. The repotr is just doing some filters and iterations on some tables. I have upgraded to a server several generations newer with shining CPU and memory, brought in plenty of SSDs, split database in files among them…
-
Can we use Item with new Expiry date once it is Expired.If Possible how this can be done.
Can we use Item with new Expiry date once it is Expired.If Possible how this can be done without changing LOT no.
-
Upgrading From Server 2003, NAV Activigence Issues
Hi, Just wondering if anyone can help me and might have gone down this path We've finally got to the point that our long serving Navision NAS Server needs to be upgraded to a more modern operating system. Our ops team is targeting a minimum of Windows Server 2012, if not 2016 We are running IT IS Activigence for the…
-
Create PDF without PDF Printer
Hallo everybody, could anyone tell me, if there anyway to create PDF Document without to install PDF-Printer? Thanks navsyst2
-
multi column filter using OR
How to perform multiple field/column filter using OR operator? For example, we want to filter Value Entry table (through Security Filter or C/AL code) to ["Global Dimension Code 1"='XXX' OR "Salesperson/Purchaser Code"='999'] Thank you in advance.
-
Problem to change Expiration Date for Lot
Hello, Current situation: - Bin Manadatory for Location SILVER is turned on and all other options are turned off on Warehouse tab. This Location do not use full WMS functionality and use only Bins functionality. - Tracking Code for Item ITM1 is LOTALLEXP, i.e. Lot No. and Expiration Date need to be registered. - Then we've…
-
file location in intercompany functionnality
Hello i have this problem when i want to import an xml file transaction can you please help me to fix this problem?
-
NAV 2016 Combine shipments very slow
Hello, Does anybody know why combine shipments is so slow when the customer has several orders some of which have many lines ? We have a customer that has no more than 3.000 sales lines and preparing the Invoice with "Combine Shipments" may take more than 4 hours. It seems that with every order it goes slower, slower, ....…
-
Item Cost included in Standard Cost of Production BoM but not respective Production Order
Afternoon all, We're currently working Navision Classic 2009, Manufacturing environment. Struggling at the moment to keep on top of items that are more suited to being on KANBAN as opposed to automatically adjusted inventory stock. We need to have these items on the Production BoMs such that the respective costs are pulled…
-
How can I see the price of a lot?
I'm checking the item ledger entries and I see the lot number: But where can I see the price of that lot? For example the first line, a Purchase for lot no. 1234-3 where can I check the cost of that purcharsed lot? Also for sales the sales price... for posted assembly it also should have a price Where can I check it?…
-
the transaction cannot be completed because it will cause inconsistencies in the g/l entry table NAV
Hi, In NAV 5.0 SP1 I get this error message when I try to POST an Sales Invoice the transaction cannot be completed because it will cause inconsistencies in the g/l entry table NAV 5.0 SP1 It only happens when I try to post an Invoice with a G/L Account (only found problem with one G/L Entry 7000000001). When I try to post…
-
Overhead Applied Account in General Posting Setup
Hi! Can someone give me a brief overview of the importance and use of the Overhead Applied Account in the General Posting Setup window? In our actual setup of posting groups, we have not entered any G/L Account in the Overhead Applied Account field and we could post our invoices. But just today, while posting an invoice,…
-
Problem using RecordRef and Changecompany
Hi. I am trying to copy a lot of tables from one company to another using RecordRef. But it seems that the OPEN method doesn't work as planned. This is the code I am trying to execute, (I have set filter on just one table here to test..) rTables is of record 2000000028 with information about tables. sOldCompany :=…
-
SendRequestAndReadResponse - HTTP Web Request Mgt - Procedure
Dear all! The case : I am having to do a post request using http method. What i need to know is , when exactly, does the post request in the sendrequestandreadresponse procedure, occurs? Because there are times that i am getting a timeout error in the getwebresponse , which is called by getresponse procedure ( codeunit…
-
Debugging NAS Code
Hoping someone can help me solve an issue. I have a virtual machine set up with ADCS, NAS, and the 2009 R2 Classic client and have it pointed at a test copy of my SQL Database. I'm trying to debug a new codeunit that I'm writing for ADCS. I'm running the client as admin, have opened up the codeunit in the designer, set a…
-
winhttprequest send method (with blob) with Umlaut conversion problem.
When in send a BLOB through an InStream that contains a special character ( german umlauts Ä/Ö/Ü ) i get a "400" response because the character doesn't get converted correctly. According to the ms docs you can add a second parameter to the function for enconding but it doesn't work with navision 2009sp1 does it? I'm…
-
Removing dates from Reservations.
This is an issue I have seen for a few clients, normally a training one, but one particular client really does need reservations to be independent of date. The client is on old 3.10 objects. The issue is that if you are in (say) a sales order and you want to reserve an item, it will only show you purchase orders with and…
-
Post resource cost to general ledger in Job Journal
Hi, I'm using NAV 5.0 SP1. When posting resource usage to a job in Job Journal, I would like to create general ledger entries. The WIP-method is contract completed. Resource costs should be posted debet on a WIP-G/L-account (3110) and credit on a G/L-account called "covering Salary" (4080). This means the journal ledger…
-
Nav 2014 diameter pie chart
Hello all, I have the following problem: I have programmed 3 different pie charts in C/AL in Dynamics Nav 2014. In the display all 3 charts are shown with the correct data, but all 3 pie charts have different diameters (despite the same measured variables). Is there any way to set the pie chart diameter so that in the…
-
Error while changing Phys Invt Counting Period Code value
Hi Friends, Version: 2009 In item card, Warehouse tab: I am trying to change the Phys Invt Counting Period Code from A to B and I am getting an error The date is not valid when Last Counting Period Update field contains some date value. If Last Counting Period Update is 0D, then I could able to change Phys Invt Counting…