-
Cost Adjustment issue
Hello, Trying to solve a following problem: Item Costing Method is Average. Customer purchase raw material by units but consume them by weight. For example Purchased and invoiced 100 units at 1£ so value entry shows 100£ as Actual cost Then Consumed 50 units (49 kg), so posted actual cost on value entry is -49£ Then…
-
Return Quantity Shipped Not Invoiced
Hello Everyone, Is it possible to return the only the Quantity Shipped Not Invoiced on Sales Documents. The Scenario is like this: I am shipping the Item A with 1000 Liters, and it happens all the time that i ship at the customer point thay say that are not 1000 liter but 950, so at the end of the month i have to invoice…
-
Posting Date
Using C/AL How do I test if a user entered Posting Date is within their range of allowed posting dates? Thanks for your help
-
excel download
hi experts In a particular excel download I am sending vendor cstno into excel . in some cases cst no is starting with 0 like 09437800008 but in excel download only 9437800008 is coming. It is eliminating the zero . Please give details how i will solve it so that zero will come into the excel column.
-
XML not accepting special character
Hi all, I want to generate a XML file using codeunit in NAV 2013. This is format I need to generate. Im using Dotnet variable instead of automation. <?xml version="1.0" encoding="UTF-8"?> <POSLog xmlns:pcms="http://www.pcmsgroup.com/XML" xmlns="http://www.nrf-arts.org/IXRetail/namespace/"> <Transaction> <BusinessUnit>…
-
Navision Mail
When one of my users goes to post a shipment she gets this error message: This message is for c\AL programmers: Could not create an instance of the OLE control or Automation server identified by GUID={68AEAA7B-9523-3511-AF5F-F2381D2C6F04}1.0{F9DAE2A4-D2F8-37C3-86D5-E4FFE166D860}:'Microsoft Navision Mail'.SmtpMessage. Check…
-
Time counting
Hello, I have a question: how to sum data type TIME thanks
-
PrintPreview NAV2009SP1 Classic
Anyone knows whether it is possible to remove focus on print-button in PreintPreview and by that forcing user to click on the print-button if they really want a paper-print? Users often press the Enter-key trying to stop the PrintPreview to study some of the first pages - resulting in huge amounts of needless papers.…
-
Find Sales Invoice No from Sales Shipment no
Hi Is there a way to find Sales Invoice No from Sales Shipment no. I am trying to create an item ledger entry report and user insists that (if it is a sale) the related Invoice No to be printed instead of the Shipment from Item Ledger Entry. He also raise several shipment and invoices for single order (part delivery).…
-
Conditional Hide Function on Reports
Hi all, Can someone guide me on the line to hide this line if a value on another variable is zero? Thanks in advance. For example, if MD Discount = 0, I do not want it to appear on the report.
-
Report 411
hi experts In report id 411-Vendor - Payment Receipt how to list the document no in report filter. give any suggestion.
-
Session on NAV 2009 R2 Classic
hello experts, I have facing an issue about active sessions in NAV 2009 R2. So I need to access session table by SQL server, which I couldn't find. ](*,) I read somewhere it is a virtual table, is it correct? If not what is the active session table name/id? If it is a virtual table, how can I access it? Thank you.
-
Inventory Movement Report
Gurus, Is there a standard report which shows the movement of the item. Looking for a report to see the transaction history/ledger entries by giving a Starting Date and End Date and with applicable filters like Item No, Location Code etc. Report to show the Opening Balance qty, posted ledger entries and closing balance of…
-
Copy Menusuite for Windows Login
Hi all, Can someone please guide me on how to copy users settings (menusuite + windows login permission) from 1 user to another? I have created as per below for copying of database logins. Thanks in advance. DataItem - User Menu Level User Menu Level - OnPreDataItem() SETRANGE(ID, OldUserId); IF Overwrite THEN BEGIN…
-
Red Customer Ledger Entries NAV2013
In NAV2013, some customer entries are in red. It appears that the Red Bold are past due, although not all past dues are in red. We have some entries that are closed, which are also in red. I haven't been able to locate any documentation on this. Thanks,
-
Flowfield calcformula based on date range
Here is my scenario: Table1 fields are: Item No. , location code, Rate Effective Date, Rate Table2 fields are: Item No. , Location Code, Ship Date, Table1Rate. Table1Rate is a flowfield. Table 1 data is: Apple, US, 03/01/14,$5 Apple, US,03/15/14,$6 Table 2 data is: a) Apple, US, 03/04/14,Table1Rate, I need to show it as…
-
'TODAY' is not a valid date
I am trying to filter the Purchase Header table, using the following code: GrecPurchaseHeader.RESET;GrecPurchaseHeader.SETFILTER("Expected Receipt Date",'<TODAY');CurrForm.UPDATE(FALSE); Placed in the OnOpenForm trigger. I get the error 'TODAY' is not a valid date. I'm surely missing something obvious, but I can't find…
-
BA Business Analytics on Windows 2012 / SQL 2012
Did someone manage to install and run the basic BA package on a W12, SQL12 machine? I tried installing and running the 2009R2 Classic Client and the BA configurator exe (2008 Version 4.0.0.27) on a W12, SQL 12 test box but the configurator wouldn't even start. Error: ProblemEventName: CLR20r3,…
-
Upload/download PDF File BLOB
Hello =; , I want to upload and download a pdf file into the database. I created a table "Documents" (No., Date, Time, Doc,...) and "Doc" is of type BLOB. Can you tell me how to upload/download to /from "Doc" ? #-o Regards.
-
Filter in decimal field
Hi .. i want to apply filter to decimal field with below criteria : 100.75 19.50 12.00 21.50 98.35 45.50 i want to filter for value ending with (0.50), the result ( 19.50 - 21.50 - 45.50 ) ...can we do it direct or need to write code. i am planning if can't be direct from the field , need the code to be used in data port .
-
Error printing a Blanket PO
Good day! We received this error while printing the blanket PO. "There is no currency Exchange Rate within the filter" Filters" Currency Code: USD, Starting Date: ".." Our currency exchange is already setup covering the current month.
-
Company information report
Dear community of mibuso, i am new on dynamics NAV, currently i am working on the report customization, but now i was trying to print company information, like company name, company address and other information from company information table on my new report. please help me, thanks Marry
-
Blank Currency Code under Blanket PO
We created a blanket PO using a specific vendor. The currency field under the Foreign Trade tab is blank. What could be the possible factors for this scenario? Could it be a blank curr. code from the Vendor card prior to BPO creation? We are using Dynamics NAV 2009 SP1. Thanks.
-
How i make conusmption to raw material = 0 to purchased item
Hi guys i want to set consumption to raw material in my company to 0 how i set consumption to 0 to specified raw material Example I purchasing aggregate with 200000 and details quantity 2000 kg and unit price is 100 I make consumption to 800 kg but details of these 800kg is more than one transaction Now i want to make…
-
Action Message on Requisition Line
Hi, After i run the MRP, one of the Item line suggesting reschedule(action Message) but when i see the original and New due dates are same? any reason for this? Regards, Ali
-
Different posting dates for same document No - NAV 2013
Hello, I would like to know if there is a way to prevent NAV to validate a General Journal containing different Posting Dates for the same Document No. Thank you for your Help
-
Linked Object Read Only failure across 2 server - MSDTC
Hi, I have 2 servers - NAVDEV and SRVSQL both running SQL Server 2012. Both servers have MSDTC on, firewall exceptions enabled, and no authentication required for incoming requests. I have a linked table object in my navision db on NAVDEV, what uses a view to access a table in a db from SRVSQL. From Mgt studio on NAVDEV, I…
-
NAV Integration 2013 Slowness
Dear All, One of my client want to integrate his sales system with Dynamics NAV 2013 R2. They have all the data in a SQL database and they want to transfer data batch wise (once a day) and this one particular batch contain around 5000 journal lines. To do that I have created new tables depending on the integration types…
-
Check Box Selection
i create form based on " Employee table" in field " family status" i want to add in form two check box, if use select first one , it will return in this field = single , if user select the second check box it will return in same field = Married . how can i do that . thanks for usual help ..
-
Show details of Statistics in FactBox in Sales Invoice
I am trying to customized Fact box of sales Invoice line to Show the details of Statistics in the fact box Customer Statistic i.e it should show all details of Statistic page in fact box i tried to keep the fields of Statistics page in Customer Statistics FactBox and took an record Variable for sales line but how can i…