-
Question on reports
I should create a sales order report
-
How to get last day of a year?
Hi, i am looking for a solution to get simply the last day of a year, especially, if the date is in a text data type like "01.05.15..12.12.16" or only "01.05.15". I have the following solution with a simple function: Text := '01.05.15'; PostingDate := '31.12.' + COPYSTR(Text,7,2);
EXIT(PostingDate); There must be a better…
-
VAT charges
How to calculate VAT
-
QR Code Printing in Nav 2009 SP1
Does anyone help tat how to print QR Code from Classic reporting like barcodes, I have installed the MicrosoftDynamicsNav2009SP1MXSignatureProvider.msi but it only showing in 2013 R2 version , I need to use the Dotnet or Automation from 2009 SP1. Thanks in Advance.
-
Background Posting
Hi, Can any one explain me the process of background posting feature please help me how to add the filed in background after hitting the post button?
-
general doubt
can we use same table names for both main form and sub form..??
-
How to add a new line of item charges after posting the item in sales order??
Hi, I have a charges field in sales line and in sales order subform I have added this field and in sales order I want to select the item in type field by giving the quantity, unit price I can get line amount and amount incluidng tax and also I have some amount in charges filed also but my problem is How can I get this…
-
Can't Invoice item charges?
Hi, I am getting the error while invoicing the amount like Value Entry Entry No. 830 already Exists Can any one help me
-
Sales order posting
I add the new field in sales line table as "New field" for item charges.
-
How to get extra charges
Hi, I add three new fields and post them as item charges
-
Error
Hi, There is no value entry within the filter Filters item ledger entry No.501 entry type: direct cost When I turn on debugger I am getting the error at this line DirCostValueEntry.FINDLAST; Please help me
-
Insert a Sales Line automatically
I have add a field to the Sales Line table and Subform 46 called "Sample". Upon clicking this field it inserts a second line based on the current line (using Line No., Item No. and Qty). I want the second line to be the current line no. + 1. You can probably guess that due to Autsplit and DelayedInsert my original line…
-
question
I have to create a form using sales invoice line table,but there are three fields customer no, from date, to date and the fields from that table are below. but condition is when i put data in above three fields i mean customer no, from date and to date then all fields should retrieve automatically.I added a new field name…
-
how to pass the information after posting in sales order?
I have some fields in sales Line, and in sales order I gave the data to those fields but after invoicing how can I pass the information of those fields to Cust.Ledger entry table.
-
Which codeunit is used for posting the item charges?
Hi Experts, I have charges field in sales line and in sales order subform I have added this field but how to post this charges as item charges, I want to post the field amount I have in charges as like amount including tax field in sales order. Can any one please suggest me
-
how to update the items in subform..using from and to dates
I have purchase date only.....I create new form which consists of items information........I create two text boxes with labels as from date and to date...by entering from date and to date how items information will be updated....how I can link the purchase date to these dates.....any suggestions plz..urgent
-
how to dispaly posted item charge value in negative in value entry table
I am adding the one item charge named as rebate. If I select and post that item charge amount is posted as negetive value in value entry table how can I display negetive value
-
updation of subform
using the from date and to date and customer no given in the form should update the sub form using the from and to dates by using the field purchase date in sub form. I am having the purchase date info in sales invoice line. How can update and which table i should use?
-
To flow data in sales line table to items ledger entries table
I add new field such as description 3 in sales line table..After posting sales order form I want same field vales in items ledger entries table.. please suggest me how it possible.
-
Parent item group in Resources group structure.
Hello, I want to set up a Resources group structure that is similiar to the item groups structure, i.e.: 1. Deliveries 1.1 Furniture deliveries 1.2 Office supplies deliveries 2. Service 2.1 On-site service 2.2 In-shop service See example from item group structure: http://imgur.com/YRgSOmo Is it possible with Resources in…
-
FTP Import
Hi All, This is the snippet of code that I've written to import an order from FTP for further processing in Navision. The same script which is generating through this code is running completely fine if use command prompt to execute each step manually. But if I am executing this then the files are not imported from the FTP.…
-
About carrier charges
I have added carrier charges field in sales line and in sales order, post as item charge.
-
I want C/AL code for posting the total amount displayed in amount including tax field
Hi experts, I have a field in sales line table and in sales order while posting the item I have added amount to the amount including tax field but my problem is after posting the amount it is displaying only some amount without inlcuding charges can any one explain me where I have to write the code and in which code unit?
-
Using requestform and option buttons to make Item report multilangual
Hello all! I've a question: I have a report which uses among others the table Item as DataItem. I've created a nice Product Specifications report to send to customers, but now some international customers want them also. So, for me the challenge is to make it multilangual. I've used the captionML of all fields to translate…
-
Salesperson/Purchaser Code (Table 13) Nav 2009 R2)
Hi, We are having a lot of salespersons names in this table and since i have joined this company in 2011 to till now there are almost 60 to 70 names being used for those people who joined as salesman and left the company. Most of the names are quite common and we have salesman codes created as JT1, JT2 or GS1 and GS2 and…
-
How I can get sales line field value to sales invoice line after the posting
How I can get sales line table field(ex:truck no:101) value to same value in sales invoice line table after the posting in sales order form..how it will possible please suggest me..very urgent
-
Pre-Assigned No.
Hello Experts !! You know, if the field "Pre-assigned No." of purchase invoices used in some other table besides the "Purch. Inv. Header" table? They ask me renumbers these values and need to know if it affects any other table. Thanks in advance.
-
how to sum another field amount and line amount in sales order
I want to display the total amount in amount including tax field, while posting in sales order
-
Customer License Issue (SQL - NAV 2009)
Hello, I have a license problem with one of our customers. The license is stored in DB, when I check from the Db Information, I saw that current sessions number is 8 while the licensed session is 26. In this case users cannot login because of the max. permitted user exceeded error. There are external connections to NAV DB…
-
Inventory Valuation Report seems extra slow
Is there anything that can be done to speed up the Inventory Valuation report? I never "timed" it before, but it seems as though the report is now running much slower. I seem to remember running a 60 page report in a few minutes (8) as opposed to it now generating a page every 90 seconds... any ideas on anything that can…