-
How to print in report type - Code
Hello. I'm trying to print in my report Data Type as Code. But the TextBox is empty. Thanks.
-
NAS server failing with yes/no option
Hi all Hope someone can solve this problem as I am out of ideas for the reason. I presume the NAS always operates in english and I have tried also to change to english on the app.server, but nothing helps. Have tried to look for solution in here but was unable to find anything except for the change language thing. The…
-
How to separate the cents from an amount and put it in another field - SSRS
Hi All, Sorry this question for reporting issue but maybe the solution in NAV, so my question is i have an amount such as 180.60 USD i want separate the 0.60 to another filed and 180 in another filed also for reporting purpose in SSRS. Do you have any idea how we can do it in NAV development as coding or in SSRS ?
-
Round decimal field in report
Hi experts! I have a decimal field with 5 decimal digits, but on my report, I would like NAV 2009 to round or truncate the value to 2 digits (from 1.23456 to 1.23). I have tried to set the property DecimalPlaces to "<2:2>" and "2:2", but it still shows too many decimal digits. When I print the value 42, it is shown nicely…
-
How do I Find a non numeric value in a string?
I'm trying to find the position of the first value that is not a numeric value within a string. pTxtNumber is passed in and could be 10-15672 for example. So I want to return position 3 because this is the first non numeric character. Then I want to chop of the string up to and including this character so that I am left…
-
GETFILTER
Hi I have a question. I'm trying to select in a XMLPort. I have a Report that calls an XMLPort. Now the question I have a filter in the report on Vendor from No. 50000..50010. The Filter is on Element Vendor, but how do I do to get the Filters on Vendor2 and Vendor3 The XMLPort look like this Mandate = Element Vendor…
-
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…
-
Value Entries on Production Output
Hi, I have an issue where a value entry is for a consumption journal is updating the last direct cost on the item card. I've attached two examples. In each example, you will see there are three value entries for the exact same item, exact same production journal. There is one item ledger entry that sums the value ledger…
-
Production order creation from sales order
Hi, For Ex: ItemA Contains Production BOM as ItemABom and ItemB contains ItemBBom If ItemB is used in ItemABom BOM. Now we create a new sales order contains ItemA in sales line and we create production order by selecting order type project order and new released production order gets created. On the Production order lines…
-
For creating a Pick...
Hi Everyone, I have created a sales order for an item and create a warehouse shipment and create pick for that sales order. Now whenever i create a pick the items form the bin are taken in this order. BIN1-45 BIN2-5 BIN3-3 That is that bin which has high items are pick first and bin low contents are picked last. Now all I…
-
Regarding item picking from bin content.
I want to create a sales order, where item have to select in such a type which having different quantity in different bins. After that have to create a warehouse shipment and create pick lines, which should be come this type:- E.g: If,Quantity of any particular item in bin content is, bin 1- 20 bin 2- 90 bin 3- 10 Should…
-
Lookup on field in request page
Hi, I'm new to NAV, and for the first time, I have made a request page for a new report in NAV 2009. In the request page, the user can enter a filter on item numbers. The entered value is saved in a text variable, I use later on. I would like to add a lookup arrow to the field, but nomatter what I do, there is no lookup…
-
Microsoft.Dynamics.Nav.SMTP.SmtpMessage add a signature
How to add a signature-jpg to a Microsoft.Dynamics.Nav.SMTP.SmtpMessage?
-
Nav 2009R2 Excel 365 slow performance
Hi We have a Navision 2009R2 (native db) with a lot off custom reports using uses excel automation to produce excel files. This works fine with Office 2010, but now we have to upgrade to office 365 and when I test the same reports it seems like they are a lot slower (5-8 times slower actually) Has anyone had the same…
-
pass parameter with \ to function
Hello how i can pass file path with \ for function FunctionlaunchJetReport(FileName : Text[1024]) recReport.SETFILTER(DescriptionJet,FileName); IF recReport.FINDSET THEN txtPath:='c:\temp\Résultats-V900.xlsx'; HYPERLINK(recReport.PathJet); i have this message: Link adress is not valid Thanks
-
Multiple date lines in report
Hello! How it's possible to print different shipment date in report? Example: Lines: For line 1 No. -> Shipment Date: 12.12.18 For line 2 No. -> Shipment Date: 13.12.18 Report should be like this: No. | Shipment Date Line 1 No. | 12.12.18 Line 2 No. | 13.12.18
-
Upgrade vs New Implementation NAV 2009 R2 to NAV 2018
My company is currently on NAV 2009 R2 Classic and we want to move to NAV 2018. There have been quite a few programming changes made to the old software mostly to match our pricing program, however we also would like to reclassify our products in newly created item categories, product and posting groups and revamp our…
-
How to get an automatic posting description customised for each vendor?
Hi, Is it possible to have "Posting Description" bracket to fill automatically when I'm booking a purchase invoice? For some vendors I want it to say i.e. "Subscription 2018/", for others "Rent 2018/" etc. Even better yet, is it possible for a description to be the same as description in the first line of purchase line…
-
Blocked customer and overdue reminders?
Hi If the blocked field on a customer card is set to SHIP or ALL will Navision send reminders in the case of overdue invoices ? Thanks
-
Picking Lists & Routes
Production of our finished manufactured items takes around 3 to 4 weeks and comprises various operations at different work centres. In order to help manage inventory we use routes along with route link codes so that purchased components are delivered at the appropriate time during the manufacturing process. There are…
-
how to setup outlook sync with nav 2009 and database login?
if anyone could please help.... tia
-
MULTIPLE CHOICE OPTION FIELD
HI ALL how can i select multiple option in my option fields... like i have a option field post...n options are mail,letter,card,person Now if i want to select both mail and letter what should i do? normally we can only select 1 option right ! thank you :)
-
Error: add library and procedure xp_ndo_enumusergroups SQL Server 2008 and NAV 5
I'm trying to open Nav 5 with SQL Server 2008 but I get an error about the precedence xp_ndo_enumusergroups. Could you help me solve it, please?
-
How to save as PDF using Adobe Acrobat Pro version?
Hi friends, [Version using: NAV 2009 Classic Client] Can anyone tell me how to save a report as PDF (also with password protected) using Adobe Acrobat Pro version? If you have any links please share. I do not know how and what to use in the Automation library classes and bit confusing. Thanks is advance, Aarvi
-
How to print in Arabic for POS Receipt
Dear Friends, I am using Nav 2005 and Nav 2009 with LS Retail. I want print bills/receipts in Arabic. Now the government made it mandatory will you suggest me the solution please. Warm regards KMK
-
Arabic characters @ POS
Hi i am LS NAV consultant , i am working in Retail company ... our version is NAV 4.0 , i want to print in POS receipt arabic font .... is there any solution to print arabic characters
-
Change a label dynamically
Hi, Is it possible to change a label his Caption in the OnAfterGetRecord method? And could we make a textbox invisible, or disabled? Also in the OnAfterGetRecord... Thx
-
Navision4
i am tacking backup in nav version W1 3.60(4.0 SP3) after completing 100% backup i am gating this error. Error: There Are Errors In The Text Conversion (Text No. 1965-0 Does Not Exist In The .Stx File). Internal Error: 47-1 what will be the issue ?
-
Flickering of screen when using Nav
Hello, Has anyone encountered this bizarre problem? I have an HP EliteBook 840 Gen8 with Windows 10 Pro. Only when using NAV Classic, the screen flickers. Any solution for this?
-
hii friends , while taking the back from navision 2009 , i found the below error kindly suggest..
this error comes when i am trying for a specific company back but for other company it is ok. i can not find how to solve this error, i cross checked the customer table also , and corrected in the data level also, may be something i am missing please help me out.