-
sales order from multiple warehouse items
hi frnds, suppose I want to create a sales order that has 3 items from location A,5 items from location B,17 items from location C in a single sales order,then how to do that?
-
Purchase Order Confirmation in NAV
I order an article from a supplier. The supplier confirms an alternative item with a price. Where in NAV can I place this purchase order confirmation (to be used later for comparison with the invoice) in NAV? It does not make sense to compare the invoice with the order. A purchase contract only comes into being after…
-
dataport in dynamics navision 2009r2 classic client
hi am using to export payment journal with vendor bank account and company bank account in header , how can manage this dataport and how do this , please it s urgently. Thank you
-
E
hi
-
Set new qty to ship and qty to invoice from new field
Hi am using business central,I have created a new field executed qty in sales line i want this qty to be used for shipment and invoice not quantity inserted. How can change to use my new field than use quantity
-
Alternate way to run codeunit for update the custom field(Available Inventory) in item table.
Hi Everyone,[NAV 2009] I have to update Custom field(Available inventory) of item table continuously. so, i created codeunit to run by jobqueue by every 5 min., but this activity became deadlock or this job became stop due to modifying anything in item table by another user. My codeunit: with property: singleinstance=yes;…
-
How to log into Event Viewer
Hi Nav Guys, Is there any way to write a error log in Event Viewer from Navision?? (using Automation/OCX Control) Our company customized Job Scheduling functionality in which i do generate error log in one table but Client wants same kind of log in Event Viewer also.
-
Please i need a Step-by-step process of reversing a posted purchase invoice using a credit memo
Please i need a Step-by-step process of reversing a posted purchase invoice using a credit memo
-
NAV2009 - Classic Client User Permissions / Roles no longer work
All users seem to be able to access any area with write access no matter what permissions are in the permissions table for that user. These used to work. Has anyone ever experienced this or have any ideas I ca try to fix the issue?
-
Insert new row in an existing Excelsheet
Hi, I want to add new rows in an existing excel template file, in an existing worksheet. The worksheet contains the headlines and i want wo add data in row 3 and the following. Is there a function in the excel buffer for this? thanks
-
Diff between finance charge memo and credit memo
Hi Can someone Say me what is the difference between Finance Charge Memo & Credit Memo.
-
"Another user hat..." for the xth time
Hi, This topic has been discussed many times, unfortunately I have found in the forum posts no one that fits my current problem. To the point: A customer of us has a special field, which is calculated for each line ,among other things, based on the weight of the sales document. In each line it has the same value. If lines…
-
Error Dialog in Form VS RTC Page
When displaying an error dialog in Forms it displayed a popup disabling all activity on form. In RTC Pages it displays a message on top of page allowing the user to alter fields on the page which is not desirable since it should not allow the user to edit fields when the error occurs. Is there a way around this?
-
How can i get current record from sales order page.
Hi Everyone, [In Nav 2009] I would like to catch current record from sales order Page. I wrote codeunit and I put this in custom button in sales order page.I am able to call that codeunit after clicking the custom button, but I am not able to get current Field value('No' field from Header). Below is my codeunit, please…
-
Which menu has which user
Hello, I work with Navision 2009 R2. I'm looking for a way to get a list of users with the menus assigned to them. On the one hand, I can see who has access to the menu, using the right-click on the menu "Assign users", so I imagine that there must be the possibility to extract this type of information from a table, "User…
-
Interpreting BLOB field in User Menu Level table
Does anybody know or have a routine to interpret the BLOB field in the User Menu Level table? Somehow this has to be tied to the Menu objects (GUID link?), it would be nice to get a report of what menus each user has access to. I have exported our menu suite object to text and can see the GUID # and description of the…
-
Retrieve Dot net Dll parameter in Nav.
Hi Everyone, [I want to check dll response in nav] I created one Dot net dll and installed in nav, I am able to get that dll in nav ie i am able to create a dot net variable with created dll type(CaptureStripe.CapturePayment). The dll file had created with one parameter "TransactionId". This "TransactionId" parameter, I…
-
Scheduler Replication Counter
Hello, I am trying to replicate sales transaction from the store server to Head office, i have added replication counter on the transaction header table on the scheduler job and when replicate it say " Nothing to do" when i remove the replication counter it replicates, and when i add the counter again it will replicate to…
-
Exporting multiplication sign in dynamics nav
Hih Folks - One of customer has a item description as SS MAT 140 TERRY PRO 18 WHT 39 × 80 where x is a actual multiplication sign and not X from the keyboard. When I create a simple dataport and export the description it comes as "SS MAT 140 TERRY PRO 18 WHT 39 í 80" where x is substituted with strange character. Is there…
-
Filtering flow fields with Date
Is it possible to filter a date flow field? Sum("Sales Line"."Outstanding Quantity" WHERE (No.=FIELD(Style),Document Type=CONST(Order),Shipment Date=xxxxxx)) I want the shipment date to be a date range example 09/01/11 to 09/30/12 or possibly Today +30 days?? Thanks
-
why transfer order same ship and receive date
When our users receive a transfer order, the receipt date is taking same date as shipment date.suppose it is shipped on 12.04.2019 and I am receiving on 16.10.2019, it is showing receipt date also 12.04.2019 not the day,16.10.2019,i.e., of actual receiving. please help how to correct it...
-
server move nav 2009
hello. we need to move our nav from one server to another. after restoring the db, how do I access the new servers? is there anything particular i need to do with this client
-
Transfer order receive codeunit
I want to run a function when transfer order receive Boolean OK is clicked. whenever the user click ok of receive Boolean ,then the function will check the condition if the condition it meets for that user by running the function defined,if is ok then receive will work else it will show an error message. Please help me…
-
c/al code
I have made a zero price validate customization. When the price is zero an error will be thrown saying 'sales price not found'.The next item that I scan in the POS has the amount section zero. How can I make it go away? I have shared the screenshot with you guys. below is my code. code: In pos trans line table -Number on…
-
Using an IF statement inside the sourcexpr of a textbox on a Form
I need to ajust the value inside a textbox according to a record value. I cannot use a function stored in the form because I cannot edit them (since I'm an end user without developper license). According to Mircrosoft : A source expression is a C/AL expression that defines where to find the value of a control.[...] A…
-
SETSELECTIONFILTER sends empty record
I'm using Dynamics nav 2009 R2. I have 2 forms Clients and Invoice Header. In my Invoice Header table i have a field named "Clientid" and "payment date". Right now i have this code on my ClientId OnAfterValidate()…
-
XMLport (export) problem with temp table
would like to know if XML Port (with Export Direction) can work with temporary table? I have a XMLItem called "Item" in my xml port with Source Table = Item (table 27), Temporary = YES Then I pass the Temp table record "l_recItem" to the xmlport in my Codeunit as below : XMLPORT.EXPORT(XMLPORT::"Export…
-
C/AL code for specific user
I need only specific user to update the sales price.In the user setup table i have created a boolean .only the person with that boolean tick can update the sales price.how to write c/al code for this? thanks gugan
-
Eliminating items with zero price in LS retail
Hi I have some customization to do in the pos transaction code unit. The retail items which have zero price are being entered in the pos . We have to eliminate the line by throwing an error that the item has zero price in pos. Thanks Gugan
-
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…