-
Suisse Sepa CT payment
We are trying to get the Suisse Sepa CT payments to work for a customer, who is still working on 2009R2. We downgraded and merged the CH solution into their version but are struggling with the correct xml output of this solution. Like currxmlport.skip does not seem to work properly in this NAV version. Did anyone know a…
-
filtering on a record
Hi guys, I have a question about filtering. Here is a situation: I filter Item table on product posting group: Item.SETRANGE("Product Posting Group", 'Test'); And what I need now is to filter on Sales Shipment Line table to find all the lines where these items are used. So SalesShipLine.SETRANGE(Type,…
-
Document Notifications by SMS in Navision 2009 R2
Hello EveryOne, I want to integreate Document Notifications by SMS in Navision 2009 R2, i dont want to buy bulk sms from any providers or dont want to buy 3rd party software or OCX. I heared that, it is possible to do SMS by using Codeunit 400 SMTP Mail' CreateMessage function, is it true ? if true then show mw the path…
-
How can I see the approval status of a journal line
Hello, Please help me with this issue. I have an active workflow on journal lines and I can not find a status of the line in order for me to see if it was approved or rejected. For example in the sales order workflow after the request is sent the order status is "Pending Approval" and after approval it converts to…
-
Textbox and taking area of the document
Hello. I make to dynamic print text in report. But now he is taking area even if he doesn't print. Check the yellow area. There is the area that I don't want to be if there is nothing to print. When there is nothing to print there I want to be like this
-
how to calculate end date from start date and No. of month in nav
Am working on page which contains Start Date, No. of Month and End Date. When I inputted the Start Date and No. of month, It should display End Date.
-
Page design in Microsoft Dynamics NAV 2017
Hi, I have two table called: Commutation Matrix and Membership Exit, in commutation matrix table are fields as follow: Schedule (code 10), Age (integer), Gender (option: Male,Female), Nx (decimal), Dx (decimal), why Membership Exit table are fields as follow: No. (code 10), Member No. (code 20 link to vendor table), member…
-
Visible TextBox or Label condition
Hello. I have a boolean who is called Print. I need if the boolean is true to print a text, who is always the same. I just need to print him ONLY when the bool is ticked/true.
-
How to install Microsoft Dynamic Nav 2009 R2 Client and Server
Hi Experts, I have tried installing Nav 2009 R2 classic option to have multiple clients to connect to a central database in a server machine, but could not get it work. When i install the server and then install the client and tried to connect the client to the server, It gives "TCP/IP error ECONNREFUSED". I have ping the…
-
Conditional Mapping on a Lanham EDI Document
I need to be able to send pricing on 810 based on the item unit of measure that came in on the 850. I setup a conditional element (element 4) for the IT1 segment (see below), but it is not working. What am I missing?
-
How to evaluate Action data type
I am porting some ancient code that looks something like this... PushAction := FORM.RUNMODAL(50087,SalesLine); CASE PushAction OF PushAction::OK:BEGIN Split := TRUE; SplitQty := ROUND(Available / SalesLine."Qty. per Unit of Measure",0.1); END; PushAction::Yes:BEGIN Split := FALSE; SplitQty := 0; END; END; In 2009r2 it…
-
PAYMENT METHODS
How we can done payment invoices wise in navision.
-
Over Picking on Warehouse Pick Lines?
We have a requirements where client needs to update the quantity to handle field with a greater quantity than the quantity field on the warehouse pick. Has anyone implemented this type of picking before? The reason for this is they consume steel sheets and coil and cannot just pick partial quantities that the pick gets…
-
Problem with reservation logic and bin
Hi I have this problem in Navision. I am on Navision version 5.1 SG. I am using the reservation logic as well as the Bin (With Directed Pick and Put-away) The issue that I faced is that the users do not do a receipt and put-away on the same day. They do need to check the items before they put-away the items. This delay can…
-
spurious quantity in undefined item line tracking
I have a sales order that we're trying to invoice. The item lines have been shipped but I believe there was some edited of the sales order took place after the lines were shipped. When trying to invoice I see the error 'Item Entry Relation Item Entry No. 0 Does Not Exist' When I look at the item line tracking for some of…
-
Assign different Posting No series on sales credit memo
Hi everyone, I'm having a hard time trying to find why in "Sales Credit Memo" page the posting no series is being filled by the order series number by default. In the "Sales & Receivables Setup" I have everything assign in the credit memo to be filled with "MRVNC" but when i run the page I mentioned before it is filled…
-
Working with DateTime in C/AL
Hi, I need to subtract 2 hours from the current date and time, and then convert to ISO8601. I am able to get the new DateTime, but cannot find anything on the conversion? Would there be a simpler way to do this? NewDate := CreateDateTime(TODAY,TIME); NewDate - (2 * 60 * 60 * 1000) T.I.A.
-
Display calculated data in report but getting last value in every row
Hi i am trying to calculate the sync duration but issue is that its display last value in every row. IF "WMS Activity Log".FIND('-') THEN REPEAT IF "WMS Activity Log"."Action Type" = 'SyncStart' THEN BEGIN CurrentUser := "WMS Activity Log"."User ID"; StartTime := "WMS Activity Log"."Date Time"; IF "WMS Activity…
-
Can i have different General business posting group in a service item
hi everyone i want to select a different general business posting group for one item type service example: screws business posting groups screws for building screws for office screws for general maintenance this for create a purchase order with this item thanks for your help! Kind regards!!!
-
Nav "Fields" table: Does it exists on SQL Server?
Hi, I was looking for the table called "Field" in sql server but cannot find it. Is it an internal table? It shows all fields from any table. You ca browse it by making a new form and typing "Field", then retrieve all the fields. Any idea? thanks! :)
-
[solved] Encrypt with SHA-1
Hi We need to encrypt a string with SHA-1 to send it to a webservice. Has anybody done this in Navision (I'm not sure this is possible at all) or somebody knows a software that could be used as automation object? Thanks in advance Thomas
-
List in a report
Hi Hi In a report I have Dimension Value . In filter Code appears as TextBox . I want that user should get List for selection . Thanks
-
Convert a Text to a Blob
I have 2 fields - 1) CreditCardNo (text 16) & 2) CreditCardNoBlob (Blob). On Validate for CreditCardNo I want to push the text data to a blob - I understand you can use INSTREAM to do this - but I need help to get it right. So far I have the following: Definitions: StreamInObj = DataType InStream CreditCardNoProtect = BLOB…
-
Fill posting no series Sales Credit Memo
Hi everyone, I'm trying to fill the "posting no. series" on the Sales Credit Memo because by default it appears empty. So I want to fill with the series "MRVNC" and I'm trying the code below in "OnValidate" Trigger IF "Posting No. Series" <> '' THEN BEGIN SalesSetup.GET; TestNoSeries;…
-
problem with Warehouse Shipments
Hello all :smile: i use the microsoft NAv 2009 R2 at my work , i have a the basic end user license , but i'm a IT technician and i had a course develop C/AL in NAV . My company have the warehouse shipments with a setup POST/PRINT, coming out 2 print copies . that was how they wanted before but now they want only 1 file…
-
Archive fully received and invoiced orders: Where is code?
Hi mates. Does any1 know where NAV does this in the code? I mean if you´ve got "Archive Quotes and Orders" in tablee 312 enabled, I can´t find in the code where does the archive. I see on delete trigger does some deletion but I dont see where it does such archive.
-
Strange linkedobject behaviour
Hi Mates, Does any1 know under NAV2009 if there is any row limitation for linkedobject loops? I mean: T77007.RESET; T77007.SETRANGE(T77007.ID_TABLA_NAV,38); IF T77007.FINDSET THEN REPEAT IF NOT T77015.GET( T77007.CDSOCIED_NEW,T77007.ID_TABLA_NAV,T77007.ID_CAMPO_NAV,T77007.ID_ADM_CAMPO,T77007.ID_SERVIDOR,…
-
What Table does NAV store Item Tracking (Serial Number) information on?
Where does NAV store Item Tracking information for production orders? In this particular case, we are trying to figure out where NAV stores the serial number so we can retrieve that data to automate the printing of property stickers of items being manufactured. The Production Order Lines table has a lot of useful…
-
Is it possible to do a daily import using the NAS of a csv file using XMLPorts in NAV 2009 R2?
We are still using the classic client and the NAS, but the webservice service is operational. (Dynamics NAV 2009 R2, build 39038) I created a dataport to import the data manually and that works. Only after doing that work did I find out that the NAS cannot run dataports. So, I've got to import the CSV data using an…
-
Microsoft Power BI
Hi, Can Microsoft Power BI connect to Navision 5.0?