-
DueDate -Designflaw
Hi Why MS allowed the duedate in the vendor/customer open transactions form ? Is it design flaw or is there any specific business reason ? Can you all share your experience ? Thanks
-
COGS
Hi Experts, We have faced a major problem in 2014. The cost adjustment was not ran for a long time it was last run around august 2014..Now auditors came and took the data of 2014. after running the cost adjustment for remaining months of 2014. It is showing almost 4 million increase in COGS and company profit in the year…
-
Finding Parent Node Name in XML file whilst processing
Hello, I am wondering if someone could help me please with regards getting a value from an XML file whilst I am looping through the nodes Basically I need to find the parent node name (Hopefully that's the correct term) of the XMLNode I have in context. I have attached an example of the XML file I am reading data below. If…
-
Error when Deleting Purchase Order
Hi, We are trying to delete Some Purchase order and get the following error: "Microsoft dynamics NAV classic client executable for SQ has stopped Working". I am not able to debug the system as it keeps crashing. The version of the Nav is 2009 R2. Any suggestion? Thanks,
-
Default Dimensions for Locations
Hi, When we post sales, we have dimensions default from the customer and the item. This works well. I notice there is not a place to enter a default dimension for a location. Does anyone know of a way to default the location dimensions on to a sales order? Or, can anyone advise on how they can breakout sales by location at…
-
2013 R2 Upgrade There must not be empty base unit of measure
Am trying to complete Navision upgrade and got the following error on running step 2: There must not be empty Base Unit of Measure. Please fill it in for Temp Item ItemNo before updating.
-
Rollback - Make to Order
Hi, I have a situation where in i have modified the Codeunit-83 (Sales-Quote to Order(Yes/No). I have some customized code which makes use of the SalesHeader Number that the methodSalesQuoteToOrder.GetSalesOrderHeader(SalesHeader2); fills in the 'SalesHeader2'. What i want is that if the customization that i have done…
-
Access xRec-Data via RecRef?
Hello! I wonder if it is somehow possible to access the data from a xRec by RecordRef? To explain the background: I'm working on an Export to an external system and I have to check if relevant fields have changed. As I don't want to add code to each OnValidate-Trigger or do 50 "if Description <> xRec.Description" I'm…
-
Issue Importing with Rapid Start - Item Identifier
Hello, I'm trying to import into the Item Identifier table (7704). I created an excel export template using the Configuration Template. I populated the template with the "Code" and the Item No. The file imports just fine. However, when I apply the data, nothing imports. I get an error stating: "Item No. must have a value…
-
Gen. Prod. & Gen. Bus. Posting Group req. when posting G/L
When posting to a G/L account in a Purchase Order my client is getting the message that a Gen. Prod. & Bus. Prod. Posting Group is required! The vendor is set up properly. It doesn't make sense that you would have to do this set up for EACH G/L account! They are using VAT. I believe the VAT posting groups are set up…
-
Set code on "pause" until window is active again
Hi all Hope someone can help me with this little issue - have tried to make it work but it seems to be more difficult that I presumed. Situation: when an "outside NAV" feature is called - ex. IE or CMD - how can I stop code executing further on until I return to the form (become active again). Suggestions would be very…
-
Only Recording one Infocode on a Transaction in LS Retail
I have an Infocode attached to certain items to collect the Salesperson details for these transactions, but it doesn't always record and I have just discovered that when they select the item - it is correctly requesting the salesperson information (first), but if staff then select the Pricechange button at the POS to…
-
Item Reclass Journal - Posting Error
Hi, Can anyone help me with this error while posting Item Reclass Journal? "A fixed application was not unapplied and this prevented the reapplication. Use the Application Worksheet to remove the applications". Many item lines were entered on this Item Reclass Journal, how can I tell which item is triggering the mentioned…
-
NAV writing blob to xmldom
I am using the xmldom automation to create an Item Export. (I have NAV 2009 R2) My one problem is that I have a blob field with text that is over 1024 characters. How can you write to a node if you have more than 1024 characters? xmlnode.text := bigtext unfortunatley does not work. Maybe I could use a variant variable or…
-
DateTime Field only Returns Date in Dynamic NAV
Hello Experts, I have a Table: CREATE TABLE [dbo].[CHECKINOUT]( [USERID] [int] NOT NULL, [CHECKTIME] [datetime] NOT NULL, [CHECKTYPE] [varchar](1) NULL, [VERIFYCODE] [int] NULL, .................. I have the following query in a codeunit in NAV SQLString := 'SELECT c.CHECKTIME, '+ 'c.VERIFYCODE, CAST(c.SENSORID AS INT) AS…
-
Residual Account, Business Unit Consolidation
Hello all, I've tried finding the answer to my question, but the only topic I found (viewtopic.php?f=23&t=57683&start=0&hilit=consolidation+residual+account) is not active anymore. I'm consolidating a Chart of Accounts from a subsidiary in the same database, using the Import Database function. After the consolidation is…
-
Dynamics Online Payment Configuration Table
Dear expert, When trying to issue a sales creidt memo, a users received an error message saying: ***************************** You do not have permission to read the Dynamics Online Payment Configuration table. Contact your system administrator to have your permissions changed. ***************************** I checked all…
-
approval management
Hello, When I try to send approval request it is giving me error that User xxx doesn't exist in User Setup table. Then I went to code and I found out this in codeunit 439. How could this ever can be possible? (Right me if I am wrong). And it is default code. UserSetup.SETRANGE("User ID",UserSetup."Approver ID");IF NOT…
-
Residual Account on business unit, Consolidation
We are onNav 5.0 SP1. And, we use multicurrency. I’m trying to understand the functionality behind Residual Account configuration on the business unit, G/L Account tab. During the consolidation, when we import Closing-Rate balance sheet accounts that already have a balance from a prior period's consolidation, it may be…
-
Journal batch names
Hi, Why does Journal batch name suffixed with number (Ex. PAY-USA1) getting incremented after posting the transaction? In fact, after posting, the batch name is getting changed to PAY-USA2 automatically. What could be the cause?
-
Running ACIE in Jobqueue
Hi Nav Experts, Would like to ask for your expertise regarding Jobqueue. We've created a Job that will run Adjustment Cost - Item Entries and also we customized Codeunit 5895 to restrict the dialog when running in NAS, also the NAS is already working but the thing is, cost of items is still not adjusted even it shows in…
-
How to highlight the current record?
Hello All, For example in the sales line, the user pointed and click on any field, that line should be highlighted. I know that we can do this by clicking on the Rows bar on the left side. But how can i do this with just selecting the columns? Then if i selected another record, it should release the highlight on the last…
-
Developer's Toolkit - is it in NAV 2015 ?
Hi, I use the old Developer's Toolkit a lot, especially the "Where Used" function, as it is very useful. It isn't supported anymore, but I use the latest version available (v3.01 from the NAV 2009 DVD) Recently I did some new NAV installations of NAV 2013 and NAV 2015. The NAV 2009 Developer Toolkit kind of still works,…
-
32 or 64 bit office with nav2009r2
Hi all We are installing a New version off office 2013 pro plus. We are considering 32 or 64 bit. Because we are also gonna use powerbi and then 64 bit is better for large sheets. Because of nav 2009r2 im thinking of 32 bit Because integration is better with the export to word excel etc is better What is best to choose 32…
-
NAV 2009 - Outlook Sync : Resync Outlook
Hello everyone ! I would know how resync outlook contact from Navision ? What I do : - Remove all contact from Outlook - Remove %APP_DATA%\Local\OutlookSync data - Restart Outlook - Reconfigure Outlook Navision Add-in - Remove lines from table 672, 673, 5302 - Reset User Setup - Outlook setup (table 5305 and 5300) - Set…
-
Processing Output very slow
Hi, to get the "Amount" for the selected customer and date period from the "Cust. Ledger Entry" table using the following code. But to show the output it is taking long time if there are lot of records for the customer. To speed up what the change need to do. ========================================== RVCusLedger.RESET;…
-
AEP renewal plan
Hi, May i know if there is any changes on the AEP renewal plan for the latest Nav and what's the impact of not to renew it?
-
User permission issue
Good afternoon, My company is running NAV 2009 R2 classic with SQL option on a physical Dell server. The SQL version is 2008 R2 enterprise. Since the only reason for using enterprise is we need 128GB of RAM, we are looking into the possibility of using SQL 2014 standard with a vm. It can support up to 128GB of RAM and we…
-
Automatic complying
Hi Is there anyone who knows about tools that can compile automatically all objects i Navision? Best Recards Javaid Sethi
-
TableRelation issue [SOLVED WITH WORKAROUND]
Hi everybody i'm trying to setup a conditional table relation for a textbox on a form, based on the value of a field in the current SourceTable record. I know this is quite trivial but somehow i can't get it to work properly. The form simply shows records from a custom table, which contains an option "Type" field with a…