-
code syntax remove comma from decimal in RecRef
need to convert 11,375.75 to 11375.75 in Recref can someone give me guidance.
-
I want to ignore thousand separator from RecRef filed.
my code is this. IF (TableID = 271) AND (BankMapRec."Field No." = 17) THEN IF EVALUATE(testDecimal,FORMAT(RecField)) THEN BEGIN RecField.VALUE(FORMAT(ABS(testDecimal),0,9)); But this is not going correctly. Still appear thosusand thousand separator. what should I do?
-
Will data from table extensions propagate in the process of posting?
Hi, in former versions of NAV, fields added to the Sales Header table would propagate to the Sales Shipment Header, Sales Invoice Header and Sales Credit Memo header tables in the process of posting if the respective fields were also added to the other tables (TRANSFERFIELDS magic). What would happen in Business Central…
-
Zero value GL Entry is created after apply 2 transactions
Hi, I posted 2 GL transactions A and B with account type Vendor, same vendor. B is contra of A, then applied B to A. Navision then created 1 new GL entry with Doc No A and Zero amount. Anyone can help explain me whether this is a bug or feature? any reference? P/S: I'm using NAV 5.0 SP1 Thank you.
-
I need help parsing a string
I have this connection string. String := Eventstatus='Calculated' and ErrorCode='0000' This string will always have this format but can differ the number of the fields and the operator (it can be 'AND' or 'OR') How I can parse this string in order to get those fields and values and then to filter a specific record…
-
Check if month and year exist between 2 dates
Hello everyone, I have a function which receive 3 parameters CustomerNo, Year and Month. I have to search on Contract Line Table and check if that Month and Year correspond to one of the contract lines. What I did so far AfisareContract(pCustomerNo : Code[20];pYear : Integer;pMonth : Integer;VAR pContractNo : Code[20];VAR…
-
Execute code when clicking a record in a table (in a form)
Hi so apparently no trigger is activated when i am clicking on a record. My intentions are to update a subform after clicking on a record on the parent form. is there a way to implement this ?
-
Create dynamics NAV error message when sales amount is 0
Hi everyone , I'm relatively new to NAVISION world , I have a question i will be very grateful if someone can help me. I have to create an error message that block a user when he tries to validate an sales invoice with 0 amount. I'm sure I will be use an IF with Error msg like this : SalesHeader.SetRange("No.", "Document…
-
Weighbridge integration
I have recently done a weighbridge integration with the Nfcomm OCX. But getting strange return from the weighbridge. CLEARALL;NFCOM.ClearBuff;WBLocation.GET(Location); WBLocation.TESTFIELD("No. Characters to Retrieve");WBLocation.TESTFIELD("Weight String Length");IF WBLocation."Integration Type" = WBLocation."Integration…
-
Excel 2007 SaveAs Method of Workbook Class Failed
Hey everyone, I just moved the NAS from one machine to another - installed the same version of Excel 2007. Running on Server 2008 NAV 5.0 SP1. Before I ran updates, I tried having the NAS Fire off some of the jobs I had setup and been using for quite some time now. In them I am using Excel Buffer to make an excel file and…
-
Merging cells in Excel using Excel Buffer
Hi all! I have made a report, using Excel Buffer. But I need to merge cells in report header row. It seems, that is impossible to merge cells using excel buffer. :cry: I found in previous topics one way to do it: xlSheet.Range('A1:C1').Merge; The only way I can imagine is to complitely modify my report and do not use Excel…
-
Focus on empty record in tablebox triggers OnInsertRecord()
Hi, my problem is , i open the form the form already filtered. If no record is found, an empty one is automatically created to set the focus on it. As soon as i try to click somewhere else it tries to insert that empty record into the table which results in an error ( thankfully ). If i set the property focusable to false…
-
Display multiple Document No.s as 1 row in Report
hey guys, I need the correct total for my report. I'm getting my source from VAT Entries. the 2nd column is from VAT entries they are the consist of multiple document no.s in my VAT Entries then the 3rd Column is the sum of the Amounts based on the Document no.'s in the 2nd. Column yet, the total of the 3rd column is…
-
Job Queue run on earlier one day
Hi guys, I have question want to ask, example my job queue set running on every Friday, but sometime holiday/rest day will fall on Friday, so my job queue want to running on earlier one day that mean run on Thursday, may I know how I can archive this scenario? I hope expert in NAV people can teach me to solve this problem.…
-
How to run CodeUnit
I wonder if you make an CodeUnit, can you call for a report in a CodeUnit, for an exemple Run.REPORT(50000), but can you also give a filter example RUN.REPORT(50000,Vendor."No.")?
-
Navision Classic 2009 - Unable to post Journal Entry suddenly
Hi, I am unable to post Journal Entry, it hasn't happened before, and now Navision is posing an error message "You must specify Source Code G/L Entry to CA in Cost Accounting Setup Primary Key="." (Image as below) It seems that I can resume posting Journal Entries after changing to this configuration: Source Code G/L Entry…
-
Is it possible for item cards to have multiple routings and BOMs?
Hello, our company has added a second location, meaning that we will be producting same items at another location due to capacity issues. We have created the 2nd location in Nav with their own bin codes, etc. We are now trying to test production orders. Then ran into the question if we can have item cards with multiple…
-
NAV 2009 R2 supported SQL Server Versions
Hi all, up to which SQL Server Version, is it possible to run NAV 2009 R2 (latest CU)? Currently they are running under SQL Server 2008R2 and Windows Server 2008R2. But as the support from Microsoft has ended, our idea was to update the SQL Server Version, and the operating system. Thanks in advance, Gido
-
Subtotals
Greettings, I need to create a subtotal on a table based upon the value of a field . On the table 5601(FA Ledger Entry), I want to be able to sum the values of the field 'Amount' based upon these creterion : - FA Posting Type : Depreciation Knowing that this can be rolled out by the use of Setfilter , the totaling needs…
-
General Dimension Value Type Question
Hi all, during a setting and testing of a new client, my colleague and I saw that it is possible to post on dimension value types "Standard" and "Begin-Total". We could not believe that until we saw it in the codeunit 408: [..] IF NOT (DimVal."Dimension Value Type" IN [DimVal."Dimension Value Type"::Standard,…
-
Is it possible to have User Personalization per locations?
Hello, We have added a second location to our system, the second location is physically in a different area/city with different users. Example location A & B, we will stay with location A and would like Nav to default production orders, purchase orders, receipts, shipments, entries, etc. for the second location as location…
-
Custom Sales Invoice Numbers
Hi, we have a setup in No. series which creates records in Sales Invoice Header with numbers from our invoice numbers range. Now, I would need to have an option to post extra invoices with custom numbers different from our numbers range (creating for us by external partner). If I put this custom number into Sales Header,…
-
Navision Integration with PDF Creator terminal server
Hello After installing the PDFCreator terminal server from Navision, the PDFCreator_COM object and the PDFCreator printer became available. Can you tell me an example of a code, how to use PDFCreator_COM from the Navision application (or another language)? As a result, users need to select a PDFCreator printer, and save…
-
how do you modify the value of the primary key of a record?
So whenever i try a MODIFY i get the error " "Table.Field" 'NEW_VALUE' does not exist " seems like it tries to find the record with the new primary key value which obviously doesn't exist yet in the table... so how am i supposed to change the value of the primary key field then? Do i have to delete the old row and insert a…
-
Changing dates in a Flow Filter field in Lot. No. Information
Hello, Anybody knows how to change this filter? our Lot No. Information is curently filtering 01/01/0000..04/15/20 and we believe this is the reason why data is taking too long to load.
-
using Coupons on POS
Hello, is there a full documentation about issuing coupons and using them on POS, what i am looking for is a way to issue coupons or vouchers with unique code or barcode, that can be used as long as there is an amount left in it, i have tried so many ways, but couldn't reach a satisfying solution. Thank You
-
how to copy the records from one table to another table
hai all i am new to navision programming i have a problem in coping the records from a perticulat field of a table to another table for example item1 is the table which i have created i want to copy all the item nos from item table to item1 table's itemno field which is not a primary key. All the records should be copied…
-
How to transfer data from one table to another where some data is already present?? Please Help
What i am trying is using FINDSET and getting error of data already exists at line no.
-
Customer Rebate Issue
Has anyone had any experience of developing a customer rebate system, whereby a set % of any sales invoice is posted to a balance sheet account as a rebate, but leaving the customer ledger showing the full gross value. , ie, Sales Invoice 100, not showing any record of rebate on print of report Rebate 10% Sales Value will…
-
How to disable gui messages?
Hello, How can I disable GUI messages during import? I am working on Nav 2009 R2 and created an xml port to import sales invoices and during import, I get a message it says You may have changed a dimension. Do you want to update the lines? I do not wish to see this message. I traced the code and saw that salesperson…